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 How Do I...?

Photopost Pro How Do I...? Wondering how to do things in PhotoPost?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old November 25th, 2006, 11:59 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Nov 2006
Posts: 14
Error when viewing member galleries

When you click on the member gallery tab on our site, you get the following message with debug turned on. Can someone help me figure this out?

I do apologize if this has been posted before. It's late and I'm not finding it.

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

Script:

Query: SELECT p.id, p.date, p.user, p.userid, SUM(p.views) AS tviews, COUNT(*) AS pcount, SUM(p.numcom) as numcom, MAX(p.lastpost) AS maxlast, MAX(p.date) AS maxdate, SUM(p.filesize) AS tfilesize, p2.lastphoto, p2.lastdate, p2.bigimage, p2.cat, p2.storecat, p2.height, p2.width FROM pp_photos p LEFT JOIN pp_users u ON (u.userid=p.userid) LEFT JOIN pp_photos p2 ON (p2.id=u.lastphoto) WHERE p.approved=1 GROUP BY p.userid ORDER BY maxlast DESC

Result: Unknown column 'p2.lastphoto' in 'field list'

Database handle: Resource id #6

If necessary, the site is www.scrap2basics.net/PhotoPost
HHeinzer is offline   Reply With Quote
Old November 26th, 2006, 02:52 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
If you recently upgraded did you run all the applicable upgrades?
__________________
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 November 26th, 2006, 03:05 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Nov 2006
Posts: 14
I just BOUGHT Photopost yesterday. And last night there were two others having the same issue. I wouldn't think there would be anything to upgrade the day you get the product.
HHeinzer 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors when viewing any member profile! mholtum Installs and Upgrade - vBulletin 3.5.X 3 February 7th, 2006 01:13 AM
Member always viewing gallery tommyxv Installs and Upgrade - vBulletin 3.5.X 4 December 17th, 2005 09:30 PM
error when viewing member profiles weirdpixels Installs and Upgrade - vBulletin 3.5.X 12 December 2nd, 2005 10:54 PM
vB Member Galleries new-guy Before You Buy 11 June 7th, 2005 02:15 PM
Member galleries SoCalrailFan Photopost Pro How Do I...? 1 May 28th, 2005 05:27 AM


All times are GMT -5. The time now is 07:48 PM.

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