throwing error

  • Resolved Melissa

    (@maxwellnorton)


    2 years, 9 months ago

    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

    (@vupdraft)

    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

    (@maxwellnorton)

    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 2 years, 9 months ago by Melissa.
    Plugin Contributor Prashant Baldha

    (@pmbaldha)

    @maxwellnorton @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.

    Let me know whether it helps you to resolve the issue or not.

    I am very sorry for the inconvenience you face.

    Thank you!

    Hi @pmbaldha, your development version is not accessible anymore, may you provide a valid link, I have the same issue. Tks

    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.