DB-Errors, SQL Query Errors and a question about mod-individual-progression HOT 7 CLOSED

From the latest update 'The True Masters questline fixes'

quest_missing_diplomat.sql
/* SQL Error (1062): Duplicate entry '1748-11223' for key 'creature_queststarter.PRIMARY' */

from mod-individual-progression.

Thank you for the helpful and detailed report! None of these errors should prevent playable, but can be fixed. I will create an update to solve them as I can. The negative resistances error may require a change to AzerothCore upstream to support, but I can create a PR with that update if needed.

For the AQ quest, you are correct, it seems I did not check in that SQL file! I will push an update to add the missing file.

Thank you for willing to test the project! Please let me know if you are encountering any more issues.

EDIT: I have added the file with the AQ Rep Reward tweak in the latest update.

from mod-individual-progression.

With the latest updates, all SQL errors should be resolve, so I am going to close this issue. Please re-open if you are continue to see any problem. Thank you!

from mod-individual-progression.

So, I recently switched to MySQL 8.0.29 and updated the module, only to find out that I couldn't apply the restore_vanilla_elites.sql. Here is the error message i got:

SQL Error (1064): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'rank=1 WHERE entry=314" at line 2

Here is a screenshot of the query in HeidiSQL:

restore_vanilla_elites.sql

Unfortunately 'rank' is a reserved keyword. AC suggests to use backticks ( ` ) around table- and column names.
To solve this, the query should look like this (I got it working that way):

UPDATE `creature_template` SET `DamageModifier`=6.43, `HealthModifier`=3.00, `minlevel`=31, `maxlevel`=31, `rank`=1 WHERE `entry`=314;

Oh, and the mounts_and_riding.sql still needs a fix for it's spacing error. (see original post)

The Vile Familiars (Warlock) entries in the zone_the_barrens.sql should be in the zone_durotar.sql.
(This is the Imp-Quest in the Orc starter zone.)

On top of that, there are also some new errors in the DBError.log.
(there are still some from the original post, I'm listing only the new ones here, although tell me if you need the old ones again):

DB-Errors:

Creature (Entry: 11679, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22796, class 1).
Creature (Entry: 12157, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22792, class 1).
Creature (Entry: 13419, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22627, class 1).
Creature (Entry: 13539, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22532, class 1).
Creature (Entry: 13541, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22774, class 1).
Creature (Entry: 13542, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22534, class 1).
Creature (Entry: 13548, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22529, class 1).
Creature (Entry: 13557, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22537, class 1).
Creature (Entry: 13956, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22790, class 1).
Creature (Entry: 13958, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22791, class 1).
Creature (Entry: 14021, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22599, class 1).
Creature (Entry: 16505, class 8) has different `unit_class` in difficulty 1 mode (Entry: 29273, class 1).

Creature (GUID: 88165) does not exist but has a record in `creature_addon`
Creature (GUID: 88166) does not exist but has a record in `creature_addon`

Finally there is a config error in the Server.log:

Config-Error in Server.log:

Config: Missing property IndividualProgression.VanillaHealingAdjustment in all config files, at least the .dist file must contain: "IndividualProgression.VanillaHealingAdjustment = 1.000000"

This is just a spelling error. In the config file (and .dist) it says:

IndividualProgression.VanillaHealingAdjustmnet = 0.5

Edit: Apparently I can't reopen this because you closed it, so maybe you should just reopen it and leave it open.

from mod-individual-progression.

Sorry, I did not see your comment earlier! Thank you for the corrections! I will make these fixes.

from mod-individual-progression.

From the latest update 'The True Masters questline fixes'

quest_missing_diplomat.sql /* SQL Error (1062): Duplicate entry '1748-11223' for key 'creature_queststarter.PRIMARY' */

Thank you for the reporting, it looks like there was a typo causing a re-run of the SQL file to give an error. This is fixed in the latest update.

from mod-individual-progression.

With commit 23e25e7, all SQL errors and DB import errors should be resolve, except for one warning about negative resistance with is waiting for this AC PR to merge: azerothcore/azerothcore-wotlk#12958

I am going to close this issue, but please re-open or post new issue if you see any additional errors! Thank you for reporting.

from mod-individual-progression.