[gigafare]

Problem: A syntax error occurs when creating a page where the link is not shown in the menu. It's an MySQL syntax error so it should be here somewhere.

Error: Error In Execution
MYSQL Said: DB Error: syntax error

AddPage.php

PHP Code:

<?php
$no_need_to_display=0;
if( isset($_POST["submit"]) )
{
    if( is_array($_POST) )
    {
        while( list($k, $v) = each($_POST) )
        {
            $$k=$v;
        }
        @reset($_POST);
    }
    if( empty($name)  )
    {
        $error_messages[]=$smarty->get_config_vars('pagenamemiss');
    }
    if( empty($title)  )
    {
        $error_messages[]=$smarty->get_config_vars('titlemiss');
    }

    if( empty($content)  )
    {
        $error_messages[]=$smarty->get_config_vars('bodytextmiss');
    }

    if( count($error_messages) == 0 )
    {
            $now   = time();
            $query= "insert into ".$prefix."_pages (name,title,content,priv,parentid,view) values
            ('$name','$title','$content',$priv,$parentid,$view)";
            $res = $db->query($query);
            if (DB::isError($res) )
            {
                $error_messages[]="Error In Execution<br>MYSQL Said: ".$res->getMessage() ;
                $smarty->assign('error_messages', $error_messages);
                $smarty->assign('width', "50%");
                $smarty->display("errors_table.tpl");
            }
            else
            {
                $message_title = $error_messages[]=$smarty->get_config_vars('success');
                $messages[] = $error_messages[]=$smarty->get_config_vars('opsuccess');        
                $smarty->assign('message_title', $message_title);
                $smarty->assign('messages', $messages);
                $smarty->assign('width', "50%");
                $smarty->display("admin_messages.tpl");
                $no_need_to_display=1;
            }
    }
    else
    {
        $smarty->assign('error_messages', $error_messages);
        $smarty->assign('width', "50%");
        $smarty->display("errors_table.tpl");
    }
}

if($no_need_to_display==0)
{
$query= "SELECT * FROM ".$prefix."_pages WHERE parentid = 0";
$pages = $db->getAll($query);
$smarty->assign('pages', $pages);            
$smarty->display("addpage.tpl");
}
else
{
$smarty->display("default.tpl");
}
?>

AddPage.tpl (snippet)

<tr>
<td align="right">
<input type="checkbox" name="view" value="1" {if 1 eq $smarty.request.view|default:$cat.view}checked="checked"{/if} />
</td>
<td align="left">
Link tonen in het menu
</td>
</tr>

SQL

CREATE TABLE be_pages ( 
ID bigint(20) unsigned NOT NULL auto_increment,
parentid bigint(20) unsigned NOT NULL ,
name varchar(255) NOT NULL ,
title varchar(255) NOT NULL ,
content text NOT NULL ,
views bigint(20) unsigned NOT NULL ,
priv smallint(2) unsigned NOT NULL ,
view tinyint(1) unsigned NOT NULL ,
sortorder int(11) unsigned NOT NULL ,
PRIMARY KEY (ID)
);