/ Галерея изображений
/ 2005
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 cms_photogalery_rozdil pr,
cms_photogalery p
WHERE pr.site_id = 1
AND p.vis
AND p.site = 1
AND SUBSTRING_INDEX( pr.rozdil, '/', 1 ) ='2005'
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
Can't create/write to file '/tmp/#sql_537_0.MAI' (Errcode: 28 "No space left on device")
Fatal error: Uncaught Error: Call to a member function data_seek() on boolean in /home/ju-jutsu-admin/gdcms/scripts/core/core.php:1935
Stack trace:
#0 /home/ju-jutsu-admin/gdcms/scripts/core/core.php(69): db->db_getrows('SELECT DISTINCT...')
#1 /home/ju-jutsu-admin/gdcms/scripts/gallery/category_model.php(209): e::__callStatic('db_getrows', Array)
#2 /home/ju-jutsu-admin/gdcms/scripts/gallery/category_model.php(91): GalleryCategory->get_list()
#3 /home/ju-jutsu-admin/cache/%%AB^AB1^AB19222F%%template_photogallery.html.php(75): GalleryCategory->__get('items_found')
#4 /home/ju-jutsu-admin/gdcms/scripts/smarty/libs/Smarty.class.php(1270): include('/home/ju-jutsu-...')
#5 /home/ju-jutsu-admin/gdcms/scripts/site/page/page_view_functions.php(106): Smarty->fetch('db:/home/ju-jut...')
#6 /home/ju-jutsu-admin/gdcms/scripts/gallery/photogallery.php(122): process_template('/home/ju-jutsu-...', Array)
#7 /home/ju-jutsu-admin/gdcms/scripts/lib/functions.php(34): include('/home/ju-jutsu-...')
#8 /home/ju-jutsu-admin/www/cms/index.php( in /home/ju-jutsu-admin/gdcms/scripts/core/core.php on line 1935