ok so I was having some issues loading into my update on exile on my server. No after reviewing all my logs I found this in my MySQL logs. [02:16:39:524332 --4:00] [Thread 150800] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'money' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id,class,spawned_at,account_uid,is_locked,fuel,damage,hitpoints,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,vehicle_texture,deleted_at,money FROM vehicle WHERE id = ?
so what is the issue well after reviewing the update sql files in the server update download the following alter table sql updates were missing
ALTER TABLE container ADD `money` INT NOT NULL DEFAULT '0' AFTER `deleted_at`; I found this this one reviewing the exile.sql
ALTER TABLE vehicle ADD `money` INT NOT NULL DEFAULT '0' AFTER `deleted_at`;
the above sql updates were missing in the upgrade-0.9.60-to-0.9.80.sql. I hope this helps anyone else updating their servers for 0.9.8
ok so I was having some issues loading into my update on exile on my server. No after reviewing all my logs I found this in my MySQL logs. [02:16:39:524332 --4:00] [Thread 150800] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'money' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id,class,spawned_at,account_uid,is_locked,fuel,damage,hitpoints,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,vehicle_texture,deleted_at,money FROM vehicle WHERE id = ?
so what is the issue well after reviewing the update sql files in the server update download the following alter table sql updates were missing
Share this post
Link to post
Share on other sites