SQL errors after upgrade

[cdub]

I just upgraded my PP from 5.6 to 6.23. I'm now getting email like the following:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 AND cat IN (2,c) ORDER BY date DESC LIMIT 34

The query returned with an errorcode of:

Unknown column 'c' in 'where clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

I get a few different email for different queries, but each has the same

Unknown column 'c' in 'where clause'

error in each of them. I haven't run into any errors on the site, but the amount of email is a bit alarming. Any help?

[Chuck S]

Interesting error. I dont see anywhere in our code where we would issue c as a cat number.

The query I beleive is found in showframe.php you can try changing this line in that file

Content visible to verified customers only.

to say this and see if it helps

Content visible to verified customers only.

[cdub]

That didn't seem to fix this issue. It also looks like the category section on the home page is all hosed, due to this error being with the categories, I assume the issues are connected...You can see this here Main Index - Scroll Saw Woodworking & Crafts Photo Gallery

[Chuck S]

Did you run your upgrades from your last version to the latest?

If I look at your site it looks like your missing important field in the cats table before we can not pull cat info.

You might want to upload your upgrade script and you can safely run 5.2 through 6.2 upgrades again without affecting anything.

[cdub]

Awesome that looks to have fixed it. Thanks for your help. I adopted this from my predecessor, it looks like he borked the config-inc.php file to have the wrong version in it.

[Chuck S]

no problem