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: Disappeared photos  (Read 4758 times)

0 Members and 1 Guest are viewing this topic.

atilius

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Disappeared photos
« on: March 22, 2005, 05:18:54 pm »

Hello,

please, I need your assistance. Carrefuly I have been using your gallery v 1.2.1 and in one time all photos disapperead. On the server I can see them. And for example, the most viewed category shows me 527 pictures in 44 pages but no picture. I dont know where is a problem. If you can help me I will be very glad.

Thank you,

Martin

PS: http://www.cfai.cz/photo/cpg/index.php?cat=0
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Disappeared photos
« Reply #1 on: March 22, 2005, 09:58:05 pm »

Could you please put back the classic theme so we can see if this is a theme-specific issue?
Logged

atilius

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Disappeared photos
« Reply #2 on: March 23, 2005, 05:58:01 am »

In setting is "default theme" and only modifications which I did were in css file to set background and fonts colors.

if it can help you, I can send you via email password and username for admin.

Martin
Logged

atilius

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Disappeared photos
« Reply #3 on: March 24, 2005, 09:51:45 pm »

Here is the list from debug mode. I do hope it can help you.

Martin


USER:

Array
(
    [ID] => 124fc4820a3310f4fe615e8311ffe538
    [am] => 1
    [liv] => Array
        (
           
  • => 552

        )

)
USER DATA:

Array
(
   
  • => 1
[user_id] => 1
    [1] => 1
    [user_group] => 1
    [2] => YES
    [user_active] => YES
    [3] => atilius
    [user_name] => atilius
    [4] =>
    [5] => 2004-02-07 13:45:31
    [user_lastvisit] => 2004-02-07 13:45:31
    [6] => 2004-02-07 13:45:31
    [user_regdate] => 2004-02-07 13:45:31
    [7] =>
    [user_lang] =>
    [8] =>
    [user_email] =>
    [9] =>
    [user_website] =>
    [10] =>
    [user_location] =>
    [11] =>
    [user_interests] =>
    [12] =>
    [user_occupation] =>
    [13] =>
    [user_actkey] =>
    [14] => 1
    [group_id] => 1
    [15] => Administrators
    [group_name] => Administrators
    [16] => 0
    [group_quota] => 0
    [17] => 1
    [has_admin_access] => 1
    [18] => 1
    [can_rate_pictures] => 1
    [19] => 1
    [can_send_ecards] => 1
    [20] => 1
    [can_post_comments] => 1
    [21] => 1
    [can_upload_pictures] => 1
    [22] => 1
    [can_create_albums] => 1
    [23] => 0
    [pub_upl_need_approval] => 0
    [24] => 0
    [priv_upl_need_approval] => 0
)
Queries:

Array
(
   
  • => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '1cdf4c400619855d6dba5d6292da42fa'
  • [1] => DELETE FROM cpg11d_banned WHERE expiry < 1111697352
        [2] => SELECT * FROM cpg11d_banned WHERE ip_addr='62.240.183.30' OR ip_addr='62.240.183.30' OR user_id=1
        [3] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = ''  ORDER BY pos
        [4] => SELECT aid FROM cpg11d_albums WHERE category = 4
        [5] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 4
        [6] => SELECT count(*) FROM cpg11d_albums WHERE category = '4'
        [7] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '4' ORDER BY pos LIMIT 0,2
        [8] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1, 1) AND approved = 'YES' GROUP BY aid
        [9] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '4'  ORDER BY pos
        [10] => SELECT aid FROM cpg11d_albums WHERE category = 7
        [11] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 7
        [12] => SELECT count(*) FROM cpg11d_albums WHERE category = '7'
        [13] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '7' ORDER BY pos LIMIT 0,3
        [14] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (2, 2, 8) AND approved = 'YES' GROUP BY aid
        [15] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '7'  ORDER BY pos
        [16] => SELECT aid FROM cpg11d_albums WHERE category = 6
        [17] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 6
        [18] => SELECT count(*) FROM cpg11d_albums WHERE category = '6'
        [19] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '6' ORDER BY pos LIMIT 0,4
        [20] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (3, 2, 1, 9) AND approved = 'YES' GROUP BY aid
        [21] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '6'  ORDER BY pos
        [22] => SELECT aid FROM cpg11d_albums WHERE category = 5
        [23] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 5
        [24] => SELECT count(*) FROM cpg11d_albums WHERE category = '5'
        [25] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '5' ORDER BY pos LIMIT 0,2
        [26] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (3, 1) AND approved = 'YES' GROUP BY aid
        [27] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '5'  ORDER BY pos
        [28] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [29] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [30] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [31] => SELECT aid FROM cpg11d_albums WHERE category = 8
        [32] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 8
        [33] => SELECT count(*) FROM cpg11d_albums WHERE category = '8'
        [34] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '8' ORDER BY pos LIMIT 0,2
        [35] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (2, 2) AND approved = 'YES' GROUP BY aid
        [36] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '8'  ORDER BY pos
        [37] => SELECT aid FROM cpg11d_albums WHERE category = 9
        [38] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 9
        [39] => SELECT count(*) FROM cpg11d_albums WHERE category = '9'
        [40] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '9' ORDER BY pos LIMIT 0,1
        [41] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1) AND approved = 'YES' GROUP BY aid
        [42] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '9'  ORDER BY pos
        [43] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [44] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [45] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [46] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [47] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [48] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [49] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [50] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [51] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [52] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [53] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [54] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [55] => SELECT aid FROM cpg11d_albums WHERE category = 2
        [56] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 2
        [57] => SELECT count(*) FROM cpg11d_albums WHERE category = '2'
        [58] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '2' ORDER BY pos LIMIT 0,7
        [59] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (3, 3, 2, 2, 2, 1, 6) AND approved = 'YES' GROUP BY aid
        [60] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '2'  ORDER BY pos
        [61] => SELECT count(*) FROM cpg11d_albums WHERE 1
        [62] => SELECT count(*) FROM cpg11d_pictures WHERE 1
        [63] => SELECT count(*) FROM cpg11d_comments WHERE 1
        [64] => SELECT count(*) FROM cpg11d_categories WHERE 1
        [65] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
    )
    GET :

    Array
    (
    )
    POST :

    Array
    (
    )
Logged
Pages: [1]   Go Up
 

Page created in 0.03 seconds with 19 queries.