Import Issues with Database – (WP 5.0.22 + PHP 7.

Thank you for reaching out and sharing the details of the issue.

I believe you have encountered 2 distinct issues.

1. Database Corruption Issues
I’ve seen rare cases where WordPress installations lack proper AUTO_INCREMENT settings on critical tables like wp_posts or wp_options. This usually happens due to the environment or method used to initially install WordPress on either the source or destination site. Without AUTO_INCREMENT, inserting new records can silently fail or overwrite existing entries, which can lead to broken functionality after import.
First) Check your database schema (e.g., via phpMyAdmin or a database tool) and ensure that the ID column in tables like wp_posts, wp_options, and wp_users is set as AUTO_INCREMENT.
Second) If not, you can manually correct this with a SQL command like:
ALTER TABLE wp_posts MODIFY ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;

2. “Not Found” Errors on Frontend
This is usually related to permalink settings or Apache’s mod_rewrite module being disabled on the destination server.
First) Go to Settings > Permalinks in your WordPress dashboard and switch to the Default setting, then save changes. This will reset the .htaccess file.
Second) If that works, you can switch back to your preferred permalink structure afterward.
Third) Ensure the mod_rewrite module is enabled on your web server. If you’re unsure, your hosting provider should be able to confirm this.

The latest version of the plugin is the most optimal version to use.
The plugin supports you version of WordPress without issue. I *strongly* recommend you to update to the latest version of WordPress.