[TF2] Store plugin

Post Reply
DellacryGamingHD
New to forums
New to forums
Posts: 4
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sat Mar 01, 2014 11:42 am

[TF2] Store plugin

Post by DellacryGamingHD »

Hello, I am trying to install the Store plugin for my server. I've done everything it has asked, and im still getting the following error:

Error Number: 1146

Table 'dellacrygaming_Store.store_users' doesn't exist

SELECT * FROM (`store_users`) ORDER BY `credits` desc

Filename: /usr/www/dellacrygaming/public/StoreWebpanel/models/users_model.php

Line Number: 45


Any help would be appreciated, thanks

(and I am using the correct database stuff and all that. it's connecting. Im not sure how to continue, and that's why Im asking for help.)
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: [TF2] Store plugin

Post by soja »

Table 'dellacrygaming_Store.store_users' doesn't exist
That pretty much says it all. the store_users table does not exist.

Did you import the sql file included with store?

EDIT: Did you complete this step in the installation instructions?
Next, navigate to configs/store/sql-init-scripts and execute store.sql in your database.
Not a NFO employee
DellacryGamingHD
New to forums
New to forums
Posts: 4
Joined: Sat Mar 01, 2014 11:42 am

Re: [TF2] Store plugin

Post by DellacryGamingHD »

That worked. Thanks.!
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: [TF2] Store plugin

Post by soja »

You're welcome :)
Not a NFO employee
DellacryGamingHD
New to forums
New to forums
Posts: 4
Joined: Sat Mar 01, 2014 11:42 am

Re: [TF2] Store plugin

Post by DellacryGamingHD »

and sorry if i seemed noobish about this. Im new to all this Database stuff.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: [TF2] Store plugin

Post by soja »

Completely fine, if you need anything else please don't hesitate to ask :D
Not a NFO employee
DellacryGamingHD
New to forums
New to forums
Posts: 4
Joined: Sat Mar 01, 2014 11:42 am

Re: [TF2] Store plugin

Post by DellacryGamingHD »

Once again, another error which is prob solved easily but would like help.


Error is as follows:

Error Number: 1054

Unknown column 'flags' in 'field list'

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', 11, NULL, NULL)

Filename: /usr/www/dellacrygaming/public/StoreWebpanel/models/items_model.php

Line Number: 224
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: [TF2] Store plugin

Post by soja »

Looks like you need to update the database to 1.2 beta, thankfully this is pretty easy :)

Log into phpmyadmin(or any other sql databse tool) and run this query on your database:

Code: Select all

ALTER TABLE `store_items` ADD `flags` varchar(11) DEFAULT NULL;
Make sure you have the latest files, that store is very unorganized atm(to the average user), did you download the provided smx files, or did you compile it from source?

You should compile the plugins yourself from https://github.com/alongubkin/store

If you can't figure it out let me know, and I can compile them for you :)
Not a NFO employee
Post Reply