*sigh* Ok, I have a poll deleting error in the forums...

NuclearX · New Member Joined: May 21, 2004 Posts: 21

Sorry to come up with yet another error. Crying or Very sad

Anyways. I have this error when I attempted to delete another user's poll (it had already been replied to, btw):

Code:

DEBUG MODE

SQL Error : 1064 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 '' at line 2

DELETE FROM nuke_bbvote_results WHERE vote_id =

Line : 583
File : /home/nuclearx/public_html/includes/functions_post.php

Then when I go back to look at the post, I don't see the poll (as if it had been deleted), but the [Poll] text is still on the thread title.

Any ideas? Evil or Very Mad

NuclearX · New Member Joined: May 21, 2004 Posts: 21

PS, the functions_post.php lines are here:

Code:

$sql = "DELETE FROM " . VOTE_DESC_TABLE . "
WHERE topic_id = $topic_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in deleting poll', '', __LINE__, __FILE__, $sql);
}

$sql = "DELETE FROM " . VOTE_RESULTS_TABLE . "
WHERE vote_id = $poll_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in deleting poll', '', __LINE__, __FILE__, $sql);
}

$sql = "DELETE FROM " . VOTE_USERS_TABLE . "
WHERE vote_id = $poll_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in deleting poll', '', __LINE__, __FILE__, $sql);
}