Unknown column 'run_id' in 'field list' causes "No Default Instance" Error

I'm still working on getting a world server up and running based on the code in trunk. After getting past my problem with the message number text file, I discovered another problem. A few of the services are expecting a database a bit different than in the install.sql:

Code:: wmgr_1.out:ERROR [2012-06-08 18:18:15,771] main Database.registerStatusReportingPlugin com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'run_id' in 'field list'
wmgr_1.out:ERROR [2012-06-08 19:30:47,875] main Engine: Engine.registerStatusReportingPlugin: Registration of plugin 'WorldManager1' failed!

This causes problems with the instance manager, as seen in instance.out:

Code:: instance.out:ERROR [2012-06-08 19:32:43,973] Instance-2 CreateInstanceHook: no world manager for instance, templateName=sampleworld template
instance.out:ERROR [2012-06-08 19:32:43,973] Instance-2 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,975] SelfMessage Unexpected RPC response requestId=25 from=instance,27
instance.out:ERROR [2012-06-08 19:32:43,984] Instance-4 CreateInstanceHook: no world manager for instance, templateName=bigbrother template
instance.out:ERROR [2012-06-08 19:32:43,985] Instance-4 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,993] SelfMessage Unexpected RPC response requestId=30 from=instance,32
instance.out:ERROR [2012-06-08 19:32:43,996] Instance-6 CreateInstanceHook: no world manager for instance, templateName=frontier template
instance.out:ERROR [2012-06-08 19:32:43,996] Instance-6 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:43,999] SelfMessage Unexpected RPC response requestId=35 from=instance,37
instance.out:ERROR [2012-06-08 19:32:44,004] Instance-8 CreateInstanceHook: no world manager for instance, templateName=video template
instance.out:ERROR [2012-06-08 19:32:44,004] Instance-8 handleMessageImpl java.lang.NullPointerException
instance.out:ERROR [2012-06-08 19:32:44,012] SelfMessage Unexpected RPC response requestId=40 from=instance,42

I modified the database to add the run_id column to the plugin_status table and all of those errors went away. My first try was an int, but that didn't work so I went with varchar:

Code:: alter table plugin_status add column run_id varchar(50);

Things still aren't quite right yet, since it looks like the WORLD_NAME and WORLD_DIR variables aren't getting set during startup script execution:

Code:: instance.out:ERROR [2012-06-08 19:36:44,035] Instance-2 CreateInstanceHook: world file not found fileName=../config//.mvw
instance.out:ERROR [2012-06-08 19:36:44,043] Instance-4 CreateInstanceHook: world file not found fileName=../config//bigbrother.mvw
instance.out:ERROR [2012-06-08 19:36:44,049] Instance-6 CreateInstanceHook: world file not found fileName=../config//frontier.mvw
instance.out:ERROR [2012-06-08 19:36:44,061] Instance-8 CreateInstanceHook: world file not found fileName=../config//video.mvw

Still, I'm getting closer to having a working sampleworld server online based on trunk... it feels like once I get those path variables sorted things will be good. Smile

Looks like run_id should actually be a bigint. Seems to be in the install.sql file, so I must have set up the db with an older version or something...

To continue the conversation with myself...

The server from 2008-06-23 has an install.sql that doesn't include run_id in the plugin_status table. That's what I used initially.

Yes I encountered this and modified the install.sql to include the field.

It looks like they had removed it in the version after the 2008-6-23 because we are running just fine with out it.

» No Default Instance at Character Creation Screen
» Stop-multiverse...unknown command (Vista)
» Demo World Available - New York Times Square
» Tools List(s)
» Character Creation - Select name from list