语法错误...找不到它

There is an error in the SQL syntax below, supposedly on the last line (closing: "));") according to the error thrown. I can't see what's wrong. Anyone here spot it?

根据抛出的错误,下面的SQL语法中存在错误,据说在最后一行(结束:“));”)。我看不出有什么问题。这里有人发现它吗?

No other errors thrown. Just the syntax error. However, it states "...the right syntax to use near ''..." but references line 244 which is the closing of execute.

没有抛出其他错误。只是语法错误。但是,它指出“...在''...附近使用正确的语法”,但引用第244行,它是执行的结束。

$save = $database->prepare('INSERT INTO checklists VALUES(:id, :name, :user, :agent, :status, :date_created, :date_submitted, :last_updated, :technique, :machine, :ink, :finish, :item, :thickness, :rolls, :sheets, :deformation, :deformation_details, :surface, :surface_details, :process, :process_details, :quality, :quality_details, :drying, :drying_details, :finishing, :finishing_details, :reason, :how, :uid');
$save->execute(array(
    ':id' => ' ',
    ':name' => $name,
    ':user' => $printer,
    ':agent' => $agent,
    ':status' => '0',
    ':date_created' => $stamp,
    ':date_submitted' => $sub,
    ':last_updated' => $stamp,
    ':technique' => '',
    ':machine' => '',
    ':ink' => '',
    ':finish' => '',
    ':item' => '',
    ':thickness' => '',
    ':rolls' => '',
    ':sheets' => '',
    ':deformation' => '',
    ':deformation_details' => '',
    ':surface' => '',
    ':surface_details' => '',
    ':process' => '',
    ':process_details' => '',
    ':quality' => '',
    ':quality_details' => '',
    ':drying' => '',
    ':drying_details' => '',
    ':finishing' => '',
    ':finishing_details' => '',
    ':reason' => '',
    ':how' => '',
    ':uid' => $uid
));

1 个解决方案

#1

There is a ) missing ad and of your statement:

有a)缺少广告和您的陈述:

... :reason, :how, :uid)');