View Single Post
Old February 20th, 2007, 05:13 PM   #1 (permalink)
pengrus
Senior Member
Verified Customer
 
Join Date: Dec 2002
Location: San Francisco
Posts: 603
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.
pengrus is offline   Reply With Quote