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: Output Code issue on Index..  (Read 7004 times)

0 Members and 1 Guest are viewing this topic.

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Output Code issue on Index..
« on: November 26, 2006, 06:07:26 am »

I am having a major issue with a code that is displayed on my site. it looks like this

Code: [Select]
USER:
------------------
Array
(
    [ID] => 531e78d798f5440fa109705e4098b944
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Anonymous
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg132_filetypes; (0s)
    [1] => select * from cpg132_plugins order by priority asc; (0s)
    [2] => delete from `fanavril_fanavrilsql`.cpg132_sessions where time<1164513752 and remember=0; (0s)
    [3] => delete from `fanavril_fanavrilsql`.cpg132_sessions where time<1163307752; (0s)
    [4] => select user_id from `fanavril_fanavrilsql`.cpg132_sessions where session_id=md5("562a397c11ee17e7564d596e7b266d0f2837801bd253dd8a3f98e75d7d8293a6"); (0s)
    [5] => select user_id as id, user_password as password from `fanavril_fanavrilsql`.cpg132_users where user_id=0 (0s)
    [6] => 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 cpg132_usergroups WHERE group_id in (3) (0s)
    [7] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 3 (0s)
    [8] => update `fanavril_fanavrilsql`.cpg132_sessions set time='1164517352' where session_id=md5('562a397c11ee17e7564d596e7b266d0f2837801bd253dd8a3f98e75d7d8293a6'); (0s)
    [9] => DELETE FROM cpg132_banned WHERE expiry < '2006-11-26 05:02:32' (0s)
    [10] => SELECT * FROM cpg132_banned WHERE (ip_addr='69.136.184.211' OR ip_addr='69.136.184.211' OR user_id=0) AND brute_force=0 (0s)
    [11] => SELECT aid FROM cpg132_albums (0s)
    [12] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = ''  ORDER BY pos (0s)
    [13] => SELECT aid FROM cpg132_albums as a WHERE category>=10000 (0s)
    [14] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [15] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos (0s)
    [16] => SELECT aid FROM cpg132_albums WHERE category = 3 (0s)
    [17] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [18] => SELECT count(*) FROM cpg132_albums as a WHERE category = '3' (0s)
    [19] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,1 (0s)
    [20] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg132_albums AS a  LEFT JOIN cpg132_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (3)GROUP BY a.aid (0s)
    [21] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '3'  ORDER BY pos (0s)
    [22] => SELECT aid FROM cpg132_albums WHERE category = 4 (0s)
    [23] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
    [24] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '4'  ORDER BY pos (0s)
    [25] => SELECT aid FROM cpg132_albums WHERE category = 5 (0s)
    [26] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
    [27] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '5'  ORDER BY pos (0s)
    [28] => SELECT aid FROM cpg132_albums WHERE category = 6 (0s)
    [29] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
    [30] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '6'  ORDER BY pos (0s)
    [31] => SELECT aid FROM cpg132_albums WHERE category = 7 (0s)
    [32] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [33] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '7'  ORDER BY pos (0s)
    [34] => SELECT aid FROM cpg132_albums as a WHERE category = '0' (0s)
    [35] => SELECT count(*) FROM cpg132_albums as a WHERE 1 (0s)
    [36] => SELECT count(*) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [37] => SELECT count(*) FROM cpg132_comments as c LEFT JOIN cpg132_pictures as p ON c.pid=p.pid LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [38] => SELECT count(*) FROM cpg132_categories WHERE 1 (0s)
    [39] => SELECT sum(hits) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [40] => SELECT count(*) FROM cpg132_albums as a WHERE category = '0' (0s)
    [41] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  (0s)
    [42] => SELECT * FROM cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  ORDER BY RAND() LIMIT 8 (0.002s)
    [43] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  (0s)
    [44] => SELECT * FROM cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  ORDER BY pid DESC  LIMIT 0 ,8 (0.001s)
)

==========================
GET :
------------------
Array
(
)

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

==========================
Page generated in 0.62 seconds - 45 queries in 0.004 seconds - Album set : ; Meta set: AND aid IN (3) ;



Please someone help me.
Logged

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #1 on: November 26, 2006, 06:12:19 am »

Also the thumbs do not show up either.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Output Code issue on Index..
« Reply #2 on: November 26, 2006, 06:40:07 am »

I am having a major issue with a code that is displayed on my site. it looks like this

Code: [Select]
USER:
------------------
Array
(
    [ID] => 531e78d798f5440fa109705e4098b944
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Anonymous
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg132_filetypes; (0s)
    [1] => select * from cpg132_plugins order by priority asc; (0s)
    [2] => delete from `fanavril_fanavrilsql`.cpg132_sessions where time<1164513752 and remember=0; (0s)
    [3] => delete from `fanavril_fanavrilsql`.cpg132_sessions where time<1163307752; (0s)
    [4] => select user_id from `fanavril_fanavrilsql`.cpg132_sessions where session_id=md5("562a397c11ee17e7564d596e7b266d0f2837801bd253dd8a3f98e75d7d8293a6"); (0s)
    [5] => select user_id as id, user_password as password from `fanavril_fanavrilsql`.cpg132_users where user_id=0 (0s)
    [6] => 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 cpg132_usergroups WHERE group_id in (3) (0s)
    [7] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 3 (0s)
    [8] => update `fanavril_fanavrilsql`.cpg132_sessions set time='1164517352' where session_id=md5('562a397c11ee17e7564d596e7b266d0f2837801bd253dd8a3f98e75d7d8293a6'); (0s)
    [9] => DELETE FROM cpg132_banned WHERE expiry < '2006-11-26 05:02:32' (0s)
    [10] => SELECT * FROM cpg132_banned WHERE (ip_addr='69.136.184.211' OR ip_addr='69.136.184.211' OR user_id=0) AND brute_force=0 (0s)
    [11] => SELECT aid FROM cpg132_albums (0s)
    [12] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = ''  ORDER BY pos (0s)
    [13] => SELECT aid FROM cpg132_albums as a WHERE category>=10000 (0s)
    [14] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [15] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos (0s)
    [16] => SELECT aid FROM cpg132_albums WHERE category = 3 (0s)
    [17] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [18] => SELECT count(*) FROM cpg132_albums as a WHERE category = '3' (0s)
    [19] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,1 (0s)
    [20] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg132_albums AS a  LEFT JOIN cpg132_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (3)GROUP BY a.aid (0s)
    [21] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '3'  ORDER BY pos (0s)
    [22] => SELECT aid FROM cpg132_albums WHERE category = 4 (0s)
    [23] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
    [24] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '4'  ORDER BY pos (0s)
    [25] => SELECT aid FROM cpg132_albums WHERE category = 5 (0s)
    [26] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
    [27] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '5'  ORDER BY pos (0s)
    [28] => SELECT aid FROM cpg132_albums WHERE category = 6 (0s)
    [29] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
    [30] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '6'  ORDER BY pos (0s)
    [31] => SELECT aid FROM cpg132_albums WHERE category = 7 (0s)
    [32] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [33] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '7'  ORDER BY pos (0s)
    [34] => SELECT aid FROM cpg132_albums as a WHERE category = '0' (0s)
    [35] => SELECT count(*) FROM cpg132_albums as a WHERE 1 (0s)
    [36] => SELECT count(*) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [37] => SELECT count(*) FROM cpg132_comments as c LEFT JOIN cpg132_pictures as p ON c.pid=p.pid LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [38] => SELECT count(*) FROM cpg132_categories WHERE 1 (0s)
    [39] => SELECT sum(hits) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [40] => SELECT count(*) FROM cpg132_albums as a WHERE category = '0' (0s)
    [41] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  (0s)
    [42] => SELECT * FROM cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  ORDER BY RAND() LIMIT 8 (0.002s)
    [43] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  (0s)
    [44] => SELECT * FROM cpg132_pictures WHERE approved = 'YES' AND aid IN (3)  ORDER BY pid DESC  LIMIT 0 ,8 (0.001s)
)

==========================
GET :
------------------
Array
(
)

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

==========================
Page generated in 0.62 seconds - 45 queries in 0.004 seconds - Album set : ; Meta set: AND aid IN (3) ;



Please someone help me.

This is debug out put , you can disable it by going to
config=>Maintenance settings=> Enable debug mode
and set it to No

Also the thumbs do not show up either.
Post a link to your gallery ...
Logged
‍I don't answer to PM with support question
Please post your issue to related board

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #3 on: November 26, 2006, 06:41:01 am »

I fixed that problem but now, my thumbs are not showing.

fanavril.00o.us/galerie

Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Output Code issue on Index..
« Reply #4 on: November 26, 2006, 06:49:40 am »

if you try this :
http://www.fanavril.00o.us/galerie/albums/userpics/10001/
you'll see that you don't have 10001 folder at all !!!

what did you do at first place ?
Logged
‍I don't answer to PM with support question
Please post your issue to related board

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #5 on: November 26, 2006, 06:54:32 am »

O M F G

I feel so stupid. Let me change that real quick.
Logged

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #6 on: November 26, 2006, 07:00:17 am »

Ok got the thumbs to work but the others are not there.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Output Code issue on Index..
« Reply #7 on: November 26, 2006, 07:07:35 am »

You don't have intermadiate (normal) and fullsize pics on that folder , put them back or re-upload those pics
Logged
‍I don't answer to PM with support question
Please post your issue to related board

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #8 on: November 26, 2006, 07:45:41 am »

Umm. I only have thumb_ and the regular images. that is all
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Logged
‍I don't answer to PM with support question
Please post your issue to related board

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #10 on: November 26, 2006, 08:06:34 am »

not found on the server


http://tail5.free.fr//galerie/

if you go there there is a fatal error.

I have enabled debug mode and it still shows that. Any clue. i am asking because these are both the same site on different servers. I was trying to move it from http://tail5.free.fr//galerie/ to the one I showed earlier because of that error.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Output Code issue on Index..
« Reply #11 on: November 26, 2006, 10:23:16 am »

How are http://www.fanavril.00o.us/galerie/ and http://tail5.free.fr/galerie/ related? We have a "one question per thread" policy you agreed to respect. Start a new thread for your issues with http://tail5.free.fr/galerie/ after having searched the board.
Logged

5C0 Networks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Output Code issue on Index..
« Reply #12 on: November 26, 2006, 07:06:05 pm »

It is the same site. That is how. With the exact same problem.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Output Code issue on Index..
« Reply #13 on: November 26, 2006, 08:38:12 pm »

Sorry but this way we can't solve your problem !
Stick in to one gallery and let us solve one issue per thread ...
you need to describe what did you do at first place
Logged
‍I don't answer to PM with support question
Please post your issue to related board
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.