[DiscordArchive] Hey guys! I'm trying to load backups of a few characters with pdump load. All but one work, the one
[DiscordArchive] Hey guys! I'm trying to load backups of a few characters with pdump load. All but one work, the one
Original source
Hey guys! I'm trying to load backups of a few characters with pdump load. All but one work, the one that doesn't yields the following error:
`[1048] Column 'data' cannot be null
Unhandled MySQL errno 1048. Unexpected behaviour possible.`
The character is not loaded into the database, contrary to the first message.
Any advice?
![[Image: image.png?ex=690c5de2&is=690b0c62&hm=5ec...5a8190dea&]](https://cdn.discordapp.com/attachments/1255602330431127753/1374485780646465536/image.png?ex=690c5de2&is=690b0c62&hm=5ec60c54a0cede05d347e15dd21931c14dd28d9fcda7a4d48bfab355a8190dea&)
rektbyfaith
05-20-2025, 08:35 PM #1Archived author: MrHarbinger • Posted: 2025-05-20T20:35:46.948000+00:00
Original source
Hey guys! I'm trying to load backups of a few characters with pdump load. All but one work, the one that doesn't yields the following error:
`[1048] Column 'data' cannot be null
Unhandled MySQL errno 1048. Unexpected behaviour possible.`
The character is not loaded into the database, contrary to the first message.
Any advice?
Original source
The dump probably has an insert from a previous module, that now is no longer in the database, so you have to manually edit it
rektbyfaith
05-20-2025, 08:37 PM #2Archived author: brian8544 • Posted: 2025-05-20T20:37:15.888000+00:00
Original source
The dump probably has an insert from a previous module, that now is no longer in the database, so you have to manually edit it
Original source
For example a custom xp gain table which is missing, since you don't use that anymore, etc..
rektbyfaith
05-20-2025, 08:38 PM #3Archived author: brian8544 • Posted: 2025-05-20T20:38:12.577000+00:00
Original source
For example a custom xp gain table which is missing, since you don't use that anymore, etc..
Original source
All right, thanks! I'll take a look. It's odd since all of them are from the same date and time, but maybe something's messed up with the character
rektbyfaith
05-20-2025, 08:40 PM #4Archived author: MrHarbinger • Posted: 2025-05-20T20:40:38.714000+00:00
Original source
All right, thanks! I'll take a look. It's odd since all of them are from the same date and time, but maybe something's messed up with the character
Original source
There was a bad entry under 'character_account_data', filling in the blank fields and redoing the write/load fixed it. Thanks a lot for the help!
rektbyfaith
05-20-2025, 08:45 PM #5Archived author: MrHarbinger • Posted: 2025-05-20T20:45:53.835000+00:00
Original source
There was a bad entry under 'character_account_data', filling in the blank fields and redoing the write/load fixed it. Thanks a lot for the help!
1 Guest(s)
1 Guest(s)