Raised This Month: $ Target: $400
 0% 

Issue Store Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
PrO Kill3R
Junior Member
Join Date: Mar 2009
Old 12-17-2013 , 09:30   Store Error
Reply With Quote #1

Hi everyone,

So I've managed to install the in-game store plugin along with the webpanel. The webpanel seems to be working as I can add credits. Although I tried installing the Equipment Module (https://forums.alliedmods.net/showthread.php?t=208125), uploaded the files from the download and tried importing the equipment.json file through the webpanel and recieve an error stating

"
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', 14, NULL, NULL)
Filename: /home/******/public_html/storepanel/models/items_model.php
Line Number: 224


"


I've had a look on the forums about way in which I can fix it and can't seem to find a resolution trying the methods other people have tried. If you could help me I'd be very greatful.


Thanks
PrO Kill3R is offline
sk8terz0mbie
Junior Member
Join Date: May 2013
Location: California,USA
Old 12-20-2013 , 19:45   Re: Store Error
Reply With Quote #2

Quote:
Originally Posted by carnifexe View Post
unknown column 'flags' in 'field list'
means you need to add the field 'flags' into your database!
Go in store_items

click on top to sql add the code

alter table `store_items` add `flags` varchar(11) default null;

and press ok
wow it works......
__________________

Last edited by Arrow768; 12-21-2013 at 10:26. Reason: Added the quote tags
sk8terz0mbie is offline
Carnifexe
Member
Join Date: Nov 2004
Old 12-21-2013 , 05:06   Re: Store Error
Reply With Quote #3

Quote:
Originally Posted by Carnifexe View Post
There is no 1.2!
Unknown column 'flags' in 'field list'
Means you need to add the field 'flags' into your database!
GO in store_items

click on top to SQL add the code

ALTER TABLE `store_items` ADD `flags` varchar(11) DEFAULT NULL;

and press OK

WOW IT WORKS......

Quote:
Originally Posted by Carnifexe View Post

next time quote me sk8terz0mbie
Carnifexe is offline
paludan95
Junior Member
Join Date: Jun 2014
Old 06-20-2014 , 15:45   Re: Store Error
Reply With Quote #4

Quote:
Originally Posted by sk8terz0mbie View Post
wow it works......
Thanks
paludan95 is offline
Send a message via Skype™ to paludan95
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:29.


Powered by vBulletin®
Copyright ©2000 - 2022, vBulletin Solutions, Inc.
Theme made by Freecode