error mysql

[Gubailovo]

after logout all things disappear how to fix this problem

 

[HalfAway]

Explain more about your error.
What does the error message say?

Server version?

 

[Gubailovo]

Explain more about your error.
What does the error message say?

Server version?

I can’t determine the version I can not find out the version of TFS (https://otland.net/threads/i-can-not-find-out-the-version-of-tfs.268559/)
that's what gives out with logout

when entering through a regular client 7.6
and when entering through OT, the client doesn’t allow the connection of characters 10051 further than the list of characters with an error

 

[Gubailovo]

I still can’t solve this problem (although everything works locally) and on the server it either doesn’t synchronize things, and when it exits, everything disappears, or it doesn’t open with error 10051

Post automatically merged: Mar 8, 2020

which port needs to be opened or what needs to be configured for proper operation from the OTclient

 

[HalfAway]

The field 'Sender' does not have a default value.
Adjust the part that handles the items save, or do a workaround (no idea what Sender affects) set column 'Sender' as default empty.

 

[Gubailovo]

The field 'Sender' does not have a default value.
Adjust the part that handles the items save, or do a workaround (no idea what Sender affects) set column 'Sender' as default empty.

could you explain to me in more detail what you meant
By the way, I started working fine with the client otclientv8-master (and with its compiled client it gives an error 10051)
but still does not save the database

 

[Rombadr]

could you explain to me in more detail what you meant
By the way, I started working fine with the client otclientv8-master (and with its compiled client it gives an error 10051)
but still does not save the database

You have to give the Sender field in the items table a default value OR fix the query that gets sent to have a default value for Sender.

 

[Leo32]

AAC - Database error.

Type: voidQuery (voidQuery is used for update, insert or delete from database) Field 'comment' doesn't have a default value When i try to create new character.

otland.net

ALTER TABLE items ALTER COLUMN Sender SET DEFAULT '';

Or maybe it needs to be NULL:

ALTER TABLE items ALTER COLUMN Sender SET DEFAULT NULL;

Idk your DB structure.