/ Галерея зображень
/ 19.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 ) ='19.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.0014 | 603280 | run( ) | .../index.php:82 |
3 | 0.0014 | 606680 | include( '/var/www/cms/scripts/gallery/photogallery.php' ) | .../functions.php:34 |
4 | 0.0429 | 670880 | process_template( ) | .../photogallery.php:121 |
5 | 0.0430 | 678024 | Smarty->fetch( ) | .../page_view_functions.php:106 |
6 | 0.0579 | 755800 | include( '/var/www/cms/cache/%%F1^F1B^F1BB2BFC%%template_photogallery.html.php' ) | .../Smarty.class.php:1270 |
7 | 0.0591 | 760864 | GalleryCategory->__get( ) | .../%%F1^F1B^F1BB2BFC%%template_photogallery.html.php:75 |
8 | 0.0591 | 760864 | GalleryCategory->get_list( ) | .../category_model.php:91 |
9 | 0.0591 | 761760 | e::db_getrows( ) | .../category_model.php:209 |
10 | 0.0591 | 762136 | e::__callStatic( ) | .../category_model.php:209 |
11 | 0.0591 | 762136 | db->db_getrows( ) | .../core.php:69 |