New exile starting SQL server error

[dave.tf 1]

Hi guys, maybe you can help me, I'm starting my server with the new exile 0.9.8 and it never finishes unlocking. I can see the following error in the logs;

Quote

[19:57:57:043578 --4:00] [Thread 8964] 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 = ?
[19:57:57:043578 --4:00] [Thread 8964] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:57:57:043578 --4:00] [Thread 8964] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadVehicle:271
[20:21:13:133421 --4:00] [Thread 8964] extDB2: Stopping ...

 

[Rappidxshots 23]

[01:34:47:067928 +01:00] [Thread 2508] extDB2: Database Type: MySQL
[01:34:47:069283 +01:00] [Thread 2508] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'changeme'@'localhost' (using password: NO)
[01:34:47:069499 +01:00] [Thread 2508] extDB2: Sending Shutdown to Armaserver

this is mine I think we need to make a new data base

 

[dave.tf 1]

@Eichi I think you forgot to add the money column to vehicle and container in upgrade-0.9.60-to-0.9.80.sql. Please let me know if theres anything else missing.

[dave.tf 1]

12 hours ago, Rappidxshots said:

[01:34:47:067928 +01:00] [Thread 2508] extDB2: Database Type: MySQL
[01:34:47:069283 +01:00] [Thread 2508] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'changeme'@'localhost' (using password: NO)
[01:34:47:069499 +01:00] [Thread 2508] extDB2: Sending Shutdown to Armaserver

this is mine I think we need to make a new data base

 

You need to edit the database username and password, you replaced the old file with the credentials

[glouton 1]

Hello everyone,

I concur with dave.tf

Found the same error in extDB logs after upgrade. Couldn't join the server. Add 'money' field in both 'container' and 'vehicle' tables and now it works.

[DEN 1]

Yeah. Try to add field money to vehicle table is work 

[ThePartyCrasher 1]

I am not trying to be a pain but could some one show us a screenshot of what needs to be changed. I am lost... or simple directions, including file names and locations. This has been a long road over night trying to fix this.

[glouton 1]

Hi there,

Running these two sql requests on your Exile database should do the trick:

ALTER TABLE `container` ADD `money` INT NOT NULL DEFAULT '0' AFTER `deleted_at`;
ALTER TABLE `vehicle` ADD `money` INT NOT NULL DEFAULT '0' AFTER `deleted_at`;

Hope this helps.