Title: Unexpected errors in CSV upload Last modified: August 29, 2020 --- # Unexpected errors in CSV upload * Resolved [Mike Dodds](https://wordpress.org/support/users/midodds/) * (@midodds) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/) * Hi * I’m struggling with an error in the csv upload process. I have a CSV file with 7 rows inc Header. I’ve created a target table using Data Designer for the data to be loaded into, mapped CSV to the table with headings set correctly ( I think) and validated the load using preview – all looks as expected * But … I’m getting errors in the CSV load process * I can send screenshots of the CSV preview, mapping and error ( looks like I can’t upload them here ) * Any help welcomed – thanks * **Messages from load copied below ** * Reading CSV file info… * Validating column mapping… * Enabling buffering… * Reading CSV file… * Connecting to database… * Error: Unknown column ‘cinnamon’ in ‘field list’ Error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘violet,null,null,’[https://xxxx/uploads/2020/08/image…](https://xxxx/uploads/2020/08/image…);.’ at line 1 Error: Unknown column ‘blackcurrant’ in ‘field list’ Error: Unknown column ‘green’ in ‘field list’ Error: Unknown column ‘green’ in ‘field list’ Error: Unknown column ‘blackcurrant’ in ‘field list’ Import ready! * 0 rows inserted 7 errors (not inserted) * Mike - This topic was modified 5 years, 9 months ago by [Mike Dodds](https://wordpress.org/support/users/midodds/). Viewing 7 replies - 1 through 7 (of 7 total) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13332172) * Hi Mike, * Can you add a screenshot of your mapping page? * You can use the contactform on the plugin website if you prefer to send it in private. * Thanks, Peter * Thread Starter [Mike Dodds](https://wordpress.org/support/users/midodds/) * (@midodds) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13332837) * Hi Peter thanks for the quick reply – ok feeling v dumb how do I add attachment/ screenshot , either here or in the contact form 🙁 * Have also posted the ” comment” in the contact form * Mike * Thread Starter [Mike Dodds](https://wordpress.org/support/users/midodds/) * (@midodds) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13332848) * [Mapping screenshot ](https://agenor.me.uk/home/wine/csv-error/) * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13334020) * Hi Mike, * Sorry, I didn’t explain myself very well. If you go to the plugin website and scroll down to bottom, you will see a link to the contactform in the middle. Just send me a mail so I can reply. After that you have my email address and you can send your attachments. * Can you please do that? I need a full screenshot. If possible I would like to receive your csv file and the destination table script as well. * Thanks, Peter * Thread Starter [Mike Dodds](https://wordpress.org/support/users/midodds/) * (@midodds) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13334222) * Thanks I’ve posted a follow up email in the contacts area. Mike * Thread Starter [Mike Dodds](https://wordpress.org/support/users/midodds/) * (@midodds) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13334853) * Peter thanks for all your help , once again a great job ! * So in summary ( for anyone else who may be having problems ) * We checked the target table design – using Explorer ( Manage and then columns) there was a mismatch in the expected column format – * We fixed column definition by dropping the table and then recreating table ; – corrected format using Designer – exported sql from Designer to my local machine- loaded sql using Explorer and checked columns * Reused the CSV that had had been loaded into Explorer, after re-mapping to the corrected table. * Works a treat * Many thanks Peter ! * Mike * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13334932) * Your welcome Mike! 🙂 Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Unexpected errors in CSV upload’ is closed to new replies. * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063) * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/) * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/) * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/) ## Tags * [csv](https://wordpress.org/support/topic-tag/csv/) * 7 replies * 2 participants * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/unexpected-errors-in-csv-upload/#post-13334932) * Status: resolved