/ Галерея зображень
/ 2015
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 = 70
AND p.vis
AND p.site = 70
AND SUBSTRING_INDEX( pr.rozdil, '/', 1 ) ='2015'
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 | 361712 | {main}( ) | .../index.php:0 |
2 | 0.0027 | 603568 | run( ) | .../index.php:82 |
3 | 0.0028 | 606968 | include( '/var/www/cms/scripts/gallery/photogallery.php' ) | .../functions.php:34 |
4 | 0.0072 | 672152 | process_template( ) | .../photogallery.php:121 |
5 | 0.0073 | 679280 | Smarty->fetch( ) | .../page_view_functions.php:106 |
6 | 0.0215 | 757112 | include( '/var/www/cms/cache/%%77^77D^77D2E6FD%%template_photogallery.html.php' ) | .../Smarty.class.php:1270 |
7 | 0.0221 | 762144 | GalleryCategory->__get( ) | .../%%77^77D^77D2E6FD%%template_photogallery.html.php:75 |
8 | 0.0222 | 762144 | GalleryCategory->get_list( ) | .../category_model.php:91 |
9 | 0.0222 | 763040 | e::db_getrows( ) | .../category_model.php:209 |
10 | 0.0222 | 763416 | e::__callStatic( ) | .../category_model.php:209 |
11 | 0.0222 | 763416 | db->db_getrows( ) | .../core.php:69 |