MyBB Community Forums

Full Version: SQL error while upgrading 1.6.14 - 1.8.01
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Sorry to add yet another SQL error thread, but after some searching and testing I'm still stumped. 

While upgrading my test forum, I ran into the following error during the 'Optimizing Database' step:

SQL Error:

1054 - Unknown column 'codepress' in 'mybb_adminoptions'

Query:

ALTER TABLE mybb_adminoptions MODIFY codepress tinyint(1) NOT NULL default '0'
try this suggestion (see if required => SQL query guidance)
(2014-11-03, 03:50 AM).m. Wrote: [ -> ]try this suggestion (see if required => SQL query guidance)

Thank you. This worked after I double checked on appropriately adding SQL queries through PHPMyAdmin.