На денвере все норм работало - а на хостингу выбивает вот такую ошибку. ( Что , или где подправить)???-
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay »
SQL: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, ntv1.value AS `image1`, ntv2.value AS `nprice`, ntv3.value AS `razmerd`, ntv4.value AS `razmerv`, ntv5.value AS `razmerg`, ntv6.value AS `proizvod`, ntv7.value AS `posektsiy` FROM `site_site_content` sc LEFT JOIN( SELECT DISTINCT tv1.contentid , tv1.value FROM `site_site_tmplvar_contentvalues` tv1 WHERE tv1.tmplvarid = '7' ) AS ntv1 ON sc.id = ntv1.contentid LEFT JOIN( SELECT DISTINCT tv2.contentid , tv2.value FROM `site_site_tmplvar_contentvalues` tv2 WHERE tv2.tmplvarid = '6' ) AS ntv2 ON sc.id = ntv2.contentid LEFT JOIN( SELECT DISTINCT tv3.contentid , tv3.value FROM `site_site_tmplvar_contentvalues` tv3 WHERE tv3.tmplvarid = '5' ) AS ntv3 ON sc.id = ntv3.contentid LEFT JOIN( SELECT DISTINCT tv4.contentid , tv4.value FROM `site_site_tmplvar_contentvalues` tv4 WHERE tv4.tmplvarid = '21' ) AS ntv4 ON sc.id = ntv4.contentid LEFT JOIN( SELECT DISTINCT tv5.contentid , tv5.value FROM `site_site_tmplvar_contentvalues` tv5 WHERE tv5.tmplvarid = '22' ) AS ntv5 ON sc.id = ntv5.contentid LEFT JOIN( SELECT DISTINCT tv6.contentid , tv6.value FROM `site_site_tmplvar_contentvalues` tv6 WHERE tv6.tmplvarid = '12' ) AS ntv6 ON sc.id = ntv6.contentid LEFT JOIN( SELECT DISTINCT tv7.contentid , tv7.value FROM `site_site_tmplvar_contentvalues` tv7 WHERE tv7.tmplvarid = '19' ) AS ntv7 ON sc.id = ntv7.contentid WHERE ((sc.id IN (9,10,11,12,21,22,23,24,25,40,54,26,13,14,15,16,17,18,19,20,42,27,51,49,50,36,35,55,56,37,38,39)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%шкаф%') OR (`image1` LIKE '%шкаф%') OR (`nprice` LIKE '%шкаф%') OR (`razmerd` LIKE '%шкаф%') OR (`razmerv` LIKE '%шкаф%') OR (`razmerg` LIKE '%шкаф%') OR (`proizvod` LIKE '%шкаф%') OR (`posektsiy` LIKE '%шкаф%'))) ORDER BY publishedon,pagetitle
