Page 1 of 1

SQL Code Errors

Posted: Sat Mar 21, 2015 4:58 am
by xelloss
So tried an update. Looks like someone got messy in this table:

Code: Select all

INSERT INTO `mob_droplist` VALUES (4519,0,17854,133);
INSERT INTO `mob_droplist` VALUES (4520,0,11409,167);
INSERT INTO 'mob_droplist' VALUES (4521,0,2428,50);
INSERT INTO 'mob_droplist' VALUES (4521,0,2426,60);
INSERT INTO 'mob_droplist' VALUES (4521,0,2427,205);
' is not ` and Navi is not happy about it.

Re: SQL Code Errors

Posted: Sat Mar 21, 2015 12:03 pm
by kjLotus
looks like it was fixed now, thanks

for faster turnaround time, tell us in irc and it'll get fixed instantly

Re: SQL Code Errors

Posted: Sat Apr 18, 2015 7:19 pm
by xelloss
I don't have IRC readily available most times. Only when the main machine is on which is on off-work days. I don't have much reason to use it these days outside of getting scanlations.

Anyhow, necro'ing the thread because someone did it again. item_latents.sql has something wrong with it around Unicorn Leggings that's making Navicat pissy. Not anything with the SQL itself, it seems to be the comments? I erased the comments and it proceeded without issue. I noticed in the GIT change logs that there are spacing differences now, but I'm not sure if that's the issue or not. Notepad++ still shows them in green, but Navicat won't take it.

Re: SQL Code Errors

Posted: Sun Apr 19, 2015 2:59 am
by demolish