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: lots of debug notices help!  (Read 3470 times)

0 Members and 1 Guest are viewing this topic.

stock

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 109
lots of debug notices help!
« on: September 28, 2005, 03:24:53 am »
I have turned debug on and suddenly note this massive notice.

Can someone in the know please help.

Stock






USER:
------------------
Array
(
    [ID] => 7dfb6784598e9b022c49da55dccda374
    [am] => 1
    [liv] => Array
        (
           
  • => 2003
    • [1] => 1738
                [2] => 2004
                [3] => 2008
                [4] => 2009
            )

       
[search] => ###cactus
    [sort] => na
    [uid] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => admin
    [user_password] => ********
    [user_lastvisit] => 2005-09-28 00:48:52
    [user_regdate] => 2005-08-02 16:04:55
    [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] => 1
    [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] => 1
    [priv_upl_need_approval] => 1
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content FROM cpg133filetypes;
    • [1] => SELECT * FROM cpg133users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '******************************'
        [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 cpg133usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg133usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg133banned WHERE expiry < '2005-09-28 01:23:01'
        [5] => SELECT * FROM cpg133banned WHERE ip_addr='86.138.210.175' OR ip_addr='86.138.210.175' OR user_id=1
        [6] => SELECT cid, name, description, thumb FROM cpg133categories WHERE parent = ''  ORDER BY pos
        [7] => SELECT aid FROM cpg133albums as a WHERE category>=10000
        [8] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category >= 10000
        [9] => SELECT aid FROM cpg133albums WHERE category = 22
        [10] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 22
        [11] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1536'
        [12] => SELECT count(*) FROM cpg133albums as a WHERE category = '22'
        [13] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=22 ORDER BY a.pos LIMIT 0,13
        [14] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (96, 39, 40, 41, 109, 55, 42, 34, 43, 98, 99, 97, 112) AND approved = 'YES' GROUP BY aid
        [15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2075'
        [16] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2070'
        [17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1992'
        [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2008'
        [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2057'
        [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2021'
        [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2013'
        [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2004'
        [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1912'
        [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1624'
        [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1885'
        [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2035'
        [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1899'
        [28] => SELECT aid FROM cpg133albums WHERE category = 9
        [29] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 9
        [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1286'
        [31] => SELECT count(*) FROM cpg133albums as a WHERE category = '9'
        [32] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,4
        [33] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (31, 36, 37, 106) AND approved = 'YES' GROUP BY aid
        [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1961'
        [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1972'
        [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1361'
        [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1932'
        [38] => SELECT aid FROM cpg133albums WHERE category = 11
        [39] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 11
        [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1372'
        [41] => SELECT count(*) FROM cpg133albums as a WHERE category = '11'
        [42] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,9
        [43] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (20, 76, 13, 74, 14, 23, 21, 66, 110) AND approved = 'YES' GROUP BY aid
        [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1391'
        [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1394'
        [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1695'
        [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1605'
        [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1381'
        [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1386'
        [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1377'
        [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1366'
        [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1505'
        [53] => SELECT aid FROM cpg133albums WHERE category = 12
        [54] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 12
        [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1271'
        [56] => SELECT count(*) FROM cpg133albums as a WHERE category = '12'
        [57] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=12 ORDER BY a.pos LIMIT 0,4
        [58] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (29, 9, 79, 73) AND approved = 'YES' GROUP BY aid
        [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1265'
        [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1693'
        [61] => SELECT aid FROM cpg133albums WHERE category = 20
        [62] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 20
        [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1598'
        [64] => SELECT count(*) FROM cpg133albums as a WHERE category = '20'
        [65] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=20 ORDER BY a.pos LIMIT 0,9
        [66] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (70, 27, 49, 105, 103, 104, 28, 50, 111) AND approved = 'YES' GROUP BY aid
        [67] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1629'
        [68] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1649'
        [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1608'
        [70] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1604'
        [71] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1954'
        [72] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1626'
        [73] => SELECT aid FROM cpg133albums WHERE category = 29
        [74] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 29
        [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1439'
        [76] => SELECT count(*) FROM cpg133albums as a WHERE category = '29'
        [77] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=29 ORDER BY a.pos LIMIT 0,4
        [78] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (89, 88, 90, 87) AND approved = 'YES' GROUP BY aid
        [79] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1525'
        [80] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1905'
        [81] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1590'
        [82] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1519'
        [83] => SELECT aid FROM cpg133albums WHERE category = 3
        [84] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 3
        [85] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1433'
        [86] => SELECT count(*) FROM cpg133albums as a WHERE category = '3'
        [87] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,7
        [88] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (93, 45, 92, 94, 91, 84, 107) AND approved = 'YES' GROUP BY aid
        [89] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1438'
        [90] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1411'
        [91] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1498'
        [92] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1420'
        [93] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1417'
        [94] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1460'
        [95] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1945'
        [96] => SELECT aid FROM cpg133albums WHERE category = 25
        [97] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 25
        [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1403'
        [99] => SELECT count(*) FROM cpg133albums as a WHERE category = '25'
        [100] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=25 ORDER BY a.pos LIMIT 0,4
        [101] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (95, 65, 63, 77) AND approved = 'YES' GROUP BY aid
        [102] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1973'
        [103] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1402'
        [104] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1410'
        [105] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1403'
        [106] => SELECT aid FROM cpg133albums WHERE category = 26
        [107] => SELECT count(*) FROM cpg133pictures as p, cpg133albums as a WHERE p.aid = a.aid AND category = 26
        [108] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1906'
        [109] => SELECT count(*) FROM cpg133albums as a WHERE category = '26'
        [110] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133albums as a LEFT JOIN cpg133pictures as p ON a.thumb=p.pid WHERE category=26 ORDER BY a.pos LIMIT 0,6
        [111] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133pictures WHERE aid IN (101, 102, 61, 85, 62, 108) AND approved = 'YES' GROUP BY aid
        [112] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1553'
        [113] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1426'
        [114] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1886'
        [115] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1552'
        [116] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='2038'
        [117] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133pictures WHERE pid='1916'
        [118] => SELECT aid FROM cpg133albums as a WHERE category = '0'
        [119] => SELECT count(*) FROM cpg133albums as a WHERE 1
        [120] => SELECT count(*) FROM cpg133pictures as p LEFT JOIN cpg133albums as a ON a.aid=p.aid WHERE 1
        [121] => SELECT count(*) FROM cpg133comments as c LEFT JOIN cpg133pictures as p ON c.pid=p.pid LEFT JOIN cpg133albums as a ON a.aid=p.aid WHERE 1
        [122] => SELECT count(*) FROM cpg133categories WHERE 1
        [123] => SELECT sum(hits) FROM cpg133pictures as p LEFT JOIN cpg133albums as a ON p.aid=a.aid WHERE 1
        [124] => SELECT count(*) FROM cpg133albums as a WHERE category = '0'
    )

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

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.2 - OK
    ------------------
    mySQL version: 3.23.58
    ------------------
    Coppermine version: 1.3.3
    ==========================
    Module: gd
    ------------------
    GD Support enabled
    GD Version bundled (2.0.12 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 3.23.58
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/lib/mysql/mysql.sock
    MYSQL_INCLUDE -I/usr/include/mysql
    MYSQL_LIBS -L/usr/lib/mysql -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 | On | 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 | .:/php/includes:/usr/share/php | .:/php/includes:/usr/share/php
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | me@localhost.com | me@localhost.com
    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 | 60 | 60
    max_input_time | 60 | 60
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.116 seconds - 125 queries in 0.038 seconds - Album set :
« Last Edit: September 28, 2005, 08:21:57 pm by Nibbler »
Logged

OmegaGOD

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • I approve.
Re: lots of debug notices help!
« Reply #1 on: September 28, 2005, 04:28:21 am »
Yes. This a standard debug message. You have nothing to worry about. If you don't want to see it, then turn it off :-)
Logged
Please do not PM me with support questions. Please read the manual and then if posting questions please place them in the proper sub-boards.

stock

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 109
Re: lots of debug notices help!
« Reply #2 on: September 28, 2005, 08:11:29 pm »
thanks, it wasn't so much that as the other notices on the page too but having read through some posts and know I can almost use my site pproperly apart from apostrophe's I'm not going to worry. the other notices are relating to undefined... and I don't think are related to apostrophes anyway.

Please call this solved and thanks

Stock
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.028 seconds with 20 queries.