Conquer icon indicating copy to clipboard operation
Conquer copied to clipboard

Database Error with EN db

Open JevLOMCN opened this issue 1 year ago • 2 comments

Game Server with CN Database:

[15/05/2024 21:07:14] Connecting to 'System' database [15/05/2024 21:07:14] Loading system data... [15/05/2024 21:07:15] MonsterInfo Template loaded, Total: 2323 [15/05/2024 21:07:15] GuardInfo Template loaded, Total: 923 [15/05/2024 21:07:15] NpcDialog Template loaded, Total: 798 [15/05/2024 21:07:15] GameMap Template loaded, Total: 177 [15/05/2024 21:07:15] Terrain Template loaded, Total: 192 [15/05/2024 21:07:15] MapArea Template loaded, Total: 206 [15/05/2024 21:07:15] TeleportGate Template loaded, Total: 557 [15/05/2024 21:07:15] MonsterSpawn Template loaded, Total: 215 [15/05/2024 21:07:15] MonsterBossTimedZen Template loaded, Total: 124 [15/05/2024 21:07:15] MapGuard Template loaded, Total: 1070 [15/05/2024 21:07:16] GameItem Template loaded, Total: 4203 [15/05/2024 21:07:16] RandomStats Template loaded, Total: 0 [15/05/2024 21:07:16] EquipmentStats Template loaded, Total: 13 [15/05/2024 21:07:16] GameStore Template loaded, Total: 84 [15/05/2024 21:07:16] RareTreasureItem Template loaded, Total: 57 [15/05/2024 21:07:16] GameTitle Template loaded, Total: 68 [15/05/2024 21:07:16] InscriptionSkill Template loaded, Total: 396 [15/05/2024 21:07:16] GameSkill Template loaded, Total: 1302 [15/05/2024 21:07:16] SkillTrap Template loaded, Total: 749 [15/05/2024 21:07:17] GameBuff Template loaded, Total: 3128 [15/05/2024 21:07:17] GameMount Template loaded, Total: 25 [15/05/2024 21:07:17] ItemSetInfo Template loaded, Total: 0 [15/05/2024 21:07:17] MountStats Template loaded, Total: 0 [15/05/2024 21:07:17] ItemCrafting Template loaded, Total: 0 [15/05/2024 21:07:17] System.ArgumentOutOfRangeException: Exception of type 'System.ArgumentOutOfRangeException' was thrown. (Parameter 'name') Actual value was VIPID. at Microsoft.Data.Sqlite.SqliteDataRecord.GetOrdinal(String name) at SqlReaderExtension.GetValue[T](DbDataReader reader, String column, T defValue) in G:\Mir3DEMU\GitHub\Conquer\Common\SqlReaderExtension.cs:line 13 at SqlReaderExtension.GetInt32(DbDataReader reader, String column, Int32 defValue) in G:\Mir3DEMU\GitHub\Conquer\Common\SqlReaderExtension.cs:line 24 at GameServer.Template.VIPSystem.LoadData() in G:\Mir3DEMU\GitHub\Conquer\GameServer\GameServer.Template\VIPSystem.cs:line 47 [15/05/2024 21:07:17] VIPSystem Template loaded, Total: 0 [15/05/2024 21:07:17] TreasureChestInfo Template loaded, Total: 0 [15/05/2024 21:07:17] Administrator Template loaded, Total: 0 [15/05/2024 21:07:17] The system data load is complete [15/05/2024 21:07:17] Loading user data... [15/05/2024 21:07:17] MentorInfo Loaded, Quantity: 0 [15/05/2024 21:07:17] GuildInfo Loaded, Quantity: 0 [15/05/2024 21:07:17] TeamInfo Loaded, Quantity: 0 [15/05/2024 21:07:17] MailInfo Loaded, Quantity: 0 [15/05/2024 21:07:17] PetInfo Loaded, Quantity: 2 [15/05/2024 21:07:17] BuffInfo Loaded, Quantity: 2 [15/05/2024 21:07:17] SkillInfo Loaded, Quantity: 80 [15/05/2024 21:07:17] AccountInfo Loaded, Quantity: 26 [15/05/2024 21:07:17] SystemInfo Loaded, Quantity: 1 [15/05/2024 21:07:17] ItemInfo Loaded, Quantity: 117 [15/05/2024 21:07:17] EquipmentInfo Loaded, Quantity: 67 [15/05/2024 21:07:17] CharacterInfo Loaded, Quantity: 6 [15/05/2024 21:07:17] Start working on data correlation tasks... [15/05/2024 21:07:17] Data correlation task processing completed, total number of tasks:170 [15/05/2024 21:07:17] Data Type:[ItemInfo], Internal Fields:[Owner], Total[107]Failed to correlate data [15/05/2024 21:07:17] Data Type:[EquipmentInfo], Internal Fields:[Owner], Total[13]Failed to correlate data [15/05/2024 21:07:17] Data Type:[AccountInfo], Internal Fields:[Characters], Total[20]Failed to correlate data [15/05/2024 21:07:17] The user data is loaded

Game Server with EN Database: Stuck at Terrain

[15/05/2024 21:08:09] Connecting to 'System' database [15/05/2024 21:08:09] Loading system data... [15/05/2024 21:08:10] MonsterInfo Template loaded, Total: 2323 [15/05/2024 21:08:10] GuardInfo Template loaded, Total: 923 [15/05/2024 21:08:10] NpcDialog Template loaded, Total: 798 [15/05/2024 21:08:10] GameMap Template loaded, Total: 177

Game Server with EN Database (With CN terrain files): Stuck at GameItem

[15/05/2024 21:09:29] Connecting to 'System' database [15/05/2024 21:09:29] Loading system data... [15/05/2024 21:09:31] MonsterInfo Template loaded, Total: 2323 [15/05/2024 21:09:31] GuardInfo Template loaded, Total: 923 [15/05/2024 21:09:31] NpcDialog Template loaded, Total: 798 [15/05/2024 21:09:31] GameMap Template loaded, Total: 177 [15/05/2024 21:09:31] Terrain Template loaded, Total: 192 [15/05/2024 21:09:31] MapArea Template loaded, Total: 206 [15/05/2024 21:09:31] TeleportGate Template loaded, Total: 557 [15/05/2024 21:09:31] MonsterSpawn Template loaded, Total: 215 [15/05/2024 21:09:31] MonsterBossTimedZen Template loaded, Total: 124 [15/05/2024 21:09:31] MapGuard Template loaded, Total: 1070

Maybe Terrains (Maps) and Items are somewhere hard coded in the Game Server. This will need to be adjusted to allow the use of an English Database.

Database - EN.zip

JevLOMCN avatar May 15 '24 20:05 JevLOMCN