MysqlError: Duplicate column name 'id' in all requests

I’m investigating this for you. I’ll let you know what I find.

-Brian

Thanks! Let me know if there’s anything I can do to help

In the meantime, is there somewhere I can download 6.0.4?

Strange that you’re seeing this with every request. It’s from the routine that runs at plugin upgrade. Is it possible that your DB is read-only?

You can probably solve this by doing a factory default reset on Wordfence: https://docs.wordfence.com/en/I%27d_like_to_reinstall_Wordfence_completely._How_do_I_do_that%3F

Bear in mind that you’ll be deleting all your wordfence options.

We’re investigating this further on our end.

Regards,

Mark.

Reseting Wordfence seemed to do the trick. Errors are back down to 0!

Yes, we’re using RDS instances on AWS with read replicas. Let me know if you have any other questions to help troubleshoot on your end. I’m happy to help.

Thanks!!

This is happening again for me with 6.0.7, except a variation of the last error (column ‘permanent’ rather than ‘id’). Same solution fixed the issue but figured I’d post it in case it was a bug.

Error message
MysqlError: Duplicate column name 'permanent'

Sample stack trace

…ery called at /data/home/mysite.com/httpdocs/wp-content/db.php (777)
…/mysite.com/httpdocs/wp-content/plugins/wordfence/lib/wfDB.php (30)
in wfDB::queryWrite called at ? (?)
…/mysite.com/httpdocs/wp-content/plugins/wordfence/lib/wfDB.php (50)
…mysite.com/httpdocs/wp-content/plugins/wordfence/lib/wordfenceClass.php (333)
…mysite.com/httpdocs/wp-content/plugins/wordfence/lib/wordfenceClass.php (455)
…mysite.com/httpdocs/wp-content/plugins/wordfence/wordfence.php (25)
…_once called at /data/home/mysite.com/httpdocs/wp-settings.php (215)
…re_once called at /data/home/mysite.com/httpdocs/wp-config.php (125)
…uire_once called at /data/home/mysite.com/httpdocs/wp-load.php (37)
…ce called at /data/home/mysite.com/httpdocs/wp-blog-header.php (12)
in require called at /data/home/mysite.com/httpdocs/index.php (17)

Hi,
Thanks for this support ticket. I am getting exactly the same error after the last automatic upgrade of Wordfence to 6.1.2:
Duplicate column name ‘permanent’.
This is triggered in every page.

Hi again,
I solved the problem by:
– saving my wordfence settings
– deleting wordfence
– with wordfence assistant delete all wf data
– reinstall wordfence
– import settings

Next time I have this problem I will try before doing this to clear my cache (Zencache / Comet cache) as I suspect this might be a cache problem.

An hour ago Wordfence upgraded to its latest version 6.1.4 and the results on my site were catatrosphical.

Error Rate jumped from 0% to 97%+ (the error is Duplicate column name ‘permanent’) and transaction times doubled.
https://prntscr.com/auy457

I first tried to delete caches – did not work. Then I tried to simply disable wordfence: did not work either. The errors were still there.
I then tried to delete (errors stopped) and then reinstall a fresh version: did not work, the errors re-appeared.
So I had to delete and use wordfence assitant to completely delete all the tables, and then reinstall a fresh version and re-import the settings, as I described in my post 6 days ago.

I have now disabled automatic upgrades, but am not sure it’s worth my time keeping this plugin which causes so much work with each upgrade.

Hi xberg,

Seeing the duplicate column error more than once sounds like that plugin installation is trying to run on every pageload. This could happen if your database isn’t writable by the user, or if you have a database cache that’s continually returning old data. If you check your database user’s privileges, and also check for tables needing repair (using a tool like phpmyadmin), that may help.

If you still have trouble and need more details, please make a new post using the form at the bottom of the Wordfence forum here. (The www.remarpro.com forum rules ask us to keep each person’s issues separate, and it also helps us keep track of open issues, so no one gets skipped in old / long posts.) Thanks!

-Matt R