World Server Fatal Error

Place your questions about osirose here

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Re: World Server Fatal Error

Postby Rescudo on Wed Jul 23, 2008 1:00 pm

If you look at your error message it would be quite obvious which range you were supposed to change ...
MYSQL_RES *result = DB->QStore("SELECT id, map, x, y, range, respawntime, `limit`, tacticalpoints, moblist FROM list_mobgroups"); 
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: World Server Fatal Error

Postby Russak88 on Wed Jul 23, 2008 1:10 pm

Okay thanks i thought so but i was not 100% sure. I have changed it but the Fatal Error still appears. This above the range is a comma which belong to the manual and its not an apostrophe or something like that.
Russak88
Jelly Bean
Jelly Bean
 
Posts: 16
Joined: Tue Jul 22, 2008 7:27 pm

Re: World Server Fatal Error

Postby Rescudo on Wed Jul 23, 2008 1:32 pm

Try ` or ´.
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: World Server Fatal Error

Postby Russak88 on Wed Jul 23, 2008 9:34 pm

I have tried all with ´ or ` or other things but the Fatal Erros still appears...

Thanks for your help

BTW: Can anybody say me which client is better to use and cleaner?
the Hrose or the krose client?

Thx a lot :)
Russak88
Jelly Bean
Jelly Bean
 
Posts: 16
Joined: Tue Jul 22, 2008 7:27 pm

Re: World Server Fatal Error

Postby PurpleYouko on Thu Jul 24, 2008 2:19 pm

There should not be anything around range
the line of code should be
  1. MYSQL_RES *result = DB->QStore("SELECT id, map, x, y, range, respawntime, `limit`, tacticalpoints, moblist FROM list_mobgroups");

The only reason there are any kind of punctuation marks around 'limit' is that limit is a reserved command word in mysql so we have to make sure it is read in as a variable and not a command.

range should work fine without apostrophes or anything.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: World Server Fatal Error

Postby Rescudo on Thu Jul 24, 2008 2:25 pm

Not in MySQL 6.0 ... that's why we were having this discussion in the first place, remember?
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: World Server Fatal Error

Postby PurpleYouko on Thu Jul 24, 2008 2:58 pm

well if range is a reserved word in 6.0 it should be as simple as making range into `range` shouldn't it?

Do we have something inherently incompatible with 6.0 in our server?
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: World Server Fatal Error

Postby Rescudo on Thu Jul 24, 2008 3:30 pm

PurpleYouko wrote:well if range is a reserved word in 6.0 it should be as simple as making range into `range` shouldn't it?

... yes, that is exactly what this is all about ... :roll:
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: World Server Fatal Error

Postby PurpleYouko on Thu Jul 24, 2008 3:45 pm

But did we actually determine whether 'range' is a reserved word in 6.0. i didn't actually see that in this thread. Or was that in another thread that I missed?
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: World Server Fatal Error

Postby Rescudo on Thu Jul 24, 2008 4:09 pm

SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

PreviousNext

Return to Question Zone

Who is online

Users browsing this forum: No registered users and 3 guests

cron