An error was encountered during execution of the query
 

I am getting the follow error e-mailed to me after upgrading from 6.02 to 6.10

An error was encountered during execution of the query:

SELECT * FROM pp_photos WHERE cat IN (559,Array) ORDER BY date DESC LIMIT 50

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

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


How do I go about fixing this error?

Try going into your category editor and make sure to set the top level categories to thumbnail view. See if that helps.

I am still geting a SQL error via e-mail.

An error was encountered during execution of the query:

SELECT * FROM pp_photos WHERE cat IN (503,Array) ORDER BY date DESC LIMIT 50

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

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


Thanks for your help!

Have you done this as I noted in my post? Category 503?

Yes, I went into the Photopost admin in the category editor and made sure to set the top level categories were changed to thumbnail view.

I just verified the settings for thumbnail view for the top categories. Everything is set like you recommended.

You have done this for every category? You still get the email?

Yes, that is correct.

Please pm me a url and admin login