PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old September 29th, 2007, 11:34 AM   #1 (permalink)
Member
Verified Customer
 
joseduddy's Avatar
 
Join Date: Jan 2006
Location: Biddeford, Maine
Posts: 206
Send a message via MSN to joseduddy Send a message via Yahoo to joseduddy Send a message via Skype™ to joseduddy
Error mgs

After upgrade to 6.0 . when on photopost/index.php and i click a link.
Here's the message with debug on. Maybe its time for me to have Photopost as a seperate program and not intergrated?? Please help

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 AND cat IN (501,a) ORDER BY rand_col DESC LIMIT 17

Result: Unknown column 'a' in 'where clause'

Database handle: Resource id #23

Jose
http://www.dollchatter.com

Last edited by joseduddy; September 29th, 2007 at 11:51 AM.
joseduddy is offline   Reply With Quote
Old September 29th, 2007, 12:45 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
Have you ran your upgrade?

Go into admin edit categories and hit SAVE to reload the cats.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 29th, 2007, 10:56 PM   #3 (permalink)
Member
Verified Customer
 
joseduddy's Avatar
 
Join Date: Jan 2006
Location: Biddeford, Maine
Posts: 206
Send a message via MSN to joseduddy Send a message via Yahoo to joseduddy Send a message via Skype™ to joseduddy
yup

Thank you chuck.......That fixed it......all set.
Jose
joseduddy is offline   Reply With Quote
Old September 30th, 2007, 11:24 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
enjoy your weekend buddy!
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 06:53 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0