WordPress database error after every upgrade

  • Resolved rtpHarry

    (@rtpharry)


    8 years, 11 months ago

    I get the following block of errors everytime I upgrade to a new version of duplicator. Everything continues to work but these errors show up the first time I navigate to a page after updating. It’s happened on tons of sites.

    WordPress database error: [Duplicate column name 'id']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'id'	BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Duplicate column name 'name']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'name'	VARCHAR(250)	NOT NULL

WordPress database error: [Duplicate column name 'hash']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'hash'	VARCHAR(50)	NOT NULL

WordPress database error: [Duplicate column name 'status']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'status'	INT(11)	NOT NULL

WordPress database error: [Duplicate column name 'created']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'created'	DATETIME	NOT NULL DEFAULT '0000-00-00 00:00:00'

WordPress database error: [Duplicate column name 'owner']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'owner'	VARCHAR(60)	NOT NULL

WordPress database error: [Duplicate column name 'package']
ALTER TABLE wp_duplicator_packages ADD COLUMN 'package'	MEDIUMBLOB	NOT NULL

WordPress database error: [Duplicate key name 'hash']
ALTER TABLE wp_duplicator_packages ADD KEY 'hash' ('hash')

    It works for me so I’m not so bothered about it but I just thought I would let you know in case you are missing a test for existing or something in your update code?

    https://www.ads-software.com/plugins/duplicator/

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

  • Hey Harry,

    I have seen that on rare occasions but not on every install. The issue right now is that we call into a core method dbDelta and for some reason on some server it throws the error others it doesn’t. It should not effect anything as you said. We have a todo item to look at this some point.

    Thanks~

    Thread Starter rtpHarry

    (@rtpharry)

    Cory, thanks for the reply. It seems that I see it quite often with my development environment.

    My dev environment is based on VVV 1.2.0 which runs nginx on ubuntu 14.04 lts through a virtual box.

    You might be able to recreate the issue if you’re having trouble pinning it down by using this to scaffold a site?

    Hey Harry,

    Thanks for the details! It is in the back-log, but its still a ways down may be a bit of time before we can really dive into it…

    Cheers~

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error after every upgrade’ is closed to new replies.