SQL Database Player Condition: "BLOB - 43"

[lorinholukete69]

Hello,

I'm having the next issue: in my server after save server, all accounts bug. i go check phpmyadmin, and all players have this condiction, and all players with this dont log ands crash server, how i work ? help me please !!!!!!!!!!!!!!!





I was researching more about it, and I saw that the blob has a limit to save, how do I increase this size? I saw something related to BLOB = 64KB, MEDIUMBLOB = 16MB and LONGBLOB = 4GB

but I have no idea where to increase this in "localhost/phpmyadmin" all the accounts of the players online today have this condition, and the accounts that were offline nothing happened.

Post automatically merged: Jan 5, 2025

SAME PROBLEM IN 2017 -> TFS[1.3] SQL Database Player Condition: "BLOB - 43" (https://otland.net/threads/tfs-1-3-sql-database-player-condition-blob-43.254068/)

PLEASE DUDE HELP ME, I dont wan'd reset my server and lose my players

 

[222222]

What does your SQL file look like? In there it is specified what datatype is used for that column. The sizes shown in the picture are so small so I don't think it's any issue with the size of the data. I think it's more an issue about converting the data.

I have not played any OT server in years. But I assume the Conditions column just stores information about conditions like: on fire, paralyzed, magic shield, haste, etc?

Backup your database first (by exporting it). And try clear all those values. See if that makes it possible to login without crashing.

UPDATE table_name SET conditions = NULL;

If you are sure those values are the issue, then look through your server save script and remove anything that stores information about the conditions. Or check how it's importing them. It's impossible to give you any answers here if you don't provide code examples.

 

[Gesior.pl]

in my server after save server

What OTS engine is it?
What happens on server save? Database backup? Some other script that may affect conditions column?
Are there problems with relogs without server restart?

 

[lorinholukete69]

What OTS engine is it?
What happens on server save? Database backup? Some other script that may affect conditions column?
Are there problems with relogs without server restart?

3 players dead by monster and lose position temple worg and in save server all player log out .. 10 min server back, bug in all accounts =/ i go checl phpmyadmin and all player with blob - 40 or other number dont log and server crash, i delet my adm, and work, but i dont need reset server :s

Post automatically merged: Jan 5, 2025

i go

What does your SQL file look like? In there it is specified what datatype is used for that column. The sizes shown in the picture are so small so I don't think it's any issue with the size of the data. I think it's more an issue about converting the data.

I have not played any OT server in years. But I assume the Conditions column just stores information about conditions like: on fire, paralyzed, magic shield, haste, etc?

Backup your database first (by exporting it). And try clear all those values. See if that makes it possible to login without crashing.

UPDATE table_name SET conditions = NULL;

If you are sure those values are the issue, then look through your server save script and remove anything that stores information about the conditions. Or check how it's importing them. It's impossible to give you any answers here if you don't provide code examples.

i go try , and i come back, thanks bro

 

[222222]

3 players dead by monster and lose position temple worg and in save server all player log out .. 10 min server back, bug in all accounts =/ i go checl phpmyadmin and all player with blob - 40 or other number dont log and server crash, i delet my adm, and work, but i dont need reset server :s

Post automatically merged: Jan 5, 2025

i go

i go try , and i come back, thanks bro

Can you post your SQL file here? The one that you imported to phpMyAdmin when you setup your server.
And can you tell us what server engine you are using?

 

[lorinholukete69]

man! i fix this. i need only "update" my phpmyadmin and all accounts works normaly now !!!!!!!!!!!!!!!!!! 2 days no sleeping

Post automatically merged: Jan 7, 2025

thanks for all !!!!!!!!!!!!!!