 | |  | | | Photopost Pro Installation & Upgrades If you're having install or upgrade problems | 
May 8th, 2008, 01:02 PM
|
#1 (permalink)
| | Junior Member Verified Customer
Join Date: Nov 2007
Posts: 9
| 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? | 
|  | |
May 8th, 2008, 03:19 PM
|
#2 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,647
|
Try going into your category editor and make sure to set the top level categories to thumbnail view. See if that helps.
| |
| | |
May 9th, 2008, 09:57 AM
|
#3 (permalink)
| | Junior Member Verified Customer
Join Date: Nov 2007
Posts: 9
| Quote:
Originally Posted by Chuck S  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!
| |
| | |
May 9th, 2008, 09:58 AM
|
#4 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,647
|
Have you done this as I noted in my post? Category 503?
| |
| | |
May 9th, 2008, 10:02 AM
|
#5 (permalink)
| | Junior Member Verified Customer
Join Date: Nov 2007
Posts: 9
| Quote:
Originally Posted by Chuck S 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.
| |
| | |
May 9th, 2008, 10:07 AM
|
#6 (permalink)
| | Junior Member Verified Customer
Join Date: Nov 2007
Posts: 9
|
I just verified the settings for thumbnail view for the top categories. Everything is set like you recommended.
| |
| | |
May 9th, 2008, 10:52 AM
|
#7 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,647
|
You have done this for every category? You still get the email?
| |
| | |
May 9th, 2008, 10:55 AM
|
#8 (permalink)
| | Junior Member Verified Customer
Join Date: Nov 2007
Posts: 9
| Quote:
Originally Posted by Chuck S You have done this for every category? You still get the email? | Yes, that is correct.
| |
| | |
May 9th, 2008, 11:03 AM
|
#9 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,647
|
Please pm me a url and admin login
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread |  Linear Mode | | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | | All times are GMT -5. The time now is 07:04 AM. | |
