Technote Details :: I get a developer error when importing CSV data

When using a CSV Import page to load data from a CSV file into a database, although the file format is correct, I get a developer error message saying:

Failed checking unique key SQL QUERY (CSV_IMPORT_ERROR)

This happens because one or more of the table columns into which data should be imported uses a reserved keyword for name.

Modify the table column name that causes problems to a different value. For a list of the reserved keywords of your database server, consult its user manual.

Login to add a new note