• Resolved kojaksite

    (@kojaksite)


    Hi, I have been pulling my hair for 24 hours no on how to fix this error. When exporting my wordpress from xampp I am always getting unable to export error when its trying to export the database.

    Here’s the error log.

    Aug 16 2022 22:57:16
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    Aug 16 2022 22:57:19
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    Aug 16 2022 22:57:24
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    Aug 16 2022 22:57:28
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    Aug 16 2022 22:57:33
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    Aug 16 2022 22:57:39
    {"type":1,"message":"Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php:113\nStack trace:\n#0 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php(113): mysqli_fetch_assoc(false)\n#1 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(1295): Ai1wm_Database_Mysqli->fetch_assoc(false)\n#2 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database.php(840): Ai1wm_Database->get_create_table('wp_wfhoover')\n#3 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\model\\export\\class-ai1wm-export-database.php(155): Ai1wm_Database->export('D:\\\\xampp htdocs...', 0, 30, 0, 17934)\n#4 D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\controller\\class-ai1wm-export-controller.php(70): Ai1wm_Export_Database::execute(Array)\n#5 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(307): Ai1wm_Export_Controller::export(Array)\n#6 D:\\xampp htdocs\\cakemeaway\\wp-includes\\class-wp-hook.php(331): WP_Hook->apply_filters('', Array)\n#7 D:\\xampp htdocs\\cakemeaway\\wp-includes\\plugin.php(476): WP_Hook->do_action(Array)\n#8 D:\\xampp htdocs\\cakemeaway\\wp-admin\\admin-ajax.php(187): do_action('wp_ajax_ai1wm_e...')\n#9 {main}\n  thrown","file":"D:\\xampp htdocs\\cakemeaway\\wp-content\\plugins\\all-in-one-wp-migration\\lib\\vendor\\servmask\\database\\class-ai1wm-database-mysqli.php","line":113}
    
    

    I tried the method here https://help.servmask.com/2018/10/27/how-to-increase-maximum-upload-file-size-in-wordpress/ but the instructions is not very clear on the .htaccess and wp-config file. I tried to paste the code at the end of each file but it didnt work.

    Please help.

    Thanks a lot!

Viewing 1 replies (of 1 total)
  • Plugin Author Yani

    (@yaniiliev)

    You need to check your MySQL server logs. It looks like the process stops working during the export. Your server might not be powerful enough or you need to adjust the MySQL configuration to use more memory.

Viewing 1 replies (of 1 total)
  • The topic ‘Unable to export database’ is closed to new replies.