5.62 database error
 

I just upgraded to 5.62, and got a lot of mysql errors that look like this:

----------------------------------------
An error was encountered during execution of the 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,
u.lastphoto, u.lastdate,
p2.bigimage, p2.cat, p2.storecat, p2.height, p2.width
FROM photos p
LEFT JOIN users u ON (u.userid=p.userid)
LEFT JOIN photos p2 ON (p2.id=u.lastphoto)
WHERE p.user LIKE 'b%'AND p.approved=1
GROUP BY p.userid ORDER BY maxdate DESC

The query returned with an errorcode of:

Unknown column 'u.lastphoto' in 'field list'

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.

Looks to me like your running 5.6 and have not ran the upgrade script cause a lastphoto column indeed should exist under your Photopost users table

Chuck,

You are absolutely right. How could I miss this? I am sorry for my oversight and trouble...

Not a problem my friend