SQL Problem

[RavenStylez]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4422
L2JDP Revision Number: 7669

(I'm not sure if this is the rights place for this thread...)

Hello L2J Members,

I'm posting here because I have a problem with installing my database...
The thing is that I've had an L2J server before, without any problems.
I have completely removed everything of the old server and want to start from scratch, but now, when I'm installing my database, it gives me errors at npc.sql and spawnlist.sql.

I have logged the errors and this is what came in the log files:

install-npc.sql.log:

Code: Select all

zo 14-11-2010 17:50ERROR 1064 (42000) at line 180: 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 '',40,3290,1524,0.00,0.00,40,43,30,21,20,20,0,0,1627,577,1117,384,230,0,333,0,0,0' at line 93

install-spawnlist.sql.log:

Code: Select all

zo 14-11-2010 17:50ERROR 2013 (HY000) at line 4585: Lost connection to MySQL server during query

I have also tried to add them manual, but that's giving me even more errors. All errors are considering the syntax...

Anybody who knows what to do? (I haven't changed ANYTHING within the files, just a fresh download.)

THANKS IN ADVANCE!

[web]

Hmm this is a little strange.
I guess you left the old tables in the database and this is why you get the error, if not i sugest you to create a new database and install it useing the installer in the tools folder.
Hope you will fix your errors this way.

[RavenStylez]

Well, I tried what u said, but it gave the exact same result...
Then, I thought it might be the MySQL program, but, no -.-
Tried with MySQL and EasyPHP, both not working :\
My previous server was with EasyPHP, so I thought it should work then, but no -.-

When I'm in phpMyAdmin and try to manually insert it from there, I get these errors:

npc.sql (as you can see it does the first part, until it gets to the second 'INSERT INTO'):

Code: Select all

Error SQL query: INSERT INTO `npc` VALUES (12077,12077,'Wolf',0,'',0,'LineageMonster.pet_wolf',13.00,11.50,15,'male','L2Pet',40,195,164,3.95,1.21,40,43,30,21,20,25,0,0,9,19,3,17,304,0,333,3907,0,0,24,125,0,0), (12311,12311,'Hatchling of the Wind',0,'',0,'LineageMonster.hatchling',9.00,10.00,35,'male','L2Pet',40,610,433,7.11,1.84,40,43,30,21,20,25,0,0,48,42,22,39,278,0,333,0,0,0,80,140,0,0), (12312,12312,'Hatchling of the Stars',0,'',0,'LineageMonster.hatchling',9.00,10.00,35,'male','L2Pet',40,610,433,7.11,1.84,40,43,30,21,20,25,0,0,48,42,22,39,278,0,333,0,0,0,80,140,0,0), (12313,12313,'Hatchling of Twilight',0,'',0,'LineageMonster.hatchling',9.00,10.00,35,'male','L2Pet',40,610,433,7.11,1.84,40,43,30,21,20,25,0,0,48,42,22,39,282,0,333,0,0,0,88,154,0,0), (12526,12526,'Wind Strider',0,'',0,'LineageMonster.strider',23.00,31.00,55,'male','L2Pet',40,2728,1138,10.27,2.45,40,43,30,21,20,25,0,0,703,332,360,301,304,0,333,5178,0,0,80,170,0,0), (12527,12527,'Star Strider',0,'',0,'LineageMonster.strider',[...] MySQL said: Documentation#2006 - MySQL server has gone away

spawnlist.sql (when cutting it in 2 pieces (coz it's too big otherwise...)):

Code: Select all

Error SQL query: DocumentationEdit SELECT `comment`FROM `phpmyadmin`.`pma_column_info`WHERE db_name = 'l2jdb'AND table_name = ''AND column_name = '(db_comment)' MySQL said: Documentation#2006 - MySQL server has gone away

Soo f-ed up -.-

[hope]

Upload into a zip file the full thing you are trying to add will fix it for you

[RavenStylez]

I'm just trying to add the standard SQL files to my (empty) database...
With standard I mean the Nightly ones... (I also have eclipse, but I thought that Nightly might help fixing this problem, but it didn't...)

[jurchiks]

try something other than phpmyadmin, god knows what's wrong with that thing but the sql tables are correct.
if even the database_installer.bat/sh doesn't work for you, then it's most probably something wrong with mysql.

[hope]

You just trying to add the normal npc SQL table? Try deleting the old table before you upload the new one

[web]

Try to install mysql server, don't use apache, mysql, php packs. From what i see there your problem is the connection with the mysql server, not the script itself.

[RavenStylez]

Nothing seems to work... I've decided to just back-up my whole pc and then format it.
This way I finally have some space again
I'll just take the external hard drive with me to wherever I go and all problems are hopefully solved ^^

[RavenStylez]

*bump* getting my external hd today and hopefully things ll get fixed. Anyway what I find weird is, that if I use old files, it works perfectly, but the Freya files fail.