[Help] fresh spawn

[istealth]

Ok so this is our problem when we spawn in our server, walk around for 3-5 minutes abort, come back in we are a fresh spawn.

in the hiveext log it says

2013-02-11 19:46:19 Database: [Error] Error 1054 (Unknown column 's.DistanceFoot' in 'field list') in MySQLQuery SQL: 'update `survivor` s set s.`DistanceFoot` = (s.`DistanceFoot` + 38564) , s.`backpack` = '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]' , s.`inventory` = '[[\"ItemFlashlight\",\"ItemCompass\",\"ItemHatchet\"],[\"ItemPainkiller\",\"ItemBandage\",\"ItemMorphine\",\"ItemBandage\"]]' , s.`medical` = '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]' , s.`model` = 'Survivor2_DZ' , s.`state` = '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady02\",36]' , s.`Worldspace` = '[243,[13077,3879.37,0.001]]' where s.`id` = 23752'

its flooded with the same info

i do have my database updated to 0.38 well when i run the database migration it says i do

i have noticed that if i do a fresh install of the profile,survivor table it is fine with no errors. but when i transfer over a backup from my bliss server (survivor table) it comes up with that error. and I DID do the bliss migration

 

[wriley]

It looks like your backup of the survivor table drops and recreates the table and it is now missing a column. Try running schema/Reality/mysql/0.37-0.38/20_survivor.sql manually against your database to add the missing column.

 

[istealth]

It looks like your backup of the survivor table drops and recreates the table and it is now missing a column. Try running schema/Reality/mysql/0.37-0.38/20_survivor.sql manually against your database to add the missing column.

that fixed it thank you -D

i know this is off topic but is this error anything to worry about

2013-02-11 22:08:35 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23826)'
2013-02-11 22:09:56 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23827)'
2013-02-11 22:18:18 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23828)'
2013-02-11 22:20:22 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23829)'
2013-02-11 22:26:24 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23830)'
2013-02-11 22:26:43 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23831)'

 

[JoSchaap]

i just created a new DB and copied over the contents of the tables by hand
but you can also use navicat' s data transfer option, ass long as you uncheck 'recreate objects'

 

[thevisad]

that fixed it thank you -D

i know this is off topic but is this error anything to worry about

2013-02-11 22:08:35 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23826)'
2013-02-11 22:09:56 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23827)'
2013-02-11 22:18:18 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23828)'
2013-02-11 22:20:22 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23829)'
2013-02-11 22:26:24 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23830)'
2013-02-11 22:26:43 Database: [Error] Error 1292 (Truncated incorrect DOUBLE value: '336641AX') in MySQLStmtExecute SQL: 'UPDATE `survivor` SET `inventory` = ? , `backpack` = ? WHERE `unique_id` = ? VALUES("[["ItemFlashlight"],["ItemBandage","ItemPainkiller"]]", "["DZ_Patrol_Pack_EP1",[],[]]", 23831)'

This is due to Arma X players who have an invalid ID according to the hive, I have yet to find a fix for this. I am still working on it. Look in your survivor table and see if you find a player with this ID 23831, that would be the player in question.