phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

I can not vote!


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Tue Sep 01, 2009 1:14 pm 
Post subject: I can not vote!

When I try to vote, I get this:

Code:
Could not obtain user 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 'AND vote_user_id = 3' at line 4

SELECT * FROM phpbb_vote_voters WHERE vote_id = AND vote_user_id = 3

Line : 558
File : posting.php

I am using Advanced Vote Manager 1.0.2. It was working fine, I was voting. I did not install too much MODs after it, 2 or 3. Avatar on Index and... I don;t know... but not something that could have, or should have afected this. I don't understand!
This is posting.php: http://pastebin.com/m4a29035

I don't get it. icon_sad.gif

_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 551
Location: North West UK


flag
PostPosted: Tue Sep 01, 2009 1:47 pm 
Post subject: Re: I can not vote!

You say not too many mods. How many incompatible mods or wrongly installed mods does it take to cause a problem?
The answer is 1.
If you made backups when you installed the two mods then restore the board to its state before the last mod and test the voting.
If it still does not work then restore it to the point before the previous mod.
If it still does not work then the problem likely lies with your addition of the Vote manager.

Sometimes problems are not evident at the time. I installed the "Card hack" on my board and my son added it to his. There were problems with it on mine but not on his. That indicates an incompatibility with some other mod on mine. I just left in place that which allowed a user to report a post. A user on my son's site then (2 years later) reported that the option to reorder posts showed an error in a file called card.php.
I checked on my own site and sure enough the error was there as well but no one had either reported it or tried to re order the posts.

The more mods you add the greater the chance of some incompatibilities occurring. I enjoy adding mods but am forcing myself to add no more.


Jim.

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 663
Location: Texas


flag
PostPosted: Tue Sep 01, 2009 8:36 pm 
Post subject: Re: I can not vote!

One of the variables is not working, as it's missing from the SQL:
Code:
SELECT * FROM phpbb_vote_voters WHERE vote_id = AND vote_user_id = 3

Check anything related to vote_id and make sure all of your edits are correct, that nothing is spelled wrong.

_________________
phpBBDoctor Blog
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Wed Sep 30, 2009 12:12 pm 
Post subject: Re: I can not vote!

Well, this is the SQL querries that Advance Vote Management required:
Code:
ALTER TABLE phpbb_vote_desc ADD vote_max INT( 3 ) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_vote_desc ADD vote_voted INT( 7 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_vote_desc ADD vote_hide TINYINT( 1 ) DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_vote_desc ADD vote_undo TINYINT ( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_vote_voters ADD vote_option_id TINYINT( 4 ) DEFAULT '-1' NOT NULL;

They exist in the phpMyAdmin tables. icon_confused.gif

LATER EDIT: Where is the SQL manual I have heard so much about? icon_rolleyes.gif

_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 663
Location: Texas


flag
PostPosted: Wed Sep 30, 2009 2:55 pm 
Post subject: Re: I can not vote!

It's not missing from the table definition, it's not being set properly in the php code. There should be something here:
Quote:
SELECT * FROM phpbb_vote_voters WHERE vote_id = XX AND vote_user_id = 3

_________________
phpBBDoctor Blog
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0272 seconds using 15 queries. (SQL 0.0023 Parse 0.0009 Other 0.0240)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo