cmangos / wotlk-db

A content database for mangos-wotlk, and World of Warcraft Client Patch 3.3.5
GNU General Public License v3.0
112 stars 99 forks source link

Installation fails due to MySQL error at 5325_spell_list.sql #1315

Closed KidProtect closed 6 months ago

KidProtect commented 6 months ago

Using Debian 12 with MariaDB. InstallFullDB.sh script fails when loading a completely new database.

  - Applying Updates/5320_q.14096_14142.sql ... SUCCESS
  - Applying Updates/5321_c.33780_33778.sql ... SUCCESS
  - Applying Updates/5322_c.33698.sql ... SUCCESS
  - Applying Updates/5323_Hrothgars_Landing.sql ... SUCCESS
  - Applying Updates/5324_Loot_DBErrors.sql ... SUCCESS
  - Applying Updates/5325_spell_list.sql ... FAILED!
>>> ERROR 1175 (HY000) at line 28: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Press space to continue...
Feoseg commented 6 months ago

https://discord.com/channels/362206349339262976/1238048684319707176 try this.

KidProtect commented 6 months ago

Thank you.

For future reference: solution seems to be in manually adding SET sql_safe_updates=0; before the line which gets specified in error, then add SET sql_safe_updates=1; after that line.

In my case it looked something like this:

SET sql_safe_updates=0;
UPDATE IGNORE creature_template a INNER JOIN temp_entries b ON a.entry=(b.entry DIV 100) [...]
SET sql_safe_updates=1;