MyBB Community Forums

I get the following error clicking on a thread in the www.palacecomrades.com forum.

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1406 - Data too long for column 'BinaryUserIP' at row 1Query: INSERT INTO forum_referers (UserID,BinaryUserIP,URL) VALUES (92,X'2a020c7f080c3d00790b5341f4e1c622','https://www.palacecomrades.com/forum/index.php')
Please contact the MyBB Group for technical support.


Any assistance would be appreciated

1. Where does the "X" come from after the UserID (92,X'2a02...)
2.Am not fully familiar with the IP compression of IPv4 and IPv6, but this does not represent a valid compressed IP, that is expected to store in database, isn't it!?

Nevertheless get rid of the "X"!

[ExiTuS]

It appears most of the members have this error. 

Has the user database got screwed?  Can it be restored.

Your table "forum_referers" is no standard MyBB table - it's not part of a current forum installation (up to v1.8.21).

So where does this table come from?
Do you have any plugin installed that created and uses this table? Have a look at the plugin and the php code for a resolution then.
If you're not sure about plugins, deactivate these one by one to identify.

[ExiTuS]

(2019-06-25, 07:02 PM)[ExiTuS] Wrote: [ -> ]1. Where does the "X" come from after the UserID (92,X'2a02...)
2.Am not fully familiar with the IP compression of IPv4 and IPv6, but this does not represent a valid compressed IP, that is expected to store in database, isn't it!?

Nevertheless get rid of the "X"!

[ExiTuS]

You'll almost always see that "X" when viewing the binary byte strings of IP addresses. IP columns are VARBINARY(16) instead of the old VARCHAR. At least I always see it when attempting to view it raw.