MyBB Community Forums

We've been having some members with issues accessing our forum and this is one of the error's that spat out for example updating their status:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?','0')' at line 3
Query:
INSERT INTO mybb_statusupdate (sid,uid,text,dateline,lastedituid,lasteditdate,ipaddress,totalcomments) VALUES ('NULL',49,'hi',1444967888,49,1444967888,'&


y�Ž<Ս'�','0')
Please contact the MyBB Group for technical support.

We've seen a similar error for posting too. Any idea what the heck this means? Thanks!

---

NEvermind! Figured it out.

 $session->packedip

conflicted and it doesn't work with ipv6 or cloudflare

That's not the reason. You try to store binary data in a varchar(?) field which doesn't work.

Moved to plugin support.

(2015-10-16, 05:56 AM)StefanT Wrote: [ -> ]That's not the reason. You try to store binary data in a varchar(?) field which doesn't work.

that column is binary

`ipaddress` VARBINARY(16) NOT NULL DEFAULT '',