CSV Import error/limit

  • Resolved greatghu

    (@greatghu)


    2 years, 8 months ago

    Hi there

    I’m trying to import a CSV that has 9180 entries. The file is 707k in size. For some reason, the import always caps at 811 entries, with the error: “Database Error: WordPress database error: Could not perform query because it contains invalid data.”.

    I tried divvying up the file into separate, smaller files, but after the initial 811 entries, the following upload attempt would be capped at “1 entry uploaded”, which really means none (no change to list of participants).

    Not sure why and would love some ideas of how to fix this. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter greatghu

    (@greatghu)

    2 years, 8 months ago

    Nevermind, I figured it out! There was a – in the the 812th entry that it didn’t like. Need to remember those special characters… hope this info can help someone else!

    Plugin Author xnau webdesign

    (@xnau)

    2 years, 8 months ago

    Yes, the error message tries to be helpful, but it’s hard to be more specific than that, given the range of possibilities.

    Thanks for sharing what worked.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘CSV Import error/limit’ is closed to new replies.