Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Wrong Link for "Last Additions" on Main Page  (Read 3793 times)

0 Members and 1 Guest are viewing this topic.

Connie

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Solved]: Wrong Link for "Last Additions" on Main Page
« on: July 03, 2004, 12:54:55 pm »

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
« Last Edit: July 06, 2004, 09:34:09 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Wrong Link for "Last Additions" on Main Page
« Reply #1 on: July 03, 2004, 01:07:57 pm »

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

GauGau
Logged

Connie

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Wrong Link for "Last Additions" on Main Page
« Reply #2 on: July 03, 2004, 01:32:25 pm »

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]
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
« Last Edit: July 04, 2004, 01:21:42 am by Connie »
Logged

Connie

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Wrong Link for "Last Additions" on Main Page
« Reply #3 on: July 06, 2004, 12:42:43 am »

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

Thanks.

- Connie
« Last Edit: July 06, 2004, 08:02:04 am by Connie »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged

Connie

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Wrong Link for "Last Additions" on Main Page
« Reply #5 on: July 06, 2004, 09:28:08 am »

Thanks Gau Gau.  It worked.

- Connie
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 20 queries.