Working DB sql out there?

[IN005 24]

Hello guys,

 

I'm setting up a server right now and being still confused, why the exile developers don't upload any working sql files to create the database.

Currently there are four files included:

exile.sql	- working

upgrade-0.9.40-to-0.9.41.sql 	- working

upgrade-0.9.41-to-0.9.60.sql	- not working

upgrade-0.9.60-to-0.9.80.sql	- not working

 

I'm using Navicat Lite to work on my mysql database, with the first two files I'm able to create the database, but the other two files aren't working for me, so I can't update it...

 

But thats not the only problem, as you can see here:

Spoiler

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads


[16:41:18:146125 +00:-1] [Thread 3900] extDB2: Database Type: MySQL
[16:41:18:149604 +00:-1] [Thread 3900] extDB2: Database Session Pool Started
[16:41:18:152327 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Program Files (x86)\Steam\steamapps\common\Arma 3 Server\@ExileServer\extDB\sql_custom_v2\exile.ini
[16:41:18:152631 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[16:42:37:028422 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Field 'hitpoints' doesn't have a default value	[mysql_stmt_errno]: 1364	[mysql_stmt_sqlstate]: HY000	[statemnt]: INSERT INTO vehicle SET class = ?, account_uid = ?, is_locked = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, pin_code = ?
[16:42:37:028533 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:42:37:028557 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:Exile_Bike_QuadBike_Black:76561197972232595:0:27621.525391:22514.251953:0:-0.943747:0.330669:00:00:0:1:6618
[16:57:45:305781 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Field 'hitpoints' doesn't have a default value	[mysql_stmt_errno]: 1364	[mysql_stmt_sqlstate]: HY000	[statemnt]: INSERT INTO vehicle SET class = ?, account_uid = ?, is_locked = ?, position_x = ?, position_y = ?, position_z = ?, direction_x = ?, direction_y = ?, direction_z = ?, up_x = ?, up_y = ?, up_z = ?, pin_code = ?
[16:57:45:305872 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:57:45:305904 +00:-1] [Thread 3900] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:Exile_Car_Hunter:76561197972232595:0:21365.804688:19653.0839844:-0.122913:-0.805078:0.583338:0.107544:0.102038:-0.0424054:0.993876:8143

 

I don't know, if these errors are caused by the missing updates, but I now that on every table is no default value. I don't know why this wasn't addes, so someone might help me with this problem.

 

Greetings

IN005

[IN005 24]

4 minutes ago, Crazy Mike said:

the exile.sql is the most recent version, your using old version updates to mess it up,

 

why would you need to activate the 1.0.2 exile database, then try to update it from 9.4 to 9.6 and so on lol

 

Ok maybe........ I'm stupid 

Thanks for your fast reply