Author Topic: Can't import more than 1264 rows from CSV  (Read 369 times)

0 Members and 1 Guest are viewing this topic.

Offline markvaughn2006Topic starter

  • Enthusiast
  • Posts: 105
    • View Profile
Can't import more than 1264 rows from CSV
« on: February 16, 2010, 03:57:17 PM »
For some reason, no matter what I do I can only upload 1264 rows from a CSV file, keep getting Invalid field count in CSV input on line 1265 error. The csv file is 128 kb and has 2390 rows. It's not a problem with row 1265 because I've tried deleting that row, replacing it with another row, etc... the table structure is UTF8, sym is the index

sym     varchar(15)     utf8_general_ci
name    varchar(100)    utf8_general_ci
ppschange    varchar(25)    utf8_general_ci
pps    varchar(25)    utf8_general_ci       
bid    varchar(25)    utf8_general_ci       
ask    varchar(25)    utf8_general_ci       
volume    int(25)          No          
trades    int(25)          No          
10dayvol    int(25)          No

any idea what could be causing this??

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,443
  • Gender: Male
    • View Profile
Re: Can't import more than 1264 rows from CSV
« Reply #1 on: February 23, 2010, 12:48:48 PM »
Sounds like parsing error.
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.