how to fix this server problem

Page 2 of 2 FirstFirst 12
Results 16 to 30 of 30
  1. #16
    Last of the OsRose Devs Purpleyouko is offline
    MemberRank
    Oct 2006 Join Date
    Missouri USALocation
    2,161Posts

    Re: how to fix this server problem

    Table 'roseon.skills_data' doesn't exist
    It's a table in your database
    Please take a look in your DB and see if there is a table called "skills_data
    It should be there.
    If it isn't then I suggest re-installing your database.

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

    Re: how to fix this server problem

    thx purpleyouko
    thank you :)

    n yeah i know im starting to annoy u.

    the last of all

    there is an error on roseevo installation.
    so i download avatar rose client.
    and put the launcher n a note pad "ICONFIG.NHD"

    n type in
    Code:
    [CFG]
    Server=127.0.0.1
    HTTPReg=yourwebcms.com/register.php
    HTTPNot=yourwebcms.com
    n my ip for my server is all default. i dont change. which is 127.0.0.1.


    so the problem is.......i cant log in. when i type anything n log in

    then i switch n check if there any entry in login.exe
    user connected.
    user disconnected.

    so how do i want to play..... :(

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

    Re: how to fix this server problem

    user connected.
    user disconnected.
    That is totally normal.
    When a player logs in they first go to the login server and it registers user connected.
    The login server then passes the player to the charserver and logs them out of the login server and registers user diconnected at the login.

    Do you get any error message on the client when you try to log in?

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

    Re: how to fix this server problem

    no error message...... but forever it says connecting.......
    i dont see no char select

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

    Re: how to fix this server problem

    something is configured wrong in your .conf files then
    either that or you have a corrupted charserver.exe that is not accepting the request from loginserver.exe
    I've seen that happen before

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

    Re: how to fix this server problem

    hmm but still cant :(
    ive try reinstall. the server. still cant log in n see the char select :(

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

    Re: how to fix this server problem

    do you have all 3 servers running?

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

    Re: how to fix this server problem

    i have 3 server running, everything is green light.
    im downloading rose evo client. i try to test it

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

    Re: how to fix this server problem

    Don't forget to patch it with the GG patch or else you won't be able to connect to your server using the latest NA Rose client. The packet architecture is completely different.

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

    Re: how to fix this server problem

    purpleyouku
    ive done it. guess my insticts tell me it was the client

    thank you so much for helping me to establish my server

    infact i can help ppl to. who have the prblems same as mine

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

    Re: how to fix this server problem

    Great news. Congrats on that.

  12. #27
    Enthusiast SolarisJ is offline
    MemberRank
    Jan 2009 Join Date
    27Posts

    Re: how to fix this server problem

    hmm i have a problem now lol,

    this is my current code under startup.cpp/loadskilldata()

    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,buffv3 2,clevel,aoe,aoeradius,script,value1 FROM skills_data order by id");

    *note: buffv3 2 is supposed to be together without the space

    I've added the brackets for special words in SQL such as level, type and range.. is there anything else I have to do? Im getting the same error as the above mentioned =\

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

    Re: how to fix this server problem

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

    Change the .level remove the ' on 'level' and 'type' and recompile it and it should work fine after that and use the new compiled Worldserver.exe and shoudl start up and the one 'range' is good dont remove that one

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

    Re: how to fix this server problem

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

    Should look like this

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

  15. #30
    Enthusiast SolarisJ is offline
    MemberRank
    Jan 2009 Join Date
    27Posts

    Re: how to fix this server problem

    Thanks dudes, great help it has been xD fixed it and got the server running smoothly =)



Page 2 of 2 FirstFirst 12

Advertisement