mySQL error: 1136
Column count doesn't match value count at row 1
Query: INSERT INTO mybb_pollvotes VALUES (NULL,'5','1','1','1143580111')
I just created a poll and the above came up when I went to vote.
umm have u recently installed some kind of mods that affects this part of the system?
i'm not sure i didn;t have time to check 1st by having a new poll.php uploaded to ur server.
later on if that didn't help we will need to check your database
regards
I haven't uploaded any new mods recently. Too much HW. I tried reuploading the polls.php file and no luck. Could you please walk me through what I'm supposed to be looking for in the DB?
zaher1988 Wrote:we will have to repair your table
so backup you table in case it was empty then just go ahead and drop it
then execute this sql
CREATE TABLE mybb_pollvotes (
vid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
pid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' ,
uid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
voteoption SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
dateline bigint(30) NOT NULL DEFAULT '0',
PRIMARY KEY ( vid )
) TYPE = MYISAM ;
regards
How do I backup just a table? Thanks!
in the phpmyadmin. select the database.
then in the right side frame, look up, you see export.
from there, you can see a box that included all the tables you have, select the one you want, and perform the rest operations.
*make sure to click on the database 1st
regards
Quote:mySQL error: 1054
Unknown column 'pollvotes_cash' in 'field list'
Query: UPDATE mybb_pollvotes SET pollvotes_cash = 1.00 WHERE pid = '5' AND uid = '1'
It's a problem with your cash mod probably. Now you don't have the pollvotes_cash column that probably came with the cash mod?
I didn't see it. If I deactivated the Cash Mod and reactivated it, would that create the column?