Problem starting server

[IAPills]

When I start World.exe it loads doe a split second then it closes it self. It says up long enough for me to read "Error could not load.." its the the only thing i can read. The same thing happens when I run Boot5zones.exe.

I did everything exactly as the readme says. I did notice a few strange things:

3.4) This part might be a little tricky for some, so read word-by-word.

- Go to your MySQL bin directory ( C:\mysql\bin ) and open " mysql.exe "

- Now type the following in this order ( Type one line, hit enter, move on to next)

create database eq;

use eq

source db.sql;

A bunch of lines should pass by ( this is normal ).

< If your computer 'beeps' , just ignore it >

Once it finishs(stop scrolling lines) Type the following

source reloaddb.sql;

(More lines will scroll by, you might wanta go make some food at this point ,as this will take 5 min plus to finish)

After it finishs Type " Exit " . MySQL will close.

on the source reloaddb.sql; step it starts to load correctly then

"ERROR 1054: Unknown column 'usedspells' in 'field list'

It keeps repeating this and has yet to stop. Also my computer beeps the entire time. So I just close it.


Other than the above everything has worked. Help!

[Hardy]

When I start World.exe it loads doe a split second then it closes it self

Did you use the search button? I am tired of coming to the forums every day and see the same problem posted EVERY day.

[IAPills]

since you bothered posting, why didn't you include the solution?

[IAPills]

since you bothered posting, why didn't you include the solution?

[IAPills]

I just went and tried all the solutions that I found with search. nothing worked

[MatthewF]

i posted the same problem yesterday,hardy helped me somewhat,may be what your looking for,but yet i still cant get world.exe to load,we sorta have same prob....i still cant get my server to work..

[Hardy]

since you bothered posting, why didn't you include the solution

Would be faster for you to search for it.

I have yet to solve this problem, but I have posted a few ideas.

[a_Guest03]

/nod Hardy. I see the same damn problems day in and day out... A few still exist where I have to think, but many of those I just can't solve.

Just start cramming answers into your sig :P

[IAtommy_pitts]

Originally Posted by tommy_pitts

Dude i had the same prob and the way i fixed it was to of course make sure the boot5zones said 127.0.0.1 for YourIP

Anyway go to your command prompt (start | run)
and type
(win 98/ME) command
(win 2000/xp) cmd

A command prompt should come up.

Then type;

cd c:\mysql\bin (press enter)
mysql.exe --user=root(press enter)
use eq(press enter)
GRANT ALL ON *.* to 'mysqlusername'@'127.0.0.1'(press enter)
IDENTIFIED BY '*.*';(press enter)

It then should say 0 rows effected

if doesn't work the try to get a screen shot when your run the boot5zones.bat (press the print screen next to F12 key)
then go to your wordpad or word and press Ctrl+V...
When you paste the screen shot and you can't read one of the zones then, keep trying. it can be frustrating but trust me that i tried about dozen and a 1/2 times before i could see it.

In the screen shot you should see

"Access denied for blah blah blah"

what ever the blah blah blah is change the 'mysqlusername'@'127.0.0.1' to with the appropriate quotes in it.

GRANT ALL ON *.* to 'mysqlusername'@'127.0.0.1'(press enter)
IDENTIFIED BY '*.*';(press enter)

still dosen't work then try to put your password also where it says

IDENTIFIED BY '*.*';

change the '*.*'; to 'yourcurrentmysqlpassword';

HOPE THIS HELPS!!!