World.exe crashing when somebody joins...

[psalm]

Do I source the 'updates' folder in the same dir as peqdb_rev1667.sql ?

or just drop_system/peqdb?

[psalm]

Ok, I just tried running the server. All goes well - made a character etc.

when I load into the world - it just pops up 'zone not available' - I'm happy it's no longer crashing the world.exe, just need to know what to do now

[psalm]

Straight up swapping world.exe / zone.exe out for newer versions - presents the error 'The program can't start because perl510.dll is missing from your computer.'

any ideas?

[rencro]

Im not sure you are applying the updates properly. Now there are several methods to update the sqls, but I think first you want to know why you are updating them.. So long boring wall of text explanation follows:

Peq, one of the databases commonly used for the emulator, will hold all the structures required by the core to work properly, as well peq database holds all the spawn/creature info. When peq releases a database, they will label it with a number that relates to the latest core it was made for. As I write this that would be peqdb_rev1667.sql. This means that all the sql for the "core" up to 1667 are applied, as well as any changes peq has for spawns/creatures, ect..

EQemulator is in a constantly evolving state, changes are sometimes made to the way the database and core interact with each other and this will require an sql update to "an existing database", in this case if you applied the peq_rev1667 database, but then decided to update your emulator, or core, to say the latest binary release of 1708, then any sql's numbering above 1667 would need to be applied, unless they state "optional" of course. For this example these would be 1696_modify_zone_and_object_tables.sql as this sql falls between the last version of your peq db, 1667, and the current version of your core, 1708....

To get a better appreciation of the process it would be better to pull the source yourself and recompile whenever a dev releases a new push, which would require an sql update if one was pushed with that version. The reality is most people just use the precompiled binaries, but you should still understand the process nonetheless.

Eventually, peq will update to a newer version, and they will have incorporated all the sql updates that were released between their last db and the new one they are releasing..

[rencro]

Originally Posted by psalm

Straight up swapping world.exe / zone.exe out for newer versions - presents the error 'The program can't start because perl510.dll is missing from your computer.'

any ideas?

You have an old version of perl installed on your machine, more than likely when you installed the all-in-one server from earlier it installed what was then needed..

Also straight up swapping should not be done, use all the files from the current binary release, to a new directory, if you were not planning on deleting your old one....

[psalm]

Thanks for posting Rencro,

I admit, I am alittle beyond my depth here heh, but I feel it's slowly coming together.

I just uninstalled perl, and reinstalled perl 5.10 - which resolved my last error.

I no longer get the 'zone is not available' pop up ingame at char select, but now when i enter the worl, i am presented with the 'YOU HAVE BEEN DISCONECTED!' black screen.


Any ideas?

[psalm]

Originally Posted by rencro

Also straight up swapping should not be done, use all the files from the current binary release, to a new directory, if you were not planning on deleting your old one....

Ok, I am running 1708 now, with all the relevant files, in a new folder.

The World/Zone seems to be working fine, however, EQEmu Login Server crashes on startup (from startup bat)

Using Port: 5999
Dumping Inbound packets.
Dumping Outbound packets.
Database Server: localhost
Database Catalog: eqdb -- is that correct?
Database Username: equser
Database Password: equser

MYSQL CONNECT FAILED:
localhost
equser
equser
eqdb
Query failed:





So I think I need to change those fields to root/password and peq, respectively?

But where?

[rencro]

Make sure you have your config files set up, thats where you will be setting username/password and database settings used..Refer to your old config files for guidance since it seemed you were past this step on previous setup..

[psalm]

Checked my config, matches my previous one.

Still getting the 'YOU HAVE BEEN DISCONNECTED!' message upon hitting enter world at char select.

I've made the zone (kaladima) that the specific char is entering static, but to no avail.


Here is my config.


<?xml version="1.0"?>
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>

<!-- address has to be specified for minilogin to work -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>make up some random string of characters here</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>peq</db>
</database>
</server>

[psalm]

I presume the below is whats causing the disconnect, as it seems to no be able to find the character. I tried creating a new char, and logging straight in, but had the same problem.

World.exe

[Error] in AdventureManager:::GetLeaderboardInfo: Select ch.name, ch.id, adv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_stats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
Error in GetCharacterInfo query 'SELECT id, account_id, zonename, instanceid, x, y, z, FROM character_ WHERE name='Gold'' #1054: Unknown column 'instanceid' in field list'

[debug] [WORLD_CLIENT_ERR] mini: Could not get CharInfo for 'Gold'
[debug] [WORLD_CLIENT] mini: Client disconnected (not active in process)

[rencro]

Ok,,,,,,, so you are still using your old player tables from the old install and you did not drop_players when you upgraded peq..

You would'nt want to drop the players if you wanted to preserve existing characters, but I'm thinking in your case there prob arent many existing chars, so best thing is to drop world and players on yor peq db, and install it again, as well as the updated sql 1696..

You could preserve your chars if you wanted, but you would need to apply any sql's that modified those tables from when your db was initially made.

[rencro]

Take a read here for basic info on db

http://www.peqtgc.com/phpBB2/viewtopic.php?t=7112

[psalm]

Rencro,

I'm going to run a fresh install.

I really appreciate your tolerance

[rencro]

Np, when you get this going and having your own world to play in, it "almost" brings back that feeling of playing eq for the first time...

[psalm]

Yea, I bet!


I've reinstalled - ran system/players/rev .sql

replaced the quest files

and am running from the new binaries.


I no longer see any server in server select.

World.exe is spamming me with -
Error 'DBAsyncCB_LoadVariables failed !GetAnswer: '#1146: Table 'peq.variables doesn't exist'