import fails PHP Fatal error

  • Resolved jpgoem

    (@jpgoem)


    1 year, 12 months ago

    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 ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Javier Carazo

    (@carazo)

    The \\\\ in option value is strange. Please consider to change the path and saving it without import to set a correct value there.

    Anyway, how many users are you trying to import?

    Thread Starter jpgoem

    (@jpgoem)

    Thanks for your quick response.
    Changing the path and saving without importing didn’t help, but your suggestion prompted me to update the acui_settings in the wp_options table using SQL.
    After the SQL update, the issue is now resolved.
    Thank you for the support.
    This request can be closed as resolved.

    Plugin Author Javier Carazo

    (@carazo)

    Thanks ??

    This seems to be a problem with the Windows slashes. But this is strange… this problem has not happened in other sites.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘import fails PHP Fatal error’ is closed to new replies.