Duplicate column name ‘permanent’

  • Resolved Fred Marvila

    (@marvila)


    8 years, 4 months ago

    Hi All.

    Ever since 6.2.4 (at least), Query Monitor plugin has been raising a DB error:

    
Database Errors
Query
alter table wp_uJPAJQdDMzyv2yrs_wfBlocks add column permanent tinyint UNSIGNED default 0	

Call Stack
wfDB->queryWrite()
wfDB->queryWriteIgnoreError()
 wp-content/plugins/wordfence/lib/wfDB.php:50
wordfence::runInstall()
 wp-content/plugins/wordfence/lib/wordfenceClass.php:379
wordfence::install_actions()
 wp-content/plugins/wordfence/lib/wordfenceClass.php:604

Component
Plugin: wordfence

Error
Duplicate column name 'permanent'

    It does not seem that anything is affected, but it is not good, or safe, to keep an error running.

    I waited for the auto-update to be executed today and the error is still there. I tried disabling the plugin and enabling it again and the error only went away during the time the plugin was disabled.

    I am using NGINX and today I found an issue with the order of some locations, which has been solved now, but the error is still there after all the cache was cleared and all. (not sure if moving to NGINX did anything, but the error was not there when I moved a couple of months back.)

    Could you please let me know what could be causing it and a possible plan of action?

    The site where the problem is happening is https://sundaycooks.com.

    Thank you very much,
    Fred Marvila

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

  • Hi Fred,
    I’m not really sure what might cause this issue, I suggest re-installing the plugin with “Delete Wordfence tables and data on deactivation” option enabled from (Wordfence > options) then deactivate the plugin and delete it before re-installing it again, by doing this you should know that you will lose all the current plugin configuration and it will be as if the plugin has been activated on your website for the first time.

    P.S. You could make use of “Exporting and Importing Wordfence Settings” option, however, I’m not sure if this can recreate this problem or not.

    Thanks.

    Thread Starter Fred Marvila

    (@marvila)

    Thanks a lot wfalaa ??

    I started seeing some unusual behaviors as to options of plugins not being saved, even though WP sent a message that it was saved and the same with activation and deactivation of plugins, that is, I deactivated a plugin, wordpress said it was deactivated, but the list still showed it activated.

    After a few hours trying to troubleshoot this, I came to the Redis cache and as soon as I disabled the cache through the Redir Object Cache. THe plugin has been upgraded a couple of days back, but I’m not sure that had anything to do with it.

    ANyway, I only came to this because my server was experiencing some weird CPU spikes and I went after what was causing it, which had something to do with the DB. Looks like Redis was the cause.

    After that, no more error messages about Wordfence’s table. It was probably cached and never cleared by Redis.

    Thanks again,
    Fred Marvila
    Sundaycooks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Duplicate column name ‘permanent’’ is closed to new replies.