Author
|
Message
|
Junior Member
Join Date: Sep 2014
Location: Korea, Republic of
|
08-22-2015
, 00:02
MySQL (MariaDB) Syntax Error - Can't open Shop/Inventory
|
#1
|
First, I'm using my modified version of SourceMod:Store which is converted SMJansson to EasyJSON.
I will upload these things if this doesn't have bugs. (Currently no errors - Trails, Equipment, Skins, etc)
First when server opens, no errors.
But, when server changed the map, always get this error.
(~ 2015.08.19) MySQL: SQL Error on GetCategories: 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 '' at line 1
(2015.08.22 ~) MariaDB: SQL Error on GetCategories: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
and, also the other error is here. (I didn't check that error on MariaDB because I didn't change my servers private to public.)
MySQL: GetEquippedItemsByType: Lost connection to MySQL server during query
GetCategories: Lost connection to MySQL server during query
It's my problem or SourceMod:Store's problem?
Please give me the answer.
P.S: When I got syntax error, I can't open my inventory/shop.
It said "No categories are currently available."
and when I got lost connection error, I need to click twice when I'm choosing my items or open categories.
Last edited by Mr.Halt; 08-22-2015 at 00:03.
|
|
|
|