Plugin Author
Yani
(@yaniiliev)
Hi!
I hope you are well.
Could you please share the file and plugin/theme that show the error message above?
The All-in-One WP Migration plugin itself supports PHP 8 and should not be causing this error.
I have your plugin installed on ALL of my websites with NO issues, I downloaded the same website and uploaded on the same server without any issues, but for some reason the main website is having issues backing up.
The theme is Kadence and All In One Migration plugin.
{“type”:1,”message”:”Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database-mysqli.php:126\nStack trace:\n#0 \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database-mysqli.php(126): mysqli_fetch_assoc()\n#1 \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database.php(1364): Ai1wm_Database_Mysqli->fetch_assoc()\n#2 \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database.php(914): Ai1wm_Database->get_create_table()\n#3 \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/model\/export\/class-ai1wm-export-database.php(159): Ai1wm_Database->export()\n#4 \/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/controller\/class-ai1wm-export-controller.php(77): Ai1wm_Export_Database::execute()\n#5 \/home\/obitmome\/public_html\/wp-includes\/class-wp-hook.php(324): Ai1wm_Export_Controller::export()\n#6 \/home\/obitmome\/public_html\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()\n#7 \/home\/obitmome\/public_html\/wp-includes\/plugin.php(517): WP_Hook->do_action()\n#8 \/home\/obitmome\/public_html\/wp-admin\/admin-ajax.php(192): do_action()\n#9 {main}\n thrown”,”file”:”\/home\/obitmome\/public_html\/wp-content\/plugins\/all-in-one-wp-migration\/lib\/vendor\/servmask\/database\/class-ai1wm-database-mysqli.php”,”line”:126}
Plugin Author
Yani
(@yaniiliev)
Thank you for providing the full log. Here is what I can see based on the log.
The error occurs because the MySQL query SHOW CREATE TABLE is failing and returning false instead of a valid result. This happens when trying to export the database.
Most likely causes:
1. One or more tables might be corrupted or have issues
2. The database user lacks permissions to run SHOW CREATE TABLE
3. Special characters in table names but this is unlikely
4. The connection drops during the export process also unlikely
To diagnose:
– Run CHECK TABLE on all tables to identify corruption
– Verify the database user has full privileges
– Look for tables with special characters or unusual names
Since it works on other sites with the same setup, it’s likely a database-specific issue on that particular site.
Plugin Author
Yani
(@yaniiliev)
Ok I will try the mod version and get back to you!
Is it possible low disk space could be an issue?
Plugin Author
Yani
(@yaniiliev)
If the MySQL server is on the same server and the server runs out of disk space, it is possible for MySQL server to stop responding to some queries but you will see a lot more errors than just this one.
Your mod plugin WORKED!!!!!!
I spent all night talking to ChatGPT and my host, finally your plugin work.
It’s working with php 8.2.
Let me if you will release an update in the furtre for this issue!
THANK YOU!!!
Plugin Author
Yani
(@yaniiliev)
Glad to hear that it worked out. Can you make sure that the backup file can be safely restored on a test website: https://playground.wordpress.net/
This is not exactly a fix but we will include this change in the next release of the plugin. Thanks for trying it out.
Restore WORKED!!!
Backed up and Restore successful.
Plugin Author
Yani
(@yaniiliev)
Great! Thanks for confirming. Yes, this will be included in the next release.
