Forumlar / Cotonti / Support / Similar pages sql error

2010-03-24 04:36
Fatal error : SQL error : 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 'LIMIT' at line 1

<?php
/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/similar/similar.php
Version=0.99
Updated=18-jan-2007
Type=Plugin
Author=Raveex
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=similar
Part=main
File=similar.main
Hooks=page.tags
Tags=
Order=1
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

if (!defined('SED_CODE')) { die('Wrong URL.'); }

$relev = $cfg['plugin']['similar']['relev'];
$limit = $cfg['plugin']['similar']['max_sim'];

$sql_sim = sed_sql_query("SELECT p.*, u.user_name FROM $db_pages AS p LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid WHERE (p.page_state='0' OR p.page_state='2') AND p.page_id != $pag[page_id]  AND MATCH (page_title) AGAINST ('$pag[page_title]')>$relev LIMIT $limit");

$i=1;

$plugin_out = "<table width=\"100%\" class=\"tbl-border\">\n";

$plugin_out .= "<tr><td width=\"8\" class='tbl2' align=center>#</td><td class='tbl2'>Benzer konular</td><td class='tbl2'>Katagori</td><td align=center class='tbl2'>İzlenim</td><td align=center class='tbl2'>Tarih</td></tr>\n";

if (sed_sql_numrows($sql_sim)==0)
    {
           
    }
while ($row = sed_sql_fetcharray($sql_sim))
       {
               $row['page_pageurl'] = (empty($row['page_title'])) ? "page.php?id=".$row['page_id'] : "page.php?id=".$row['page_id'];
               $plugin_out .= "<tr><td>$i</td><td><a href=\"$row[page_pageurl]\">$row[page_title]</a><td>".sed_build_catpath($row['page_cat'], "<a href=\"list.php?c=%1\$s\">%2\$s</a>")."</td><td align=center>$row[page_count]</td><td align=center>".date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."</td></tr>\n";
               $i++;
       }
$plugin_out .= "</table>";

$t->assign("SIMILAR_PAGES", $plugin_out);


?>

<?php
/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/similar/similar.query.php
Version=0.99
Updated=18-jan-2007
Type=Plugin
Author=Raveex
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=similar
Part=query
File=similar.query
Hooks=standalone
Tags=
Order=1
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

$sql_tmp = sed_sql_query("SELECT config_value FROM $db_config WHERE config_name = 'fulltext' LIMIT 1");

if (sed_sql_numrows($sql_tmp)>0)
    {
            echo "Âû óæå àêòèâèğîâàëè ïëàãèí!";
    }
else
    {
            $sql_tmp = sed_sql_query("ALTER TABLE $db_pages ADD FULLTEXT(page_title)");
            $sql_tmp = sed_sql_query("INSERT INTO $db_config (config_owner, config_cat, config_order, config_name, config_type, config_value, config_default, config_text) VALUES ('Raveex', 'Raveex', '1', 'fulltext', '1', '1', '1', 'Raveex')");
    }
?>

helpe me

Added 16 hours 1 minute later:

Do not answer? Case of little importance