Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[KO_EN]

V22 After the character logs in, the server starts reporting errors and various red colors appear！Attachment 83422

Where is this happening? I doubt I can be any help, but I can tell you that those are errors about critters.
14881 is a spider, 4075 is a rat

[KO_EN]

For others like me wanting to move their accounts and characters from v21 to v22
I got it working again, so I'll share what I did to help others.
the database structure changed a bit compared to v21,
so we can't just copy and paste. but no worries, it's not too bad.

this is what I did:
- start up the database of v21 (run 'Start MySQL.bat') no need to start the rest. just mysql.
- run heidisql, open the database
- export characters database to sql file (on page 64 you can find a post of mine where I explain how to do this)
- export realmd/realmcharacters to sql file
- shut down v21

- start up new v22 (mysql, realmd and mangosd)
- recreate all your accounts in the mangosd console. in the same order as they were created in v21.
check with v21 if you have to.
- go over every database in characters from 'account_data' to 'worldstates' and delete all content in it.
hit 'show all' when needed, ctrl+a to select everything. right click 'delete selected rows'
afterwards go over every database in characters again, make sure everything is empty.
- run your characters database sql file, run the query. check afterwards if it filled up your characters database.
should not give any errors or warnings.
- select everything in realmd/realmcharacters and delete it.
run your realmcharacters sql file, run the query to fill it with data from v21.
- edit realmd/realmlist

done.

We had to manually recreate the accounts because realmd/account has 2 new columns, os and platform
And characters has 2 new tables as well, account_data and character_account_data

[splord1990]

V22 After creating a character and entering the game, Mangos starts reporting this error. I don't know if it's just me or if it happens to everyone. The character will report an error every time they go online, but it does not affect playing the game.

I have been running the server for a while, but now he reports other red errors. I don't understand what this means either.1.png

[KO_EN]

V22 After creating a character and entering the game, Mangos starts reporting this error. I don't know if it's just me or if it happens to everyone. The character will report an error every time they go online, but it does not affect playing the game.

I have been running the server for a while, but now he reports other red errors. I don't understand what this means either.1.png

After a bit of searching in the database I found script 852401 is about:
Cursed Mage - Cast Spell Tainted Mind
it's a curse that reduces intellect by 20%

When I kill a Cursed Mage in eastern plaguelands, when it dies I get the error as well.
and I'm not cursed by the mage.

Not a fix, but at least now you know what's happening.

[splord1990]

After a bit of searching in the database I found script 852401 is about:
Cursed Mage - Cast Spell Tainted Mind
it's a curse that reduces intellect by 20%

When I kill a Cursed Mage in eastern plaguelands, when it dies I get the error as well.
and I'm not cursed by the mage.

Not a fix, but at least now you know what's happening.

s there any way to solve this error? Will it have an impact on the game process? It is reporting an error in a loop, is it ignoring this error now?

[Crixx]

I got a graphic problem with polymorph, don't know if it's only me, instead of a sheep I see a cube with white and blue squares.
About the errors I have them even in a clear start, without porting, that I post ...
some are warning easily solvable, others are due to patch restrictions (I'm playing with wow patch 0 while some enrty start in future patch)
but others like "Table `gameobject` has gameobject..." seems they refer to something really missin in the DB

2023-06-25 21:26:15 WARNING! Database `characters` has the following extra migrations:
2023-06-25 21:26:15 20200316170243
2023-06-25 21:26:15 WARNING! Database `logs` has the following extra migrations:
2023-06-25 21:26:15 20190314171530
2023-06-25 21:26:20 ERROR: Gameobject (Entry: 180053 GoType: have data2=181029 but trap GO (Entry 181029) not exist in `gameobject_template`.
2023-06-25 21:26:20 Spell 6346 listed in `spell_proc_event` has exactly same proc flags as in spell.dbc, field value redundant
2023-06-25 21:26:21 Spell 25918 listed in `spell_threat` as custom rank has same data as Rank 1, so redundant
2023-06-25 21:26:22 Unknown item (entry=19214) in creature_equip_template.equipentry1 for entry = 3794, forced to 0.
2023-06-25 21:26:22 Unknown item (entry=2441 in creature_equip_template.equipentry1 for entry = 7013, forced to 0.
2023-06-25 21:26:22 Unknown item (entry=2441 in creature_equip_template.equipentry2 for entry = 7013, forced to 0.
2023-06-25 21:26:22 Table `creature_template` have creature (Entry: 10162) with equipment_id 10162 not found in table `creature_equip_template`, set to no equipment.
2023-06-25 21:26:22 >> Loaded `reputation_reward_rate`, table is empty!
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 99915) with non existing gameobject entry 180401, skipped.
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 99914) with non existing gameobject entry 180250, skipped.
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 99913) with non existing gameobject entry 180249, skipped.
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 99912) with non existing gameobject entry 180402, skipped.
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 99894) with non existing gameobject entry 179677, skipped.
2023-06-25 21:26:24 Table `gameobject` has gameobject (GUID: 563) with non existing gameobject entry 179552, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38277) defined for pool id (4033), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38274) defined for pool id (4030), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38273) defined for pool id (4029), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29691) defined for pool id (4055), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29690) defined for pool id (4053), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38265) defined for pool id (4021), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38263) defined for pool id (4019), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38261) defined for pool id (4017), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38259) defined for pool id (4015), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38257) defined for pool id (4013), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38245) defined for pool id (4001), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38252) defined for pool id (400, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38251) defined for pool id (4007), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38249) defined for pool id (4005), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38247) defined for pool id (4003), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38266) defined for pool id (4022), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38262) defined for pool id (401, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38256) defined for pool id (4012), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38271) defined for pool id (4027), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38270) defined for pool id (4026), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38280) defined for pool id (4036), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38282) defined for pool id (403, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38283) defined for pool id (4039), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38285) defined for pool id (4041), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38286) defined for pool id (4042), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3828 defined for pool id (4044), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38290) defined for pool id (4046), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38291) defined for pool id (4047), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38293) defined for pool id (4049), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38295) defined for pool id (4051), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38296) defined for pool id (4052), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38297) defined for pool id (4053), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38299) defined for pool id (4055), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38300) defined for pool id (4056), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38302) defined for pool id (405, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38303) defined for pool id (4059), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38306) defined for pool id (4062), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38307) defined for pool id (4063), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3830 defined for pool id (4064), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38312) defined for pool id (406, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38314) defined for pool id (4070), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38315) defined for pool id (4071), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38316) defined for pool id (4072), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38319) defined for pool id (4075), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38322) defined for pool id (407, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38323) defined for pool id (4079), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38324) defined for pool id (4080), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38325) defined for pool id (4081), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38326) defined for pool id (4082), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38327) defined for pool id (4083), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3832 defined for pool id (4084), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38330) defined for pool id (4086), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38333) defined for pool id (4089), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38334) defined for pool id (4090), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38335) defined for pool id (4091), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38336) defined for pool id (4092), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3833 defined for pool id (4094), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38340) defined for pool id (4096), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38342) defined for pool id (409, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38343) defined for pool id (4099), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38344) defined for pool id (4100), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38345) defined for pool id (4001), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38347) defined for pool id (4003), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38349) defined for pool id (4005), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38351) defined for pool id (4007), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38352) defined for pool id (400, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38356) defined for pool id (4012), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38357) defined for pool id (4013), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38359) defined for pool id (4015), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38361) defined for pool id (4017), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38362) defined for pool id (401, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38363) defined for pool id (4019), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38365) defined for pool id (4021), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38366) defined for pool id (4022), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38370) defined for pool id (4026), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38371) defined for pool id (4027), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38373) defined for pool id (4029), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38374) defined for pool id (4030), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38377) defined for pool id (4033), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38380) defined for pool id (4036), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38382) defined for pool id (403, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38383) defined for pool id (4039), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38385) defined for pool id (4041), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38386) defined for pool id (4042), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3838 defined for pool id (4044), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38390) defined for pool id (4046), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38391) defined for pool id (4047), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38393) defined for pool id (4049), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38395) defined for pool id (4051), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38396) defined for pool id (4052), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38397) defined for pool id (4053), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38399) defined for pool id (4055), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38400) defined for pool id (4056), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38402) defined for pool id (405, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38403) defined for pool id (4059), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38406) defined for pool id (4062), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38407) defined for pool id (4063), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3840 defined for pool id (4064), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38412) defined for pool id (406, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38414) defined for pool id (4070), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38415) defined for pool id (4071), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38416) defined for pool id (4072), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38419) defined for pool id (4075), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38422) defined for pool id (407, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38423) defined for pool id (4079), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38424) defined for pool id (4080), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38425) defined for pool id (4081), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38426) defined for pool id (4082), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38427) defined for pool id (4083), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3842 defined for pool id (4084), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38430) defined for pool id (4086), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38433) defined for pool id (4089), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38434) defined for pool id (4090), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38435) defined for pool id (4091), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38436) defined for pool id (4092), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3843 defined for pool id (4094), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38440) defined for pool id (4096), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38442) defined for pool id (409, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38443) defined for pool id (4099), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38444) defined for pool id (4100), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38445) defined for pool id (4001), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38447) defined for pool id (4003), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38449) defined for pool id (4005), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38451) defined for pool id (4007), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38452) defined for pool id (400, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38456) defined for pool id (4012), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38457) defined for pool id (4013), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38459) defined for pool id (4015), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38461) defined for pool id (4017), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38462) defined for pool id (401, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38463) defined for pool id (4019), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38465) defined for pool id (4021), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38466) defined for pool id (4022), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38470) defined for pool id (4026), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38471) defined for pool id (4027), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38473) defined for pool id (4029), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38474) defined for pool id (4030), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38477) defined for pool id (4033), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38480) defined for pool id (4036), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38482) defined for pool id (403, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38483) defined for pool id (4039), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38485) defined for pool id (4041), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38486) defined for pool id (4042), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3848 defined for pool id (4044), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38490) defined for pool id (4046), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38491) defined for pool id (4047), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38493) defined for pool id (4049), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38495) defined for pool id (4051), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38496) defined for pool id (4052), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38497) defined for pool id (4053), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38499) defined for pool id (4055), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38500) defined for pool id (4056), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38502) defined for pool id (405, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38503) defined for pool id (4059), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38506) defined for pool id (4062), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38507) defined for pool id (4063), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3850 defined for pool id (4064), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38512) defined for pool id (406, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38514) defined for pool id (4070), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38515) defined for pool id (4071), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38516) defined for pool id (4072), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38519) defined for pool id (4075), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38522) defined for pool id (407, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38523) defined for pool id (4079), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38524) defined for pool id (4080), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38525) defined for pool id (4081), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38526) defined for pool id (4082), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38527) defined for pool id (4083), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3852 defined for pool id (4084), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38530) defined for pool id (4086), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38533) defined for pool id (4089), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38534) defined for pool id (4090), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38535) defined for pool id (4091), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38536) defined for pool id (4092), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 3853 defined for pool id (4094), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38540) defined for pool id (4096), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38542) defined for pool id (409, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38543) defined for pool id (4099), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 38544) defined for pool id (4100), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26364) defined for pool id (4022), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26365) defined for pool id (4027), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26366) defined for pool id (4030), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26367) defined for pool id (4062), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 2636 defined for pool id (4089), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26369) defined for pool id (4001), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29692) defined for pool id (4059), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29693) defined for pool id (4071), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29694) defined for pool id (4072), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29695) defined for pool id (4081), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29697) defined for pool id (4086), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 2969 defined for pool id (4089), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 29699) defined for pool id (409, skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26370) defined for pool id (4053), skipped.
2023-06-25 21:26:25 `pool_gameobject` has a non existing gameobject spawn (GUID: 26371) defined for pool id (402, skipped.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 11351 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 11487 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 12397 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 14321 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 14327 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 14682 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 14686 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15111 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15807 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15808 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15810 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15811 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15812 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 15980 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'creature_loot_template' entry 16154 isn't creature entry and not referenced from loot, and then useless.
2023-06-25 21:26:30 Table 'skinning_loot_template' entry 10184 (creature skinning id) not exist but used as loot id in DB.
2023-06-25 21:26:30 Table 'skinning_loot_template' entry 10990 isn't creature skinning id and not referenced from loot, and then useless.
2023-06-25 21:26:32 ERROR: Craft spell 24654 create item (Entry: 20295) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24656 learn to invalid spell 24654, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 7866) has broken learning spell 24656, ignore
2023-06-25 21:26:32 ERROR: Craft spell 24655 create item (Entry: 20296) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24657 learn to invalid spell 24655, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 7867) has broken learning spell 24657, ignore
2023-06-25 21:26:32 ERROR: Craft spell 24655 create item (Entry: 20296) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24657 learn to invalid spell 24655, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 7866) has broken learning spell 24657, ignore
2023-06-25 21:26:32 ERROR: Craft spell 24654 create item (Entry: 20295) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24656 learn to invalid spell 24654, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 7867) has broken learning spell 24656, ignore
2023-06-25 21:26:32 ERROR: Craft spell 22808 create item (Entry: 18294) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 22809 learn to invalid spell 22808, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 1386) has broken learning spell 22809, ignore
2023-06-25 21:26:32 ERROR: Craft spell 22808 create item (Entry: 18294) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 22809 learn to invalid spell 22808, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 794 has broken learning spell 22809, ignore
2023-06-25 21:26:32 ERROR: Craft spell 22808 create item (Entry: 18294) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 22809 learn to invalid spell 22808, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 4160) has broken learning spell 22809, ignore
2023-06-25 21:26:32 ERROR: Craft spell 22808 create item (Entry: 18294) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 22809 learn to invalid spell 22808, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 4611) has broken learning spell 22809, ignore
2023-06-25 21:26:32 ERROR: Craft spell 23070 create item (Entry: 18641) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 23095 learn to invalid spell 23070, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 8736) has broken learning spell 23095, ignore
2023-06-25 21:26:32 ERROR: Craft spell 22808 create item (Entry: 18294) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 22809 learn to invalid spell 22808, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5032) has broken learning spell 22809, ignore
2023-06-25 21:26:32 ERROR: Craft spell 23071 create item (Entry: 18631) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 23088 learn to invalid spell 23071, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5037) has broken learning spell 23088, ignore
2023-06-25 21:26:32 ERROR: Craft spell 23070 create item (Entry: 18641) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 23095 learn to invalid spell 23070, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5037) has broken learning spell 23095, ignore
2023-06-25 21:26:32 ERROR: Craft spell 23486 create item (Entry: 18984) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 23490 learn to invalid spell 23486, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5037) has broken learning spell 23490, ignore
2023-06-25 21:26:32 ERROR: Craft spell 23489 create item (Entry: 18986) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 23491 learn to invalid spell 23489, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5037) has broken learning spell 23491, ignore
2023-06-25 21:26:32 ERROR: Craft spell 24654 create item (Entry: 20295) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24656 learn to invalid spell 24654, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5040) has broken learning spell 24656, ignore
2023-06-25 21:26:32 ERROR: Craft spell 24655 create item (Entry: 20296) but item does not exist in item_template.
2023-06-25 21:26:32 ERROR: Spell 24657 learn to invalid spell 24655, and then...
2023-06-25 21:26:32 Table `npc_trainer` (Entry: 5040) has broken learning spell 24657, ignore

[KO_EN]

hi Crixx,

a lot of these errors can be chased down and solved

I've seen the polymorph error as well, in previous versions of the repack at least
I think it's caused by mages casting Polymorph pig instead of sheep.
And because polymorph pig wasn't available in early wow patches I think that's why we see the white and blue square box instead

Gameobject 180053 is about a brazier placed in patch 0
the database is trying to add burning coals to the brazier that don't exist until patch 8
this can be fixed by making the coals available at patch 0 or by not trying to place the coals.
or ignore it, it's not harmful. I made the coals available at patch 0.

19214 = Monster - Staff, Wooden Handle Spiral Head Dark
the item is patch 4, so I think that's why you get this error when you run the server on patch 0
the item is given to creature 3794 (druid of the talon)
Druid of the Talon - NPC - Classic World of Warcraft
the creature is not placed anywhere in the world.
harmless error, could be fixed by giving the item to the creature at patch 4 instead of 0. That's what I did

24418 = Monster - Dagger Badass Naxx
the item is patch 9, so that's why we get this error when we run the server on anything before patch 9.
the item is given to creature 7013 (blackrock rampager)
Blackrock Rampager - NPC - Classic World of Warcraft
the creature is not placed anywhere in the world.
harmless error, could be fixed by giving the item to the creature at patch 9 instead of 0. That's what I did

creature 10162 = Lord Victor Nefarius, set to patch 0
but the database is trying to give him an item 19404 (Monster - Mace, The Hand of Nefarius) that doesn't exist until patch 4
so because you're running the server on patch 0 you get this error
we see Nefarius in UBRS before patch 4.
can be fixed by giving him the mace at patch 4 instead of 0

all the gameobject errors seem to be about mining nodes
trying to place game objects (mining nodes) that don't exist yet
edit: I found the problem.
in pool_template the patch_min is set to 0
but in gameobject the patch_min is set to 5
so you're getting those errors because those mining nodes are not available until patch 5.
that also explains why I don't get those errors. I play on patch 6.
probably resulting in the desired effect, fewer mining nodes before patch 5, but it should be done in a way that doesn't give so many errors.

the creature_loot_template errors are about adding loot to enemies that don't exist yet.
example, the last one, 16154, a Risen Deathknight, found in Naxx
you can go to creature_loot_template and set all patch_min to 9 for entry 16154
do this for all of them and that will get rid of the errors.

the errors with 'npc_trainer has broken learning spell'
not 100% sure why you are getting these
it's about crafting recipes, like 24657 is 'green dragonscale gauntlets'
if i remember correctly this recipe is not available right away
so I think it's again because of you are running wow patch 0
like it's trying to add the recipe to the merchant, but it fails because the recipe shouldn't exist yet.
I think that's what's happening.

22809 is Elixir of Greater Water Breathing
after reading wowhead comments it seems this recipe was also not available at the start

[KO_EN]

s there any way to solve this error? Will it have an impact on the game process? It is reporting an error in a loop, is it ignoring this error now?

I don't know the answers to those questions. I'm not sure how the spell, the curse works.
a wowhead comment from 2006 says "These buggers always cast Tainted Mind (Int -20% for 10 minutes) before they die. Every time."
I don't know for sure if the mage is supposed to curse you when he dies, or while he's still fighting you,
niether do I know if distance matters at the time the mage dies.

I don't know what the target_param1 and target_param2 or what target_type 1 is. it's not explained in the database comment section. and I can't find it online either, i tried googling it.
it shouldn't report that error in a loop. only when a cursed mage dies.

I'm getting quite a lot of errors in v22 as well that I was not getting in v21
most are about movement, the "failed to generate random points for creature"
I'll see if someone has any answers on discord.

https://i.gyazo.com/bebd87ea12d1f3ea...1362d2db2e.png
i get these often. campfires being removed by Syndicate Conjurors. at least that's what it looks like.
I don't know yet what's going on. Are Syndicate Conjurors placing their own campfires now?
and the other one is about a Stormsnout not knowing where to walk to next.
but I get all sorts of creatures producing that error.

[Crixx]

Thanks a lot KO_EN, with your help I've solved almost all the errors, at least till "Table 'creature_loot_template' entry...",
about setting the patch_min there, it is already at the correct number, for example the first entry 11351 it is already at patch min 5, the entry 16154 it is already at patch min 9,
I've seen with entry the tables creature_loot_template and creature_template and with id the table creature, don't know if creature is related with id/entry but anyway the patch is aligned ...
about the other errors of spells and npc_trainer I'm too tired now to continue, but I will see tomorrow following your helpfull instructions

thanks again

[KO_EN]

there are multiple rows for 16154. Most of them were indeed already set correctly. only a few of them weren't.
there are 35 rows for 16154 as an example. carefully go over them and set patch_min to 9 for each of those.

you do have to be careful though. like with 11351 it's a bit different already. that's a Gurubashi Headhunter in ZG.
most loot he can drop should be set at patch_min 5. but some loot was added to his loot table in patch 7.
you can set all the patch_min entries that are now at 0 to 5 to get rid of the errors, but some of it may have to be set to 7 to be correct.
I haven't touched this one yet myself because ZG is available for me on patch 6, so 11351 has not been giving me errors.

but let's check it now, 11351 has 1 entry at the bottom where patch_min is set to 0. item 14557
I then look up item 14557 in item_template and find out it's "The Lion Horn of Stormwind"
tough example as I have no idea after looking it up on wowhead if this is supposed to drop in patch 5 or 7
but as it is right now it's dropping for me with it's current setting of patch_min = 0.
so I might as well set it to patch_min = 5.
if I ever go back to patch 4 or lower this one won't give me any errors anymore.

[Najnos]

Huge THANKS for version 22! Very much appreciated

Whaaaaat, when, where, whats new?

[Crixx]

@Najnos at page1 @KO_EN It puzzles me that the errors reported are less than they should be according to this query:

SELECT * FROM creature_loot_template a WHERE patch_min < (SELECT MIN(patch) FROM creature_template b WHERE b.entry = a.entry) ORDER BY entry;

where I get 65 rows while reported errors of this kind are only 6
for example item 19882 for entry 11380 has patch_min 0 while 11380 has patch 5 in creature_template like the entry 11351, but no error is reported for this
Cattura.JPG

[KO_EN]

let's take this to PM's. no need to fill up this forum with our messages.




sorry Najnos, I didn't know about the 5 messages limit per day.

https://www.ownedcore.com/forums/wor...ml#post4379591 (Elysium Core 1.12 Repack - Including MMaps and Optional Vendors)
this post on page 64 should answer your question.

[Najnos]

Ive been tryin to transfer characters from v21 to 22 for 5h non stop now, and i give up.
One time i do it and when i log into account, i see my character and everything looks fine, then i log in and i found out that all my items are gone and character is naked, everything else is saved, i have my reputation, the quest i was on, and even location, but all items gone. (i checked heldisql character database and at row where equipment cache is, all is 0,0,0,0,0,0) it was fine until i loged in*
Then i deleted everything and tried again, this time, i didnt get reputaiton or quest even, only location and level 40..
And after i exit and start mysql and realmd and try to open any mangosd.exe it just auto-exit after flash... long story short i didnt do something right..
I fck something in Helidsql and i just dont get it.. If u could post video about it i would much appritiate it..

[KO_EN]

Ive been tryin to transfer characters from v21 to 22 for 5h non stop now, and i give up.
One time i do it and when i log into account, i see my character and everything looks fine, then i log in and i found out that all my items are gone and character is naked, everything else is saved, i have my reputation, the quest i was on, and even location, but all items gone. (i checked heldisql character database and at row where equipment cache is, all is 0,0,0,0,0,0) it was fine until i loged in*
Then i deleted everything and tried again, this time, i didnt get reputaiton or quest even, only location and level 40..
And after i exit and start mysql and realmd and try to open any mangosd.exe it just auto-exit after flash... long story short i didnt do something right..
I fck something in Helidsql and i just dont get it.. If u could post video about it i would much appritiate it..

Alright, I just finished making a 15 minute video to show you how I managed to copy my accounts and characters
https://youtu.be/QgmAauaaT88
I'll post it here so it can maybe help others as well.

Make back-ups. Don't throw your v21 installation away.
And sorry in advance for some loud mic noices during the recording