EQEmu / Server

Open Source Fan-Based EverQuest Emulator Server project
https://docs.eqemu.io/
GNU General Public License v3.0
447 stars 410 forks source link

#copycharacter MySQL duplicate key error #4484

Closed Morzain closed 1 week ago

Morzain commented 1 week ago

When I attempted to use #copycharacter it gave the Failed message, and the logs showed the following MySQL error:

[09-23-2024 20:14:53] [Zone] [QueryErr] MySQL Error (1062) [Duplicate entry '58008' for key 'PRIMARY'] Query [INSERT INTO character_instance_safereturns (id,character_id,instance_zone_id,instance_id,safe_zone_id,safe_x,safe_y,safe_z,safe_heading) VALUES ('58008','1349','173','230','345','0.44','-77.4','2.08','0')]

Leaving the instance and doing /dzquit on the source character allowed the command to succeed.

Kinglykrab commented 1 week ago

Fixed by #4485.