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 Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old February 20th, 2007, 05:13 PM   #1 (permalink)
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
Old February 20th, 2007, 05:25 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,665
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old February 20th, 2007, 05:33 PM   #3 (permalink)
Senior Member
Verified Customer
 
Join Date: Dec 2002
Location: San Francisco
Posts: 603
Chuck,

You are absolutely right. How could I miss this? I am sorry for my oversight and trouble...
pengrus is offline   Reply With Quote
Old February 21st, 2007, 09:25 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,665
Not a problem my friend
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Error armagan Installs and Upgrade - vBulletin 3.6x 14 November 11th, 2006 05:33 AM
Error with 3.51: Error adding new category to the database. Returned id was 0. WebDork Photopost Pro Installation & Upgrades 15 July 17th, 2006 08:03 PM
Database error in vBulletin 3.5.4: Error Number : 1062 s2kinteg916 Installs and Upgrade - vBulletin 3.5.X 1 May 27th, 2006 10:38 AM
Database error Toxiedog Classifieds Installation & Upgrades 2 March 2nd, 2006 02:03 PM
Database Error... maikj Photopost Pro Installation & Upgrades 8 July 14th, 2004 03:01 PM


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

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