Home
Contact
Login
Album list
Last uploads
Last comments
Most viewed
Top rated
My Favorites
By date
Search
Critical error
There was an error while processing a database query.
While executing query 'SELECT user_id AS user_id,user_name AS user_name,COUNT(DISTINCT a.aid) AS alb_count,COUNT(DISTINCT pid) AS pic_count,MAX(pid) AS thumb_pid, MAX(galleryicon) AS gallery_pid FROM cpg15x_albums AS a INNER JOIN `mnicc_pictures`.cpg15x_users AS u ON u.user_id = a.category - 10000 INNER JOIN cpg15x_pictures AS p ON p.aid = a.aid WHERE ((ISNULL(approved) OR approved='YES') AND category > 10000) AND p.aid NOT IN (10) GROUP BY user_id ORDER BY category LIMIT 0, 12 ' in bridge/udb_base.inc.php on line 483 mySQL error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'mnicc_pictures.a.category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /var/www/html/com.mindanews.www/pictures/include/functions.inc.php - Line: 272
Debug Info
Debug Output:
show / hide
Select All
USER: ------------------ Array ( [ID] => f56ca48dff44a12875b01a557fa21694 [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] => 0 [access_level] => 2 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] => Guests [can_create_public_albums] => 0 [can_see_all_albums] => 0 [group_id] => 3 [allowed_albums] => Array ( ) ) ========================== Queries: ------------------ Array ( [0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0.42 ms) [1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:52] (0.24 ms) [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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM cpg15x_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:323] (0.31 ms) [3] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:327] (0.11 ms) [4] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:340] (0.08 ms) [5] => SELECT aid FROM cpg15x_albums WHERE moderator_group IN (3) [include/init.inc.php:274] (0.19 ms) [6] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:332] (0.34 ms) [7] => DELETE FROM cpg15x_banned WHERE expiry < '2023-09-25 15:44:14' [include/init.inc.php:446] (0.25 ms) [8] => SELECT null FROM cpg15x_banned WHERE ('185.93.229.14' LIKE ip_addr OR '' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:462] (0.31 ms) [9] => SELECT aid FROM cpg15x_albums WHERE (category > 10000 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:978] (0.16 ms) [10] => SELECT p.cid, p.name FROM cpg15x_categories AS c, cpg15x_categories AS p WHERE c.lft BETWEEN p.lft AND p.rgt AND c.cid = 1 ORDER BY p.lft [include/functions.inc.php:2839] (0.25 ms) [11] => SELECT NULL FROM cpg15x_albums AS p INNER JOIN cpg15x_pictures AS pics ON pics.aid = p.aid WHERE ( category > 10000 AND p.aid NOT IN (10) ) GROUP BY category; [bridge/udb_base.inc.php:456] (0.9 ms) [12] => SELECT user_id AS user_id,user_name AS user_name,COUNT(DISTINCT a.aid) AS alb_count,COUNT(DISTINCT pid) AS pic_count,MAX(pid) AS thumb_pid, MAX(galleryicon) AS gallery_pid FROM cpg15x_albums AS a INNER JOIN `mnicc_pictures`.cpg15x_users AS u ON u.user_id = a.category - 10000 INNER JOIN cpg15x_pictures AS p ON p.aid = a.aid WHERE ((ISNULL(approved) OR approved='YES') AND category > 10000) AND p.aid NOT IN (10) GROUP BY user_id ORDER BY category LIMIT 0, 12 [bridge/udb_base.inc.php:483] (0.3 ms) ) ========================== GET : ------------------ Array ( [cat] => 1 ) ========================== POST : ------------------ Array ( ) ========================== COOKIE : ------------------ Array ( ) ==========================