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

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

Posted: Tue Jun 08, 2004 10:03 pm

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);


                }