Ошибка в SQL запросе!
Запрос:
SELECT COUNT(DISTINCT data.id)
            FROM prefix_ddata_\\\' data, prefix_documents doc, prefix_folders fold
            WHERE
               doc.id = data.id
            AND
                doc.visible = '1'
            AND
               fold.id IN (1253)
            AND
               ( FIND_IN_SET( fold.id, data.cat_category )
               OR
                FIND_IN_SET( fold.id, data.category ) )
Ответ сервера:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\\\' data, prefix_documents doc, prefix_folders fold
            WHERE
       ' at line 2
backtrace:
#0  sql::error(SELECT COUNT(DISTINCT data.id)
            FROM prefix_ddata_\\\' data, prefix_documents doc, prefix_folders fold
            WHERE
               doc.id = data.id
            AND
                doc.visible = '1'
            AND
               fold.id IN (1253)
            AND
               ( FIND_IN_SET( fold.id, data.cat_category )
               OR
                FIND_IN_SET( fold.id, data.category ) )

            
            ) called at [/var/www/designex/data/www/designex.ru/cms/includes/sql.php:128]
#1  sql::query(SELECT COUNT(DISTINCT data.id)
            FROM prefix_ddata_\\\' data, prefix_documents doc, prefix_folders fold
            WHERE
               doc.id = data.id
            AND
                doc.visible = '1'
            AND
               fold.id IN (1253)
            AND
               ( FIND_IN_SET( fold.id, data.cat_category )
               OR
                FIND_IN_SET( fold.id, data.category ) )

            
            , , , 1) called at [/var/www/designex/data/www/designex.ru/cms/includes/sql.php:55]
#2  sql::result(SELECT COUNT(DISTINCT data.id)
            FROM prefix_ddata_\\\' data, prefix_documents doc, prefix_folders fold
            WHERE
               doc.id = data.id
            AND
                doc.visible = '1'
            AND
               fold.id IN (1253)
            AND
               ( FIND_IN_SET( fold.id, data.cat_category )
               OR
                FIND_IN_SET( fold.id, data.category ) )

            
            , 0, 0, , , 1) called at [/var/www/designex/data/www/designex.ru/includes/site.php:1715]
#3  Site->count_userforcategory(Array ([1253] => 1253)) called at [/var/www/designex/data/www/designex.ru/includes/plugins/catalog/catalog.inc.php:619]
#4  Catalog->build_subcatalog(1252) called at [/var/www/designex/data/www/designex.ru/includes/plugins/catalog/catalog.inc.php:335]
#5  Catalog->showSection(12, 1252, organization, name) called at [/var/www/designex/data/www/designex.ru/includes/plugins/catalog/catalog.inc.php:152]
#6  Catalog->doit() called at [/var/www/designex/data/www/designex.ru/includes/plugins/catalog/catalog.inc.php:25]
#7  Catalog->__construct(Site Object ([] => 1,[] => iTemplate Object ([] => Templaters Object ([html] => ,[array] => Array ([site_url] => http://designex.ru/templates/default/,[sitename] => Южный дизайн-портал,[title_delimiter] =>  | ,[base_url] => design/default/,[adm_url] => templates/default/tpl//,[site_path] => /,[POST] => Array (),[GET] => Array ([url] => catalog/graphics_design/,[type] => \\\'),[COOKIE] => Array (),[VARS] => ,[page_name] => Графический дизайн. Композиции, элементы, рисунки,[meta_description] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[meta_keywords] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[url] => ,[main_url] => /catalog/graphics_design/,[self_url] => catalog/graphics_design/,[self_url_wp] => catalog/graphics_design/,[self_url_wpp] => catalog/graphics_design/,[self_url_wd] => catalog/graphics_design/,[back_url_ref] => ,[all_url] => catalog/graphics_design/,[itsMainPage] => ,[last_year] => 2024,[user_agreement] => /agreement/,[adv_url] => /advertising/,[auth] => Array ([vis_city] => /l_cab/vis_city/,[cur_city] => ,[reg_url] => /reg/,[auth_url] => /auth/),[online_users] => Array ([auth] => 0,[guest] => 8),[path] => Главная >>   Каталог >>  Графический дизайн
,[path_level] => Array,[menu_arr] => Array ([0] => Array ([id] => 1239,[key] => catalog,[name] => Каталог,[url] => /catalog/,[checked] => ,[active] => 1,[position] => 2,[itslast] => 1,[itsfirst] => ,[submenu] => ),[1] => Array ([id] => 1238,[key] => party,[name] => Участники,[url] => /party/,[checked] => ,[active] => ,[position] => 3,[itslast] => ,[itsfirst] => ,[submenu] => )),[build_sitemap] => /sitemap/,[build_faq] => /faq/,[is_catalog] => 1,[categories_type] => list,[url_list] => /catalog/?cat_type=list&type=organization,[url_cloud] => ?cat_type=cloud&type=organization,[links] => Array ([curr_type] => organization,[org_url] => /catalog/graphics_design/?type=organization&cat_type=list,[ind_url] => /catalog/graphics_design/?type=individuals&cat_type=list,[all_url] => /catalog/graphics_design/?cat_type=list&type=organization&goods=all,[sort_name_url] => /catalog/graphics_design/?cat_type=list&type=organization&sort=name,[sort_name_url_catalog] => /catalog/graphics_design/?cat_type=list&type=organization&sort=name,[sort_rating_url] => /catalog/graphics_design/?cat_type=list&type=organization&sort=rating,[sort_rating_url_catalog] => /catalog/graphics_design/?cat_type=list&type=organization&sort=rating,[sort_new_date_url] => /catalog/graphics_design/?show=new&sort=date,[sort_new_comments_url] => /catalog/graphics_design/?show=new&sort=comments,[sort_video_date_url] => /catalog/graphics_design/?show=video&sort=date,[sort_video_comments_url] => /catalog/graphics_design/?show=video&sort=comments,[curr_sort] => name),[poka] => 1,[html_header] => Графический дизайн,[url_oblako] => ?type=organization&cat_type=cloud,[count_goods] => 11),[handler] => ,[parseHTML] => ),[] => Array ([site_url] => http://designex.ru/templates/default/,[sitename] => Южный дизайн-портал,[title_delimiter] =>  | ,[base_url] => design/default/,[adm_url] => templates/default/tpl//,[site_path] => /,[POST] => Array (),[GET] => Array ([url] => catalog/graphics_design/,[type] => \\\'),[COOKIE] => Array (),[VARS] => ,[page_name] => Графический дизайн. Композиции, элементы, рисунки,[meta_description] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[meta_keywords] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[url] => ,[main_url] => /catalog/graphics_design/,[self_url] => catalog/graphics_design/,[self_url_wp] => catalog/graphics_design/,[self_url_wpp] => catalog/graphics_design/,[self_url_wd] => catalog/graphics_design/,[back_url_ref] => ,[all_url] => catalog/graphics_design/,[itsMainPage] => ,[last_year] => 2024,[user_agreement] => /agreement/,[adv_url] => /advertising/,[auth] => Array ([vis_city] => /l_cab/vis_city/,[cur_city] => ,[reg_url] => /reg/,[auth_url] => /auth/),[online_users] => Array ([auth] => 0,[guest] => 8),[path] => Главная >>   Каталог >>  Графический дизайн,[path_level] => Array,[menu_arr] => Array ([0] => Array ([id] => 1239,[key] => catalog,[name] => Каталог,[url] => /catalog/,[checked] => ,[active] => 1,[position] => 2,[itslast] => 1,[itsfirst] => ,[submenu] => ),[1] => Array ([id] => 1238,[key] => party,[name] => Участники,[url] => /party/,[checked] => ,[active] => ,[position] => 3,[itslast] => ,[itsfirst] => ,[submenu] => )),[build_sitemap] => /sitemap/,[build_faq] => /faq/,[is_catalog] => 1,[categories_type] => list,[url_list] => /catalog/?cat_type=list&type=organization,[url_cloud] => ?cat_type=cloud&type=organization,[links] => Array ([curr_type] => organization,[org_url] => /catalog/graphics_design/?type=organization&cat_type=list,[ind_url] => /catalog/graphics_design/?type=individuals&cat_type=list,[all_url] => /catalog/graphics_design/?cat_type=list&type=organization&goods=all,[sort_name_url] => /catalog/graphics_design/?cat_type=list&type=organization&sort=name,[sort_name_url_catalog] => /catalog/graphics_design/?cat_type=list&type=organization&sort=name,[sort_rating_url] => /catalog/graphics_design/?cat_type=list&type=organization&sort=rating,[sort_rating_url_catalog] => /catalog/graphics_design/?cat_type=list&type=organization&sort=rating,[sort_new_date_url] => /catalog/graphics_design/?show=new&sort=date,[sort_new_comments_url] => /catalog/graphics_design/?show=new&sort=comments,[sort_video_date_url] => /catalog/graphics_design/?show=video&sort=date,[sort_video_comments_url] => /catalog/graphics_design/?show=video&sort=comments,[curr_sort] => name),[poka] => 1,[html_header] => Графический дизайн,[url_oblako] => ?type=organization&cat_type=cloud,[count_goods] => 11),[] => ,[] => templates/default/tpl,[homeDir] => templates/default/tpl/,[] => design/default,[] => Array (),[] => SmartyExt Object ([template_dir] => /var/www/designex/data/www/designex.ru/templates/default/tpl,[compile_dir] => /var/www/designex/data/www/designex.ru/templates/default/tpl/compile,[config_dir] => /var/www/designex/data/www/designex.ru/templates/default/tpl/configs,[plugins_dir] => Array ([0] => plugins),[debugging] => ,[error_reporting] => ,[debug_tpl] => ,[debugging_ctrl] => URL,[compile_check] => 1,[force_compile] => ,[caching] => ,[cache_dir] => /var/www/designex/data/www/designex.ru/templates/default/tpl/cache,[cache_lifetime] => 3600,[cache_modified_check] => ,[php_handling] => 0,[security] => ,[secure_dir] => Array (),[security_settings] => Array ([PHP_HANDLING] => ,[IF_FUNCS] => Array ([0] => array,[1] => list,[2] => isset,[3] => empty,[4] => count,[5] => sizeof,[6] => in_array,[7] => is_array,[8] => true,[9] => false,[10] => null),[INCLUDE_ANY] => ,[PHP_TAGS] => ,[MODIFIER_FUNCS] => Array ([0] => count),[ALLOW_CONSTANTS] => ,[ALLOW_SUPER_GLOBALS] => 1),[trusted_dir] => Array (),[left_delimiter] => {,[right_delimiter] => },[request_vars_order] => EGPCS,[request_use_auto_globals] => 1,[compile_id] => ,[use_sub_dirs] => ,[default_modifiers] => Array (),[default_resource_type] => file,[cache_handler_func] => ,[autoload_filters] => Array (),[config_overwrite] => 1,[config_booleanize] => 1,[config_read_hidden] => ,[config_fix_newlines] => 1,[default_template_handler_func] => ,[compiler_file] => Smarty_Compiler.class.php,[compiler_class] => Smarty_Compiler,[config_class] => Config_File,[_tpl_vars] => Array ([SCRIPT_NAME] => /index.php,[app_name] => Manheim_KR),[_smarty_vars] => ,[_sections] => Array (),[_foreach] => Array (),[_tag_stack] => Array (),[_conf_obj] => ,[_config] => Array ([0] => Array ([vars] => Array (),[files] => Array ())),[_smarty_md5] => f8d698aea36fcbead2b9d5359ffca76f,[_version] => 2.6.25,[_inclusion_depth] => 0,[_compile_id] => ,[_smarty_debug_id] => SMARTY_DEBUG,[_smarty_debug_info] => Array (),[_cache_info] => Array (),[_file_perms] => 420,[_dir_perms] => 505,[_reg_objects] => Array (),[_plugins] => Array ([modifier] => Array (),[function] => Array (),[block] => Array (),[compiler] => Array (),[prefilter] => Array (),[postfilter] => Array (),[outputfilter] => Array (),[resource] => Array (),[insert] => Array ()),[_cache_serials] => Array (),[_cache_include] => ,[_cache_including] => ,[_supers] => Array ([get] => Array ([url] => catalog/graphics_design/,[type] => \'),[post] => Array (),[server] => Array ([REDIRECT_REDIRECT_UNIQUE_ID] => ZiNtib-4ut9-CxUUfLA@2AAAAAQ,[REDIRECT_REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins,[REDIRECT_REDIRECT_STATUS] => 200,[REDIRECT_UNIQUE_ID] => ZiNtib-4ut9-CxUUfLA@2AAAAAQ,[REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins,[REDIRECT_HANDLER] => application/x-httpd-php5,[REDIRECT_STATUS] => 200,[UNIQUE_ID] => ZiNtib-4ut9-CxUUfLA@2AAAAAQ,[PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins,[HTTP_HOST] => designex.ru,[HTTP_X_FORWARDED_PROTO] => http,[HTTP_X_FORWARDED_PORT] => 80,[HTTP_CONNECTION] => close,[HTTP_ACCEPT] => */*,[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,[SERVER_SIGNATURE] => ,[SERVER_SOFTWARE] => Apache/2.4.6 (CentOS) mpm-itk/2.4.7-04 OpenSSL/1.0.2k-fips PHP/5.3.29,[SERVER_NAME] => designex.ru,[SERVER_ADDR] => 127.0.0.1,[SERVER_PORT] => 80,[REMOTE_ADDR] => 3.137.174.216,[DOCUMENT_ROOT] => /var/www/designex/data/www/designex.ru,[REQUEST_SCHEME] => http,[CONTEXT_PREFIX] => /php-bin/,[CONTEXT_DOCUMENT_ROOT] => /var/www/php-bin-isp-php52/designex/,[SERVER_ADMIN] => webmaster@designex.ru,[SCRIPT_FILENAME] => /var/www/designex/data/www/designex.ru/index.php,[REMOTE_PORT] => 36842,[REDIRECT_QUERY_STRING] => url=catalog/graphics_design/&type=%27,[REDIRECT_URL] => /index.php,[GATEWAY_INTERFACE] => CGI/1.1,[SERVER_PROTOCOL] => HTTP/1.0,[REQUEST_METHOD] => GET,[QUERY_STRING] => url=catalog/graphics_design/&type=%27,[REQUEST_URI] => /catalog/graphics_design/?type=%27,[SCRIPT_NAME] => /index.php,[ORIG_SCRIPT_FILENAME] => /var/www/php-bin-isp-php52/designex/php,[ORIG_PATH_INFO] => /index.php,[ORIG_PATH_TRANSLATED] => /var/www/designex/data/www/designex.ru/index.php,[ORIG_SCRIPT_NAME] => /php-bin/php,[PHP_SELF] => /index.php,[REQUEST_TIME] => 1713597833),[session] => Array ([path] => /userfiles/),[request] => Array ([url] => catalog/graphics_design/,[type] => \'),[cookies] => Array (),[env] => Array ()))),[] => Typograph Object ([] => ,[] => ),[] => ,[] => 1252,[did] => ,[] => graphics_design,[] => 1239,[] => 43,[] => section_catalog,[] => ,[] => ,[] => main,[] => 1236,[] => ,[] => ,[] => ,[] => Array (),[] => Array ([url] => catalog/graphics_design/,[type] => \\\'),[] => Array ([auth] => 0,[guest] => 8),[] => 1713596033,[] => 8,[] => Array ([0] => 1252,[id] => 1252,[1] => 1239,[parent] => 1239,[2] => Графический дизайн,[name] => Графический дизайн,[3] => graphics_design,[key] => graphics_design,[4] => graphics_design,[url_key] => graphics_design,[5] => 43,[template] => 43,[6] => 1,[visible] => 1,[7] => 17,[sort] => 17,[8] => 2,[level] => 2,[9] => Графический дизайн. Композиции, элементы, рисунки,[meta_title] => Графический дизайн. Композиции, элементы, рисунки,[10] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[meta_keywords] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[11] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[meta_description] => графический дизайн, графический дизайн композиция, элементы графического дизайна, графический дизайн рисунки,[12] => 1296625646,[create_date] => 1296625646,[13] => 1322215730,[modify_date] => 1322215730,[14] => 61,[create_user] => 61,[15] => 2,[modify_user] => 2,[16] => 7,[site_id] => 7),[] => ,[] => 2,[] => 2,[] => 0,[] => ,[] => catalog/graphics_design/,[] => catalog/graphics_design/,[] => /,[] => ,[] => ,[] => ,[name] => Графический дизайн,[path] => ,[] => ,[] => ,[] => ,[] => ,[] => \\\',[] => 1,[] => 7,[options] => Array ([show_text] => 1,[show_path] => 1,[show_topic] => ,[show_innerPages] => ,[show_bot_menu] => ,[show_filter] => ,[show_auth_reg] => 1,[show_home_map_mail] => 1,[show_chosen] => ,[build_submenu] => ,[menu] => mainMenu,[check_folder] => ,[build_catalog] => 1,[show_menu_level_2] => 1,[show_reg] => 1,[get_online_users] => 1,[get_time_online] => 1,[get_all_users_now] => 1),[] => inside.tpl,[] => ,[] => ,[] => Array (),[] => Array (),[] => ,[] => ,[under_construct] => ,[root_url] => /catalog/graphics_design/,[currentPlugin] => section_catalog)) called at [/var/www/designex/data/www/designex.ru/includes/site.php(920) : eval()'d code:1]
#8  eval() called at [/var/www/designex/data/www/designex.ru/includes/site.php:920]
#9  Site->launchPlugin() called at [/var/www/designex/data/www/designex.ru/includes/site.php:141]
#10 Site->__construct() called at [/var/www/designex/data/www/designex.ru/index.php:13]