Installation fails due to MySQL error at 5325_spell_list.sql

[KidProtect]

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]

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

[KidProtect]

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;