Hello,
I am no longer able to import.
I get error message : PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 62914592 bytes) in C:\Users\xxxx\Local Sites\yyyyyyyyyyyy\app\public\wp-includes\class-wpdb.php on line 1533.
I increased the WP_MEMORY_LIMIT’ and WP_MAX_MEMORY_LIMIT. The problem is still there.
I now get error message :
WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = ‘a:4:{s:14:\”import_backend\”;a:13:{s:12:\”path_to_file\”;s:29360245:\”C:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\…………………………………….
\\\\\\\classes/test.csv\”;s:4:\”role\”;a:1:{i:0;s:10:\”subscriber\”;}s:17:\”empty_cell_action\”;s:5:\”leave\”;s:11:\”sends_email\”;s:2:\”no\”;s:18:\”send_email_updated\”;s:2:\”no\”;s:21:\”update_existing_users\”;s:3:\”yes\”;s:25:\”force_user_reset_password\”;s:2:\”no\”;s:28:\”update_emails_existing_users\”;s:2:\”no\”;s:27:\”update_roles_existing_users\”;s:2:\”no\”;s:29:\”update_allow_update_passwords\”;s:2:\”no\”;s:24:\”delete_users_not_present\”;s:2:\”no\”;s:23:\”change_role_not_present\”;s:2:\”no\”;s:28:\”change_role_not_present_role\”;s:10:\”subscriber\”;}s:15:\”import_frontend\”;a:0:{}s:11:\”import_cron\”;a:0:{}s:14:\”export_backend\”;a:0:{}}’ WHERE option_name = ‘acui_settings’ made by require_once(‘wp-admin/admin.php’), do_action(‘tools_page_acui’), WP_Hook->do_action, WP_Hook->apply_filters, ACUI_Import->show, ACUI_Settings->save_multiple, update_option
And there are literally millions of \\\\ in the SQL statement !!
After some investigation, I discovered something strange in the database table wp_options :
‘72545’, ‘acui_settings’, ‘a:4:{s:14:\”import_backend\”;a:5:{s:4:\”role\”;a:1:{i:0;s:10:\”subscriber\”;}s:12:\”path_to_file\”;s:14680181:\”C:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\………………………\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\classes/test.csv\”;s:11:\”sends_email\”;s:2:\”no\”;s:18:\”send_email_updated\”;s:2:\”no\”;s:25:\”force_user_reset_password\”;s:2:\”no\”;}s:15:\”import_frontend\”;a:0:{}s:11:\”import_cron\”;a:0:{}s:14:\”export_backend\”;a:0:{}}’, ‘yes’.
And again there are literally millions of \\\\ in the table row !!
I have no idea where this is coming from. Can you help ?