't Contrast

Kritieke fout

Er was een fout bij het ophalen van de gegevens uit de database.

While executing query "SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved = 'YES' WHERE a.aid IN (3, 5, 6, 7, 8)GROUP BY a.aid" on 0 mySQL error: 'id00540_coppDB.a.keyword' isn't in GROUP BY

Bestand: /home/id00540/domains/cafe-contrast.be/public_html/contrast/foto/include/functions.inc.php - Regel: 249

Foutenverwijderings-informatie
Selecteer alles
USER: ------------------ Array ( [ID] => c30c401d8543717d6b1189a5e8df9f3e [am] => 1 ) ========================== USER DATA: ------------------ Array ( [user_id] => 0 [user_name] => Guest [groups] => Array ( [0] => 3 ) [group_quota] => 0 [can_rate_pictures] => 0 [can_send_ecards] => 0 [can_post_comments] => 0 [can_upload_pictures] => 0 [can_create_albums] => 0 [pub_upl_need_approval] => 0 [priv_upl_need_approval] => 1 [upload_form_config] => 3 [num_file_upload] => 5 [num_URI_upload] => 3 [custom_user_upload] => 0 [disk_max] => 0 [disk_min] => 0 [ufc_max] => 3 [ufc_min] => 3 [has_admin_access] => 0 [group_name] => Guests [can_see_all_albums] => 0 [group_id] => 3 ) ========================== Queries: ------------------ Array ( [0] => SELECT extension, mime, content, player FROM cpg135_filetypes; (0s) [1] => select * from cpg135_plugins order by priority asc; (0s) [2] => delete from `id00540_coppDB`.cpg135_sessions where time<1328696924 and remember=0; (0.001s) [3] => delete from `id00540_coppDB`.cpg135_sessions where time<1327490924; (0.001s) [4] => SELECT session_id FROM `id00540_coppDB`.cpg135_sessions WHERE session_id=MD5('f4cecd763980dda64af9c1ade1ca2ea0092664232b6431da31d40e5a9d45ee96') (0s) [5] => insert into `id00540_coppDB`.cpg135_sessions (session_id, user_id, time, remember) values ("c5837e851557d2c8e296130a310264b8", 0, "1328700524", 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 cpg135_usergroups WHERE group_id in (3) (0s) [7] => SELECT group_name FROM cpg135_usergroups WHERE group_id= 3 (0s) [8] => update `id00540_coppDB`.cpg135_sessions set time='1328700524' where session_id=md5('f4cecd763980dda64af9c1ade1ca2ea0092664232b6431da31d40e5a9d45ee96'); (0s) [9] => DELETE FROM cpg135_banned WHERE expiry < '2012-02-08 11:28:44' (0s) [10] => SELECT * FROM cpg135_banned WHERE (ip_addr='38.107.179.241' OR ip_addr='38.107.179.241' OR user_id=0) AND brute_force=0 (0s) [11] => SELECT aid FROM cpg135_albums (0s) [12] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = '' ORDER BY pos (0s) [13] => SELECT aid FROM cpg135_albums as a WHERE category>=10000 (0s) [14] => SELECT count() FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s) [15] => SELECT aid FROM cpg135_albums WHERE category = 3 (0s) [16] => SELECT count() FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s) [17] => SELECT count(*) FROM cpg135_albums as a WHERE category = '3' (0s) [18] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,5 (0s) [19] => SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved = 'YES' WHERE a.aid IN (3, 5, 6, 7, 8)GROUP BY a.aid (0s) ) ========================== GET : ------------------ Array ( ) ========================== POST : ------------------ Array ( ) ========================== Page generated in 0.046 seconds - 20 queries in 0.002 seconds - Album set : ; Meta set: AND aid IN (1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,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,51,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,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127) ;

't Contrast - foto-album