SQL Code Errors

[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.

[kjLotus]

looks like it was fixed now, thanks

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

[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.

[demolish]

https://github.com/DarkstarProject/dark ... 0061e712d9