Error: Unable to create DB Table

[Avly]

Hi, I installed free BPS, and Setup wizard generated the following red errors on BulletProof Security Database Tables Setup:

Error: Unable to create DB Table xxxx_bpspro_seclog_ignore
Error: Unable to create DB Table xxxx_bpspro_login_security
Error: Unable to create DB Table xxxx_bpspro_db_backup
Error: Unable to create DB Table xxxx_bpspro_mscan

Is this a problem that should be fixed? How?

Is maybe the solution the same as in this post?:  https://forum.ait-pro.com/forums/topic/setup-wizard-unable-to-install-bps-pro-db-tables/#post-41422

Thanks in advance for the reply.

Andrej

[AITpro Admin]

Yep, see if that solution works for you.  If it does not then your database probably has mixed Storage Engine tables and Collation.  If you see InnoDB and MyISAM mixed database tables then change the MyISAM database tables to InnoDB.

Changing the Storage Engine for database tables:

Open phpMyAdmin in your web host control panel.

Click on the table in phpmyadmin
Click “Operations” on the top right.
In the Table Options section choose your storage engine in the drop down menu. change to InnoDB instead of MyISAM.
Click the Go button to save.

Changing the collation of your database
Click the database name in the left pane.
Click Operations in the top menu.
Choose your desired collation from the dropdown menu. For WordPress you should use:  utf8mb4_unicode_520_ci or utf8mb4_unicode_ci.
Click the Go button to save.

[Avly]

Thank you for your quick answer.

I followed your advices but the problem persists. All my tables are InnoDB and utf8mb4_unicode_ci

Any other suggestion?

Best, Andrej

[AITpro Admin]

Try uninstalling and reinstalling BPS now.  If that does not work then are you using any sort of database caching like Redis? If so, you may need to flush your database cache > https://serverok.in/how-to-flush-redis-cache

[Avly]

Hi, I uninstalled and reinstalled BPS – no change.

I don’t use Redis. I use WP-Optimize. I deactivated all plugins and reinstalled BPS – no change 🙁

Can you suggest any other solution?

Best, Andrej

[AITpro Admin]

Out of ideas. Try asking your web host about this. Maybe they can figure out what is going on with your database.

[Avly]

My web host say that they cannot reproduce this error on their side 🙁  And that I should contact you 🙂

Maybe the error is because this domain is temporarily redirected to my computer in hosts file?

[AITpro Admin]

BPS creates database tables based on the wp-config.php file database connection info.  A URL redirect would not cause this problem.

[Avly]

OK. Thank’s a lot for your answers.

Best, Andrej

[Author]

Posts