[CS:GO]Problem

NrX · **Author**

Quote:

[Store] SQL Error on GetItems: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY Priority ASC' at line 1
[Store] SQL Error on GetItems: Unknown column 'priority' in 'field list'

downloaded the newest version of the store plugin 1.2.4a but when i type !store and try to buy something or open my inventory doesn't work.

Robin955 · 04-20-2015 , 13:40 Re: [CS:GO]Problem

just a guess here, did you import the upgrade to ur store mysql database when upgrading to 1.2.4a?
https://github.com/Drixevel/store/tr...l-init-scripts

NrX · 04-20-2015 , 13:48 Re: [CS:GO]Problem

Quote:

Originally Posted by Robin955

just a guess here, did you import the upgrade to ur store mysql database when upgrading to 1.2.4a?
https://github.com/Drixevel/store/tr...l-init-scripts

well when i try to upload show that

Quote:

Error
Query SQL:

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

Mensage do MySQL: Documentation

#1060 - Duplicate column name 'flags'

Robin955 · 04-20-2015 , 14:15 Re: [CS:GO]Problem

and what happends when you type !store now?

NrX · 04-20-2015 , 14:54 Re: [CS:GO]Problem

when i type !store it appears but when i try to click shop or inventory or refund the !store just close

Robin955 · 04-20-2015 , 15:53 Re: [CS:GO]Problem

same warning as before? when you do !shop? in steamCMD

Drixevel · 04-20-2015 , 21:57 Re: [CS:GO]Problem

Quote:

Originally Posted by NrX

well when i try to upload show that

Open up the file and remove the 1st line entirely then save & try it again.

NrX · 04-20-2015 , 22:28

Quote:

Originally Posted by r3dw3r3w0lf

Open up the file and remove the 1st line entirely then save & try it again.

Quote:

Query SQL:

ALTER TABLE `store_items` ADD COLUMN `priority` INT( 11 ) NOT NULL DEFAULT '0' AFTER `id` ;

Mesage MySQL: Documentation

#1060 - Duplicate column name 'priority'

Well i think it works now thanks !

darkyy1994 · 11-04-2015 , 14:07 Re: [CS:GO]Problem

Hey for me happened the same just in css... :/ i did it same like here but when i upload new items (.json file to webinterface) they appear in webinterface but not on the server (still just close the shop)

thanks for helping

EDIT :

Quote:

L 11/04/2015 - 19:10:14: [Store] SQL Error on GetCategories: Unknown column 'priority' in 'field list'
L 11/04/2015 - 19:10:27: [Store] SQL Error on GetCategories: Unknown column 'priority' in 'field list'
L 11/04/2015 - 19:11:11: [Store] SQL Error on GetCategories: Unknown column 'priority' in 'field list'

thats my log :/