Title: Database Initialization and Admin Email Mapping issues
Last modified: August 21, 2016

---

# Database Initialization and Admin Email Mapping issues

 *  Resolved [itpixie](https://wordpress.org/support/users/itpixie/)
 * (@itpixie)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/)
 * Hi OSE Firewall team,
 * Thank you so much for resolving the PDO issue ([http://wordpress.org/support/topic/updated-to-202-getting-fatal-php-error-on-site](http://wordpress.org/support/topic/updated-to-202-getting-fatal-php-error-on-site))
 * I do have some questions/issues using the plugin, now that I can get it to work
   with my site:
 * As I was initializing the database for the first time, the process stopped/got
   stuck (or so it seems) half way through. So I closed the pop-up window and the
   page refreshed, it said everything was ready to do. How can I tell that all the
   database tables got created and initialized correctly? Or is there a way for 
   me to (force) re-initialize everything?
 * I also notice that in the Admin Email Mapping config page there is no data. When
   I try to add myself to receive email alerts, my WP user ID is never shown. As
   I poked around my database, I noticed the table ose_app_admin is empty. I would
   imagine my WP user ID should be in the table… So how do I populate this table.
   And I assume the Admin Email Mapping config page not showing my WP user ID because
   ose_app_admin table is empty? Is all this a sign that my ose tables didn’t get
   initialized correctly?
 * Thank you again,
    itpixie
 * [http://wordpress.org/plugins/ose-firewall/](http://wordpress.org/plugins/ose-firewall/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Helix.L](https://wordpress.org/support/users/prohelix/)
 * (@prohelix)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134365)
 * Hi itpixie
 * For the database tables creation i, we tried it again in our local testing server,
   it works fine, may we have the temp access your website and check it? If so, 
   please send the login in our secure support center here:
 * [https://www.protect-website.com/support-center/](https://www.protect-website.com/support-center/)
 * For the Email-Admin Mapping issue, we fixed it in version 2.1.2, please upgrade
   to that version, the issue will be resolved.
 * Hope this helps 🙂
    Best wishes Helix _[ [Signature moderated](http://codex.wordpress.org/Forum_Welcome#Signatures).]_
 *  Plugin Author [Helix.L](https://wordpress.org/support/users/prohelix/)
 * (@prohelix)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134428)
 * Hi itpixie
 * BTW, we wrote a tutorial here for how to use Firebug to report the error messages
   you received in the database creation process
 * [https://www.protect-website.com/using-firebug-report-bugs/](https://www.protect-website.com/using-firebug-report-bugs/)
 * so you can check the error without sending the temp admin account to us, please
   copy-paste the error messages you see in the console so we can track down the
   error messages and fix it asap.
 * Best wishes
    Helix _[ [Signature moderated](http://codex.wordpress.org/Forum_Welcome#Signatures).]_
 *  Thread Starter [itpixie](https://wordpress.org/support/users/itpixie/)
 * (@itpixie)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134526)
 * Hello Helix,
 * Thank you so much for the Firebug info. One of the sites that I’m having problem
   initializing the database has the following SQL error:
 * > <h1>CDbException</h1>
   >  <p>CDbCommand failed to execute the SQL statement: SQLSTATE[
   > HY000]: General error: 1005 Can’t create table ‘fireflys_wordpressdb.ffsd_osefirewall_acl’(
   > errno: 121). The SQL statement executed was:
   > CREATE TABLE IF NOT EXISTS `ffsd_osefirewall_acl` (
   >  `id` INT(11) NOT NULL 
   > AUTO_INCREMENT , `name` VARCHAR(300) NOT NULL , `status` TINYINT(1) NOT NULL,`
   > datetime` DATETIME NOT NULL , `score` TINYINT(3) NOT NULL , `country_code` 
   > CHAR(2) NULL DEFAULT NULL , `host` VARCHAR(300) NULL DEFAULT NULL , `notified`
   > TINYINT(1) NULL DEFAULT NULL , `referers_id` INT(11) NOT NULL , `pages_id` 
   > INT(11) NOT NULL , `visits` INT(11) NOT NULL , PRIMARY KEY (`id`) , INDEX `
   > idx1_oseacl` (`referers_id` ASC) , INDEX `idx2_oseacl` (`pages_id` ASC) , CONSTRAINT`
   > fk1_oseacl` FOREIGN KEY (`referers_id` ) REFERENCES `ffsd_osefirewall_referers`(`
   > id` ) ON UPDATE CASCADE, CONSTRAINT `fk2_oseacl` FOREIGN KEY (`pages_id` ) 
   > REFERENCES `ffsd_osefirewall_pages` (`id` ) ON UPDATE CASCADE) ENGINE = InnoDB
   > AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8 (/home/fireflys/public_html/
   > dealers/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php:541)</p
   > >
   >     ```
   >     #0 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php(376): CDbCommand->queryInternal('', 0, Array)
   >     #1 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/db/oseDB2.php(58): CDbCommand->query()
   >     #2 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/installer/wordpress.php(43): oseDB2->query()
   >     #3 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(159): oseInstaller->createTables('/home/fireflys/...')
   >     #4 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(56): DashboardModel->createTables()
   >     #5 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/protected/controllers/DashboardController.php(34): DashboardModel->actionCreateTables()
   >     #6 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/actions/CInlineAction.php(49): DashboardController->actionCreateTables()
   >     #7 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
   >     #8 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
   >     #9 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
   >     #10 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/web/CWebApplication.php(282): CController->run('createTables')
   >     #11 /home/fireflys/public_html/dealers/wp-content/plugins/ose-firewall/framework/oseframework/ajax/oseAjax.php(28): CWebApplication->runController('dashboard/creat...')
   >     #12 [internal function]: oseAjax::runAction('')
   >     #13 /home/fireflys/public_html/dealers/wp-includes/plugin.php(406): call_user_func_array('oseAjax::runAct...', Array)
   >     #14 /home/fireflys/public_html/dealers/wp-admin/admin-ajax.php(72): do_action('wp_ajax_createT...')
   >     #15 {main}
   >     ```
   > 
 * There are 2 WordPress installs using the same database, though each has their
   own set of tables (with different table prefix). Would that be the reason (2 
   WP installs using the same database) I’m encountering the sQL error? I had no
   problem initializing OSE Firewall database/tables on the 1st WP install.
 * My other question is:
    Is there a way to force database initialization again,
   other than deleting the existing OSE Firewall tables?
 * Thanks,
    itpixie
 *  Thread Starter [itpixie](https://wordpress.org/support/users/itpixie/)
 * (@itpixie)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134527)
 * Hello OSE Firewall team,
 * After trying to re-initialize the OSE Firewall database by dropping all OSE Firewall
   related tables, here’s the error I see in Firebug:
 * >  Ext.Error: You’re trying to decode an invalid JSON String: <h1>CDbException
   > </h1> <p>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax
   > error or access violation: 1142 CREATE VIEW command denied to user ‘itpixiec_admin’@’localhost’
   > for table ‘itpx_osefirewall_aclipmap’. The SQL statement executed was: CREATE
   > VIEW `itpx_osefirewall_aclipmap` AS select `acl`.`id` AS `id`,`acl`.`name` 
   > AS `name`,`acl`.`status` AS `status`,`acl`.`datetime` AS `datetime`,`acl`.`
   > score` AS `score`,`acl`.`visits` AS `visits`, `acl`.`country_code` AS `country_code`,`
   > acl`.`host` AS `host`,`acl`.`notified` AS `notified`,`acl`.`referers_id` AS`
   > referers_id`,`acl`.`pages_id` AS `pages_id`,`ip`.`id` AS `ipid`,`ip`.`ip32_start`
   > AS `ip32_start`,`ip`.`ip32_end` AS `ip32_end`,`ip`.`iptype` AS `iptype` from(`
   > itpx_osefirewall_acl` `acl` left join `itpx_osefirewall_iptable` `ip` on((`
   > acl`.`id` = `ip`.`acl_id`))); (/home/itpixiec/public_html/wp-content/plugins/
   > ose-firewall/framework/db/CDbCommand.php:541)</p>
   >     ```
   >     #0 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/db/CDbCommand.php(376): CDbCommand->queryInternal('', 0, Array) #1 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/oseframework/db/oseDB2.php(58): CDbCommand->query() #2 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/library/oseFirewallInstaller.php(100): oseDB2->query() #3 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(196): oseFirewallInstaller->createACLIPView('/home/itpixiec/...') #4 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/models/DashboardModel.php(86): DashboardModel->createACLIPView() #5 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/protected/controllers/DashboardController.php(34): DashboardModel->actionCreateTables() #6 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/actions/CInlineAction.php(49): DashboardController->actionCreateTables() #7 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(308): CInlineAction->runWithParams(Array) #8 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(286): CController->runAction(Object(CInlineAction)) #9 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array) #10 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/web/CWebApplication.php(282): CController->run('createTables') #11 /home/itpixiec/public_html/wp-content/plugins/ose-firewall/framework/oseframework/ajax/oseAjax.php(28): CWebApplication->runController('dashboard/creat...') #12 [internal function]: oseAjax::runAction('') #13 /home/itpixiec/public_html/wp-includes/plugin.php(406): call_user_func_array('oseAjax::runAct...', Array) #14 /home/itpixiec/public_html/wp-admin/admin-ajax.php(72): do_action('wp_ajax_createT...') #15 {main}
   >     ```
   > 
 * And Admin Email mapping is still not working for me… My WP user id still doesn’t
   show up in the drop-down list, and I am unable to save any mapping even if I 
   manually type in my user id.
 * Thanks,
    itpixie
 *  Plugin Author [Helix.L](https://wordpress.org/support/users/prohelix/)
 * (@prohelix)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134529)
 * Thanks itpixie
 * For the error, I wrote the tutorial here:
 * [https://www.protect-website.com/create-view-command-denied-user-error/](https://www.protect-website.com/create-view-command-denied-user-error/)
 * This can resolve the problem.
 * For the Admin-mapping issue, we will add a manual admin email adding function
   into the system in the next version to resolve this.
 * Hope this helps. 🙂
    Best wishes Helix

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Database Initialization and Admin Email Mapping issues’ is closed to 
new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/ose-firewall_adadad.svg)
 * [Centrora WordPress Security™](https://wordpress.org/plugins/ose-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ose-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ose-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/ose-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ose-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ose-firewall/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Helix.L](https://wordpress.org/support/users/prohelix/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/database-initialization-and-admin-email-mapping-issues/#post-4134529)
 * Status: resolved