MyBB Community Forums

Full Version: Too small datatype for searchlog.sid
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Found this "bug" when helping a customer who is running
- MyBulletinBoard 1.00 Release Candidate 4

Since searchlog.sid is a smallint we got an "Duplicate entry 32767 for key 1" error because the searchlog table was "full".
Changed it to bigint and now its working.

Is RC4 old, maybe I should recommend them to update it?

And by the way, there were a few incompatibilities with MySQL 5 that I solved too...only a few joins that needed to be changed and then it worked like a charm...

/Goran
Quote:Is RC4 old, maybe I should recommend them to update it?
You certainly should, this [PR2] fixes that error as well as some other disturbing security issues with RC4.

Quote:And by the way, there were a few incompatibilities with MySQL 5 that I solved too...only a few joins that needed to be changed and then it worked like a charm...
Thanks, we've fixed the MySQL 5 issues in our development code and are currently testing it. Smile
Allrighty, I'll tell them to do an upgrade.
Thanks for the info...