Problem with installation Problem with installation
 

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]

Main Menu

Problem with installation

Started by wojo134, March 08, 2017, 10:45:18 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

wojo134

March 08, 2017, 10:45:18 AM

Hi,

i have problem with installation my gallery, with step 6 when im entering user and pass it says:

ERROR
The following errors were encountered and need to be corrected first:
Could not create a MySQL connection, please check the MySQL details entered
MySQL błąd: Access denied for user 'wojo134'@'localhost' (using password: TAK)

i have two database on my server one for gallery and one for forum.
here is url when problem occurs
http://tatuhqq.pl/galeria2/install.php?step=6

any idea why it is happening and what can i do?

gmc

#1
March 08, 2017, 01:21:04 PM
Make sure you are using the correct userid and password - for an ID with access to the gallery database...
It's reporting 'access denied' - so I would guess wojo134 doesn't have access to the gallery database.
Typically on shared hosts, ids have to be associated with the desired database via a cPanel option.

The error is coming from MySQL - not Coppermine.
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

wojo134

#2
March 08, 2017, 02:59:47 PM
Well, it seems now gallery is working but on bottom of the page http://galeria.tatuhqq.pl/ i get this error message:

USER:
------------------
Array
(
    [ID] => 4c7ad7d902837f724242254cb9bc7367
    [am] => 1
    [lang] => polish
    [liv] => Array
        (
           
  • => 1962
            )
    )
    ==========================
    USER DATA:
    ------------------
    Array
    (
        [user_id] => 0
        [user_name] => Guest
        [groups] => Array
            (
               
  • => 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] => Guests
        [can_see_all_albums] => 0
        [group_id] => 3
    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
        [1] => select * from cpg14x_plugins order by priority asc; (0s)
        [2] => delete from `wojo134_Galeria`.cpg14x_sessions where time<1488977818 and remember=0; (0.002s)
        [3] => delete from `wojo134_Galeria`.cpg14x_sessions where time<1487771818; (0s)
        [4] => select user_id from `wojo134_Galeria`.cpg14x_sessions where session_id=md5("5a96b89f82794021f886a27cb1fe1617fd37298868b8931794dc21268718736c"); (0s)
        [5] => SELECT session_id FROM `wojo134_Galeria`.cpg14x_sessions WHERE session_id=MD5('61a10f41033238896f4b2b1c96c6d666fd37298868b8931794dc21268718736c') (0s)
        [6] => insert into `wojo134_Galeria`.cpg14x_sessions (session_id, user_id, time, remember) values ("eb39767fe2f9d54983acef268ecbf7e6", 0, "1488981418", 0); (0s)
        [7] => 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 cpg14x_usergroups WHERE group_id in (3) (0s)
        [8] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 3 (0.002s)
        [9] => update `wojo134_Galeria`.cpg14x_sessions set time='1488981418' where session_id=md5('61a10f41033238896f4b2b1c96c6d666fd37298868b8931794dc21268718736c'); (0.001s)
        [10] => DELETE FROM cpg14x_banned WHERE expiry < '2017-03-08 15:56:58' (0.001s)
        [11] => SELECT * FROM cpg14x_banned WHERE (ip_addr='83.19.186.82' OR ip_addr='83.19.186.82' OR user_id=0) AND brute_force=0 (0s)
        [12] => SELECT aid FROM cpg14x_albums (0.015s)
        [13] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY pos (0s)
        [14] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0.022s)
        [15] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
        [16] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0s)
        [17] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.005s)
        [18] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '2' (0s)
        [19] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,48 (0.001s)
        [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 cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (194, 189, 142, 177, 111, 221, 19, 183, 205, 192, 220, 190, 199, 201, 18, 8, 6, 3, 218, 16, 5, 13, 88, 7, 158, 150, 239, 85, 79, 17, 9, 15, 132, 94, 10, 217, 11, 14, 82, 4, 172, 181, 225, 143, 235, 234, 124, 84)GROUP BY a.aid (0.002s)
        [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1699' (0s)
        [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1861' (0s)
        [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1551' (0s)
        [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1116' (0s)
        [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1826' (0s)
        [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1623' (0s)
        [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1759' (0s)
        [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1693' (0s)
        [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1917' (0s)
        [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1859' (0s)
        [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1730' (0s)
        [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1742' (0s)
        [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='905' (0s)
        [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1821' (0s)
        [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='110' (0s)
        [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='90' (0s)
        [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1476' (0s)
        [38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1418' (0s)
        [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1916' (0s)
        [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='65' (0s)
        [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='104' (0s)
        [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1686' (0s)
        [43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1855' (0s)
        [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='97' (0s)
        [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='814' (0s)
        [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1536' (0s)
        [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1603' (0s)
        [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1833' (0s)
        [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1374' (0s)
        [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1864' (0s)
        [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1863' (0s)
        [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1245' (0s)
        [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='831' (0s)
        [54] => SELECT aid FROM cpg14x_albums WHERE category = 3 (0s)
        [55] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0.023s)
        [56] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '3' (0s)
        [57] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,48 (0.001s)
        [58] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (214, 226, 138, 137, 107, 112, 99, 105, 155, 96, 78, 113, 33, 115, 116, 222, 36, 92, 38, 118, 27, 30, 37, 89, 20, 31, 149, 24, 39, 195, 32, 23, 35, 80, 237, 25, 238, 186, 22, 95, 28, 26, 219, 34, 198, 230, 229, 29)GROUP BY a.aid (0.002s)
        [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1801' (0s)
        [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1835' (0s)
        [61] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1064' (0s)
        [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1455' (0s)
        [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='963' (0s)
        [64] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1124' (0s)
        [65] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1884' (0s)
        [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1927' (0s)
        [67] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='371' (0s)
        [68] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='915' (0s)
        [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='872' (0s)
        [70] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1413' (0s)
        [71] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1706' (0s)
        [72] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1908' (0s)
        [73] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1955' (0s)
        [74] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1664' (0s)
        [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='166' (0s)
        [76] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1832' (0s)
        [77] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1823' (0s)
        [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1723' (0s)
        [79] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1844' (0s)
        [80] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1872' (0s)
        [81] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='244' (0s)
        [82] => SELECT aid FROM cpg14x_albums WHERE category = 4 (0s)
        [83] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
        [84] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '4' (0s)
        [85] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,44 (0.001s)
        [86] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (215, 208, 202, 200, 197, 193, 182, 148, 140, 106, 153, 102, 97, 151, 77, 46, 191, 126, 196, 232, 90, 58, 91, 55, 163, 171, 54, 50, 166, 83, 188, 53, 42, 41, 43, 49, 175, 48, 187, 207, 161, 213, 110, 152)GROUP BY a.aid (0.002s)
        [87] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1816' (0s)
        [88] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1773' (0s)
        [89] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1744' (0s)
        [90] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1767' (0s)
        [91] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1775' (0s)
        [92] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1695' (0s)
        [93] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1617' (0s)
        [94] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1604' (0s)
        [95] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1438' (0s)
        [96] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1965' (0s)
        [97] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1700' (0s)
        [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1707' (0s)
        [99] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1856' (0s)
        [100] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1507' (0s)
        [101] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1527' (0s)
        [102] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1510' (0s)
        [103] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1679' (0s)
        [104] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1491' (0s)
        [105] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1542' (0s)
        [106] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1672' (0s)
        [107] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1831' (0s)
        [108] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1489' (0s)
        [109] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1110' (0s)
        [110] => SELECT aid FROM cpg14x_albums WHERE category = 7 (0.001s)
        [111] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
        [112] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '7' (0s)
        [113] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,11 (0s)
        [114] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (71, 75, 174, 73, 72, 70, 69, 66, 68, 67, 74)GROUP BY a.aid (0s)
        [115] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='672' (0s)
        [116] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='680' (0s)
        [117] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='675' (0s)
        [118] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='664' (0s)
        [119] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='657' (0s)
        [120] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='662' (0s)
        [121] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='660' (0s)
        [122] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='684' (0s)
        [123] => SELECT aid FROM cpg14x_albums WHERE category = 6 (0s)
        [124] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
        [125] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '6' (0s)
        [126] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,1 (0s)
        [127] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (76)GROUP BY a.aid (0s)
        [128] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='701' (0s)
        [129] => SELECT aid FROM cpg14x_albums WHERE category = 5 (0s)
        [130] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0.001s)
        [131] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '5' (0s)
        [132] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,60 (0.001s)
        [133] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (227, 209, 211, 210, 203, 185, 184, 180, 179, 178, 170, 168, 167, 133, 162, 144, 159, 157, 141, 139, 145, 147, 146, 128, 127, 108, 223, 204, 121, 119, 104, 56, 109, 47, 52, 123, 103, 100, 164, 98, 81, 135, 60, 45, 134, 129, 169, 44, 57, 165, 130, 62, 131, 61, 65, 64, 63, 156, 59, 231)GROUP BY a.aid (0.002s)
        [134] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1841' (0s)
        [135] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1769' (0s)
        [136] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1771' (0s)
        [137] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1851' (0s)
        [138] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1756' (0s)
        [139] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1653' (0s)
        [140] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1638' (0s)
        [141] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1593' (0s)
        [142] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1567' (0s)
        [143] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1525' (0s)
        [144] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1518' (0s)
        [145] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1514' (0s)
        [146] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1502' (0s)
        [147] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1428' (0s)
        [148] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1486' (0s)
        [149] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1391' (0s)
        [150] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1359' (0s)
        [151] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1390' (0s)
        [152] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1382' (0s)
        [153] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1381' (0s)
        [154] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1270' (0s)
        [155] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1261' (0s)
        [156] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1830' (0s)
        [157] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1757' (0s)
        [158] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1217' (0s)
        [159] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1056' (0s)
        [160] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1860' (0s)
        [161] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1103' (0s)
        [162] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1230' (0s)
        [163] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1509' (0s)
        [164] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1339' (0s)
        [165] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1338' (0s)
        [166] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1340' (0s)
        [167] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1519' (0s)
        [168] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='475' (0s)
        [169] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1511' (0.001s)
        [170] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='631' (0s)
        [171] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1853' (0s)
        [172] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='641' (0s)
        [173] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1456' (0s)
        [174] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1846' (0s)
        [175] => SELECT aid FROM cpg14x_albums WHERE category = 8 (0.001s)
        [176] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
        [177] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '8' (0s)
        [178] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,4 (0s)
        [179] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (86, 87, 122, 216)GROUP BY a.aid (0s)
        [180] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='857' (0s)
        [181] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1680' (0s)
        [182] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='1817' (0s)
        [183] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
        [184] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
        [185] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
        [186] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
        [187] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
        [188] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0.003s)
        [189] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
        [190] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (3,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,94,95,96,97,98,99,100,102,103,104,105,106,107,108,109,110,111,112,113,115,116,118,119,120,121,122,123,124,126,127,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,172,174,175,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,207,208,209,210,211,213,214,215,216,217,218,219,220,221,222,223,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239)  (0.002s)
        [191] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (3,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,94,95,96,97,98,99,100,102,103,104,105,106,107,108,109,110,111,112,113,115,116,118,119,120,121,122,123,124,126,127,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,172,174,175,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,207,208,209,210,211,213,214,215,216,217,218,219,220,221,222,223,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239)  ORDER BY RAND() LIMIT 4 (0.009s)
        [192] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (3,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,94,95,96,97,98,99,100,102,103,104,105,106,107,108,109,110,111,112,113,115,116,118,119,120,121,122,123,124,126,127,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,172,174,175,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,207,208,209,210,211,213,214,215,216,217,218,219,220,221,222,223,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239)  (0.001s)
        [193] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (3,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,94,95,96,97,98,99,100,102,103,104,105,106,107,108,109,110,111,112,113,115,116,118,119,120,121,122,123,124,126,127,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,161,162,163,164,165,166,167,168,169,170,171,172,174,175,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,207,208,209,210,211,213,214,215,216,217,218,219,220,221,222,223,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239)  ORDER BY pid DESC  LIMIT 0 ,4 (0.001s)
    )

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

    any idea what it is about?

gmc

#3
March 08, 2017, 07:09:49 PM
Not an error message - you have 'DEBUG' turned on for all...
Look in the 'Maintenance Settings' section (bottom of Config) - and set 'Enable debug mode' to 'No' or 'Yes: Admin Only' if you prefer.
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money
Print
Go Up Pages1
User actions