Attempting server setup with peq-velious-rc1

[sianyde9]

I'm trying to get a setup going up to Velious. PEQ's site shows that db uses EQEmu v0.6.2. There is a plethora of links for 0.6.2 src and precompiled win32 binaries.

I'm using MySQL 4.1 because the .sql file syntax in peq-velious-rc1 files causes issues with MySQL 5.x (mainly due to the use of a reserved word in 5.x).

I created my db and sourced in load_system.sql and load_empty_users.sql. I started minilogin. I started world, and I get missing opcode errors.

I'm also getting a lot of 2006 errors. Most of them are due to a 'guilds' table being missing, but some are from 'zone' and 'items'. After those errors, world.exe process remains running, but keeps reiterating "MySQL server has gone away".

I'm suspecting the opcodes.conf file is missing entries, but I don't know how fatal they are yet because I can't connect a client yet to test. I suspect the 2006 errors are due to missing db entries, but I'm at a loss as to what they may be.

Does anyone know if I need to source in more sql files? Do I need an updated opcodes.conf? Will this setup even work this way (with this EQEmu, MySQL, and db versions) or is there a better way to create a Velious era server?