Closed skiperh1n1 closed 8 years ago
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'
Make sure to execute the latest SQL file on the database before starting up the server.
Of course i did use latest sql file, and at XAMPP, server working wery well.
So your data is saving properly and this error is no longer showing up?
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
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.
Hmmm, and i have one more error, scripts in DB dosent work, write that i haven
t this table Object_DATA :-(
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_updatedtimestamp 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;
Now scripts working but vechikles dont spawning? Mysql return empty result (0) :DD
Execute this command in your database: call pMain(i)
where i = your instance ID.
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.
When i started server, and have readed mission, have this massege. In HevExt.ini i`m changed Object_DATA to object_data.