SQL assistance needed

[flamehawk147]

so i'm trying to run this SQL code in my database

  update creature_text, broadcast_text
SET
creature_text.Text = broadcast_text.Text
WHERE
creature_text.BroadcastTextID = broadcast_text.ID and
creature_text.BroadcastTextID > 0;

But i keep getting 2013 - Lost connection to MySQL server during query

what i'm trying to do is use broadcast_text and creature_text tables but copy the text from the broadcast_text table if the broadcastid from creature_text matches and is not zero but for some reason everytime I do i get an error. I'm using the text from broadcast_text because it's from sniffs and the data i have in creature_text is in a different language and i want to replace it with the english version from broadcast_text

 

[mastermind]

I ran into this myself when I installed MySQL 8.0
The fix for me was to increase the max_allowed_packet value in the my.ini file to 100M.

On Windows this file is in the C:\ProgramData\MySQL\MySQL Server 8.0\ folder.
Note: ProgramData is hidden by default.

Stop the MySQL service, make the change to the INI file and restart the service.

As alway make a backup copy of the INI file first so you have a fallback plan.