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.)
[TF2] Store plugin
-
- New to forums
- Posts: 4
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sat Mar 01, 2014 11:42 am
Re: [TF2] Store plugin
That pretty much says it all. the store_users table does not exist.Table 'dellacrygaming_Store.store_users' doesn't 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
-
- New to forums
- Posts: 4
- Joined: Sat Mar 01, 2014 11:42 am
Re: [TF2] Store plugin
That worked. Thanks.!
-
- New to forums
- Posts: 4
- Joined: Sat Mar 01, 2014 11:42 am
Re: [TF2] Store plugin
and sorry if i seemed noobish about this. Im new to all this Database stuff.
Re: [TF2] Store plugin
Completely fine, if you need anything else please don't hesitate to ask
Not a NFO employee
-
- New to forums
- Posts: 4
- Joined: Sat Mar 01, 2014 11:42 am
Re: [TF2] Store plugin
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
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
Re: [TF2] Store plugin
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:
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
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;
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