Forum Moderators: open

Message Too Old, No Replies

Can't Import into MySql table, Invalid Column Error

MySql, error, invalid column specified

         

Dezblanco

3:21 pm on Oct 3, 2009 (gmt 0)

10+ Year Member



Through phpmyadmin, I'm trying to import data from an excel CSV file.

I keep getting this error:

Invalid column (parent_id;catname;alias;catdescription;meta_keywords;meta_description;image;published;ordering) specified!

These column names come directly from the table in the data base, so I don't have clue what is wrong.

The key column has an auto increment on it, and somewhere I read that may be a problem. Much of this is over my head. I have done good just getting imports right in the past, but for some reason it's not working today.

I tried importing leaving the key column out, and I still get this error. Any ideas?

rocknbil

12:47 am on Oct 4, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The error says "invalid column ([fields])", right? Is it possible for some reason it's not splitting the column names on the semicolons? Maybe set a different delimiter, or has it not been set?

Seems like if it were just one column, it would say "invalid column (column name) specified" but it's showing the whole list.