DB3 error

DB3 error

« posted: Jul 03, 2017, 12:24 PM »
Hi people i have just created an external database on my website and i have used a dump from my host machine. I have got all the database from my host machine into the external db but the db3 is throwing the following error out.



[11:18:12:777343 +01:00] [Thread 4048] extDB3: Locked
[11:18:12:791992 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.DBInfo' doesn't exist
[11:18:12:791992 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: getDBVersion
[11:18:13:370117 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.ServerInstance' doesn't exist
[11:18:13:371093 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: checkServerInstance:3
[11:18:13:763671 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.ServerMap' doesn't exist
[11:18:13:763671 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: getServerMapID:Malden:normal
[11:18:14:561523 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Table 'anarchyg_a3wasteland.ServerObjects' doesn't exist
[11:18:14:561523 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Input: getServerObjects:3:any:,Class,Position,Direction,Locked,Damage,AllowDamage,OwnerUID,Variables,Weapons,Magazines,Items,Backpacks,TurretMagazines,AmmoCargo,FuelCargo,RepairCargo
[11:18:14:844726 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.ServerInstance' doesn't exist
[11:18:14:844726 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: getWarchestMoney:3
[11:18:14:943359 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Table 'anarchyg_a3wasteland.ServerVehicles' doesn't exist
[11:18:14:943359 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Input: getServerVehicles:3:any:,Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockState,Variables,Textures,Weapons,Magazines,Items,Backpacks,TurretMagazines,TurretMagazines2,TurretMagazines3,AmmoCargo,FuelCargo,RepairCargo
[11:18:16:000976 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.ServerMines' doesn't exist
[11:18:16:000976 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: deleteExpiredServerMines:3:any:48
[11:18:16:242187 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Table 'anarchyg_a3wasteland.ServerMines' doesn't exist
[11:18:16:242187 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBQueryException: Input: getServerMines:3:any:,Class,Position,Direction,Damage,OwnerUID,Variables
[11:18:20:918945 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Table 'anarchyg_a3wasteland.ServerTime' doesn't exist
[11:18:20:918945 +01:00] [Thread 2916] extDB3: SQL: Error MariaDBStatementException0: Input: getServerTime:3:any




the database does exist and i can see data in it. Has anyone got any ideas how to fix this please


thanks in advance

Re: DB3 error

« Reply #1 posted: Jul 04, 2017, 07:42 PM »
Anyone have any ideas please ?

Re: DB3 error

« Reply #2 posted: Jul 04, 2017, 07:59 PM »
I just moved my database to an external server also, I got the same error when I just copied the data over using Import data.

I ended up having to use the script to create the database to get everything to work correctly.

Re: DB3 error

« Reply #3 posted: Jul 04, 2017, 08:01 PM »
thanks for the reply what script did you use please ?

Re: DB3 error

« Reply #4 posted: Jul 04, 2017, 08:13 PM »
The sql script from the release files. The one you used to create your db in the first place.

Re: DB3 error

« Reply #5 posted: Jul 04, 2017, 08:22 PM »
thanks for that i have just added the sql script and got it to connect But did you add your database data into it after? and did it still work after you did?

Re: DB3 error

« Reply #6 posted: Jul 04, 2017, 08:27 PM »
I ended up scrapping my old database, it had too many problems. You should be able to import now.