Object_DATA Problem

[ignacioar]

I have this problem to boot the server

 

2013-11-28 15:30:25 Database: [Error] Error 1146 (Table 'dayz_epoch.object_data' doesn't exist) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM `Object_DATA` WHERE `Instance`=11 AND `Classname` IS NOT NULL'

[Darth_Rogue]

Make sure your instance value is set to 11 in your init.sqf.  If that's not it then you may want to verify that you have loaded the Epoch tables into the database and not something in the Bliss/Reality format.  Is this a new server you are setting up or did it just start happening to an existing server?

[ignacioar]

Hi guys, thanks very much for your answer, I will to do that ;), It's a new argentine server [Los GaToS] in testing status, We need your support, this is an free mod or we will pay per use that? or donated option is pissible?

[ignacioar]

Where do I find the init.sqf file?

[Darth_Rogue]

Its inside your mission pbo. More specifically for Epoch its in the mission folder. The path should be X:\\[DayZ ServerPath]\DayZ_Epoch_11.Chernarus/init.sqf

[ignacioar]

change, still not working

/ / REALLY IMPORTANT VALUES

dayZ_instance = 11 / / The instance

dayzHiveRequest = [];

initialized = false;

dayz_previousID = 0

[Darth_Rogue]

You should now also verify that your database has entries in it referencing instance 11.  If you look in the various tables it will have a column labeled "Instance".  Make sure that all items in at least the "Character_Data" and "Object_Data" tables have references to Instance 11.  If not, then you need to install a different db.  Also check your hive.ini file and make sure that it is linking to the correct database.  Depending on how you named it when you created the db it could be different from the default hive.ini setting.  The correct area to look at in your hive.ini is shown below:

;Hostname or IP of the server to connect to
;If you leave this line commented or blank, HiveExt will connect to the OFFICIAL Hive, which requires registration
;See support.dayzmod.com for more information on what OFFICIAL Hive means, what are the rules, etc.
;If using OFFICIAL hive, the rest of the settings in this section have no effect
Host = localhost

;Currently, only MySQL is supported
Type = MySQL

;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = 3306

;Database name to connect to.
Database = dayz_epoch (this will likely be different for you, as this is a paste of my hive.ini file, but this is where the server is told what db to link to)

;Username to connect with
Username = ****
;Password to authenticate with (default is blank)
Password = ****

The default location for the hive.ini file is in your game server directory (G:\DayZ Server\instance_11_Chernarus).  It is possible that the server is looking to the wrong db.

[nedfox]

Did you create the database ánd imported /ran the SQL file ?

[ignacioar]

thank you very much problem solved

[nedfox]

ignacioar, it would be awesome when you fix something, you post how you did that as well.. Admins will google for problems, find this thread and then wonder HOW you solved it?