• Resolved rogeriodec

    (@rogeriodec)


    I installed Cerber on all my sites, but when I run the integrity check on one of these sites (which is still in development), Cerber generates the error:

    ERROR: Unable to raise memory limit

    I raised the PHP memory to 512M and also I uninstalled and reinstalled Cerber, but the same problem occurs.

    Here is the HUGE log file (but thanks to the intelligence of Winrar, it compressed into a tiny size).

    How to solve this?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author gioni

    (@gioni)

    You can ignore that error if the scanner completes scanning normally with no other related errors. The error may occur if changing memory limits in PHP code is not allowed in PHP settings or in the server configuration. Also, your WordPress configuration/plugins/theme can cause that because Cerber utilizes the wp_raise_memory_limit() function and its behavior can be altered by filters.

    Thread Starter rogeriodec

    (@rogeriodec)

    @gioni
    Sorry, but the error aborts the scan, so it’s not working.
    This image shows the point where it stops, translating is “analyzing the file list”.

    Also, I added the main 3 directories in the exclude list and even then the error keeps the same.

    Did you see the log that I sent?

    • This reply was modified 7 years ago by rogeriodec.
    • This reply was modified 7 years ago by rogeriodec.
    Thread Starter rogeriodec

    (@rogeriodec)

    Looking for the error log and opening the MySql database, I discovered that the problem occurs because of the table cerber_files doesn’t exist and is not being created on the installation.

    Thread Starter rogeriodec

    (@rogeriodec)

    Once cerber_files table is not being created at installation, manually copying cerber_files from older Cerber database installation fixes the problem.

    Plugin Author gioni

    (@gioni)

    How to fix database related errors: https://wpcerber.com/repair-database-tables/

    Thread Starter rogeriodec

    (@rogeriodec)

    You are not paying enough attention to this problem.
    I have given you a lot of information that is being systematically disregarded.
    In addition, there are several other issues that I have opened in the forum are being answered.
    I had already used the option to repair the database, but it did not solve the problem.
    In fact, the option even creates new problems, as I got in “Tools -> Diagnostics -> Database Info”:

    
    Array
    (
        [0] => Array
            (
                [0] => Duplicate column name 'ip_long'
                [1] => ALTER TABLE cerber_log ADD ip_long BIGINT UNSIGNED NOT NULL DEFAULT "0" COMMENT "IPv4 long" AFTER ip, ADD INDEX (ip_long)
            )
    
        [1] => Array
            (
                [0] => Duplicate column name 'ip_long_begin'
                [1] => ALTER TABLE cerber_acl ADD ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range begin' AFTER ip, ADD ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range end' AFTER ip_long_begin
            )
    
        [2] => Array
            (
                [0] => Duplicate key name 'ip_begin_end'
                [1] => ALTER TABLE cerber_acl ADD UNIQUE ip_begin_end (ip, ip_long_begin, ip_long_end)
            )
    
        [3] => Array
            (
                [0] => Can't DROP 'ip'; check that column/key exists
                [1] => ALTER TABLE cerber_acl DROP INDEX ip
            )
    
        [4] => Array
            (
                [0] => Can't DROP 'begin_end'; check that column/key exists
                [1] => ALTER TABLE cerber_acl DROP INDEX begin_end
            )
    
        [5] => Array
            (
                [0] => Duplicate key name 'begin_end_tag'
                [1] => ALTER TABLE cerber_acl ADD INDEX begin_end_tag (ip_long_begin, ip_long_end, tag)
            )
    
        [6] => Array
            (
                [0] => Duplicate column name 'session_id'
                [1] => ALTER TABLE cerber_log 
            ADD session_id CHAR(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "",
            ADD country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "" COMMENT "Country code",
            ADD details VARCHAR(250) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "" COMMENT "Details about HTTP request";
          
            )
    
        [7] => Array
            (
                [0] => Duplicate key name 'session_index'
                [1] => ALTER TABLE cerber_log ADD INDEX session_index (session_id)
            )
    
        [8] => Array
            (
                [0] => Table 'rogeriod_sandbox.cerber_files' doesn't exist
                [1] => ALTER TABLE cerber_files ADD file_status INT UNSIGNED NOT NULL DEFAULT '0' AFTER scan_status
            )
    
        [9] => Array
            (
                [0] => Duplicate column name 'reason_id'
                [1] => ALTER TABLE cerber_blocks ADD reason_id int(11) unsigned NOT NULL DEFAULT "0"
            )
    
        [10] => Array
            (
                [0] => Duplicate column name 'php_errors'
                [1] => ALTER TABLE cerber_traffic ADD php_errors TEXT NOT NULL AFTER blog_id
            )
    
    )
    

    I ask you to pay more attention to support because a satisfied customer can migrate to the PRO version, but an unhappy customer can denigrate this product.

    Plugin Author gioni

    (@gioni)

    How’s your scanning? The errors from your last message are not relevant because it’s a normal part of the process of recovering database tables.

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

The topic ‘ERROR: Unable to raise memory limit’ is closed to new replies.