Forums WoW Modding Support Archives Azerothcore Discord Archives [DiscordArchive] I pulled the latest code and spun up a new test server without any modules and was able to replicate

[DiscordArchive] I pulled the latest code and spun up a new test server without any modules and was able to replicate

[DiscordArchive] I pulled the latest code and spun up a new test server without any modules and was able to replicate

rektbyfaith
Administrator
0
03-06-2023, 08:19 PM
#1
Archived author: bewarellamas • Posted: 2023-03-06T20:19:22.940000+00:00
Original source

I pulled the latest code and spun up a new test server without any modules and was able to replicate the crash. I can trigger it consistently when prospecting a full stack of 20 ore on the last stack of 5 while doing one after another. Think this is more appropriate to post as an issue on github?
rektbyfaith
03-06-2023, 08:19 PM #1

Archived author: bewarellamas • Posted: 2023-03-06T20:19:22.940000+00:00
Original source

I pulled the latest code and spun up a new test server without any modules and was able to replicate the crash. I can trigger it consistently when prospecting a full stack of 20 ore on the last stack of 5 while doing one after another. Think this is more appropriate to post as an issue on github?

rektbyfaith
Administrator
0
03-06-2023, 08:41 PM
#2
Archived author: may • Posted: 2023-03-06T20:41:01.201000+00:00
Original source

Hi dear, I have two tables in the database, spell_hd and spell_cn, I need to change the field names of spell_hd to all the field names of spell_cn (keep corresponding), so I let chatGPT give me a query statement, please check it Is this correct?
```cpp
SELECT CONCAT('ALTER TABLE spell_hd CHANGE COLUMN ', hd.COLUMN_NAME, ' ', cn.COLUMN_NAME, ' ', hd.DATA_TYPE, ';')
FROM INFORMATION_SCHEMA.COLUMNS hd
JOIN INFORMATION_SCHEMA.COLUMNS cn ON hd.TABLE_SCHEMA = cn.TABLE_SCHEMA AND hd.TABLE_NAME = 'spell_hd' AND cn.TABLE_NAME = 'spell_cn' AND hd.COLUMN_NAME = cn.COLUMN_NAME; ```
rektbyfaith
03-06-2023, 08:41 PM #2

Archived author: may • Posted: 2023-03-06T20:41:01.201000+00:00
Original source

Hi dear, I have two tables in the database, spell_hd and spell_cn, I need to change the field names of spell_hd to all the field names of spell_cn (keep corresponding), so I let chatGPT give me a query statement, please check it Is this correct?
```cpp
SELECT CONCAT('ALTER TABLE spell_hd CHANGE COLUMN ', hd.COLUMN_NAME, ' ', cn.COLUMN_NAME, ' ', hd.DATA_TYPE, ';')
FROM INFORMATION_SCHEMA.COLUMNS hd
JOIN INFORMATION_SCHEMA.COLUMNS cn ON hd.TABLE_SCHEMA = cn.TABLE_SCHEMA AND hd.TABLE_NAME = 'spell_hd' AND cn.TABLE_NAME = 'spell_cn' AND hd.COLUMN_NAME = cn.COLUMN_NAME; ```

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)