MyBB Community Forums

Full Version: mybbpollvotes SQL Problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I've been getting these errors lately, and it won't stop. Not sure what's going on, but when I attempt to vote on a poll, I get the first error:
Quote:Type: 20
File: (Line no. 0)
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 '6029c888'')' at line 3
This error persists:
Quote:Type: 20
File: (Line no. 0)
SQL Error: 1054 - Unknown column 'ipaddress' in 'where clause'
do you have any poll related plugins ?
No poll-related plugins. I found out this could be fixed by adding "Ipaddress" column to SQL table. No reported errors since then.
so have you already added the column ?
Quote:ipaddress varbinary(16) NOT NULL default ''
Yes, that column was added. I am not sure why it magically disappeared from my table, but I didn't install any plugin at that time.
'ipaddress' column is not there in 'pollvotes' table by default.

[Image: Untitled_1.jpg]

not even in query of polls.php (line no. 1037)

		".TABLE_PREFIX."pollvotes (pid,uid,voteoption,dateline)
		VALUES $votesql
^ it is added in MyBB 1.8.15 !
But the table is not altered through upgrade.php?
I might be missing something ....
^ please see upgrade42.php ..