Disappeared photos

[atilius]

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

[Tranz]

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

[atilius]

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

[atilius]

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, 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
  (
  )