Fatal Error in World Server

[salleh]

Anyone knows how to fix this error. I'm using rev 76 and I try rev 77 and rev 78 but I got the same error.

[MentaL]

[tompirlet]

not sure, but i get this :

[Paco44]

Are you sure you did not edit your class_skills file manually?

[carru]

i get exactly the same error as tompirlet n i havnt edited any file (happens with rev 59 n 76)

carru ~

[Paco44]

I have 76 and did not get this error so I'm not sure how to fix it.

[Lolkereltje]

I got this problem too with a few rev's ago. It was solved when I updated the database with the .sql file again.

[carru]

i've been trying with rev76
first i execute the bat with full install n then i use the osrose_backup.sql on navicat but worldserver keeps saying theres a problem with the syntax
the fact is that i dont know in wich file there's the mistake -.-

thanks for ur time,
carru ~

[Miltown]

Anyone knows how to fix this error. I'm using rev 76 and I try rev 77 and rev 78 but I got the same error.

i got this same problem

[Shamazing]

the same here. A more detailed error:

Sun Sep 09 22:21:34 2007 [INFO]: Autosaving Every 2 minutes
Sun Sep 09 22:21:34 2007 [INFO]: Connecting to MySQL
Sun Sep 09 22:21:34 2007 [INFO]: SQL timeout set to 2678400 seconds
Sun Sep 09 22:21:34 2007 [INFO]: Connected to MySQL server
Sun Sep 09 22:21:34 2007 [LOADING]: Zone Data

Sun Sep 09 22:21:34 2007 [INFO]: Map 11 is CF mode 1 !
Sun Sep 09 22:21:34 2007 [INFO]: Map 12 is CF mode 1 !
Sun Sep 09 22:21:34 2007 [INFO]: Map 13 is CF mode 1 !
Sun Sep 09 22:21:34 2007 [LOADING]: Consumible Data

Sun Sep 09 22:21:34 2007 [LOADING]: Sell Data

Sun Sep 09 22:21:34 2007 [LOADING]: Product Data
Sun Sep 09 22:21:34 2007 [LOADING]: Consumible Data
Sun Sep 09 22:21:34 2007 [LOADING]: Natural Data
Sun Sep 09 22:21:34 2007 [LOADING]: Jem Data
Sun Sep 09 22:21:34 2007 [LOADING]: Equip Data
Sun Sep 09 22:21:34 2007 [LOADING]: Item Stats
Sun Sep 09 22:21:34 2007 [LOADING]: Skills data
Sun Sep 09 22:21:34 2007 [FATAL ERROR]: Could not execute query: 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 'range,target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv' at line 1

[Paco44]

Probably is a bad Database or something.

[cloudgr]

Same here.. Using rev76 and mysql5.1 ~

[monkeyrose]

Where ever you launch your executables from (usually Binary), create a directory called 'Log'. Then attempt to launch your server again. A new file will be created in the log directory 'queries.txt'. This contains all the queries issued to MySQL. Post the query that failed, you could also run that query from Navicat.

[Shadow]

Just update to revision 80:

https://opensvn.csie.org/osrose/

[boodog]

Still same error.

[Purpleyouko]

the problem is with the version of mysql being run at the server.

This error happens when you run version 6.XX
It doesn't happen with 5.XX

Fortunately the fix for this is incredibly simple.

just open Startup.cpp and look in function LoadSkillData()

In it you will find an sql query
it will look something like this

Log( MSG_INFO, "Loading New Skills data" );    
	MYSQL_ROW row;    
	MYSQL_RES *result = DB->QStore("SELECT id,level,levelupcost,skilltype,range,targettype,aoerange,power,\
    duration,costtype,cost,cooldown,summonid,weapon1,weapon2,weapon3,weapon4,weapon5,job1,job2,job3,job4,preskill1,level1,\
    preskill2,level2,preskill3,level3,reqtype,reqvalue,status1,stat1,statval1,statval1a,status2,stat2,statval2,statval2a,\
    status3,stat3,statval3,statval3a FROM list_new_skills order by id");
    if(result==NULL) 
    {
        DB->QFree( );
        return false;
    }

Probably not exactly though since this cam from a very old server.

In the query look for the word range
replace it with 'range'
recompile and it will work fine
The problem is that in mysql 6.xx versions, range is a keyword but in our database, we are using it as a field name.