Not Solved [Error Message] SQL Error 1054
#1
Not Solved
Unable to add a new forum or category. Get the below error. 
BATR Forum is on http://forum.batr.net/index.php

Request instructions to resolve this problem so I can add a new Forum Category.

Thanks, in advance

*************************************************

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'modposts' in 'field list'
Query:
INSERT INTO myb_forums (name,description,linkto,type,pid,parentlist,disporder,active,open,allowhtml,allowmycode,allowsmilies,allowimgcode,allowvideocode,allowpicons,allowtratings,usepostcounts,password,showinjump,modposts,modthreads,mod_edit_posts,modattachments,style,overridestyle,rulestype,rulestitle,rules,defaultdatecut,defaultsortby,defaultsortorder) VALUES ('Faith in Christ','','','c','0','','1','1','1','0','1','1','1','1','1','1','1','','1','0','0','0','0','0','0','0','','','0','','')
"Many seek to become a Syndicated Columnist, while the few strive to be a Vindicated Publisher . . . "

BREAKING ALL THE RULES Portal
BREAKING ALL THE RULES Site
BREAKING ALL THE RULES Forum
#2
Not Solved
if you have recently upgraded your forum then ensure that you have uploaded all files of the new version

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.
#3
Not Solved
Thanks for the reply. Yes I can run the file verification and no problems were found. Note using 1.6.12 (1612) version and was told a 1.8.6 (1806) version is available. Do not see an auto update, only a link to download.

Before I make a mistake, should I update to the newest version as a first step/ If yes, please instruct HOW.

If the verification did not find a problem do not understand what to replace.

Await further detail instructions.
THANKS for helping.
"Many seek to become a Syndicated Columnist, while the few strive to be a Vindicated Publisher . . . "

BREAKING ALL THE RULES Portal
BREAKING ALL THE RULES Site
BREAKING ALL THE RULES Forum
#4
Not Solved
1.6.x is not supported anymore. You need to upgrade to 1.8.x to receive further support. But my guess is that you're using a 1.8 file/plugin in 1.6 and that causes the error.


Forum Jump:


Users browsing this thread: 1 Guest(s)