I can't vote in the polls after I updated my AJAX MOD!!

[mariokaz]

Hi oxpus,

Well I updated my AJAX 1.0.4 to the lastest version 1.0.8 , but now I can't vote in the polls of my forum , I am getting this error: ¦4

Could not obtain vote data for this topic

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 ' vd.vote_max AND vr.vote_option_id = 4 GROUP BY vd.vote_id' at line 4

SELECT vd.vote_id FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 2893 AND vr.vote_id = vd.vote_id, vd.vote_max AND vr.vote_option_id = 4 GROUP BY vd.vote_id

Line : 765
File : posting.php

Error Message saved in Database

I don't know what is happen, so I put here all the files that I edited for the update.

Please help me my friend. ¢¦

[oxpus]

Here the fixed posting.php back:

[mariokaz]

Thanx my friend, I updated that file.

But now I am getting this error:

Could not insert user_id for poll

DEBUG MODE

INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip, vote_option_id, vote_cast) VALUES (33, 372, 'c9878c3c', 4)

Line : 851
File : posting.php

Error Message saved in Database

¢¦

[oxpus]

Find

Code: Alles auswählen

				$sql = "INSERT INTO " . VOTE_USERS_TABLE . " (vote_id, vote_user_id, vote_user_ip, vote_option_id, vote_cast) 
					VALUES ($vote_id, " . $userdata['user_id'] . ", '$user_ip', $vote_option_id)";

and replace with

Code: Alles auswählen

				$sql = "INSERT INTO " . VOTE_USERS_TABLE . " (vote_id, vote_user_id, vote_user_ip, vote_option_id) 
					VALUES ($vote_id, " . $userdata['user_id'] . ", '$user_ip', $vote_option_id)";

And for next error messages please use the Quote or Code BBCode tag. Thanks.

[mariokaz]

[quote="oxpus";p="63051"]And for next error messages please use the Quote or Code BBCode tag. Thanks.[/quote]

Yes sir!

And also thanx a lot, now I can vote!!!!

[oxpus]

Fine.

[mariokaz]

My friend, which one is the Mod that you use here for the polls

Thanx

[oxpus]

This one: http://www.oxpus.de/downloads.php?view=detail&id=136

[mariokaz]

Thank you Oxpus,

I asked you that because I have another similar Mod "Vote Manager", it have a lot of functions and options, but it is not working well in my forum and there aren't support of the author.

So I will try to uninstall it and install this one, that looks much better.

Ufff a lot of work but I want something that works fine in my forum.