/ Image gallery
/ 10.11.2017
ERROR - SELECT DISTINCT SQL_CALC_FOUND_ROWS
pr.rozdil `dirname`,
p.photos_m as icon,
p.photos as image,
p.pidpys as main_image_title,
pr.weight,
count(p.photos_m) as n_images
FROM cms8_photogalery_rozdil pr,
cms8_photogalery p
WHERE pr.site_id = 75
AND p.vis
AND p.site = 75
AND SUBSTRING_INDEX( pr.rozdil, '/', 1 ) ='10.11.2017'
AND SUBSTRING_INDEX( pr.rozdil, '/', 2 )=pr.rozdil
AND (pr.rozdil=p.rozdil OR pr.rozdil=SUBSTRING_INDEX( p.rozdil, '/', 2 ))
GROUP BY `dirname`
ORDER BY pr.weight, pr.rozdil
LIMIT 0,10
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms-web-serv.p.photos_m' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
( ! ) Fatal error: Uncaught Error: Call to a member function data_seek() on bool in /var/www/cms/scripts/core/core.php on line 1935 |
( ! ) Error: Call to a member function data_seek() on bool in /var/www/cms/scripts/core/core.php on line 1935 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0000 | 361424 | {main}( ) | .../index.php:0 |
2 | 0.0018 | 603280 | run( ) | .../index.php:82 |
3 | 0.0019 | 606680 | include( '/var/www/cms/scripts/gallery/photogallery.php' ) | .../functions.php:34 |
4 | 0.0054 | 645136 | process_template( ) | .../photogallery.php:121 |
5 | 0.0055 | 652280 | Smarty->fetch( ) | .../page_view_functions.php:106 |
6 | 0.0129 | 730056 | include( '/var/www/cms/cache/%%F1^F1B^F1BB2BFC%%template_photogallery.html.php' ) | .../Smarty.class.php:1270 |
7 | 0.0137 | 735120 | GalleryCategory->__get( ) | .../%%F1^F1B^F1BB2BFC%%template_photogallery.html.php:75 |
8 | 0.0137 | 735120 | GalleryCategory->get_list( ) | .../category_model.php:91 |
9 | 0.0137 | 736016 | e::db_getrows( ) | .../category_model.php:209 |
10 | 0.0137 | 736392 | e::__callStatic( ) | .../category_model.php:209 |
11 | 0.0137 | 736392 | db->db_getrows( ) | .../core.php:69 |