Print

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