L2J Server

hi, i recently started creating a c5 l2j server using the latest version from nightlies, but i have a problem with database_installer, when i put f in gameserver database selection, it shows me an error:
"ERROR(1064)<42000> at line 6: You have an error in your SQL syntax; check the manual thats corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line22"
, and the same error more times with different numbers in other lines
please if some one can help me, im new in the l2j area, and dont know what to do.
thanks for the cool stuff!

what mysql version are you using ?

im using mysql ver. 5.5.24, is that right?, and i have other problem so, when i try to register the server, i put any number, and gives me the message that the id is too high, and i saw the servername.xml and 0 its ok for bartz but nothing happens, its all related with mysql?

viewtopic.php?p=152190#p152190
TL;DR: change TYPE to ENGINE in all .sql files, MySQL 5.1 had 'TYPE' before.

P.S. it would be nice if some DP dev could commit these SQL fixes for the old forks so people don't have to ask questions like this.

jurchiks wrote:viewtopic.php?p=152190#p152190
TL;DR: change TYPE to ENGINE in all .sql files, MySQL 5.1 had 'TYPE' before.

P.S. it would be nice if some DP dev could commit these SQL fixes for the old forks so people don't have to ask questions like this.

I have been thinking on that for a long time, but I was kinda lazy to donwload every datapack

yeah! thanks jurchiks, it was usefull, i look to files that didnt get instaled on the db from the sql folder, and change TYPE for ENGINE and works, thanks a lot, oh the other thing that i asked its ok, i hadnt the servername.xml file on the registergamerserver folder, anyway, those things make me understand some editing-stuff , thanks for the help!

Zoey76 wrote:I have been thinking on that for a long time, but I was kinda lazy to donwload every datapack

Whoever said you need to download the whole datapack? @shaorod - you're welcome.