[DiscordArchive] I just delete that 1st entry i guess?
[DiscordArchive] I just delete that 1st entry i guess?
Original source
I see what's wrong 1 mmt
rektbyfaith
03-08-2025, 01:33 PM #11Archived author: Ryan Turner • Posted: 2025-03-08T13:33:50.613000+00:00
Original source
I see what's wrong 1 mmt
Original source
```sql
SELECT `entry`, `item`, `minCount`, `maxCount`, `comment` FROM creature_loot_template WHERE `reference` IN (34060, 30486, 34062, 34059)
```
rektbyfaith
03-08-2025, 01:35 PM #12Archived author: Ryan Turner • Posted: 2025-03-08T13:35:04.594000+00:00
Original source
```sql
SELECT `entry`, `item`, `minCount`, `maxCount`, `comment` FROM creature_loot_template WHERE `reference` IN (34060, 30486, 34062, 34059)
```
Original source
![[Image: image.png?ex=690bfb76&is=690aa9f6&hm=358...695c682fa&]](https://cdn.discordapp.com/attachments/1255602330431127753/1347925785180241971/image.png?ex=690bfb76&is=690aa9f6&hm=3587388601e7be3842f0153bbbebc93805631fe19f6dd39bfbc4f40695c682fa&)
rektbyfaith
03-08-2025, 01:35 PM #13Archived author: Dizlen • Posted: 2025-03-08T13:35:50.492000+00:00
Original source
Original source
aha !
rektbyfaith
03-08-2025, 01:35 PM #14Archived author: Dizlen • Posted: 2025-03-08T13:35:52.064000+00:00
Original source
aha !
Original source
you're a genius
rektbyfaith
03-08-2025, 01:36 PM #15Archived author: Dizlen • Posted: 2025-03-08T13:36:00.134000+00:00
Original source
you're a genius
Original source
The mi ncount has to match the max count
rektbyfaith
03-08-2025, 01:36 PM #16Archived author: Ryan Turner • Posted: 2025-03-08T13:36:55.224000+00:00
Original source
The mi ncount has to match the max count
Original source
You can just do via the GUI
rektbyfaith
03-08-2025, 01:37 PM #17Archived author: Ryan Turner • Posted: 2025-03-08T13:37:30.761000+00:00
Original source
You can just do via the GUI
Original source
(this in a clean version of AzerothCore doesn't happen, adjusted in https://github.com/azerothcore/azerothco...8823043964 alongside with the error message. So that might be some outdata from the modul
rektbyfaith
03-08-2025, 01:40 PM #18Archived author: Ryan Turner • Posted: 2025-03-08T13:40:05.403000+00:00
Original source
(this in a clean version of AzerothCore doesn't happen, adjusted in https://github.com/azerothcore/azerothco...8823043964 alongside with the error message. So that might be some outdata from the modul
Original source
I see this in the console when I try to change them on the gui
`/* Selected columns don't contain a sufficient set of key columns to allow editing. Please select primary or unique key columns, or just all columns. */`
rektbyfaith
03-08-2025, 01:40 PM #19Archived author: Dizlen • Posted: 2025-03-08T13:40:06.670000+00:00
Original source
I see this in the console when I try to change them on the gui
`/* Selected columns don't contain a sufficient set of key columns to allow editing. Please select primary or unique key columns, or just all columns. */`
Original source
Oh i see i thought it you could change it.
So i will give you give the hunting for the update. in the same commit there's an SQL file [here](https://github.com/azerothcore/azerothco...586300.sql)
If you just do CTRL+F for e.g
```sql
`Entry`= 11583 AND `Item` = 34009 AND `Reference` = 34009
```
should get you the fix to that row. repeat the same for the rest.
Change Entry, Item and Reference to match what it shows on your database (above).
If you want to see reference which should match the item anyways in the database you can add `reference` between `item` and `mincount` (in the previous query before your screenshot)
rektbyfaith
03-08-2025, 01:44 PM #20Archived author: Ryan Turner • Posted: 2025-03-08T13:44:37.854000+00:00
Original source
Oh i see i thought it you could change it.
So i will give you give the hunting for the update. in the same commit there's an SQL file [here](https://github.com/azerothcore/azerothco...586300.sql)
If you just do CTRL+F for e.g
```sql
`Entry`= 11583 AND `Item` = 34009 AND `Reference` = 34009
```
should get you the fix to that row. repeat the same for the rest.
Change Entry, Item and Reference to match what it shows on your database (above).
If you want to see reference which should match the item anyways in the database you can add `reference` between `item` and `mincount` (in the previous query before your screenshot)
1 Guest(s)
1 Guest(s)