Jump to content

  •  

Bug Tracker Migration

June 3rd
Good news everyone! The staff has decided that it is time to slowly kill off this Bug Tracker. We will begin the process of slowly migrating from this Bug Tracker over to our Github Issues which can be found here: https://github.com/HerculesWS/Hercules/issues

Over the next couple of days, I will be closing off any opportunity to create new reports. However, I still will keep the opportunity to reply to existing Bug Reports. Doing this will allow us to slowly fix any bug reports we have listed here so that we can easily migrate over to our Issue Tracker.

Update - June 7th 2015: Creating new bug posts has been disabled. Please use our https://github.com/HerculesWS/Hercules/issues tracker to post bugs. Users are still able to reply to existing bug posts.

- Administration

Issue Information

  • #008232

  • 0 - None Assigned

  • Unable To Reproduce

Issue Confirmations

  • Yes (0)No (0)
Photo

mob_skill_db while importing on Mysql

Posted by DeviantRaze on 14 June 2014 - 02:04 AM

Error
SQL query:

# REPLACE INTO `mob_skill_db` VALUES (1244,'Christmas Jakk@NPC_EMOTION','idle',197,1,500,0,5000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL); # REPLACE INTO `mob_skill_db` VALUES (1245,'Christmas Goblin@MG_FROSTDIVER','attack',15,5,500,1000,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL); # REPLACE INTO `mob_skill_db` VALUES (1245,'Christmas Goblin@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',0,18,NULL,NULL,NULL,NULL,NULL,NULL); # REPLACE INTO `mob_skill_db` VALUES (1245,'Christmas Goblin@NPC_EMOTION','chase',197,1,200,0,5000,'yes','self','always',0,19,0x81,NULL,NULL,NULL,NULL,NULL); # REPLACE INTO `mob_skill_db` VALUES (1245,'Christmas Goblin@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always',0,2,0x3695,NULL,NULL,NULL,NULL,NULL); # REPLACE INTO `mob_skill_db` VALUES (1245,'Christmas Goblin@NPC_WINDATTACK','attack',187,2,500,500,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALU[...]

MySQL said: Posted Image
#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 `mob_skill_db` VALUES (1246,'Christmas Cookie@MG_COLDBOLT','chase',' at line 8


Please delete this post if im wrong. but when i import mob_db_skill this error pop up. anyone?

Maybe something to do with phpMyAdmin limit,
I got:
 Import has been successfully finished, 5517 queries executed. (mob_skill_db.sql)

Are you using latest mob_skill_db: https://github.com/H...ob_skill_db.sql

@Dastgir Yes i am. maybe ill try it again. :(

changed status to: Unable To Reproduce