MyBB Community Forums

Full Version: SQL error while trying to update user thread counts
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey all,

I recently upgraded my forum (http://thevideogameforum.com) from myBB 1.6.14 to 1.8.3.

Everything went pretty smoothly, and after I sorted out my plugins and templates and whatnot, it's pretty much good to go!


I am having some trouble with the 'Recount User Thread Counts' tool under recount and rebuild. I know this built into by default 1.8 now.


On my 1.6.14 installation, I had a plugin to do this for me. I have since disabled and then removed the plugin after upgrading to 1.8.3.



However when I go to recount and rebuild to run the rebuild thread count I get this:

[Image: pM3GTYi.png]


It appears to be unable to find the right column? Is this a side effect of the old plugin? I have attached the old plugin for reference.


I can grant admin access if needed. Any help appreciated!
do you remember having a plugin for showing threads number ? if so that plugin is cause for the error

you can run below SQL Query (if required see common sql queries guidance)
ALTER TABLE `mybb_users` ADD `threadnum` INT(10) NOT NULL DEFAULT '0';
(02-11-2015, 09:04 AM).m. Wrote: [ -> ]do you remember having a plugin for showing threads number ? if so that plugin is cause for the error

you can run below SQL Query (if required see common sql queries guidance)
ALTER TABLE `mybb_users` ADD `threadnum` INT(10) NOT NULL DEFAULT '0';

Yes I had a plugin, sorry I thought I included it in my post. It was called Thread Count Pro 1.1

Here it is:
http://mods.mybb.com/view/thread-count-pro
http://community.mybb.com/thread-88214.html

Thank you for the speedy response! Ill try running the suggest query.

Running the suggest query totally solved the problem! Thank you very much .m.!

Another quick question though, there is now a contact us page built into 1.8. However at the bottom of my forum it still appears to be a mailto link.

Another quick question, where can you change what email address is used for the new contact us page? It seems to be going to the admin email by default, which I know you can define in 'Site Details' settings.

However I want it going to a different address I set up, rather than the admin email.

Thanks again!