Title: Deploy errors: Table already exists, Duplicate entry – (database error write)
Last modified: August 30, 2016
---
# Deploy errors: Table already exists, Duplicate entry – (database error write)
* [ionrane](https://wordpress.org/support/users/ionrane/)
* (@ionrane)
* [10 years, 11 months ago](https://wordpress.org/support/topic/deploy-errors-table-already-exists-duplicate-entry-database-error-write/)
* Hello
Wonderful plugin !
* On this latest version I am getting 4911 deploy errors in my install-log.txt
file.
* Never ran across this problem before. I’ve been a Duplicator user for years,
and I am not doing anything different than in previous versions.
* You state to not post the log file, so here are two examples of the type errors
appearing:
* ```
**ERROR** database error write 'Table 'wp_wfnet404s' already exists' - [sql=
CREATE TABLE wp_wfnet404s (
sig binary(16) NOT NULL,
ctime int(1...]
**ERROR** database error write 'Duplicate entry 'hU\xE66\xCF\xB5\xC28\x9E\xE0\x1E\x04\xBAT\xF9j' for key 'PRIMARY'' - [sql=INSERT INTO wp_wffilemods VALUES("hUæ6ϵÂ8žàºTùj", "wp-content/themes/a...]
```
* Now, the first time I deployed, I did deselect tables prefixed with wf (for wordfence)
and chose to not enable the plugin (since I cannot run it on my local machine).
* Since I’ve previously always kept all tables selected, and Usually (though not
always) keep all plugins enabled, only to immediately disable certain plugins
afterward, re-did the deployment using the standard settings (essentially not
using the advanced section).
Same errors.
* If I recall correctly, a few weeks ago, I used another recent version of your
plugin, and also got a bunch of errors, but after fretting for a while, I determined
that the website worked. I was puzzled but then ignored and forgot about that
until just now.
* So this time, too, it seems at first glance to be working (have not thoroughly
tested yet), but if it is like last time (perhaps 1-2 duplicator versions past),
it is probably “fine”.
* I bring this up because it is a Change. And I don’t know what caused the change.
It is also disconcerting to see so many errors, especially when I’m accustomed
to seeing “0”. I guess errors that I can ignore, pretty good, considering the
alternative ! However, no errors, when there are “none” is better. I’m guessing
that something is causing an error, something is going wrong, but I don’t know
what it is, and it could creep up later..?
* BTW, this table has been part of the website for a while, though it was incompatible
with the server I was running this site on (as well as being incompatible with
running on a local machine), hence I have kept the plugin disabled on both my
local machine, and the live server.
I have no idea if “enabling” the plugin
is part of the “change” that created these errors. I have had it enabled on another
website that has been running on this “new” server, and I do not recall any deploy
errors after migrating that site over last December. However, that site has essentially
been replaced, so there is little maintenance to do. I may not have needed to
update local or live but once since migration.
* servers and remained disabled on the both the local and live site until now.
This is the first Duplication I have done after migrating from the previous live
server to this new one. I’ve made some changes, and Really needed to get a copy
of it local so I can continue working on it locally – and not mess up the only
working copy (live at that) that I have.:)
* So the only changes I am aware of are:
– newest version of the plugin (I kept
running 5.18 for a while as I was moving websites around, and couldn’t afford
the potential of something going wrong with an untested by me version). – Duplicating
from a “new” server to my local machine. (Though, I did duplicate a different
site that I had migrated over to that “new” server about 6 -7 months ago, and
do not recall any problems) – The tables generating most of the errors in the
log file, I had not had enabled for the last 6 months, after it appeared to be
causing problems with my account on the previous server. Since the other website
on this new server seems to have no problems with this plugin, I have re-enabled
it. I doubt this would be the deciding factor generating these errors, it is
the only other related “change” I can think of.
* -The only other time I have had deploy errors was during another recent duplication(
not the latest version of duplicator, but a recent version). This was from local
machine to live website. I could not figure out the source of the errors, and
I hadn’t made any major changes like there have been this time. And the website
actually worked despite the errors. Puzzling, but I dropped it. I do not think
I have the log file saved anywhere, and cannot remember many details.
* Thank You for any insight 🙂
* (btw your link to [http://lifeinthegrid.com/partner/](http://lifeinthegrid.com/partner/)
sais “error establishing database connection) link is on page [http://lifeinthegrid.com/support/knowledgebase.php?article=12](http://lifeinthegrid.com/support/knowledgebase.php?article=12)
I was looking for your donation page.
* [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)
Viewing 1 replies (of 1 total)
* [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
* (@corylamleorg)
* [10 years, 11 months ago](https://wordpress.org/support/topic/deploy-errors-table-already-exists-duplicate-entry-database-error-write/#post-6220709)
* Hey ionrane,
* Thanks for the feedback! I think this may be related to a database permission
error. If you checked to remove all tables in step 1 of the installer then it
should connect to the db and remove all tables before trying to create the new
ones from the installer script. If it says that the table already exists then
somehow it wasn’t able to remove it first, which is related to a DB permission
issue, you can checkout [this link](http://lifeinthegrid.com/duplicator-faq)
for more info on DB and probably google PHPmyadmin WP access for how to grant
your DB full permissions, I would check with your host first to make sure the
user you use on the installer has the correct perms to remove tables…
* Hope that helps!
Viewing 1 replies (of 1 total)
The topic ‘Deploy errors: Table already exists, Duplicate entry – (database error
write)’ is closed to new replies.
* 
* [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
* [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
* [Support Threads](https://wordpress.org/support/plugin/duplicator/)
* [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
* [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
* [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)
## Tags
* [Duplicate Entry](https://wordpress.org/support/topic-tag/duplicate-entry/)
* 1 reply
* 2 participants
* Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
* Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/deploy-errors-table-already-exists-duplicate-entry-database-error-write/#post-6220709)
* Status: not resolved