ВСЯ надежда на вас Уважаемые php кодеры и по совместительству умные люди :wink: Движок DLE 7.2 Ставлю модуль tags 4.0, вроде бы все Ок, но есть беда, при чистке хеша в самом модуле и после обновлении страницы сайта выбивает ошибку: MySQL Error! ------------------------ The Error returned was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND approve='1' AND date < '2008-10-04 04:34:25' LIMIT 5' at line 1 [sql]Error Number: 1064 SELECT id, title, DATE, category, alt_name, flag FROM dle_post WHERE MATCH (title, short_story, full_story, xfields, title) AGAINST ('Приобретение и оплата скрипта ') AND id != AND approve='1' AND DATE < '2008-10-04 04:34:25' LIMIT 5[/sql] Вот кусок кода откуда происходит запрос: PHP: $metatags['title'] = stripslashes($row['title']); $comments_num = $row['comm_num']; [b]include(ENGINE_DIR.'/modules/tags/tags.story.php');[/b] $news_find = array( [b]'{news-tags}' => $tags_links,[/b] '{comments-num}' => $comments_num, '{views}' => $row['news_read'], '{category}' => $my_cat, '{link-category}' => $my_cat_link, '{news-id}' => $row['id'], ); if (date(Ymd, $row['date']) == date(Ymd, $_TIME)) { $tpl->set('{date}', $lang['time_heute'].langdate(", H:i", $row['date'])); } elseif (date(Ymd, $row['date']) == date(Ymd, ($_TIME - 86400))) { $tpl->set('{date}', $lang['time_gestern'].langdate(", H:i", $row['date'])); } else { $tpl->set('{date}', langdate($config['timestamp_active'], $row['date'])); } if ($row['editdate']) $_DOCUMENT_DATE = $row['editdate']; else $_DOCUMENT_DATE = $row['date']; if ($row['view_edit'] AND $row['editdate']) { if (date(Ymd, $row['editdate']) == date(Ymd, $_TIME)) { $tpl->set('{edit-date}', $lang['time_heute'].langdate(", H:i", $row['editdate'])); } elseif (date(Ymd, $row['editdate']) == date(Ymd, ($_TIME - 86400))) { $tpl->set('{edit-date}', $lang['time_gestern'].langdate(", H:i", $row['editdate'])); } else { $tpl->set('{edit-date}', langdate($config['timestamp_active'], $row['editdate'])); } $tpl->set('{editor}', $row['editor']); $tpl->set('{edit-reason}', $row['reason']); if ($row['reason']) { $tpl->set('[edit-reason]', ""); $tpl->set('[/edit-reason]', ""); } else $tpl->set_block("'\\[edit-reason\\](.*?)\\[/edit-reason\\]'si",""); $tpl->set('[edit-date]', ""); $tpl->set('[/edit-date]', ""); } else { $tpl->set('{edit-date}', ""); $tpl->set('{editor}', ""); $tpl->set('{edit-reason}', ""); $tpl->set_block("'\\[edit-date\\](.*?)\\[/edit-date\\]'si",""); $tpl->set_block("'\\[edit-reason\\](.*?)\\[/edit-reason\\]'si",""); } $tpl->set('', $news_find); if ($cat_info[$row['category']]['icon']) { $tpl->set('{category-icon}', $cat_info[$row['category']]['icon']); } else { $tpl->set('{category-icon}', "{THEME}/dleimages/no_icon.gif"); } // Ссылки на версию для печати $tpl->set('[print-link]',"<a href=\"".$print_link."\">"); $tpl->set('[/print-link]',"</a>"); // Ссылки на версию для печати if ($row['allow_rate']) $tpl->set('{rating}',ShowRating ($row['id'], $row['rating'], $row['vote_num'], $user_group[$member_id['user_group']]['allow_rating'])); else $tpl->set('{rating}',""); if ($config['ajax']) { $go_page = "onclick=\"DlePage(\'subaction=userinfo&user=".urlencode($row['autor'])."\'); return false;\" "; $news_page = "onclick=\"DlePage(\'subaction=allnews&user=".urlencode($row['autor'])."\'); return false;\" "; } else { $go_page = ""; $news_page = "";} if ($config['allow_alt_url'] == "yes") { $go_page .= "href=\"".$config['http_home_url']."user/".urlencode($row['autor'])."/\""; $news_page .= "href=\"".$config['http_home_url']."user/".urlencode($row['autor'])."/news/\""; } else { $go_page .= "href=\"$PHP_SELF?subaction=userinfo&user=".urlencode($row['autor'])."\""; $news_page .= "href=\"$PHP_SELF?subaction=allnews&user=".urlencode($row['autor'])."\""; } $go_page = "onClick=\"return dropdownmenu(this, event, UserNewsMenu('".htmlspecialchars($go_page)."', '".htmlspecialchars($news_page)."','".urlencode($row['autor'])."', '".$member_id['user_group']."'), '170px')\" onMouseout=\"delayhidemenu()\""; if ($config['allow_alt_url'] == "yes") $tpl->set('{author}', "<a {$go_page} href=\"".$config['http_home_url']."user/".urlencode($row['autor'])."/\">".$row['autor']."</a>"); else $tpl->set('{author}', "<a {$go_page} href=\"$PHP_SELF?subaction=userinfo&user=".urlencode($row['autor'])."\">".$row['autor']."</a>"); if ( strpos( $_SERVER['REQUEST_URI'], "pages.php" ) !== false) { $_SESSION['referrer'] = $full_link; } else $_SESSION['referrer'] = $_SERVER['REQUEST_URI']; $tpl->set('[full-link]',"<a href=\"".$full_link."\">"); $tpl->set('[/full-link]',"</a>"); $tpl->set('{full-link}', $full_link); if ($row['allow_comm']) { $tpl->set('[com-link]',"<a href=\"".$full_link."\">"); $tpl->set('[/com-link]',"</a>"); } else $tpl->set_block("'\\[com-link\\](.*?)\\[/com-link\\]'si",""); if (!$row['approve'] AND ($member_id['name'] == $row['autor'] AND !$user_group[$member_id['user_group']]['allow_all_edit'])){ $tpl->set('[edit]',"<a href=\"".$config['http_home_url']."index.php?do=addnews&id=".$row['id']."\" >"); $tpl->set('[/edit]',"</a>"); if ($config['allow_quick_wysiwyg']) $allow_comments_ajax = true; } elseif ($is_logged AND (($member_id['name'] == $row['autor'] AND $user_group[$member_id['user_group']]['allow_edit']) OR $user_group[$member_id['user_group']]['allow_all_edit'])){ $tpl->set('[edit]',"<a onClick=\"return dropdownmenu(this, event, MenuNewsBuild('".$row['id']."', 'full'), '170px')\" href=\"".$config['http_home_url'].$config['admin_path']."?mod=editnews&action=editnews&id=".$row['id']."\" target = \"_blank\" >"); $tpl->set('[/edit]',"</a>"); if ($config['allow_quick_wysiwyg']) $allow_comments_ajax = true; } else $tpl->set_block("'\\[edit\\](.*?)\\[/edit\\]'si",""); if ($config['related_news']) { if ($config['allow_cache'] != "yes") { $config['allow_cache'] = "yes"; $revert_cache = true; } else $revert_cache = false; $buffer = dle_cache("related", $row['id']); if ($buffer === FALSE) { if (strlen($row['full_story']) < strlen($row['short_story'])) $body = $row['short_story']; else $body = $row['full_story']; $body = $db->safesql(strip_tags(stripslashes($metatags['title']." ".$body))); $config['related_number'] = intval($config['related_number']); if ($config['related_number'] < 1) $config['related_number'] = 5; [u]$db->query ("SELECT id, title, date, category, alt_name, flag FROM " . PREFIX . "_post WHERE MATCH (title, short_story, full_story, xfields, title) AGAINST ('$body') AND id != ".$row['id']." AND approve='1'".$where_date." LIMIT ".$config['related_number']); [/u] Подключение модуля теги=> подключаеммый Файл::( в коде он выделен) include(ENGINE_DIR.'/modules/tags/tags.story.php'); Вот КОД подключаемого файла=>tags.story.php' PHP: <?php if(!defined('DATALIFEENGINE')) { die("Hacking attempt!"); } check_xss (); include_once (ENGINE_DIR.'/data/tagconfig.php'); require_once ENGINE_DIR.'/modules/tags/functions.php'; if (!$row['tags']) { $tags_links = "---"; } else { $id = $row['id']; $tag_list[$id] = explode (', ', $row['tags']); foreach ($tag_list[$id] as $key => $value) { $urlt = tagencode($value); $tag_link[$id][$key] = "<a href=\"".$urlt."\" title=\"Обзор по {$value}\">{$value}</a>"; } $tags_links = stripslashes(implode (', ', $tag_link[$id])); } ?> Смысл всего выше описаного в том что еси НЕ подключать файл tags.story.php НИ КАКОЙ ошибки Мускул НЕТ :shock: Знаю точно что трабла в tags.story.php( код его выше приведен) Уважаемые помогите решить пробелемму, я уже от безисходности исчу 5-й угол...