Jump to content
Ignat

Altis Life Garage not working

Recommended Posts

Hi all
this is my problem: I currently setting up a Altis Life server on 4.4. DB settup via XAMPP. The Player Database is working so far. My Problem is that Vehicles that are bought and stored in garage are not indicated in it. That means you cant retrieve your Car from the garage. My ExtDB2 Log: is fine all clear.
Does anyone has an idea how to fix this issue?
Best Regards
Ignat

Edited by Ignat

Share this post


Link to post
Share on other sites

You need to give more information and post logs, especially extdb and sever logs. Otherwise you should just throw some debug code in the script responsible for sending that sql command and see what is going on.

Share this post


Link to post
Share on other sites
41 minutes ago, killerty69 said:

You need to give more information and post logs, especially extdb and sever logs. Otherwise you should just throw some debug code in the script responsible for sending that sql command and see what is going on.

First of all i want say thank you for repond to me.



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


[22:06:50:717143 +03:00] [Thread 2176] extDB2: Database Type: MySQL
[22:06:50:721299 +03:00] [Thread 2176] extDB2: Database Session Pool Started
[22:06:50:836708 +03:00] [Thread 2176] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[22:31:08:163062 +03:00] [Thread 2176] extDB2: Stopping ...

 

Edited by Ignat

Share this post


Link to post
Share on other sites

Well that didn't help at all, perhaps you should use the debug version of extdb that shows everything. Also you should purchase a vehicle and then post the client and server side RPTS. 

Share this post


Link to post
Share on other sites

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


[22:55:25:869760 --4:00] [Thread 2384] extDB2: Database Type: MySQL
[22:55:25:882595 --4:00] [Thread 2384] extDB2: Database Session Pool Started
[22:55:25:882803 --4:00] [Thread 2384] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[22:58:23:120753 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_level' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: SELECT exp_level, exp_total, exp_perkPoints, exp_perks FROM players WHERE playerid = '76561198007151714'
[22:58:23:120806 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT exp_level, exp_total, exp_perkPoints, exp_perks FROM players WHERE playerid = '76561198007151714'
[22:59:52:049976 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'playerid' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: INSERT INTO vehicles (side, classname, type, playerid, alive, active, inventory, color, plate, gear, damage) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198007151714', '1','1','"[[],0]"', '35', '893285','"[]"','"[]"')
[22:59:52:050037 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, playerid, alive, active, inventory, color, plate, gear, damage) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198007151714', '1','1','"[[],0]"', '35', '893285','"[]"','"[]"')
[22:59:52:144092 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_level' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_level = '0' WHERE playerid = '76561198007151714'
[22:59:52:144154 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_level = '0' WHERE playerid = '76561198007151714'
[22:59:52:145009 --4:00] [Thread 4216] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_total' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_total = '5' WHERE playerid = '76561198007151714'
[22:59:52:145045 --4:00] [Thread 4216] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_total = '5' WHERE playerid = '76561198007151714'
[22:59:52:145040 --4:00] [Thread 4236] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_perkPoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_perkPoints = '0' WHERE playerid = '76561198007151714'
[22:59:52:145128 --4:00] [Thread 4236] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_perkPoints = '0' WHERE playerid = '76561198007151714'
[22:59:52:145299 --4:00] [Thread 4532] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_perks' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_perks = '[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[["perk_gunsspecialist_lessRecoil_3",0]]]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[["perk_paycheck_3",0]]]]],[["perk_processing_1",0],[[["perk_processing_2",0],[["perk_processing_3",0]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[["perk_locksmith_3",0]]]]]]' WHERE playerid = '76561198007151714'
[22:59:52:145394 --4:00] [Thread 4532] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_perks = '[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[["perk_gunsspecialist_lessRecoil_3",0]]]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[["perk_paycheck_3",0]]]]],[["perk_processing_1",0],[[["perk_processing_2",0],[["perk_processing_3",0]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[["perk_locksmith_3",0]]]]]]' WHERE playerid = '76561198007151714'
 

Share this post


Link to post
Share on other sites
Just now, MT519 said:

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


[22:55:25:869760 --4:00] [Thread 2384] extDB2: Database Type: MySQL
[22:55:25:882595 --4:00] [Thread 2384] extDB2: Database Session Pool Started
[22:55:25:882803 --4:00] [Thread 2384] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[22:58:23:120753 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_level' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: SELECT exp_level, exp_total, exp_perkPoints, exp_perks FROM players WHERE playerid = '76561198007151714'
[22:58:23:120806 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT exp_level, exp_total, exp_perkPoints, exp_perks FROM players WHERE playerid = '76561198007151714'
[22:59:52:049976 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'playerid' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: INSERT INTO vehicles (side, classname, type, playerid, alive, active, inventory, color, plate, gear, damage) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198007151714', '1','1','"[[],0]"', '35', '893285','"[]"','"[]"')
[22:59:52:050037 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, playerid, alive, active, inventory, color, plate, gear, damage) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198007151714', '1','1','"[[],0]"', '35', '893285','"[]"','"[]"')
[22:59:52:144092 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_level' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_level = '0' WHERE playerid = '76561198007151714'
[22:59:52:144154 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_level = '0' WHERE playerid = '76561198007151714'
[22:59:52:145009 --4:00] [Thread 4216] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_total' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_total = '5' WHERE playerid = '76561198007151714'
[22:59:52:145045 --4:00] [Thread 4216] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_total = '5' WHERE playerid = '76561198007151714'
[22:59:52:145040 --4:00] [Thread 4236] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_perkPoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_perkPoints = '0' WHERE playerid = '76561198007151714'
[22:59:52:145128 --4:00] [Thread 4236] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_perkPoints = '0' WHERE playerid = '76561198007151714'
[22:59:52:145299 --4:00] [Thread 4532] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'exp_perks' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE players SET exp_perks = '[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[["perk_gunsspecialist_lessRecoil_3",0]]]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[["perk_paycheck_3",0]]]]],[["perk_processing_1",0],[[["perk_processing_2",0],[["perk_processing_3",0]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[["perk_locksmith_3",0]]]]]]' WHERE playerid = '76561198007151714'
[22:59:52:145394 --4:00] [Thread 4532] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET exp_perks = '[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[["perk_gunsspecialist_lessRecoil_3",0]]]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[["perk_paycheck_3",0]]]]],[["perk_processing_1",0],[[["perk_processing_2",0],[["perk_processing_3",0]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[["perk_locksmith_3",0]]]]]]' WHERE playerid = '76561198007151714'
 

so much going on here don't know what im looking at lol

Share this post


Link to post
Share on other sites

yes, in game it seems to be working fine. not sure what all the errors are for?? i'm able to see my total xp/talent tree ect. with no problems. i'm thinking its just the data base. and with all my changes to the db i want to re frame from having to figure out how to wipe it and starting over. 

Edited by MT519
giving a bit more info

Share this post


Link to post
Share on other sites

There are missing things on your database. Contact Marverick support to fix your problems.

Share this post


Link to post
Share on other sites
13 minutes ago, joew said:

There are missing things on your database. Contact Marverick support to fix your problems.

you think that could mess with the garage data tho?

Share this post


Link to post
Share on other sites

It's not that vehicles aren't be shown in the garage, it's that they're not being inserted to the database.

[22:59:52:050037 --4:00] [Thread 4364] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, playerid, alive, active, inventory, color, plate, gear, damage) VALUES ('civ', 'C_SUV_01_F', 'Car', '76561198007151714', '1','1','"[[],0]"', '35', '893285','"[]"','"[]"')

Your query to insert is referring to "playerid", however the column has been called "pid" for a long time, it is likely that the SQL file you're using does not match the framework version that you're using. You'll need to correct these query references or use the correct file combination.

  • Like 1

Share this post


Link to post
Share on other sites

I am with the same problem, I bought the vehicle I go to the garage and I keep the vehicle, when I go to remove the vehicle it does not appear.

 

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.028
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 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: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 4 Cores, Setting up 4 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[23:31:16:631055 -03:00] [Thread 4532] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[23:31:16:631055 -03:00] [Thread 4532] extDB3: SQL: Initialized: NULL = ""
[23:31:16:631055 -03:00] [Thread 4532] extDB3: Locked
[23:32:19:113629 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Unknown column 'exp_level' in 'field list'
[23:32:19:113629 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Input: SELECT exp_level, exp_total, exp_perkPoints, exp_perks FROM players WHERE pid = '76561198273771513'
[23:36:29:537952 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Unknown column 'exp_level' in 'field list'
[23:36:29:537952 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE players SET exp_level = '0' WHERE pid = '76561198273771513'
[23:36:29:538952 -03:00] [Thread 5800] extDB3: SQL: Error MariaDBQueryException: Unknown column 'exp_perkPoints' in 'field list'
[23:36:29:538952 -03:00] [Thread 5800] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE players SET exp_perkPoints = '0' WHERE pid = '76561198273771513'
[23:36:29:538952 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Unknown column 'exp_perks' in 'field list'
[23:36:29:538952 -03:00] [Thread 5804] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE players SET exp_perks = '[[["perk_processing_1",0],[[["perk_processing_2",0],[["perk_processing_3",0]]]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[["perk_locksmith_3",0]]]]]]' WHERE pid = '76561198273771513'
[23:36:29:538952 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Unknown column 'exp_total' in 'field list'
[23:36:29:538952 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE players SET exp_total = '5' WHERE pid = '76561198273771513'
[23:38:13:458896 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Unknown column 'insure' in 'field list'
[23:38:13:458896 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Input: SELECT id, side, classname, type, pid, alive, active, plate, color, insure FROM vehicles WHERE pid='76561198273771513' AND alive='1' AND active='0' AND side='civ' AND type='Car'
[23:38:24:120506 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Unknown column 'insure' in 'field list'
[23:38:24:120506 -03:00] [Thread 5796] extDB3: SQL: Error MariaDBQueryException: Input: SELECT id, side, classname, type, pid, alive, active, plate, color, insure FROM vehicles WHERE pid='76561198273771513' AND alive='1' AND active='0' AND side='civ' AND type='Car'

 

could someone help me, please ...

arma3server_2018-09-23_23-28-43.rpt

Share this post


Link to post
Share on other sites

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

×