Error when viewing member galleries

[HHeinzer]

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

[Chuck S]

If you recently upgraded did you run all the applicable upgrades?

[HHeinzer]

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.