how to fix this server problem

Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    Proficient Member djcyber is offline
    MemberRank
    Jan 2009 Join Date
    172Posts

    Question how to fix this server problem

    Can any one explain me how to fix this i tried manny thing and still cant get it to work for connecting to my own server plz help me out here a picture of the problem and when i click connect i can log in but cant ether the server can any one help me out thx
    Attached Thumbnails Attached Thumbnails roseonlineserverproblem.jpg  


  2. #2
    TGN Studio's lCON is offline
    MemberRank
    Jan 2007 Join Date
    939Posts

    Re: how to fix this server problem

    It appears you have a error in your sql syntax
    Takes me to state the oblivious.
    Any ways not sure about these files source code but something in your sql call is formatted wrong, Or not compliant with your mysql version.

  3. #3
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    I spy the word range in that sql query.

    I've answered this several times before. You should be able to find a detailed explanation in these forums if you use search.

    In a nutshell though, the code was written for an earlier version of mysql. in later versions, range has become a keyword so we can't use it as a variable unless we wrap it in smart quotes.
    try replacing range with 'range' in the query that you will find in startup.cpp / function loadskilldata()

  4. #4
    Proficient Member djcyber is offline
    MemberRank
    Jan 2009 Join Date
    172Posts

    Re: how to fix this server problem

    ya ill try out a lastes sql and see what will it give me and see if i dont get it working ill be asking again if i dont find the search of what i need

  5. #5
    Proficient Member djcyber is offline
    MemberRank
    Jan 2009 Join Date
    172Posts

    Re: how to fix this server problem

    ok i tried to change range and still wont load up and i changed mysql to latest and still got this problem of that range error and i done a search the site keep giving me error everytime i do search

    this is what i got in the range section

    bool CWorldServer::LoadSkillData( )
    {
    Log( MSG_LOAD, "Skills data " );
    MYSQL_ROW row;
    MYSQL_RES *result = DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv11,buffv12, buff2,buffv21,buffv22,buff3,buffv31,buffv***clevel,aoe,aoeradius,script,value1 FROM skills_data order by id");
    if(result==NULL) return false;
    while( row = mysql_fetch_row(result) )
    {
    CSkills* newskill = new (nothrow) CSkills;
    if(newskill==NULL)
    {
    Log(MSG_ERROR, "Error allocing memory" );
    DB->QFree( );
    return false;

  6. #6
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    look at what you have written here

    DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp,

    I see your problem problem?

    You have no commas before and after 'range'

    try this instead

    DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,

    size increased for ease of reading

  7. #7
    Proficient Member djcyber is offline
    MemberRank
    Jan 2009 Join Date
    172Posts

    Re: how to fix this server problem

    OH yaaa i got it wooot thx so mutch hehehe

  8. #8
    Member azmancloud7 is offline
    MemberRank
    Feb 2009 Join Date
    dark pallaceLocation
    55Posts

    Re: how to fix this server problem

    here is my problem
    Code:
     
    Wed Feb 04 23:21:28 2009 [INFO]: osRose Revision 80
    Wed Feb 04 23:21:28 2009 [INFO]: Autosaving Every 2 minutes
    Wed Feb 04 23:21:28 2009 [INFO]: Connecting to MySQL
    Wed Feb 04 23:21:28 2009 [INFO]: SQL timeout set to 2678400 seconds
    Wed Feb 04 23:21:28 2009 [INFO]: Connected to MySQL server
    Wed Feb 04 23:21:28 2009 [INFO]: Map 11 is CF mode 1 !
    Wed Feb 04 23:21:28 2009 [INFO]: Map 12 is CF mode 1 !
    Wed Feb 04 23:21:28 2009 [INFO]: Map 13 is CF mode 1 !
    Wed Feb 04 23:21:28 2009 [FATAL ERROR]: Could not execute query: You have an err
    or in your SQL syntax; check the manual that corresponds to your MySQL server ve
    rsion for the right syntax to use near 'range,target,power,duration,mp, success,
    weapon,class,rskills,lskills,buff1,buffv' at line 1
    


    Quote Originally Posted by Purpleyouko View Post
    look at what you have written here

    DB->QStore("SELECT id,level,sp'range'type,target,power,duration,mp,

    I see your problem problem?

    You have no commas before and after 'range'

    try this instead

    DB->QStore("SELECT id,level,sp,'range',type,target,power,duration,mp,

    size increased for ease of reading
    purple i have the same problem as he is.
    i put as wat u say. but still the cant.

    Code:
    Log( MSG_LOAD, "Skills data" );    
    	MYSQL_ROW row;    
    	MYSQL_RES *result = DB->QStore("SELECT id,level,sp,type,'range',target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv11,buffv12, buff2,buffv21,buffv22,buff3,buffv31,buffv***clevel,aoe,aoeradius,script,value1 FROM skills_data order by id");
        if(result==NULL) return false;
    	while( row = mysql_fetch_row(result) )

  9. #9
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    I notice this in your code
    Code:
    buff3,buffv31,buffv***clevel,aoe
    i think that is a feature of the forums that it converts 32 comma into *** but just make sure you haven't copied it in from a code box here
    It won't even let me write 3 2 , without the spaces

    other than that i don't see anything obviously wrong with your query. In the code box it looks fine.
    this is perfect
    Code:
    DB->QStore("SELECT id,level,sp,type,'range',target
    in the error though, it's different.
    Code:
    syntax to use near 'range,target,power
    range has no smart quotes
    The quote that I highlighted in lime is not part of your query but is rather part of the error message

    Did you recompile after editing it?
    It doesn't look like you did.

  10. #10
    Member azmancloud7 is offline
    MemberRank
    Feb 2009 Join Date
    dark pallaceLocation
    55Posts

    Re: how to fix this server problem

    im not quite sure how to recompile. so i leave it :p
    sory bout that. huhuhu
    ok il try to recompile by following the guide. thx :)

  11. #11
    Member azmancloud7 is offline
    MemberRank
    Feb 2009 Join Date
    dark pallaceLocation
    55Posts

    Re: how to fix this server problem

    purpleyoko. sory to disturb u again.

    fter the libmysql package is installed, we need to change a few lib paths. Open up your project (such as worldserver.dev, which can be found in the "worldserver" folder) Go to menu "Project>project option".
    2. Go to "parameters" tab and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a"
    for you correct path.


    i go to the paramaters tab. mine shows empty in the compiler and C++ compiler box. no "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a"

    Open DEV C++ and in the menu go to "Project>Project Option". Then go to the tab "Parameters" and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a" to their correct paths, (look for files in the "lib" folder, and just copy and path).

    where is the folder named lib??


    plz purple help me

  12. #12
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    the lib folder is located in the root folder of your dev-cpp installation which should be (as a default) C:/Dev-Cpp/lib

    in the parameters tab of your dev-cpp program you should see 3 text areas.

    just make sure that in the right hand one, you have this
    -lmysql -lpthreadGC -lws2_32
    That should be all you need. If it doesn't work by just pasting that in then you should click on the button underneath the box ( it is labelled "Add library or Object")
    click this button then navigate to C:/Dev-Cpp/lib/libws2_32.a
    select it and click OK
    then do the same again for C:/Dev-Cpp/lib/libmysql.a
    Then one more time for C:/Dev-Cpp/lib/libpthreadGC.a

    You need all three of them.

    Those should be the correct paths unless you installed dev-cpp in an unusual place such as on your D: drive or something.

    Give it a try and tell me if it doesn't work.

  13. #13
    Member azmancloud7 is offline
    MemberRank
    Feb 2009 Join Date
    dark pallaceLocation
    55Posts

    Question Re: how to fix this server problem

    thx purple
    i dont need to add. cuz i have the -lmysql -lpthreadGC -lws2_32

    the last task.......... hope im not annoying u. so sorry

    Now, to compile the .exe, open the .dev (loginserver.dev, charserver.dev, worldserver.dev) and click on the menu "Execute>Rebuild All". And you have the .exe inside the sources folder!

    he ask to open the 3 *.dev in devc++
    but i cant open the three project at the same time.

  14. #14
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    just open worldserver.dev that's the only one we have changed

    To do all 3 you would have to open then compile them all one by one. you can't do all 3 at once.

    So just open Worldserver.dev (make sure you have the changes with 'range')
    Execute->rebuild all and it will create you a new worldserver.exe in your binary folder
    if you didn't make any changes to any .h (header) files then you can even do Execute->Compile for a much quicker build.
    If it is teh first time that you have compiled your server it will do a full compile either way.

    Like i said, you didn't change anything in loginserver.dev or charserver.dev so you won't need to recompile those unless you don't have them already.

    the last task.......... hope im not annoying u. so sorry
    No you aren't annoying me.
    Answering questions is what i do.
    It's my job to give you guys tech support on the osrose servers . That's why I'm a Mod here

  15. #15
    Member azmancloud7 is offline
    MemberRank
    Feb 2009 Join Date
    dark pallaceLocation
    55Posts

    Re: how to fix this server problem

    ok done but there is another problem.........

    it says
    Code:
    Thu Feb 05 03:59:17 2009 [FATAL ERROR]: Could not execute query: Table 'roseon.s
    kills_data' doesn't exist



Page 1 of 2 12 LastLast

Advertisement