ATM balances resetting after each restart after DB2.06

ATM balances resetting after each restart after DB2.06

« posted: Jul 13, 2017, 09:33 PM »
last night I updated to DB 2.06, I ran the sql script to update from 2.05 to 2.06, copied in the new .ini file, and added in the changes to the persistence files. Now after every restart ATM balances are reset to 0.

Re: ATM balances resetting after each restart after DB2.06

« Reply #1 posted: Jul 13, 2017, 10:18 PM »
Update: The problem seems to be in the persistence files, The new table in the database has ATM balances stored from when it was created, but wasteland doesn't seem to be able to access the new table.

Re: ATM balances resetting after each restart after DB2.06

« Reply #2 posted: Jul 13, 2017, 10:37 PM »
Here's a short error log from my dev server.

Code: [Select]

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 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[16:33:35:563254 -04:00] [Thread 1256] extDB3: Locked
[16:35:27:070056 -04:00] [Thread 6240] extDB3: SQL_CUSTOM: Error No Custom Call Not Found: Input String getPlayerBankMoney:76561198073390625
[16:35:27:070097 -04:00] [Thread 6240] extDB3: SQL_CUSTOM: Error No Custom Call Not Found: Callname getPlayerBankMoney
[16:36:09:224362 -04:00] [Thread 6240] extDB3: SQL: Error MariaDBQueryException: Unknown column 'BankMoney' in 'field list'
[16:36:09:224391 -04:00] [Thread 6240] extDB3: SQL: Error MariaDBQueryException: Input: insertOrUpdatePlayerInfo:76561198073390625:BankMoney=500000:BankMoney=VALUES(BankMoney)
[16:36:09:452833 -04:00] [Thread 6240] extDB3: SQL: Error MariaDBQueryException: Unknown column 'BankMoney' in 'field list'
[16:36:09:452854 -04:00] [Thread 6240] extDB3: SQL: Error MariaDBQueryException: Input: insertOrUpdatePlayerInfo:76561198073390625:Name='Monkey',LastSide='WEST',BankMoney=500000,Bounty=0,BountyKills='[]':Name=VALUES(Name),LastSide=VALUES(LastSide),BankMoney=VALUES(BankMoney),Bounty=VALUES(Bounty),BountyKills=VALUES(BountyKills)
[16:36:14:357638 -04:00] [Thread 7324] extDB3: SQL: Error MariaDBQueryException: Unknown column 'BankMoney' in 'field list'
[16:36:14:357664 -04:00] [Thread 7324] extDB3: SQL: Error MariaDBQueryException: Input: insertOrUpdatePlayerInfo:76561198073390625:BankMoney=500000,Bounty=0,BountyKills='[]':BankMoney=VALUES(BankMoney),Bounty=VALUES(Bounty),BountyKills=VALUES(BountyKills)
[16:37:08:558087 -04:00] [Thread 7324] extDB3: SQL: Error MariaDBQueryException: Unknown column 'BankMoney' in 'field list'
[16:37:08:558112 -04:00] [Thread 7324] extDB3: SQL: Error MariaDBQueryException: Input: insertOrUpdatePlayerInfo:76561198073390625:BankMoney=500000,Bounty=0,BountyKills='[]':BankMoney=VALUES(BankMoney),Bounty=VALUES(Bounty),BountyKills=VALUES(BountyKills)

  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2354

Re: ATM balances resetting after each restart after DB2.06

« Reply #3 posted: Jul 13, 2017, 11:03 PM »
v2.06 was made specifically for A3Armory and is still in beta. All it does is separate bank money and bounties according to the A3W_extDB_Environment variable. It requires the db206 branch from the vanilla Altis repo.

Re: ATM balances resetting after each restart after DB2.06

« Reply #4 posted: Jul 13, 2017, 11:35 PM »
Ah. Sounds like I need to do some roll backs