Sign in to follow this  
Followers 0
IN005

Working DB sql out there?

2 posts in this topic

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

Share this post


Link to post
Share on other sites
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 O.o9_9:P

Thanks for your fast reply :victory:

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.