Page 1 of 1

Problem with deleting poll.

Posted: Tue Mar 09, 2004 2:25 pm
by T-Keith
URL: lesabret.com/phpBB
Template(s) used: ?
Any and all MODs: none
Do you use a port of phpBB: no
Version of phpBB: 2.0.6
Version of PHP: 4
Which database server and version: mySQL
Host: Whizhost.com
Did someone install this for you/who: no
Is this an upgrade/from what to what: 1.4
Is this a conversion/from what to what: no
Have you searched for your problem: yes
If so, what terms did you try: missing posts, ect.
State the nature of your problem:

I got this error when deleting a poll:



SQL Error : 1064 You have an error in your SQL syntax near '' at line 2

DELETE FROM phpbb_vote_results WHERE vote_id =

Line : 544
File : /usr/local/psa/home/vhosts/lesabret.com/httpdocs/phpBB/includes/functions_post.php


On another note, the polls don't get pruned with the rest of the topics. I know this is probably because the user has chosen a never ending poll or a really long one. But how do I stop this?

thanks,
-T

Posted: Tue Mar 09, 2004 5:38 pm
by zeroK
What do your includes/functions_posts.php's lines 540 and 541 look like?

Posted: Tue Mar 09, 2004 7:49 pm
by T-Keith
I did find the answer to my second question:

http://www.phpbb.com/phpBB/viewtopic.ph ... poll+prune

Thanks for the help zeroK, I'll check it when I get home tonight.

-T

Posted: Tue Mar 09, 2004 11:20 pm
by wtfdit74
I am having exactly the same problem.....

Posted: Wed Mar 10, 2004 3:05 am
by cr95gst
Yep, same problem here as well.

Posted: Wed Mar 10, 2004 9:14 am
by Vampy
I'm getting exactly the smae error as well. I dunno if it's due to patching it to 2.0.6d. In any case this is the offending line in the file:

Code: Select all

$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);
		}
Anyone can advise on this?