Migration problem

Hi,

I was having an error trying to transfer a WP website to 000webhost free hosting service. I got this error in step 2 of 4:
“No tables where created during step 2 of the install. Please review the installer-log.txt file for ERROR messages. You may have to manually run the installer-data.sql with a tool like phpmyadmin to validate the data input. If you have enabled compatibility mode during the package creation process then the database server version your using may not be compatible with this script.”

The tables were created in the database but they were all empty. Finally I was able to find a solution. I added a @mysqli_commit($dbh) after the mysqli_query($dbh, ($sql_result_file_data[$counter])) line (around line 2125).

000webhost uses MariaDB 10.1.20 and PHP 7.1.7 right now.

I hope you can find a solution that is compatible with other services as well.
The 503 Service Unavailable page remains a registry error. The registry saves data about your PC’s configuration, software and hardware settings. Errors can become the resulting outcome when registry data experience malfunctions.

Thanks!

1 Like