![]() |
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 |
| All times are GMT -5. The time now is 09:29 PM. |
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0