Project / Support Center
Welcome, Guest. Please login or register. June 03, 2023, 10:34: PM
Home Help Search Login Register
D-Web Web Site Creator D - Web Web Site Creator On-line HTML Editor No Programming knowledge required. Web Global Net PayPal-Cart Shopping Cart System PayPal - Kart Shopping Cart System for E-Commerce over the internet, that's easy to use. Web Global Net Newsletter Manager Newsletter Manager On-line Newsletter Creator with Email Subscriber Management.
Ring Central Discount
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: Incorrect Column Count for CVS import 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: Incorrect Column Count for CVS import  (Read 8577 times)
admin
Guest
« on: July 06, 2008, 01:12: PM »

Something to look for when getting an incorrect sql column count error during import.

Take a look at the data you're trying to import if you are getting this error chances are somewhere in your data you will find quotes ("") surrounding text data assuming you have chosen the option of field data enclosed in "" (for phpmyadmin) .

This will cause the sql execution to think that there is a field and throw off the column count you have set up in your cvs data - remove the "" around any text and you should be ok

This can also be caused by not including a record_id # column (assuming you have a DB column with autonomies generated, unique ID) in this case when you do the import create a column for the ID # in the excel spreadsheet and if the ID is created automatically then just copy NULL to all records for the ID column.
« Last Edit: March 10, 2020, 05:45: PM by admin » Report to moderator   Logged
Pages: [1] Go Up Send this topic Print 
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: Incorrect Column Count for CVS import « previous next »
Jump to:  


Login with username, password and session length
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!