• Resolved Nikonn

    (@nikonn)


    Hello. When activating the plugin, an error occurred on the work site. It is completely impossible to reproduce it, as the markup in the admin area is shifting.

    First, I installed it on a test site to check that everything works, then I installed it on a working site and an error occurred. The sites are on the same server, the MYSQL version is the same for all sites. I can’t figure out what the problem is.

    Error: dPress: [Invalid default value for ‘last_popup_time’]
    CREATE TABLE RbfsEw_zdn_adblock_popup_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, user_agent text NOT NULL, last_popup_time datetime DEFAULT CURRENT_TIMESTAMP, popup_count int(11) DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY unique_user (user_id), KEY last_popup_time (last_popup_time) ) DEFAULT CHARACTER SET utf8mb4 COLLATE

    Up to this point, I had installed many plugins on my work site, and there were no such problems.

    Can you suggest any solution to deal with this problem? Thank You.

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter Nikonn

    (@nikonn)

    I tried using recovery tools, but it didn’t work (I conducted tests on another work site with the installation of your plugin)

    Add define(‘WP_ALLOW_REPAIR’, true); to the wp-config.php file (in the root of your site).
    Navigate to your-domain/wp-admin/maint/repair.php in your browser and exit the database data recovery.
    Don’t forget to delete the text when finished!

    Plugin Author cuongquach

    (@cuongquach)

    Let me check and get back to you soon. It is most likely due to the old MySQL version.

    Thread Starter Nikonn

    (@nikonn)

    applies MySQL 5-5-68

    Plugin Author cuongquach

    (@cuongquach)

    MySQL versions prior to 5.6.5 do not support using CURRENT_TIMESTAMP as a default value for DATETIME

    Thread Starter Nikonn

    (@nikonn)

    I tried to fix it in the my.cnf file. sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    But Mysql refused to work. Do you have any ideas how to work around this problem?

    Plugin Author cuongquach

    (@cuongquach)

    Let wait for next update

    Thread Starter Nikonn

    (@nikonn)

    OK, but the plugin works with databases that were created on an existing server, the error is only with migrated databases.

    Thread Starter Nikonn

    (@nikonn)

    The hosting service staff suggested that the plugin passed the DEFAULT value CURRENT_TIMESTAMP for the DATETIME type field, but CURRENT_TIMESTAMP in older versions is allowed by default mainly for TIMESTAMP.

    Plugin Author cuongquach

    (@cuongquach)

    Try new version 1.0.9

    Thread Starter Nikonn

    (@nikonn)

    I checked, there are NO problems with the installation! It works in the Chrome browser, detects the Adblock and the Adguard.

    There is a proposal for the development of the plugin. Can you delay enabling the definition of the Adblock, for example, after 3 page views?

    Plugin Author cuongquach

    (@cuongquach)

    Sure, let me think about it.

    Plugin Author cuongquach

    (@cuongquach)

    Try new version 1.1.0 that add your requested feature “Enable Delayed Popup”

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

You must be logged in to reply to this topic.