Strange behaviour of Page-By-Page-Archive addon

[ThomasV]

After the upgrade to pixelpost 1.7.1 the Page-By-Page-Archive-Addon shows some strange behaviour. When i open the browse-page of my photoblog the pictures are sorted the wrong way. i.e. the oldest pictures are shown on the first pages.

When looking at a category the sorting is done in the right way (newest pictures shown first)

Here is the link to the browse page of my photoblog http://blog.votho-web.de/index.php?x=browse&pagenum=1

And here the one for a category http://blog.votho-web.de/index.php?x=browse&category=3&pagenum=1

[austriaka]

please check your settings of the order in Admin Options. New in v1.7 you can select the way images are displayed.
And also double check the tags for paged archive, if you use them all correct and did not forget to exchange one

[ThomasV]

settings in the admin options are: date and time of entry descending

Here is the main part of the browse-template
<div id="page">
<h2>Browse Archive:</h2>
<div id="thumbnails">
<BROWSE_CATEGORIES_PAGED>
<br /><br />
<THUMBNAILS_WHOLE_PAGED>
</div> <!--/thumbnails -->
<p class="pagenumbers"><ARCHIVE_PAGES_NUM> --&nbsp; <THUMBNAILS_PAGES_LINKS></p>
</div>
the template was working with 1.6 as expected.

When using <THUMBNAILS> instead of <THUMBNAILS_WHOLE_PAGED> the sorting order is as i expect it.

[austriaka]

Could you please list the general information of your Photoblog? (Found in Admin General Information page)

[ThomasV]

Could you please list the general information of your Photoblog? (Found in Admin General Information page)
I hope this is the information you need

Pixelpost Information
You are running Pixelpost version: 1.7.1 (Better than Ever) - January 2008
Latest Pixelpost version: You have the newest version of Pixelpost!
...

Host Information

URL http://blog.votho-web.de/admin/index.php
PHP-version 5.2.5-0.dotdeb.1 (Pixelpost's min requirement: PHP version: 4.3.0 )
Session save path /var/lib/php5
MySQL version 5.0.51-Dotdeb_0.dotdeb.1 (Pixelpost's min requirement: MySQL: 3.23.58 )
GD-lib bundled (2.0.34 compatible) with JPEG support
File Uploads to Pixelpost site are possible.
Server Software Apache
EXIF Pixelpost is using exifer v1.5 for EXIF-information.

Paths
Guessed imagepath: /srv/www/htdocs/xxxxxxx/html/pixelpost/images/
Configured Imagepath: ../images/
Guessed thumbnailpath /srv/www/htdocs/xxxxxxx/html/pixelpost/thumbnails/
Configured Thumbnailpath ../thumbnails/
Image Directory: OK - Can we write to the directory? YES. Current CHMOD: 0777
Thumbnails Directory: OK - Can we write to the directory? YES. Current CHMOD: 0777
Language Directory: OK
Addons Directory: OK
Includes Directory: OK
Templates Directory: OK

[Dennis]

Strange thing this issue, I use <THUMBNAILS_WHOLE_PAGED> and it works fine.

[austriaka]

you are the third one reporting this issue, it is very strange since nowhere else this comes up. I've searched all versions of paged_archive.php for a reason but could not find one.

If none of the other genius' in the developper team has an idea it would be best to sort it out together in AIM or ICQ (you find my data in my profile) by adding some debugging lines to your code and see what happens. You can also send me a PM to [2 AT KG 3 DOT DE].

Fell free to contact me, I am from germany too so we won't have any language difficulties working this out ;-)

[sebba]

Hi,
I've got the same problem as you.
Impossible to find how to sort thumbnails like images : time posting descending order.
If you find the solution, i'll be happy :-))

Thanks

[mikebshaw]

I am having the same problem with paged-archive...

Funny thing is... it switched order even before I upgraded to 1.7.1

I thought that if I went from 1.6 to 1.7 that it would be fixed... nope!

Any thoughts?

[Dennis]

check if it is on. If you upgrade the addon is off.

[mikebshaw]

I tried to see if it was turn on in the Addon Admin sections, but turns out NONE of my addons show up in the admin. All my original and new addons are uploaded and functioning... how odd.

[mikebshaw]

I fixed the Addons List by following this thread
http://www.pixelpost.org/forum/showthread.php?t=7776&highlight=addons

But, my Page-Archive is still in reverse order....

[austriaka]

for all who have still that ordering issue in paged_archive, showing all images:

open your paged_archive.php file
find this piece of code after line 340:
else
{
$query = "SELECT id, {$headline_selection}, image FROM {$pixelpost_db_prefix}pixelpost
WHERE (datetime<='$cdate')
GROUP BY id
ORDER BY ".$cfgrow['display_sort_by']." ".$display_order.$limit;
}
replace it by this one:
else
{
$query = "SELECT id, {$headline_selection}, image FROM {$pixelpost_db_prefix}pixelpost
WHERE (datetime<='$cdate')
ORDER BY ".$cfgrow['display_sort_by']." ".$display_order.$limit;
}

(GROUP together with ORDER statement is producing unexpected results in some MySQL versions)

HTH
KArin

[mikebshaw]

Thanks Karin... that edit in the addon worked perfectly.

[ThomasV]

Thanks for your help.

Now it works perfectly.