Thread: Column count doesn't match value count at row 1

Going from 3.1 to 3.2

While running the queries enbloc (all files overwritten), MySql stalls on:

INSERT INTO `ProfilesDesc`
VALUES ( 108, 'guestbook', '_guestbook', '', '\'Enable\',\'Disable\',\'Suspend\'', 'e', '31.45', 'user,memb,adm', '', '', '', '', '', 1, '0', '', '', 'none', 0, 0, '', '0', '', '', '', '', '', '', '' )


MySQL said:

#1136 - Column count doesn't match value count at row 1


Anyone got an idea why I am getting it? I see the GUESTBOOK tabe has been created fine by the previous query.

Thanks.

This is just why I detest upgrading this application. Something always goes wrong - and then it screws up your site. I'm just going to revert to my working version until I know why its doing this.

Now I can't go back it seems. Something is wrong with the sql file i saved via mysqldump.

bash-2.05b$ mysql -uuser_****** -ppassword database_**** < late2.sql
ERROR 1064 at line 220: 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 'desc varchar(255) NOT NULL default '',
Type enum('digit','tex
----------------------------------------

The file upload cuts off right there, leaving me with 9 out of 47 tables loaded. An otherwise fine system is now totally crippled just because I tried to upgrade. 1500 plus users. So many hours. Where do I even begin to fix this now?

Any help will be appreciated.

Line 1064 is emboldened. Anyone has an idea what's wrong please?


DROP TABLE IF EXISTS polls_a;
CREATE TABLE polls_a (
IDanswer int(10) unsigned NOT NULL auto_increment,
ID int(11) NOT NULL default '0',
Answer varchar(255) NOT NULL default '',
Votes int(10) unsigned NOT NULL default '0',
PRIMARY KEY (IDanswer),
KEY ID (ID)
) TYPE=MyISAM;
--------------------------------------

SAME ERROR VIA PHPMYADMIN:

#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 'desc varchar(255) NOT NULL default '',
Type enum('digit','tex

Thanks.

I'm obviously talking to myself here.

I have been in conversation with my hosting service. It appears the DB is corrupted. 1500 members. I have backups for several weeks, but will now have to figure out when the corruption started. I have never been in there to tamper with the db as I don't know enough to do that. Only the Aewebworks guys have touched it in the past when the usual upgrade screw up happened. Not saying they did it though...

Trying now to find a backup file that works. Host says their tables may be written for older version of MySQL. They run MySQL 4.0.22-24.

Fingers crossed. ArticleLive, VB 307, Vcard, Photopost, etc. No problem with them. It is always Aedating.

Agh, I'm done griping.

Saga continues. Host managed to restore a backup from over a week ago. So I lost just the 50something new members from the last week.

So I backed up again and tried to load it into a test setup of the app/DB and it fails again. This is the backup my host loaded successfully - how, I have no idea. It won't load via SSH or big dump.

That means I can't do a test upgrade to 3.2 as I'd hoped.

Well, its 2.32am here. Tired of talking to myself. I will remain at 3.1 0002 until I can figure out how to go to 3.2. Good night world.

Sola,

I am sorry I am just now reading your post but I just joined the forum yesterday...

The issue is with the SQL statement and the way you did the mysqldump. See that field named 'desc'? Well, 'desc' is a MySQL function so when you do the mysqldump, you need to do it with the -Q option to quote table and field names.

That should fix it for you...

Good luck!

Thanks Rhet. The instructions below helped:

Backing up your database from the command line