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 September 29th, 2005, 01:08 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 19
pp 5.2 calendar problem(FIXED)

An error was encountered during execution of the query:

SELECT id, date, user, userid, SUM(views) AS tviews,COUNT(*) AS pcount, MAX(date) AS maxdate,
SUM(filesize) AS tfilesize FROM pp_photos WHERE approved=1 GROUP BY userid ORDER BY maxlast DESC

The query returned with an errorcode of:

Unknown column 'maxlast' in 'order clause'

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.
filipv is offline   Reply With Quote
Old September 29th, 2005, 03:02 PM   #2 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,736
That query doesn't appear in our 5.2 code; do you know where it is coming from? Might be showmembers.php; which has an update available in the current build.

Check the Build thread at the top of the page for updated files and make sure you have current files.
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Old September 29th, 2005, 03:35 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 19
ok, I will try to reupload showmembers.php

Thanks
filipv is offline   Reply With Quote
Old September 29th, 2005, 06:13 PM   #4 (permalink)
Member
Verified Customer
 
Join Date: Jan 2004
Posts: 218
"order by maxlast desc" is coming from the "sortmemb" table in the database. It seems that the query in sortmembers.php as changed and doesn't contain a "as maxlast" any longer.
Astaran is offline   Reply With Quote
Old September 29th, 2005, 07:21 PM   #5 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,675
Yes there is no MAXLAST definer in showmembers.

I will pass along to Michael but I would suggest that the entry be stricken from the sortmemb table

DELETE FROM {$Globals['pp_db_prefix']}sortmemb WHERE sortid='1'
__________________
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 September 29th, 2005, 07:27 PM   #6 (permalink)
PhotoPost Developer
Verified Customer
 
Join Date: Jan 2002
Posts: 11,736
or we can put it back in:

Code:
Content visible to verified customers only.
__________________
Please do not PM me for support or sales questions. Thank you for your understanding.
Michael P is offline   Reply With Quote
Old September 30th, 2005, 08:07 AM   #7 (permalink)
Member
Verified Customer
 
firstrebel's Avatar
 
Join Date: Jan 2003
Location: London
Posts: 188
I reported the MAXLAST error is message #10 in

Table 'photopost.cache' doesn't exist

What do I need to change or is there a new file in the source package.

Bob
firstrebel is offline   Reply With Quote
Old September 30th, 2005, 01:40 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,675
Michael put it back I beleive you can download the build and upload showmembers.php
__________________
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
Trying out a calendar sidebar Michael P General Discussion 8 November 28th, 2005 09:02 PM
PP5.2: Purpose of the calendar snoopy5 Photopost Pro Installation & Upgrades 1 October 4th, 2005 11:01 AM
Problem with calendar and width. iloco Photopost Pro How Do I...? 5 September 28th, 2005 11:50 AM


All times are GMT -5. The time now is 06:12 PM.

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