[DiscordArchive] Hi, I also installed with Docker (https://www.azerothcore.org/wiki/install-with-docker) and getting
[DiscordArchive] Hi, I also installed with Docker (https://www.azerothcore.org/wiki/install-with-docker) and getting
Original source
this was my fix (posted it in <#369084351129845760> )
rektbyfaith
07-04-2022, 02:37 PM #11Archived author: Vale the Violet Mote • Posted: 2022-07-04T14:37:24.950000+00:00
Original source
this was my fix (posted it in <#369084351129845760> )
Original source
my fix is this, change lines 7 & 9 in file 2022_06_18_04.sql to:
```sql
UPDATE `pool_template` SET `max_limit`=1, `description`= 'Brontus Kodo Pack Pool of Pools' WHERE `entry` = 394;
DELETE FROM `creature` WHERE `guid` IN (45809, 45810, 45811, 45812, 45813, 45814, 45815, 45816, 45817, 45818, 45819, 45820, 51815);
```
rektbyfaith
07-04-2022, 02:37 PM #12Archived author: Vale the Violet Mote • Posted: 2022-07-04T14:37:27.232000+00:00
Original source
my fix is this, change lines 7 & 9 in file 2022_06_18_04.sql to:
```sql
UPDATE `pool_template` SET `max_limit`=1, `description`= 'Brontus Kodo Pack Pool of Pools' WHERE `entry` = 394;
DELETE FROM `creature` WHERE `guid` IN (45809, 45810, 45811, 45812, 45813, 45814, 45815, 45816, 45817, 45818, 45819, 45820, 51815);
```
Original source
I'm not sure if this is the best place to put this, but I've had a few more issues with the update files on a new installation, beside that one.
rektbyfaith
07-04-2022, 03:59 PM #13Archived author: Andu • Posted: 2022-07-04T15:59:01.118000+00:00
Original source
I'm not sure if this is the best place to put this, but I've had a few more issues with the update files on a new installation, beside that one.
Original source
On 2022_06_29_05.sql I added
```
AS newrow
ON DUPLICATE KEY UPDATE
`position_x` = newrow.`position_x`,
`position_y` = newrow.`position_y`,
`position_z` = newrow.`position_z`,
`orientation` = newrow.`orientation`,
`delay` = newrow.`delay`;
```
at the end (line 34) because I was getting an error on duplicate entries
rektbyfaith
07-04-2022, 04:00 PM #14Archived author: Andu • Posted: 2022-07-04T16:00:43.919000+00:00
Original source
On 2022_06_29_05.sql I added
```
AS newrow
ON DUPLICATE KEY UPDATE
`position_x` = newrow.`position_x`,
`position_y` = newrow.`position_y`,
`position_z` = newrow.`position_z`,
`orientation` = newrow.`orientation`,
`delay` = newrow.`delay`;
```
at the end (line 34) because I was getting an error on duplicate entries
Original source
On 2022_06_28_02.sql I added
```
51386
```
to the delete statement on line 816, once again because the next line was inserting that id as a duplicate
rektbyfaith
07-04-2022, 04:02 PM #15Archived author: Andu • Posted: 2022-07-04T16:02:51.238000+00:00
Original source
On 2022_06_28_02.sql I added
```
51386
```
to the delete statement on line 816, once again because the next line was inserting that id as a duplicate
Original source
And on 2022_06_14_01.sql I made a mess of a one-time stored procedure to check if those columns already exist... this is the most questionable thing I've had to change, and would really love somebody to show me a better way, it's bad af.
```DROP PROCEDURE IF EXISTS `anonymous_block_remove_artkit_columns`;
DELIMITER //
CREATE PROCEDURE `anonymous_block_remove_artkit_columns`()
BEGIN
DECLARE `@COL_NUMBER` INT UNSIGNED DEFAULT 0;
SELECT COUNT(*) INTO `@COL_NUMBER`
FROM INFORMATION_SCHEMA.`COLUMNS`
WHERE(
`table_name` = 'gameobject_template_addon'
AND `column_name` IN ('artkit0', 'artkit1', 'artkit2', 'artkit3')
);
IF `@COL_NUMBER` > 0 THEN
ALTER TABLE `gameobject_template_addon`
MODIFY `artkit0` INT NOT NULL DEFAULT 0 AFTER `maxgold`,
MODIFY `artkit1` INT NOT NULL DEFAULT 0 AFTER `artkit0`,
MODIFY `artkit2` INT NOT NULL DEFAULT 0 AFTER `artkit1`,
MODIFY `artkit3` INT NOT NULL DEFAULT 0 AFTER `artkit2`;
ELSE
ALTER TABLE `gameobject_template_addon`
ADD `artkit0` INT NOT NULL DEFAULT 0 AFTER `maxgold`,
ADD `artkit1` INT NOT NULL DEFAULT 0 AFTER `artkit0`,
ADD `artkit2` INT NOT NULL DEFAULT 0 AFTER `artkit1`,
ADD `artkit3` INT NOT NULL DEFAULT 0 AFTER `artkit2`;
END IF;
END//
DELIMITER ;
CALL `anonymous_block_remove_artkit_columns`();
DROP PROCEDURE IF EXISTS `anonymous_block_remove_artkit_columns`;```
this goes instead of lines 3-7 (the alter table statement)
rektbyfaith
07-04-2022, 04:04 PM #16Archived author: Andu • Posted: 2022-07-04T16:04:47.876000+00:00
Original source
And on 2022_06_14_01.sql I made a mess of a one-time stored procedure to check if those columns already exist... this is the most questionable thing I've had to change, and would really love somebody to show me a better way, it's bad af.
```DROP PROCEDURE IF EXISTS `anonymous_block_remove_artkit_columns`;
DELIMITER //
CREATE PROCEDURE `anonymous_block_remove_artkit_columns`()
BEGIN
DECLARE `@COL_NUMBER` INT UNSIGNED DEFAULT 0;
SELECT COUNT(*) INTO `@COL_NUMBER`
FROM INFORMATION_SCHEMA.`COLUMNS`
WHERE(
`table_name` = 'gameobject_template_addon'
AND `column_name` IN ('artkit0', 'artkit1', 'artkit2', 'artkit3')
);
IF `@COL_NUMBER` > 0 THEN
ALTER TABLE `gameobject_template_addon`
MODIFY `artkit0` INT NOT NULL DEFAULT 0 AFTER `maxgold`,
MODIFY `artkit1` INT NOT NULL DEFAULT 0 AFTER `artkit0`,
MODIFY `artkit2` INT NOT NULL DEFAULT 0 AFTER `artkit1`,
MODIFY `artkit3` INT NOT NULL DEFAULT 0 AFTER `artkit2`;
ELSE
ALTER TABLE `gameobject_template_addon`
ADD `artkit0` INT NOT NULL DEFAULT 0 AFTER `maxgold`,
ADD `artkit1` INT NOT NULL DEFAULT 0 AFTER `artkit0`,
ADD `artkit2` INT NOT NULL DEFAULT 0 AFTER `artkit1`,
ADD `artkit3` INT NOT NULL DEFAULT 0 AFTER `artkit2`;
END IF;
END//
DELIMITER ;
CALL `anonymous_block_remove_artkit_columns`();
DROP PROCEDURE IF EXISTS `anonymous_block_remove_artkit_columns`;```
this goes instead of lines 3-7 (the alter table statement)
Original source
I hope this helps somebody
rektbyfaith
07-04-2022, 04:05 PM #17Archived author: Andu • Posted: 2022-07-04T16:05:10.240000+00:00
Original source
I hope this helps somebody
Original source
Thank you these edits to the sql files helped me a whole lot.
rektbyfaith
07-09-2022, 08:47 AM #18Archived author: polybiscuit • Posted: 2022-07-09T08:47:08.347000+00:00
Original source
Thank you these edits to the sql files helped me a whole lot.
1 Guest(s)
1 Guest(s)