Missing Opcodes?

[zippyzee]

I'm trying to get everything up to date, but am having some issues when starting the server. I've built on the latest SVN code, and have run all the sql scripts in the test_data folder, as well as the vgo-world and vgo-login scripts. There are many opcodes that won't load. I don't exactly where that problem lies. The missing ones are not in vgo-world.sql nor vgo-login.sql.

It kills the client when I try to start a dialog with the broker, as it has an error finding the struct for WS_ServerVoiceGreeting for OP_ServerVoiceGreeting.

Any ideas?

[John Adams]

May sound silly, but do you have the vgemu-structs.xml in the same folder as your WorldServer.exe? And of course, verify for sure the Opcodes table is being read and is full of the current opcodes. I have never seen anything that bad before, and things like SetTitle have been in the code for months so I am certain vgo_world.sql has the data.

If all else false, nuke your whole VGO folder and re-checkout from SVN, maybe something is corrupted somewhere.

[zippyzee]

Yes, I have the vgemu-structs.xml in the same folder. If it is not there you will see a different error message at the beginning of the log. It's not a problem with the structs file; I think it's a problem with the database. I don't see those opcodes manually looking through vgo_world.sql.

When I get back after lunch I'll delete vgo_world and pull a new update.

[zippyzee]

Ok. I spotted the opcodes with a search. I didn't realize vgo_login should not go over the top of vgo_world (i.e. replace some tables, etc.). That was the issue.

Thanks!

[Lokked]

I've made 3 databases:
vgo_world
vgo_login
vgo_test_world (used when I need to strip a table and don't want to be bothered with having to rerun vgo_world.sql)