Invalid MySQL Syntax in item_db.sql
Warning! This is the old Hercules bugtracker archive, and may not reflect the current state of Hercules. The current bugtracker is on GitHub Issues.
Issue information
Issue ID
#3082
Status
Working as Intended
Severity
None
Started
Hercules Elf Bot
May 16, 2009 2:21
Last Post
Hercules Elf Bot
Dec 13, 2011 20:42
Confirmation
Hercules Elf Bot - May 16, 2009 2:21
Originally posted by [b]Forgott3n[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=3082
Several trunk revisions have had this now. Tried multiple times on multiple machines over multiple revisions.
The error is as follows:
SQL query:
MySQL said:
Attached is Trunk r13773's item_db.sql file.
This post has been edited by Forgott3n: May 15 2009, 07:23 PM
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=3082
Several trunk revisions have had this now. Tried multiple times on multiple machines over multiple revisions.
The error is as follows:
SQL query:
CODE
# REPLACE INTO `item_db` VALUES (2736,'...','...',5,0,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,136,NULL,75,0,0,'bonus bDex,3; bonus bLuk,3; bonus bMdef,2;',NULL,NULL);
# REPLACE INTO `item_db` VALUES (2737,'...','...',5,0,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,136,NULL,75,0,0,'bonus bVit,3; bonus bMaxHPRate,10;',NULL,NULL);
REPLACE INTO `item_db`
VALUES ( 2738, 'Commemorative_Coin', 'Shining Commemorative Coin', 5, 0, NULL , 0, NULL , 1, NULL , 0, 0xFFFFFFFF, 7, 2, 136, NULL , 80, 0, 0, 'bonus bAtkRate,6; bonus bMatkRate,6;', NULL , NULL );
# REPLACE INTO `item_db` VALUES (2737,'...','...',5,0,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,136,NULL,75,0,0,'bonus bVit,3; bonus bMaxHPRate,10;',NULL,NULL);
REPLACE INTO `item_db`
VALUES ( 2738, 'Commemorative_Coin', 'Shining Commemorative Coin', 5, 0, NULL , 0, NULL , 1, NULL , 0, 0xFFFFFFFF, 7, 2, 136, NULL , 80, 0, 0, 'bonus bAtkRate,6; bonus bMatkRate,6;', NULL , NULL );
MySQL said:
CODE
#1064 - 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 'REPLACE INTO `item_db` VALUES (2739,'Commemorative_Coin_','General\'s Commemorat' at line 3
Attached is Trunk r13773's item_db.sql file.
This post has been edited by Forgott3n: May 15 2009, 07:23 PM
Attached File(s)
