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 <code>wp_wfnet404s</code> ( <code>sig</code> binary(16) NOT NULL, <code>ctime</code> 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 <code>wp_wffilemods</code> VALUES("hU?6?μ?8?àoTù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 https://lifeinthegrid.com/partner/ sais “error establishing database connection) link is on page https://lifeinthegrid.com/support/knowledgebase.php?article=12
I was looking for your donation page.
- The topic ‘Deploy errors: Table already exists, Duplicate entry – (database error write)’ is closed to new replies.