My programmer is having trouble handling a csv file with data for wordpress post content.
His plugin imports from the csv and inserts into Wordpress to create posts out of the data file. Some of the columns in the data file contain characters such as ä and ö which appear in e.g. the names of businesses in Germany for example. His import seems to be choking on those rows.
So for example, we get this error in Apache_error.log:
[Sat Jun 15 21:27:17 2013] [client 127.0.0.1] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT `image_id`, `userId`,`filename`, `uploaded` FROM `wp_agent_img` WHERE `userId` = made by WP_List_Table->display, WP_List_Table->display_row
n'), call_user_func_array, gtre_custom_columns, agent_list, referer: http://localhost/wp-admin/admin.php?page=wp-csv-import
My questions then:
1. Can you help me make heads or tails out of the error message above? Is it likely to be caused by trying to import data with special characters or is it more likely to be something else?
2. What factors need to be lined up with each other across the environment of Wordpress, Mysql, Php, and possibly Apache to ensure that none of those settings are causing the issue with the special characters?
Thanks in advance!