[DiscordArchive] No, all the loaded sql is automatically run. Should I set all the options before WOTLK to 1?
[DiscordArchive] No, all the loaded sql is automatically run. Should I set all the options before WOTLK to 1?
Archived author: stefan126 • Posted: 2023-06-19T17:11:44.048000+00:00
Original source
No, all the loaded sql is automatically run. Should I set all the options before WOTLK to 1?
Archived author: Revision • Posted: 2023-06-19T17:16:45.424000+00:00
Original source
You should
Archived author: stefan126 • Posted: 2023-06-19T17:19:10.591000+00:00
Original source
Should I run the erroring SQL manually or set all the options before WOTLK to 1?
Archived author: Revision • Posted: 2023-06-19T17:20:00.274000+00:00
Original source
It's causing an error because it's trying to insert a row that already exists. Running it manually won't fix it. By the way, it doesn't look like the module handles emblems at all (unless I'm missing it) so you'll still get end-game emblems dropping.
![[Image: f6bfbb1deb4f757b19b5b8b3721d935.png?ex=6...e556b29fb&]](https://cdn.discordapp.com/attachments/284406375495368704/1120402757371830443/f6bfbb1deb4f757b19b5b8b3721d935.png?ex=690c3021&is=690adea1&hm=fe5be7176891d91462c5bc6ecbffc832f80b6355b597feada9fbef8e556b29fb&)
Archived author: stefan126 • Posted: 2023-06-19T17:20:33.440000+00:00
Original source
When I manually run progression_60_2_the_masquerade_down.sql alone, an error occurs
![[Image: f6bfbb1deb4f757b19b5b8b3721d935.png?ex=6...e556b29fb&]](https://cdn.discordapp.com/attachments/284406375495368704/1120402757371830443/f6bfbb1deb4f757b19b5b8b3721d935.png?ex=690c3021&is=690adea1&hm=fe5be7176891d91462c5bc6ecbffc832f80b6355b597feada9fbef8e556b29fb&)
Archived author: Revision • Posted: 2023-06-19T17:22:20.776000+00:00
Original source
That's because the queries doesn't have deletes before the inserts. I have absolutely no idea why but it's a massive oversight.
Archived author: Revision • Posted: 2023-06-19T17:22:36.803000+00:00
Original source
The thing is
Archived author: Revision • Posted: 2023-06-19T17:22:53.086000+00:00
Original source
The inserts are meant to insert rows that were deleted in a previous file
Archived author: Revision • Posted: 2023-06-19T17:23:01.749000+00:00
Original source
Not running the previous patches means you get that error
Archived author: stefan126 • Posted: 2023-06-19T17:23:03.077000+00:00
Original source
Should I set all the options before WOTLK to 1?