forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: stock on September 28, 2005, 03:24:53 am

Title: lots of debug notices help!
Post by: stock 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 :

Title: Re: lots of debug notices help!
Post by: OmegaGOD 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 :-)

Title: Re: lots of debug notices help!
Post by: stock 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