• 0
Alexis

Cant buy cars

Question

[21:24:28:238274 +00:-1] [Thread 7020] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:::-1:0:0:0:0:0:0:0:0:0:
[21:28:38:918855 +00:-1] [Thread 7020] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile_chernarus`.`vehicle`, CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)	[mysql_stmt_errno]: 1452	[mysql_stmt_sqlstate]: 23000	[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 = ?
[21:28:38:919052 +00:-1] [Thread 7020] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:28:38:919086 +00:-1] [Thread 7020] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: insertVehicle:::-1:0:0:0:0:0:0:0:0:0:


What happened?  How to fix this? 

Share this post


Link to post
Share on other sites

7 answers to this question

  • 0

Ensure that:

1. You are running the latest version of MySQL 
2. The user has full access (permissions) to the database you are using
3. That the full import was made when you imported the exile-database in the first place

 

Share this post


Link to post
Share on other sites
  • 0
9 minutes ago, Tobias Solem said:

Ensure that:

1. You are running the latest version of MySQL 
2. The user has full access (permissions) to the database you are using
3. That the full import was made when you imported the exile-database in the first place

 

Yes, I am using latest SQL version. Yes, extDB2 using full root access. I installed latest SQL 0.9.8 Exile tables, and, not work!

Share this post


Link to post
Share on other sites
Advertisement
  • 0
17 minutes ago, Alexis said:

Yes, I am using latest SQL version. Yes, extDB2 using full root access. I installed latest SQL 0.9.8 Exile tables, and, not work!

I mean the database access, ie. if you have a MySQL user called 'exile' on a database called 'exile' the user needs ALL rights to the database (GRANT ALL). 

Also, do a mysql --version (if you're using Linux) ... latest version should be 5.7 

Share this post


Link to post
Share on other sites
  • 0
12 minutes ago, Tobias Solem said:

I mean the database access, ie. if you have a MySQL user called 'exile' on a database called 'exile' the user needs ALL rights to the database (GRANT ALL). 

Also, do a mysql --version (if you're using Linux) ... latest version should be 5.7 

in RPT 

22:15:53 Error in expression <000 + (random 1000)
];
_vehicleObject = createVehicle [_vehicleClassName, _tempo>
22:15:53   Error position: <createVehicle [_vehicleClassName, _tempo>
22:15:53   Error Type Number,Not a Number, expected Number
22:15:53 File exile_server\code\ExileServer_object_vehicle_carefulCreateVehicle.sqf, line 23
22:15:53 Error in expression <llExtension _query);
(_result select 1) select 0>
22:15:53   Error position: <select 0>
22:15:53   Error Generic error in expression
22:15:53 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16

Yes, all rights GRANT ALL

Share this post


Link to post
Share on other sites
  • 0

Hello.

My players report me error code 13 (on screen) if buyed car Golf.

Have Tanoa map.

Any idea what is it?

Share this post


Link to post
Share on other sites
  • 0
6 minutes ago, bombajack said:

Hello.

My players report me error code 13 (on screen) if buyed car Golf.

Have Tanoa map.

Any idea what is it?

Code 13 means that the server can't find a safe place to spawn the vehicle.

Share this post


Link to post
Share on other sites
  • 0
6 minutes ago, BetterDeadThanZed said:

Code 13 means that the server can't find a safe place to spawn the vehicle.

Ah..thank you for answer..but they lost money and vehicle too...

Ok i will give back money in DB...

 

Thanks!

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.