Database Loading/Updating Problems

[k7s41gx]

Hey guys, came across this project from google, I would love to get in and try a server out but I seem to run into some database errors. My client is working great as I can login to your server and create a character etc.. just fine, but when I attempt to run the pre-compiled 0.7.1 server for windows it runs, connects to mysql and then attempts to update/patch some of the tables, however while its doing this I get a ton of errors for some of the databases and because of this I am unable to create a toon on the server I am running. I have attached a pastebin of the log file from the logs directory within the EQ2Emu directory.

http://pastebin.com/PZ0cSqYH

Any help on this would be greatly appreciated.

MySql Version (Mysql Server 5.6)
DB Name: eq2
Win 7 Home Premium

[alfa]

Hi,

Code: Select all

 Failed to connect to database: Error: #2003: Can't connect to MySQL server on '192.168.3.105' (10061)

So that mean you have a problem on your SQL server

[thefoof]

I see you got the server connected later on from the timestamp so looks like you sorted out the connection issue.

Try using a 0.7.2-dev build. which you can find here: https://svn.eq2emulator.net/svn/eq2server/trunk/ in the bin folder. I also recommend grabbing all the files from the structs folder and putting them with your server to make sure those are up to date.

I don't know how well versed you are with databases but the queries where it says unknown column, it probably means the patcher isn't adding that column or changing the name of an old column to that first before running the replace into query, so you could manually add/change those columns. The newer world file will probably fix some of these issues however, as what version the database gets updated to depends on the world exe.

If you still can't get it working I'll try and package up some database dumps for you. I know it's kind of difficult to package one together if you don't know everything you need to get, and we don't have a very current database release at the moment so that makes it harder.

Post or hop in IRC if you run into more problems.

irc.eq2emulator.net

[k7s41gx]

Hey thanks for the reply thefoof. Updating to the 0.7.2-dev seems to have corrected the database errors, but now I am left with a few errors about op codes. I will just paste the errors below. When I updated to the dev version I dropped the old eq2 table and had it create a new one. I did not get these ops code errors until after I updated the structs like you had suggested.

I am able to login and manuever about my world, now to populate the world wish I could get this as SOE like as possible. . Do you have a database/partial database up and running somewhere I could get a copy of? This would make things much much easier.

Thanks for your time.

Code: Select all

00:27:46 E Patcher: Version Table NOT Found! Creating...
00:28:01 W Patcher: ** Data Updates are SLOW! Do not abort! **
00:31:57 I Patcher: DB Update check completed...
00:31:57 I World: Loading System Data...
00:31:59 E Packet: Warning: PacketStruct 'WS_CharacterMerc' uses an unknown opcode named 'OP_CharacterMerc', this struct cannot be serialized directly.
00:31:59 E Packet: Warning: PacketStruct 'WS_AfterInvSpellUpdate' uses an unknown opcode named 'OP_AfterInvSpellUpdate', this struct cannot be serialized directly.
00:31:59 E Packet: Warning: PacketStruct 'WS_CharacterCreatedDungeons' uses an unknown opcode named 'OP_CharacterCreatedDungeons', this struct cannot be serialized directly.
00:31:59 E Packet: Warning: PacketStruct 'WS_CharacterHousingList' uses an unknown opcode named 'OP_CharacterHousingList', this struct cannot be serialized directly.
00:32:00 I World: Loaded System Data (took 3 seconds)
00:32:00 I Spawn: Initializing Spawn Subsystem...
00:32:00 I Spawn: Initialize Spawn Subsystem complete (took 0 seconds)
00:32:00 W Reformat: JA: This is as far as I got, don't panic!
00:32:00 I Items: Loading Items...

[John Adams]

Those errors were caused by me (I added some stuff to the WorldStructs.xml and did not add the opcodes). You should be able to ignore those for now. Soon as I (or someone else) gets time, we'll add those opcodes though they do not do anything right now.

For others info, I added those structs so I could extend PacketAnalyzer a little. Then ran out of time, as usual