Setup Wizard unable to create BPS Pro DB Tables

[AITpro Admin]

Email Question:

Hi Ait-Pro: I have use the free version for a while and like it so I purchased the pro version.  I watched your video.  During the Pre-Installation Setup Wizard it is all green.  During the Setup Wizard I get the following text in red.

Can you please help?

BulletProof Security Pro Database Tables Setup

Error: Unable to create DB Table wp_bpspro_arq_quarantine
Error: Unable to create DB Table wp_bpspro_arq_exclude
wp_bpspro_seclog_ignore DB Table created Successfully!
wp_bpspro_login_security DB Table created Successfully!
Error: Unable to create DB Table wp_bpspro_dbm_monitor
wp_bpspro_db_backup DB Table created Successfully!
Error: Unable to create DB Table wp_bpspro_folder_lock
wp_bpspro_mscan DB Table created Successfully!

[AITpro Admin]

Answer|Solution:

The problem was caused by these missing constants in the wp-config.php file > DB_CHARSET and DB_COLLATE.

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Solution:

Delete the BPS Pro plugin on the WordPress Plugins page.
Delete the BPS Pro backup folder using FTP or web host control panel > /wp-content/bps-backup/
Add the DB_CHARSET and DB_COLLATE code shown above in the wp-config.php file.
Install the BPS Pro zip file using the WordPress Plugins Upload zip installer.
Run the Pre-Installation and Setup Wizard.

Additional Notes:
These php errors were generated when running the BPS Pro Setup Wizard.

PHP Fatal error: Cannot redeclare bpsPro_AP_Check()…

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 9 for query CREATE TABLE wp_bpspro_arq_quarantine

[Author]

Posts