vorp_core 2.1 character coords are not updates - RedM/CFX/VORP Project

Frequently ASKED Questions by THE Crimson Creek TEAM

I updated the vorp_core to the most recent verions (2.1) and the character coords are not being updated.

[ script:oxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: vorp_core was unable to execute a query! [ script:oxmysql] Unknown column 'hours' in 'field list' [ script:oxmysql] UPDATE characters SET `group` = ?,`money` = ?,`gold` = ?,`rol` = ?,`xp` = ?,`healthouter` = ?,`healthinner` = ?,`staminaouter` = ?,`staminainner` = ?,`hours` = ?,`job` = ?, `status` = ?,`firstname` = ?, `lastname` = ?, `jobgrade` = ?,`coords` = ?,`isdead` = ? WHERE `identifier` = ? AND `charidentifier` = ? ["user",1198.25,0,0,0,500,100,100,100,null,"unemployed","{\"Thirst\":252,\"Metabolism\":-748,\"Hunger\":626}","Lula","Smith",0,"{\"z\":115.9384765625,\"heading\":323.14959716796877,\"x\":-365.010986328125,\"y\":812.993408203125}",false,"steam:11000011ba8c9d4",4] [ script:oxmysql] > <unknown> (@oxmysql/dist/build.js:21786) [ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96) [ script:oxmysql] > async rawQuery (@oxmysql/dist/build.js:21755)

If you see this then run these sql commands.
Restart the server and restest if the character is saving the coords.
From what we’ve seen the new vorp_core has an older sql file, which does not have all the new fields in it.

ALTER TABLE `characters` ADD COLUMN `hours` float NOT NULL DEFAULT 0;
ALTER TABLE `characters` ADD COLUMN `motel` varchar(255) DEFAULT '0'; 
ALTER TABLE `characters` ADD COLUMN `created` date NOT NULL DEFAULT current_timestamp(); 
ALTER TABLE `characters` ADD COLUMN `lastlogin` date NOT NULL DEFAULT current_timestamp(); ALTER TABLE `characters` ADD COLUMN `rulesflag` int(11) NOT NULL DEFAULT 0; 
ALTER TABLE `characters` ADD COLUMN `loreflag` int(11) NOT NULL DEFAULT 0; 
ALTER TABLE `characters` ADD COLUMN `timeplayed` int(11) NOT NULL DEFAULT 0;