CSV file upload not allowed
-
Hi, can we get you to help us with an error we’re having with uploading CSV files using the plugin?
It was working correctly then we deleted a few tables and suddenly we’re getting an error message.
Would be happy to donate or pay something to help us fix this issue. Error message is below..
“[Tue Oct 04 08:23:05.943804 2016] [:error] [pid 28966] [client IPADDRESS] WordPress database error The used command is not allowed with this MySQL version for query LOAD DATA LOCAL INFILE ‘/nas/content/live/sitename/wp-content/uploads/sds-csv/SA-Court-List-1.csv’ INTO TABLE temp CHARACTER SET UTF8 LINES STARTING BY ‘sds’ /* From [sitename/wp-admin/admin.php?page=sds-upload-csv] in [/nas/content/live/sitename/wp-content/plugins/custom-searchable-data-entry-system/sds-main.php:1320] */ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, ghazale_sds_insert_csv_file, referer: https://sitename/wp-admin/admin.php?page=sds-upload-csv”
Also wondering if we could modify this plugin to search only one or two of the fields but still display the remaining fields when a match is found.
Ie table rows include; first name, last name, address, city, reason. Would like the search function to search only first name and last name. If it finds a match it displays information from all rows.
I think currently you can hide information from the results but not from the search?
- The topic ‘CSV file upload not allowed’ is closed to new replies.