[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
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?
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; ```