[Archive] SQL assistance needed
[Archive] SQL assistance needed
Original source
so i'm trying to run this SQL code in my database
Code:
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
rektbyfaith
11-04-2025, 05:12 PM #1Archived author: flamehawk147 • Posted: 2025-11-04T18:12:46.579899
Original source
so i'm trying to run this SQL code in my database
Code:
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
Original source
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.
rektbyfaith
11-04-2025, 05:12 PM #2Archived author: flamehawk147 • Posted: 2025-11-04T18:12:46.579899
Original source
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.
1 Guest(s)
1 Guest(s)