[Solved]: Wrong Link for "Last Additions" on Main Page

[Connie]

Hi,

I've been having a problem with the "last additions" feature.  On my main page, some of the "last addition" thumbnails do not link to their correct full-size picture.  You can see this here: http://www.adam-pascal.com/gallery/.  This is because some of the "last addition" pictures are not actually the ones that have been last added.

But on the page with all the last uploaded pictures, the order of the last uploaded pictures is fine.

Does my description make any sense at all?  If anyone can help, I would be very thankful.

- Connie

[Joachim Müller]

this is a know issue that has been reported already. Please search the forum before posting.

GauGau

[Connie]

Hi Gau Gau,

I did search for a solution to this problem at this forum for an hour or so before posting this message, and although I found posts where this problem was mentioned, I could not seem to find a viable solution to my particular problem.

This other message is the closest to my problem: http://forum.coppermine-gallery.net/index.php?topic=5606.0, but it didn't solve my problem.  I deleted all my temporary internet files and cookies and my gallery is still having problems.

I also tried http://forum.coppermine-gallery.net/index.php?topic=7462.0, but the solution posted there also didn't work.

This is the error that I get:

Code Select Expand

USER:
------------------
Array
(
    [ID] => f9d6c18845fda062a2242d1a65d97bea
    [am] => 1
    [liv] => Array
        (
            [0] => 511
            [1] => 512
            [2] => 515
            [3] => 514
            [4] => 485
        )

    [theme] => classic
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => connie
    [user_password] => ********
    [user_lastvisit] => 2004-07-03 19:03:14
    [user_regdate] => 2004-07-02 19:05:19
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg130_filetypes;
    [1] => SELECT * FROM cpg130_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'f47a3fe4e4ebee188be7452277422ccf'
    [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg130_usergroups WHERE group_id in (1)
    [3] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1
    [4] => DELETE FROM cpg130_banned WHERE expiry < 1088896432
    [5] => SELECT * FROM cpg130_banned WHERE ip_addr='24.81.21.102' OR ip_addr='24.81.21.102' OR user_id=1
    [6] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = ''  ORDER BY pos
    [7] => SELECT aid FROM cpg130_albums as a WHERE category>=10000
    [8] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category >= 10000
    [9] => SELECT aid FROM cpg130_albums WHERE category = 2
    [10] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 2
    [11] => SELECT count(*) FROM cpg130_albums as a WHERE category = '2'
    [12] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,2
    [13] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (1, 2) AND approved = 'YES' GROUP BY aid
    [14] => SELECT aid FROM cpg130_albums WHERE category = 16
    [15] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 16
    [16] => SELECT aid FROM cpg130_albums WHERE category = 4
    [17] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 4
    [18] => SELECT count(*) FROM cpg130_albums as a WHERE category = '4'
    [19] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,14
    [20] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32) AND approved = 'YES' GROUP BY aid
    [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='483'
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='520'
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='480'
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='486'
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='487'
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='489'
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='488'
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='521'
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='188'
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='190'
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='482'
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='477'
    [33] => SELECT aid FROM cpg130_albums WHERE category = 5
    [34] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 5
    [35] => SELECT count(*) FROM cpg130_albums as a WHERE category = '5'
    [36] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,3
    [37] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (33, 34, 35) AND approved = 'YES' GROUP BY aid
    [38] => SELECT aid FROM cpg130_albums WHERE category = 26
    [39] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 26
    [40] => SELECT count(*) FROM cpg130_albums as a WHERE category = '26'
    [41] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=26 ORDER BY a.pos LIMIT 0,3
    [42] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (36, 37, 38) AND approved = 'YES' GROUP BY aid
    [43] => SELECT aid FROM cpg130_albums WHERE category = 7
    [44] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 7
    [45] => SELECT count(*) FROM cpg130_albums as a WHERE category = '7'
    [46] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,2
    [47] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (39, 40) AND approved = 'YES' GROUP BY aid
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='522'
    [49] => SELECT aid FROM cpg130_albums WHERE category = 8
    [50] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category = 8
    [51] => SELECT count(*) FROM cpg130_albums as a WHERE category = '8'
    [52] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,2
    [53] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (42, 41) AND approved = 'YES' GROUP BY aid
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='462'
    [55] => SELECT aid FROM cpg130_albums as a WHERE category = '0'
    [56] => SELECT count(*) FROM cpg130_albums as a WHERE 1
    [57] => SELECT count(*) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE 1
    [58] => SELECT count(*) FROM cpg130_comments as c LEFT JOIN cpg130_pictures as p ON c.pid=p.pid LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE 1
    [59] => SELECT count(*) FROM cpg130_categories WHERE 1
    [60] => SELECT sum(hits) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON p.aid=a.aid WHERE 1
    [61] => SELECT count(*) FROM cpg130_albums as a WHERE category = '0'
    [62] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND aid IN (1,2,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)
    [63] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg130_pictures WHERE approved = 'YES' AND aid IN (1,2,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)  ORDER BY pid DESC  LIMIT 0 ,8
)

==========================
GET :
------------------
Array
(
    [theme] => classic
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.3 - OK
------------------
mySQL version: 4.0.18-standard
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/adam-pas/:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.125 seconds - 64 queries in 0.043 seconds - Album set : AND aid IN (1,2,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)

- Connie

[Connie]

I've re-installed the entire program, but I'm still having the same problem.  Can somebody PLEASE help me?

Thanks.

- Connie

[Joachim Müller]

try http://forum.coppermine-gallery.net/index.php?topic=6775.msg32638#msg32638

GauGau

[Connie]

Thanks Gau Gau.  It worked.

- Connie