MyBB

brownsugar · (This post was last modified: 12-04-2008 07:51 AM by brownsugar.)

Hi I just did my upgrade from 1.4.3 to 1.4.4 and the only error that I am seeing is the following SQL error when I try to access the "Preferences & Personal Notes" in Admin CP. Everything else seems to have gone just fine. Does anybody have any thoughts or suggestions?

Thank you so very much for any assistance in advance. It is greatly appreciated!

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'codepress' in 'field list'
Query:
SELECT notes, cpstyle, codepress FROM mybb_adminoptions WHERE uid='1' LIMIT 1

Ryan Loos · 12-04-2008, 07:35 AM

Did you run the upgrade script?
http://forum url/install/upgrade.php ?

brownsugar · (This post was last modified: 12-04-2008 07:51 AM by brownsugar.)

I didn't run the upgrade script, I just copied all the files over via my ftp program. I didn't realize I should do it that way, with the script, I can redo it that way if it will make a difference.

I ran the upgrade script that that worked! Thank you so very much for your fast reply!

**MattRogowski** · (This post was last modified: 12-04-2008 08:48 AM by MattRogowski.)

It was mentioned in the announcement and it would do you a lot of good for the future if you read them carefully.

brownsugar · 12-05-2008, 05:35 AM

(12-04-2008 08:47 AM)Matt_ Wrote: It was mentioned in the announcement and it would do you a lot of good for the future if you read them carefully.

I did read it carefully... I realize now that was what it was talking about. Forgive my lack of experience. I am not an expert at this... which is why I posted here for help. I fully understand now and will do that for all upgrades in the future. Thanks for making me feel little though.

**MattRogowski** · (This post was last modified: 12-05-2008 08:46 AM by MattRogowski.)

Quote:Please note, that you need to run the upgrade script for this version. This is so the templates may be updated.

I personally think that is pretty clear... and it's not a case of making you feel little, just a case of reading instructions Smile

zoog · 01-08-2009, 03:44 PM

Well, I didn't knew you had to run the upgrade.php script either, I never knew it existed, while I tend to do these things careful. Clearly not careful enough though Confused

Anyway, I stumbled upon this thread because I have the same error. In my test environment (which is the same as the live environment) I tried the solution and ran the upgrade.php script. I did the "find new templates" option too and I cleared the cache of my browser. But the error still exists.

**MattRogowski** · (This post was last modified: 01-08-2009 04:42 PM by MattRogowski.)

The error in the OP will be when you haven't upgraded properly, simple as. Are you sure ran the upgrade script??

zoog · 01-09-2009, 06:10 PM

Yep, it completed the upgrade succesfully and then locked the install folder again. I could try running the upgrade script again, don't know if that's even possible when it's already done 1 time?

**MattRogowski** · 01-09-2009, 06:12 PM

First, make sure your admin files are all 1.4.4, specifically ./admin/modules/home/preferences.php