Title: throwing error
Last modified: February 9, 2022

---

# throwing error

 *  Resolved [Melissa](https://wordpress.org/support/users/maxwellnorton/)
 * (@maxwellnorton)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/throwing-error-3/)
 * from few days this plugin is throwing error on all my sites such as
 * `AH01071: Got error 'PHP message: WordPress database error Invalid default value
   for 'created' for query CREATE TABLE nevab_aiowps_debug_log (\n id bigint(20)
   NOT NULL AUTO_INCREMENT,\n level varchar(25) NOT NULL DEFAULT '',\n message text
   NOT NULL DEFAULT '',\n type varchar(25) NOT NULL DEFAULT '',\n created datetime
   NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (id)\n )DEFAULT CHARACTER SET
   utf8mb4 COLLATE utf8mb4_unicode_ci; made by require('wp-blog-header.php'), require_once('
   wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'),
   include_once`
 * and
 * `AH01071: Got error 'PHP message: WordPress database error Invalid default value
   for 'created' for query CREATE TABLE fqaau_aiowps_debug_log (\n id bigint(20)
   NOT NULL AUTO_INCREMENT,\n level varchar(25) NOT NULL DEFAULT '',\n message text
   NOT NULL DEFAULT '',\n type varchar(25) NOT NULL DEFAULT '',\n created datetime
   NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (id)\n )DEFAULT CHARACTER SET
   utf8mb4 COLLATE utf8mb4_unicode_ci; made by require('wp-blog-header.php'), require_once('
   wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'),
   include_once('/plugins/all-in-one-wp-security-and-firewall/wp-security.php'),
   include_once('/plugins/all-in-one-wp-security-and-firewall/wp-security-core.php'),
   AIO_WP_Security->__construct, AIO_WP_Security->loader_operations, AIOWPSecurity_Logger-
   >__construct, AIOWPSecurity_Logger->maybe_create_debug_log_table, maybe_create_table,
   W3TC\\DbCache_WpdbNew->query, W3TC\\DbCache_WpdbInjection_QueryCaching...', referer:`
 * will these error get fixed, plz get it fixed asap

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

 *  Plugin Support [vupdraft](https://wordpress.org/support/users/vupdraft/)
 * (@vupdraft)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/throwing-error-3/#post-15351917)
 * Hi,
 * Can you go into php MyAdmin and in the query tab run the following query
 * SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
 * If this doesn’t resolve the issue can you provide the following information;
 * SQL version,
    php version WP version
 *  Thread Starter [Melissa](https://wordpress.org/support/users/maxwellnorton/)
 * (@maxwellnorton)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/throwing-error-3/#post-15353445)
 * still same error
 * my site is running on PHP 7.4.27 and 8.0.15
    Wordpress Version Version 5.9 MariaDB
   5.5.68
    -  This reply was modified 4 years, 3 months ago by [Melissa](https://wordpress.org/support/users/maxwellnorton/).
 *  Plugin Contributor [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/)
 * (@pmbaldha)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/throwing-error-3/#post-15354639)
 * [@maxwellnorton](https://wordpress.org/support/users/maxwellnorton/) [@vupdraft](https://wordpress.org/support/users/vupdraft/)
   I have resolved the error in our development version of the plugin. You can download
   it from [https://drive.google.com/file/d/1MtGNIwpDk9t2uWjZnc7zJlcMHF15P35u/view?usp=sharing](https://drive.google.com/file/d/1MtGNIwpDk9t2uWjZnc7zJlcMHF15P35u/view?usp=sharing).
 * Let me know whether it helps you to resolve the issue or not.
 * I am very sorry for the inconvenience you face.
 * Thank you!
 *  [jakspam](https://wordpress.org/support/users/jakspam/)
 * (@jakspam)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/throwing-error-3/#post-15414871)
 * Hi [@pmbaldha](https://wordpress.org/support/users/pmbaldha/), your development
   version is not accessible anymore, may you provide a valid link, I have the same
   issue. Tks
 *  [songsofabba](https://wordpress.org/support/users/songsofabba/)
 * (@songsofabba)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/throwing-error-3/#post-15583920)
 * Hello and thanks for this great plugin, however I still get this error since 
   about three updates ago on all my three sites, exact same error. using all latest
   wp version and php version 8.1.4 with MariaDB 10.7 and also latest of your plugin
   on a windows10/iis machine. Tried the above solution and assume the downloadable
   patch is in the latest version. Best Regards Lennart
 *     ```
       [23-Apr-2022 09:01:47 UTC] WordPress database error for Table 'xxx_aiowps_debug_log' already exists förfrågan CREATE TABLE xxx_aiowps_debug_log (
       			id bigint(20) NOT NULL AUTO_INCREMENT,
       			level varchar(25) NOT NULL DEFAULT '',
       			message text NOT NULL DEFAULT '',
       			type varchar(25) NOT NULL DEFAULT '',
       			created datetime NOT NULL DEFAULT '1000-10-10 10:00:00',
       			PRIMARY KEY  (id)
       			)DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/all-in-one-wp-security-and-firewall/wp-security.php'), require_once('/plugins/all-in-one-wp-security-and-firewall/wp-security-core.php'), AIO_WP_Security->__construct, AIO_WP_Security->loader_operations, AIOWPSecurity_Logger->__construct, AIOWPSecurity_Logger->maybe_create_debug_log_table, maybe_create_table
       ```
   

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

The topic ‘throwing error’ is closed to new replies.

 * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256.
   png?rev=2798307)
 * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 5 replies
 * 5 participants
 * Last reply from: [songsofabba](https://wordpress.org/support/users/songsofabba/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/throwing-error-3/#post-15583920)
 * Status: resolved