Just realized I was mistaken on part of this. I should have assumed all fields were given, even auto-incremented fields. This file has the appropriate fix, along with making the global $message variable available so that it doesn't hang on errors.
It is risky to make assumptions about the columns when the csv does not contain data for all columns. However an appropriate error message should be displayed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Cannot reproduce, can you attach a sample export of your table's structure and the CSV file that does not import?
I've run into the same problem. I will attach all the files needed to reproduce this issue.
This is the import file that should not work because there are not enough fields. This causes phpmyadmin to hang and eventually timeout.
Last edit: Matthew Davidson 2013-05-15
[deleted]
Last edit: Matthew Davidson 2013-05-15
Just realized I was mistaken on part of this. I should have assumed all fields were given, even auto-incremented fields. This file has the appropriate fix, along with making the global $message variable available so that it doesn't hang on errors.
This import file SHOULD work. It has all the fields.
It is risky to make assumptions about the columns when the csv does not contain data for all columns. However an appropriate error message should be displayed.