mysql error after attempting to edit posts.

[Scope]

Database error in vBulletin 2.3.4:

Invalid SQL: UPDATE post SET title='',pagetext='there\'s still a little problem with editing po asst afterwards.',allowsmilie='1',showsignature='0',ico nid='0',secret=' ',secret2=' ', WHERE postid='8'
mysql 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 'WHERE postid='8'' at line 1

mysql error number: 1064

Date: Tuesday 24th of February 2004 11:48:59 PM
Script: http://www.urbanwritings.com/forums/forums/editpost.php
Referer: http://www.urbanwritings.com/forums/...tpost&postid=8

[Scope]

up and at em.

[Zachery]

Originally Posted by Scope

up and at em.

wait at least 24 hours, if i remember correctly that error is a memor problem, try reparing and optimzing your tables.

[filburt1]

You have an extra trailing comma before the WHERE clause.

[Scope]

where do i fix it?

[Scope]

$DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',p agetext='".addslashes($message )."',allowsmilie='$allowsmilie',showsignature='$si gnature',iconid='$iconid',secr et='".addslashes($secret)."',secret2='$secret2',$e ditedbysql$attachmentsql WHERE postid='$postid'");

[Scope]

fixed, thanks for the help filburt