Archetype Saber Posted June 13, 2013 Group: Members Topic Count: 90 Topics Per Day: 0.02 Content Count: 361 Reputation: 19 Joined: 01/09/13 Last Seen: January 19 Share Posted June 13, 2013 when I execute the Item DB sql I got this error, i think it's about the version of my mysql query. but I just want to make sure. Quote Link to comment Share on other sites More sharing options...
DeadlySilence Posted June 13, 2013 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 181 Reputation: 53 Joined: 04/07/13 Last Seen: August 23, 2014 Share Posted June 13, 2013 (edited) The problem is the name. The string 'Lope's Clue' is interrupted by the apostrophe after Lope. You have to write the string like this: 'Lope\'s Clue' Edited June 13, 2013 by DeadlySilence 2 Quote Link to comment Share on other sites More sharing options...
Archetype Saber Posted June 13, 2013 Group: Members Topic Count: 90 Topics Per Day: 0.02 Content Count: 361 Reputation: 19 Joined: 01/09/13 Last Seen: January 19 Author Share Posted June 13, 2013 The problem is the name. The string 'Lope's Clue' is interrupted by the apostrophe after Lope. You have to write the string like this: 'Lope\'s Clue' REPLACE INTO `item_db` VALUES (6383,'Clue_Of_Lope','Lope\'s Clue',3,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); Like this ? thanks man, I should put this on bug track. Done. Quote Link to comment Share on other sites More sharing options...
Brian Posted June 13, 2013 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted June 13, 2013 Thanks for the bug report, I will fix this in the SVN. Quote Link to comment Share on other sites More sharing options...
Question
Archetype Saber
when I execute the Item DB sql I got this error, i think it's about the version of my mysql query. but I just want to make sure.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.