Hello, i have a not normaly problem about dayz-private-server HOT 11 CLOSED

Now i have this :D

2016-05-2100:24:37 HiveExt: [Information] HiveExt ce45a1f7524c
2016-05-21 00:24:37 Database: [Information] Connected to MySQL database 192.168.0.112:3306/dayz client ver: 5.5.28 server ver: 5.7.12-0ubuntu1
2016-05-21 00:24:37 Database: [Information] Connected to MySQL database 192.168.0.112:3306/dayz client ver: 5.5.28 server ver: 5.7.12-0ubuntu1
2016-05-21 00:24:37 HiveExt: [Information] Method: 307 Params: 
2016-05-21 00:24:37 HiveExt: [Information] Result: ["PASS",[2016,5,21,0,24]]
2016-05-21 00:24:37 HiveExt: [Information] Method: 302 Params: 1337:
2016-05-21 00:24:37 Database: [Error] Error 1146 (Table 'dayz.Object_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT COUNT(*) FROM `Object_DATA` WHERE `Instance` = 1337 AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )'
2016-05-21 00:24:37 Database: [Error] Error 1146 (Table 'dayz.Object_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM `Object_DATA` WHERE `Instance`=1337 AND `Classname` IS NOT NULL'

from dayz-private-server.

Make sure to execute the latest SQL file on the database before starting up the server.

from dayz-private-server.

Of course i did use latest sql file, and at XAMPP, server working wery well.

from dayz-private-server.

So your data is saving properly and this error is no longer showing up?

from dayz-private-server.

Error showing then i try connected to DataBase on Ubuntu server(in LAN), but then i tried connected to XAMMP(localhost) DB, i didn`t have any errors

from dayz-private-server.

You might've had a execution error on your Ubuntu machine which would've caused those errors. As long as you are up and running now, you shouldn't have a problem.

from dayz-private-server.

Hmmm, and i have one more error, scripts in DB dosent work, write that i havent this table Object_DATA :-(

from dayz-private-server.

Try to execute this code on your SQL database:
CREATE TABLE IF NOT EXISTS object_data(ObjectIDint(11) NOT NULL AUTO_INCREMENT,ObjectUIDbigint(20) NOT NULL DEFAULT '0',Instanceint(11) NOT NULL,Classnamevarchar(50) DEFAULT NULL,Datestampdatetime NOT NULL,CharacterIDint(11) NOT NULL DEFAULT '0',Worldspacevarchar(70) NOT NULL DEFAULT '[]',Inventorylongtext,Hitpointslongtext NOT NULL,Fueldouble(13,5) NOT NULL DEFAULT '1.00000',Damagedouble(13,5) NOT NULL DEFAULT '0.00000',last_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (ObjectID), UNIQUE KEY CheckUID (ObjectUID,Instance), KEY ObjectUID (ObjectUID), KEY Instance (Damage,Instance) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

from dayz-private-server.

Now scripts working but vechikles dont spawning? Mysql return empty result (0) :DD

from dayz-private-server.

Execute this command in your database: call pMain(i) where i = your instance ID.

from dayz-private-server.

Okay, but i do differently, i download sql for Linux server and add all scripts and rename other tables and this working. I can upload this sql file than You check this.

from dayz-private-server.