Hercules Elf Bot - Jun 14, 2012 12:37
Originally posted by [b]plankt[/b]
@r16253+
The values were changed in some SQL files from 0 to NULL.
The columns however still have 'NOT NULL' defined.
Hercules Elf Bot - Jun 14, 2012 13:09
Originally posted by [b]Kenpachi[/b]
I'm really sorry. The imnport worked for me because I have a customized database.
Will be fixed soon and wont happen again. Sorry sorry sorry. @.@
Hercules Elf Bot - Jun 14, 2012 13:11
Originally posted by [b]manabeast[/b]
ya. me have problem executing item_db.sql . and i realize inside alot like # < - only this empty thing.. if this problem solve can pm me the item_db.sql? urgent need.
http://rathena.org/board/topic/65554-solverathena-svn-import-item-dbsql-error/
pls pm me the fix one if you have tq =)
This post has been edited by
manabeast
on Jun 14, 2012 13:12
Hercules Elf Bot - Jun 14, 2012 13:29
Originally posted by [b]Kenpachi[/b]
The item_db.sql is fine. It's PhpMyAdmin that sometimes can't handle commented (#) lines. I suggest to use the MySQL Workbench or the commandline tool instead.
But the NULL values in mob_skill_db that I commited are wrong and must be fixed ASAP. (I think can do it in the evening.)
Hercules Elf Bot - Jun 14, 2012 16:20
Originally posted by [b]manabeast[/b]
i remove the all the # infront. now no see error. is that ok one if i remove all those #?
This post has been edited by
manabeast
on Jun 14, 2012 17:11
Hercules Elf Bot - Jun 14, 2012 17:12
Originally posted by [b]jysn[/b]
it's on mob_db.sql and mob_db_re.sql. got problem on NULL.
Hercules Elf Bot - Jun 14, 2012 21:36
Originally posted by [b]Bahmut[/b]
@[url="http://rathena.org/board/user/472-manabeast/"]manabeast[/url]
just search and replace every # with --. Because some versions of phpmyadmin don't like # for commenting lines.
Hercules Elf Bot - Jun 15, 2012 2:13
Originally posted by [b]manabeast[/b]
ok, thx bahmut. i keep this one for me future use.
Hercules Elf Bot - Jun 15, 2012 10:46
Originally posted by [b]Kenpachi[/b]
Fixed in [rev=16304]. Sorry again...