pp 5.2 calendar problem(FIXED)

[filipv]

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.

[Michael P]

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.

[filipv]

ok, I will try to reupload showmembers.php

Thanks

[Astaran]

"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.

[Chuck S]

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'

[Michael P]

or we can put it back in:

Content visible to verified customers only.

[firstrebel]

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

[Chuck S]

Michael put it back I beleive you can download the build and upload showmembers.php