Database not updating object_data

[ThaHenry]

Hello,

 

I've set up an Overpoch Server and the MySQL Database does update Character information.

 

But the server does not update anything iinside the object_data.

 

The vehicles i define inside the "dynamic_vehicles.sqf" are spawned and written into the object_data once, but are not updating.

 

The HiveExt.ini is configured properly and the database is initialized with the default "epoch.sqf" file.

 

Logging the HiveExt with trace-option only outputs Character_DATA changes and updates and on serverstart it loads all the vehicles and spawns them in the world. after that is finished, there are no more updates on object_data.

 

The server itself and the Database are not lagging or crashing.

 

MySQL Ver. 5.6.21

 

I already searched everywhere for a solution, i hope to get it here.

 

HiveExt.log: http://pastebin.com/BAisaSxQ

 

- Henry

[TNT]

are you using modified server pbo files? 

[ThaHenry]

are you using modified server pbo files? 

yes, i'm using

AdminTools 1.9.1

Single Currency 3.0

A Plot for Life

Action Menu

custom loot

DZGM

Custom GUI

Mapmarkers

Selective Spawn

Snap Pro

zeds

Service Points

 

All of them seem to work and nothing is pulling out any errors

[Guest]

I found this in your Log:

 

 

2015-04-07 22:38:14 HiveExt: [Debug] Original params: |CHILD:388:1569369095904:|

2015-04-07 22:38:14 HiveExt: [information] Method: 388 Params: 1569369095904:

2015-04-07 22:38:14 Database: [Trace] Query [1 ms] SQL: 'SELECT `ObjectID` FROM `Object_DATA` WHERE `Instance` = 13 AND `ObjectUID` = 1569369095904'

2015-04-07 22:38:14 HiveExt: [information] Result: ["PASS","30"]

 

 

In the first Line it shows you, what initialized those Lines..
2nd Line: Same as the first Line..
3rd Line: It's getting the Object from th Database..
4th Line: It got something with the ID 30..

This means everything went fine, the error is not in your Database, maybe in the Scripts...

May you post your dayz_server.pbo\compiles\server_updateObject.sqf and dayz_server.pbo\compiles\server_publishVehicle.sqf?

 

 

[ThaHenry]

I found this in your Log:

 

 

 

In the first Line it shows you, what initialized those Lines..

2nd Line: Same as the first Line..

3rd Line: It's getting the Object from th Database..

4th Line: It got something with the ID 30..

This means everything went fine, the error is not in your Database, maybe in the Scripts...

May you post your dayz_server.pbo\compiles\server_updateObject.sqf and dayz_server.pbo\compiles\server_publishVehicle.sqf?

 

server_updateObject : http://pastebin.com/4VuwJqhh

server_publishVehicle : http://pastebin.com/Fw9JzjAH

 

Thanks for taking the time

[Guest]

server_updateObject : http://pastebin.com/4VuwJqhh

server_publishVehicle : http://pastebin.com/Fw9JzjAH

 

Thanks for taking the time

 

No problem..

in "_object_inventory" look at the "_inventory[]" part.. //EDIT: This is found in server_updateObject.sqf

 

_object_inventory = {
        private["_inventory","_previous","_key"];
                _inventory = [
                        getWeaponCargo _object,
                        getMagazineCargo _object,
                        getBackpackCargo _object
                        /*ZSC*/
                        _object getVariable["bankMoney",0]
                        /*ZSC*/
                ];

I won't kill you error, in fact i'll try to explain what it is and you'll find it yourself :P

You see, _inventory is an array. If you count an array it allways starts with entry zero:

_array [0,1,2,3];

_array ["something :0", "something: 1"] etc..

That's one of the main things, also arrays don't like having a comma at the end, like so:

_array [0,1,2,3,];

And they don't like, if you miss a comma, like so:

_array [01,2,3];

So a nice array, with no comma at the end and all commas to seperate the values looks like so:

_array [0,1,2,3];

[ThaHenry]

No problem..

in "_object_inventory" look at the "_inventory[]" part.. //EDIT: This is found in server_updateObject.sqf

 

_object_inventory = {
        private["_inventory","_previous","_key"];
                _inventory = [
                        getWeaponCargo _object,
                        getMagazineCargo _object,
                        getBackpackCargo _object
                        /*ZSC*/
                        _object getVariable["bankMoney",0]
                        /*ZSC*/
                ];

I won't kill you error, in fact i'll try to explain what it is and you'll find it yourself :P

You see, _inventory is an array. If you count an array it allways starts with entry zero:

_array [0,1,2,3];

_array ["something :0", "something: 1"] etc..

That's one of the main things, also arrays don't like having a comma at the end, like so:

_array [0,1,2,3,];

And they don't like, if you miss a comma, like so:

_array [01,2,3];

So a nice array, with no comma at the end and all commas to seperate the values looks like so:

_array [0,1,2,3];

oh i see, so it should be that comma missing behind getBackpackCargo _object ?

 

I'll try it with

_object_inventory = {
        private["_inventory","_previous","_key"];
                _inventory = [
                        getWeaponCargo _object,
                        getMagazineCargo _object,
                        getBackpackCargo _object,
                        _object getVariable["bankMoney",0]
                ];

[Guest]

Do that, please let us know if it's fine after..

 

//EDIT: Is this actually supposed to show you in the Logs, who killed which vehicle?

[ThaHenry]

Do that, please let us know if it's fine after..

 

You're a god! I'd have never seen that, was sticking to the howto of Single Currency 3.0 which has the error in it.

 

Object_DATA is updating successful and saving to DB.

 

Have a nice day! :)

[ElDubya]

You're a god! I'd have never seen that, was sticking to the howto of Single Currency 3.0 which has the error in it.

 

Actually, the SC3.0 DOESN'T have an error, Zupa just put the comma in a different (but still workable) position. See below :

		_inventory = [
			getWeaponCargo _object,
			getMagazineCargo _object,
			getBackpackCargo _object
			/*ZSC*/
			, _object getVariable["bankMoney",0]
			/*ZSC*/
		]; 

He has it before _object getVariable["bankMoney",0]. It looks like it got lost in the copy/paste, but regardless, your issue is resolved so happy days! :)