• 0
jmayr2000

Database query issue in 0.9.8

Question

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
 
Jason M
  • Like 2

Share this post


Link to post
Share on other sites

11 answers to this question

  • 0
2 hours ago, wasti said:

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`;

Already did that, but thanks again.

Spoiler

 7:32:56 Error in expression <ase_handleBig;

};

};

(_result select 1) select 0>

 7:32:56   Error position: <select 0>

 7:32:56   Error Generic error in expression

 7:32:56 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27

Is the new enemy ^^ but since a lot of server owners are having this issue, i'm hoping for one of the higherups to find a solution.

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.