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!
[FIXED] help with database installer for c5
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
-
- Posts: 3
- Joined: Wed Sep 12, 2012 1:35 am
Re: help with database installer for c5
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?
- jurchiks
- Posts: 6769
- Joined: Sat Sep 19, 2009 4:16 pm
- Location: Eastern Europe
Re: help with database installer for c5
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.
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.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
- Zoey76
- L2j Inner Circle
- Posts: 7005
- Joined: Tue Aug 11, 2009 3:36 am
Re: help with database installer for c5
I have been thinking on that for a long time, but I was kinda lazy to donwload every datapackjurchiks 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.
Powered by Eclipse 4.30 | Eclipse Temurin 21 | MariaDB 11.3.2 | L2J Server 2.6.3.0 - High Five
Join our Discord!
Join our Discord!
-
- Posts: 3
- Joined: Wed Sep 12, 2012 1:35 am
Re: help with database installer for c5
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!
- jurchiks
- Posts: 6769
- Joined: Sat Sep 19, 2009 4:16 pm
- Location: Eastern Europe
Re: help with database installer for c5
Whoever said you need to download the whole datapack?Zoey76 wrote:I have been thinking on that for a long time, but I was kinda lazy to donwload every datapack
Code: Select all
svn co http://svn.l2jdp.com/branches/T2.4_DataPack/sql
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.