Database Error

[barci]

Need some help to fix this pls.

013-09-03 16:09:20 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '78982AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["DDOPP_X26"],[]]", "["DZ_Patrol_Pack_EP1",[],[]]", 22715)'
2013-09-03 16:24:55 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '78982AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["DDOPP_X26"],[]]", "["DZ_Patrol_Pack_EP1",[],[]]", 22716)'
2013-09-03 16:32:53 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '78982AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["DDOPP_X26"],[]]", "["DZ_Patrol_Pack_EP1",[],[]]", 22717)'

 

[taikonaut]

Got the same... no negative effect on the game, though.

 

[Glenn]

Not sure what command it is that you are trying to run, but the update statement is formed wrong....

Should be something like:

'UPDATE `survivor` SET `inventory` = 'XXXX', `backpack` = 'XXXX' WHERE `unique_id` = 'XXXX';

This means that if you are trying to update the inventory and backpack withthe values, you need it to look somehting like:

'UPDATE `survivor` SET `inventory` = '[["DDOPP_X26"],[]]', `backpack` = '["DZ_Patrol_Pack_EP1",[],[]]' WHERE `unique_id` = '123456';

Of course, you need to pay attention to all the [] and () that you would normally have in your inventory code, but that is how it should be calling it.