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?
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
PHP Code:
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
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?