2014-10-10, 09:43 PM
I got this SQL error each time upon trying to create or delete threads.
The issue turned to be that I recently uninstalled the (pre-1.8) plugin "Thread Count Pro" that used the custom column 'threadnum' in the 'mybb2_users' table as part of its operations and dropped it as part of its deinstallation.
Unfortunately, MyBB 1.8 seems to have used this column on a regular basis to provide for the user thread count, so its deletion caused the problem.
The solution was to recreate the column in the database, something like:
and then to recount the user thread count in the ACP.
Hope this helps.
The issue turned to be that I recently uninstalled the (pre-1.8) plugin "Thread Count Pro" that used the custom column 'threadnum' in the 'mybb2_users' table as part of its operations and dropped it as part of its deinstallation.
Unfortunately, MyBB 1.8 seems to have used this column on a regular basis to provide for the user thread count, so its deletion caused the problem.
The solution was to recreate the column in the database, something like:
ALTER TABLE mybb2_users ADD threadnum INT NOT NULL DEFAULT 0
and then to recount the user thread count in the ACP.
Hope this helps.