[TF2] Store plugin

Post Reply
DellacryGamingHD
New to forums
New to forums
Posts: 4
Joined: Sat Mar 01, 2014 11:42 am

[TF2] Store plugin

Post by DellacryGamingHD » Sat Mar 01, 2014 11:44 am

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 » Sat Mar 01, 2014 11:48 am

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 » Sat Mar 01, 2014 11:54 am

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 » Sat Mar 01, 2014 11:56 am

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 » Sat Mar 01, 2014 11:57 am

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 » Sat Mar 01, 2014 11:57 am

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 » Sat Mar 01, 2014 12:07 pm

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 » Sat Mar 01, 2014 3:56 pm

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