Installing Stores onto a CS:S server

[Bigsplash]

First off let me mention I have very limited knowledge when it comes to the world of MySQL and phpMyAdmin. I am running a server just because I like to tinker around and learn new stuff.

So my next challenge is to see if I can succesfully install !stores onto my CS:S server.

However right off the bat things are not going to well for me and I am wondering if I have gotten myself in over my head.

The first step is to create a database, well how hard can that be, right?
So I create my database in in the Databases tab of my NFO control panel, all looks great, but then I am supposed to do this

Enter the database you've just created and navigate to Import. Click Choose File, and choose configs/store/sql-init-files/store.sql from the store package. Click Go.

Don't have a clue what this means and how to go about this?

Oh! how I hope my trusty interweb goto friend Soja is reading this

[soja]

Install phpmyadmin from the autoinstallers tab and navigate to where you installed it in your web browser. Then log in with your database login information. After that, select the database you made on the left, and go to the import tab along the top. When you downloaded store from github, you downloaded a folder named "sql", it should have all of the sql files you need to get started

EDIT: Make sure you allow external connections for the database, so your game servers can use the database.

[Bigsplash]

[Bigsplash]

I have followed all instructions to a T https://github.com/SourceMod-Store/stor ... e-WebPanel

I have uploaded https://github.com/SourceMod-Store/store-webpanel via Filezilla created folder "store" inside "public"

But when I enter www.myNFOsite.com/store/uploads into my browser I get The configuration file does not exist.

[Bigsplash]

Never mind, got it working now!

For some reason when I renamed the database.sample.php to database.php I inadvertently named it database.php.php same for config.sample.php, which ended up as sample.php.php.

[Bigsplash]

I am following https://github.com/alongubkin/store/wik ... ling-Store presently I am at this step:

Open your store web panel, navigate to Import/Export System under the Tools menu, and import configs/store/json-import/trails.json.

this is the error I get:


A Database Error Occurred

Error Number: 1048

Column 'flags' cannot be null

INSERT INTO `store_items` (`name`, `display_name`, `description`, `web_description`, `type`, `loadout_slot`, `price`, `attrs`, `is_buyable`, `is_tradeable`, `is_refundable`, `category_id`, `expiry_time`, `flags`) VALUES ('trafficcone', 'Traffic Cone', NULL, NULL, 'equipment', 'hat', '650', '{\"model\":\"models/props_junk/trafficcone001a.mdl\",\"position\":[0,-1,20],\"angles\":[0,0,0],\"attachment\":\"forward\"}', '1', '1', '1', 10, NULL, NULL)

Filename: /usr/www/myNFOserver/public/store/models/items_model.php

Line Number: 232

Any ideas?

[soja]

Go into phpmyadmin, select your store database, select the store_items table, and click Structure at the top.

For the flags column, click change, set the default to NULL. It should look like this after:

[Bigsplash]

It worked!!! THANK YOU!!!