SQL fould! Help please:D

Results 1 to 9 of 9
  1. #1
    Enthusiast mangoking is offline
    MemberRank
    Apr 2010 Join Date
    41Posts

    SQL fould! Help please:D

    Hi Ragezone members,

    I've have today try to make a server and I want put a roseon.sql file into my MySQL server?

    Every time If try it say "Unsuccesfull" ?

    And when I try to start Loginserver, char,server and world server Ill get a fould?

    Screenshots:
    1.:http://i39.tinypic.com/257lq38.jpg
    2.:http://i43.tinypic.com/2nv3rih.jpg


    Mabye u can help me:D

    Thanks alot.

    Regards,

    Mitch
    Last edited by mangoking; 02-05-10 at 08:16 PM.


  2. #2
    Account Upgraded | Title Enabled! perrin9028 is offline
    MemberRank
    Nov 2007 Join Date
    806Posts

    Re: SQL fould! Help please:D

    In the first picture, scroll up to the top of the error message and it should tell you what's wrong. If you unsure about what it says, either put up another picture or upload the SQL file and I can probably fix it.

  3. #3
    Novice jacilbyr is offline
    MemberRank
    May 2010 Join Date
    3Posts

    Re: SQL fould! Help please:D

    Hey,
    I'm working with Mitch to make that server.
    Here is a picture of the error it's giving:
    http://i43.tinypic.com/163mzd.jpg

    I don't get it, I can't find that file on my pc.

    I hope you know a solution to fix this. :)

    Thanks in advance.

  4. #4
    Account Upgraded | Title Enabled! perrin9028 is offline
    MemberRank
    Nov 2007 Join Date
    806Posts

    Re: SQL fould! Help please:D

    The error it's giving you says that the value for class skills is too large. To fix it, you need to change the type of class skills. Typically, it should be varchar(255) as the type. See if you can find this line in your SQL file:

    `class_skills` varchar(255) NOT NULL default '0',

    If you can't find it, that's probably the problem.

  5. #5
    Novice jacilbyr is offline
    MemberRank
    May 2010 Join Date
    3Posts

    Re: SQL fould! Help please:D

    Thanks a lot, it worked.
    But now I have another problem:
    every time I try to run the exe, I get this message:

    http://i41.tinypic.com/2vkyolw.jpg

    I've putted my exe file in the Rose directory and started Loginserver, Charserver and Worldserver.
    Do you know a solution to this problem?

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

    Re: SQL fould! Help please:D

    Sounds like you have a very screwed up rose installation. This has nothing to do with your server. Your client is missing important files. Try re-installing.

  7. #7
    Novice jacilbyr is offline
    MemberRank
    May 2010 Join Date
    3Posts

    Re: SQL fould! Help please:D

    Ow okay thanks.
    But when I re-install the game, do I need to do something special with my server settings? Or just drag the launcher in it and done? :)

  8. #8
    Account Upgraded | Title Enabled! perrin9028 is offline
    MemberRank
    Nov 2007 Join Date
    806Posts

    Re: SQL fould! Help please:D

    Generally you have to configure the launcher too

  9. #9
    Account Upgraded | Title Enabled! fransh is offline
    MemberRank
    Jun 2010 Join Date
    Junon polisLocation
    285Posts

    Re: SQL fould! Help please:D

    I also have this problem, but what do i have to change exactly?

    pm me please!



Advertisement