MyBB Community Forums

I was able to get my forum back up again after trying a reinstall 5 different times :/ Though I'm still getting these errors while I try to edit certain things in my Admin CP

First Error:

This happens when I try to update a board on my forum or create a new board

SQL Error:
   1054 - Unknown column 'modposts' in 'field list'
Query:
   SELECT canview,canviewthreads,candlattachments,canpostthreads,canpostreplys,canpostattachments,canratethreads,caneditposts,candeleteposts,candeletethreads,caneditattachments,modposts,modthreads,mod_edit_posts,modattachments,canpostpolls,canvotepolls,cansearch FROM mybb_usergroups WHERE gid='1' LIMIT 1

Second Error:

This happens when I try to change things in regards to custom profile fields

SQL Error:
   1054 - Unknown column 'regex' in 'field list'
Query:
   UPDATE mybb_profilefields SET `name`='Profile Image', `description`='600 x 300 profile image using the <img> tag', `disporder`=10, `type`='textarea', `regex`='', `length`=0, `maxlength`=65535, `required`=0, `registration`=0, `profile`=1, `viewableby`='', `editableby`='', `postbit`=0, `postnum`=0, `allowhtml`=1, `allowmycode`=0, `allowsmilies`=0, `allowimgcode`=1, `allowvideocode`=0 WHERE fid='10'

can you run file verification tool available at tools & maintenance section of admin panel to find missing / changed files.
ignore files reported from install folder & its subfolders. Also ignore reported images.
you have to replace reported files from MyBB source files pack of your forum's version.

(if you are using Google SEO plugin then do not replace ~/inc/functions.php file)

(2015-12-01, 04:12 AM).m. Wrote: [ -> ]can you run file verification tool available at tools & maintenance section of admin panel to find missing / changed files.
ignore files reported from install folder & its subfolders.  Also ignore  reported images.
you have to replace reported files from MyBB source files pack of your forum's version.

(if you are using Google SEO plugin then do not replace ~/inc/functions.php file)

Thank you so much for your quick response.

I ran File Verification and this is what it proceeded to give me:

jscripts/sceditor/textarea_styles/jquery.sceditor.buttons.css

jscripts/sceditor/textarea_styles/jquery.sceditor.mybb.css

scripts/sceditor/editor_themes/mybb.css

I tried to re-upload all those files via Filezilla but the files aren't updating or changing.

I re-ran File Verification to make sure and they are still there.

above files are not related to the reported problems. can you disable all the plugins and check if the issue occurs again ..

(2015-12-01, 04:27 AM).m. Wrote: [ -> ]above files are not related to the reported problems. can you disable all the plugins and check if the issue occurs again ..

All plugins have been disabled on my forum and the problems still persist.

- - - - - - - - -

The Plugins I currently have installed on my forum are:

Last/First Post Avatar (1.0.2)

NewPoints (2.0)

PHP and Template Conditionals (2.0)

Recent Threads (8.0)

assuming that you have a legit forum,
would you like to PM me temporary access to forum admin panel & files (FTP) - however I might need about 3 hours to check

(2015-12-01, 04:48 AM).m. Wrote: [ -> ]assuming that you have a legit forum,
would you like to PM me temporary access to forum admin panel & files (FTP) - however I might need about 3 hours to check

Surely any help and in any form is welcome. I've been racking my brain over these issues for a few days now!

I'll send you a PM with info to the FTP.

basically it looks like database was not upgraded in correct manner !
if a couple of fields are missing then they can be added again through database manager (eg. phpMyAdmin)

(2015-12-01, 05:19 AM).m. Wrote: [ -> ]basically it looks like database was not upgraded in correct manner !
if a couple of fields are missing then they can be added again through database manager (eg. phpMyAdmin)

Ahhh! This puts a smile on my face to be pointed in a brighter direction to solving these issues.

How do I know what fields need updated and how can I update them?

I'm so sorry for the little knowledge I have.

added those two missing fields and the database is expected to work fine

ALTER TABLE  `mybb_profilefields` ADD  `regex` TEXT NOT NULL;
ALTER TABLE  `mybb_usergroups` ADD  `modposts` TINYINT(1) NOT NULL DEFAULT  '0';