Getting errors with osirose server

[hedgy]

Hello, I'm trying to make an osirose server.
But I'm getting some errors :( I hope someone can help me out:

I'm using this guide: http://forum.ragezone.com/f291/osiro...-setup-384132/

One thing at the guide isn't going correctly here.

Open navicat, open the connection you made, and open up the database by Double clicking it so it turns green and opens up. Then right click the database(see here), Click on execute Batch file, and a new window pops open. (See here)Click on the 3 dots to the right of the File: Field. Navigate to the database folder, where the database that I provided is at. (in the server folder.) Open irose.sql and let it load. It may take awhile. After it loads should look something like this After the database is in, start up each of the servers, one by one. Login, Character, World. For me the world keeps crashing at start up, if it does this to u, and gives you no real errors, just keep restarting it, it will start eventually. (I think its because of vista) once you get them started, should look something close to this

When I open up this irose.sql I get this error:

[Err] 1217 - Cannot delete or update a parent row: a foreign key constraint fails
[Err] --
-- Gegevens worden uitgevoerd voor tabel `channels`
--


-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `characters`
--

DROP TABLE IF EXISTS `characters`;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

(Sorry for those dutch lines. But it's about the channels table and characters table. )

Further information: Login server works correctly, other 2 get errors and closes after it fast. (I hope those will get away when the error from navicat is fixed, I'll notice if it wont)
Anyway if I print screen those fast I get at charserver:


And when I startup world server:

(This error will be gone when I got the charserver right I guess?)


How it looks ingame I dont know yet, still looking for a nice client since the 131client download is broken. (Tried differend sites searched @ google didn't found :( ) I tried bratok rose & titan rose but I cant extract the 3Ddata from those games.

Hope someone can help me. Thanks. ^^

Ps> Any beginner tips are welcome, I also would like to know the client I could use the best or a working link to the 131client. thanks :)

[MentaL]

[perrin9028]

Execute the tables by hand, it will give you more control over it rather than blindly trusting a batch file. If one of them is unsuccessful, the error will be at the top and you can put that here.

As for the ISC, try making a firewall exception for your world server, I don't know why it would work, but sometimes it does. Either that or restart it a couple times. Usually fixes most problems. However, if it keeps happening, open the WorldServer .cbp or .dev file and debug it.

As far as I know, there's a working 131 client on FileFront somewhere. I believe there was a link to it recently so you might try using the search function in this subforum. You could also use the HRose client that's around the internet somewhere. If nothing else, just ask someone to upload it for you.

[hedgy]

(full edit)
Nevermind about what was standing here before :D Thanks a lot for helping. I guess it works now.

[merlon]

look at this thread it works 100% cuz i made it lol:
http://forum.ragezone.com/f291/osiro...aswell-682569/