MyBB Community Forums

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)
Message
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)
Message
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.



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

	$db->write_query("
		INSERT INTO
		".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 ..