Various attempts always result in the same error (MiniLogin)
 

README:

I am trying to set up a Minilogin (local/LAN) server and I want to host and play on the same machine.
To avoid any confusion, username and password are ALWAYS the same, e.g. "Carl" and "houseboat".



Step 1: Downloads

- db.zip www.bossmob.com/Myra
- MyraDB.zip www.bossmob.com/Myra
- MySQL 4.0.18 www.mysql.com
- EQEmu.rar which contains:


Step 2: Creating my database "eq"


3. Changing EQEmu settings

a) Boot5zones.bat
b) db.ini
c) LoginServer.ini
d) MiniLoginAccounts.ini
e) eqhost.txt

4. Starting the server

a) Running Minilogin.exe
b) Running World.exe
c) Running Boot5zones.bat


Alright. This is definatly a database problem, but I've tried to run a working database since Saturday. Myras *.sql files return no error at all. I still have MW055_alpha1.sql and MW055_alpha_02.sql, but they've always resulted in (after a few OK lines):

ERROR 1136: Column count doesn't match value count at row 1

As does MyraItems.sql. I don't think those two might fix this.
I've no clue which files I should or shouldn't source.

Joining the server gives me a 1017, of course.



edit: Shouldn't it be possible to use a database "compiled" by someone else? If yes, would anyone be so kind an upload his?

Try creating a new database and source these four database files found here:

http://www.eqemulator.net/forums/vie...928cefd043af22

It looks like you just need to update the items table in your database.

You can download the SQL file from here (http://prdownloads.sourceforge.net/e...ditems.sql.gz?).

Just source it (after you uncompress it!) and you should be good to go!

Thanks for the info.

Kept reading and finally found out what had gone wrong. Myras DB files are too old/not compatible for/with 0.5.5 DR1. I am now using 0.5.5.

There's still a problem with MW055_alpha1.sql though. Minilogin.exe, world.exe and boot5zones.bat all run without a single error, but only because I've just sourced MW_055_alpha_02.sql and the doorupdate-03-15-04.sql. Both of these never return an error.

MW055_alpha1.sql ALWAYS results in the message: ERROR 1136: Column count doesn't match value count at row 1 which never stops.

Well, at least I can run the *.exe's without any screwups. Time to fix the 1017.


edit: I've just seen the new post. Shall I source that dumpeditems.sql file into my current database (the one that's working with 0.5.5) or does it already contain this data?

edit2: Alright, Myras DB now works with 0.5.5.DR1 because of the dumpeditems.sql. Thanks. Still getting that stupid 1017 error, but I'll get that one sooner or later :).

With regards to your 1017, If you want to HOST AND PLAY ON SAME COMPUTER:

Set up a server using jezebell's guide

In loginserver.ini:

replace your [loginserver] block to this:

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver=eqlogin2.eqemulator.net
loginserver=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997


make worldaddress: localhost

in boot5zones.bat - MAKE ALL IPS localhost

In eqhost.txt :

[Registration Servers]
{
"eqlogin1.eqemulator.net:5997"
"eqlogin2.eqemulator.net:5997"
"eqlogin3.eqemulator.net:5997"
}
[Login Servers]
{
"eqlogin1.eqemulator.net:5997"
"eqlogin2.eqemulator.net:5997"
"eqlogin3.eqemulator.net:5997"
}

then run world.exe, and boot5zones.bat

This will make your server show up on the public server select screen, but will only allow YOU to connect...this is how i have fixed 1017 on minilogin, HOWEVER - this will not work if your internet is down :)

Good luck.

Heh, yeah, I hoped that I would only have to do that, but I'm linked to a router. Gotta read through this guide I guess.

http://www.eqemulator.net/forums/viewtopic.php?t=1645

Hmm, is it even possible to host and play on the same machine behind a router/firewall?

Yeah.