Database issues after re-install

T

Tinman

New Member
Somehow I super borked the upgrade. So I started from scratch leaving only the database intact.

One I got it running and up to date (1.7.5.1), I logged in and noticed the vehicles were missing. I thought that was supposed to happen so I used the fancy cmd and generated vehichles. It then created only two. So when I went to the server I saw this error popped up
14:03:59 Database(1): [Error] Error 1054 (Unknown column 's.DistanceFoot' in 'field list') in MySQLQuery SQL: 'update `survivor` s set s.`DistanceFoot` = (s.`Di
stanceFoot` + 8) , s.`medical` = '[false,false,false,false,false,false,true,12000,[],[0.309,0],0,[1081.82,325.249]]' , s.`state` = '[\"M4A1_AIM_SD_camo\",\"amov
percmrunslowwrfldf\",42]' , s.`Worldspace` = '[140,[3221.1,6284.06,0.002]]' where s.`id` = 1'

14:04:12 Database(1): [Error] Error 1054 (Unknown column 's.DistanceFoot' in 'field list') in MySQLQuery SQL: 'update `survivor` s set s.`DistanceFoot` = (s.`Di
stanceFoot` + 68) , s.`medical` = '[false,false,false,false,false,false,true,12000,[],[0.309,0],0,[1081.82,325.249]]' , s.`state` = '[\"M4A1_AIM_SD_camo\",\"amo
vpercmrunslowwrfldf\",42]' , s.`Worldspace` = '[127,[3275.47,6244.58,0.002]]' where s.`id` = 1'

14:04:24 Database(1): [Error] Error 1054 (Unknown column 's.DistanceFoot' in 'field list') in MySQLQuery SQL: 'update `survivor` s set s.`DistanceFoot` = (s.`Di
stanceFoot` + 23) , s.`medical` = '[false,false,false,false,false,false,true,12000,[],[0.309,0],0,[1115.98,339.482]]' , s.`state` = '[\"M4A1_AIM_SD_camo\",\"amo
vpercmrunsraswrfldf\",42]' , s.`Worldspace` = '[132,[3294.87,6231.55,0.002]]' where s.`id` = 1'

14:04:36 Database(1): [Error] Error 1054 (Unknown column 's.DistanceFoot' in 'field list') in MySQLQuery SQL: 'update `survivor` s set s.`DistanceFoot` = (s.`Di
stanceFoot` + 42) , s.`medical` = '[false,false,false,false,false,false,true,12000,[],[0.309,0],0,[1115.98,339.482]]' , s.`state` = '[\"M4A1_AIM_SD_camo\",\"aid
lpercmstpsraswrfldnon_idlesteady04\",42]' , s.`Worldspace` = '[117,[3329.61,6208.14,0.001]]' where s.`id` = 1'
Click to expand...

Then I used Hiedi to look around and all my vehicles are still listed in the database. I'm okay if they are all gone, but how do I clear everything out so I can spawn new vehicles?
 
Distancefoot is in the latest schema, you need to run the schema update every time there is a hive update to ensrue your not missing anything.
 
My migration did not work, so I created a new database. It actually let me import survivor and vehichle tables.

Everything seems to be working and my vehicles came back. No one will even know we upgraded.

Thanks!
 
You must log in or register to reply here.
Back
Top