XF 2.2 MySQL query error [1264]: Out of range value for column 'thread_read_id'

[Mr Shap]

Hi. I just started receiving this error

Any idea what might be causing it? It's not appearing for everyone but appears for most users.

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'thread_read_id' at row 1 in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
XF\Db\AbstractAdapter->insert() in src/XF/Repository/Thread.php at line 235
XF\Repository\Thread->markThreadReadByUser() in src/XF/Repository/Thread.php at line 256
XF\Repository\Thread->markThreadReadByVisitor() in src/XF/Pub/Controller/Thread.php at line 134
XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonsLab/GuestPosting/XF/Pub/Controller/Thread.php at line 46
AddonsLab\GuestPosting\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/UBS/XF/Pub/Controller/Thread.php at line 11
XenAddons\UBS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
XF\App->run() in src/XF.php at line 512
XF::runApp() in index.php at line 20

 

[Paul B]

Looks like it's related to a third party add-on by addonslab.

 

[Mr Shap]

Thanks.

 

[mattrogowski]

xf_thread_read auto_increment out of range

If you set up a MySQL cluster for replication, the auto_increment values generated by MySQL will go up by more than 1 at a time (see auto_increment_increment) - the default (we've been told) is to increment them by 10. This means you use up IDs 10x quicker (so you'd run out of IDs at 420 million...

xenforo.com

This was what it ended up being.

 

[PaulB]

Looks like it's related to a third party add-on by addonslab.

It's quite feasible to exceed 32-byte limit on IDs in that table even without an add-on.

If anyone else encounters this issue, and you continue to encounter it with vanilla XF, you may need switch to 64-byte IDs on several of your tables. I'll leave that as an exercise to the reader, as ensuring XF doesn't overwrite your changes during upgrades is non-trivial.