The backups that are being generated by this plugin have one problem.
In the table wp_posts some of the entries are getting duplicated. Obviously since the ID is a primary key, there cannot be multiple entries with same ID but the backup file contains multiple entries with same ID. Due to this, I am not able to restore the backup.
I would have changed the sql file manually but there are lots of duplicate entries.
Earlier the plugin was generating proper backup files. Can anyone please suggest what is going wrong?
Is it possible that you have a plugin that is modifying database queries? The backup file is generated from a simple SELECT statement, so it's hard to imagine how it could be selecting the same row more than once.
Could there be an error in the database table itself?
I have checked through phpMyAdmin... the table is fine. No errors.
On the home page of my blog, instead of the default regular page which shows latest post excerpts in reverse order, I use home.php template which uses multiple database queries to show various posts in different sections. Can that be interfering with the backup? I don't think any plugin could be modifying database queries.
So are the lines one right after the other? Is every wp_posts line doubled, or just a few? Or do the lines double after every so many? Are they exactly the same? Are there any characteristics that distinguish them?
Not all the lines are doubled. Only few of them. The repetitions are not one after another. They are scattered. Each duplicate post has only one other copy. The copies are exactly the same right down to the character. I can't find any pattern as such. One set of posts is above while the other set of duplicates is below in the whole list.
I'm having the same problem but it's occurring with the comments not the posts. I tried version 2.2.2 and 2.2.3 to see if it would fix the problem but it did not.
I'm having the same issue. The duplicate post IDs are scattered. I can't access the original database by PHPmyAdmin, though, so it's hard to say if it is in the database or is the fault of the backup plugin.
I'm using version 2.2.3 of the plugin, and WordPress 3.0.4
Hi,
The backups that are being generated by this plugin have one problem.
In the table
wp_postssome of the entries are getting duplicated. Obviously since theIDis a primary key, there cannot be multiple entries with same ID but the backup file contains multiple entries with same ID. Due to this, I am not able to restore the backup.I would have changed the sql file manually but there are lots of duplicate entries.
Earlier the plugin was generating proper backup files. Can anyone please suggest what is going wrong?
Is it possible that you have a plugin that is modifying database queries? The backup file is generated from a simple SELECT statement, so it's hard to imagine how it could be selecting the same row more than once.
Could there be an error in the database table itself?
I have checked through phpMyAdmin... the table is fine. No errors.
On the home page of my blog, instead of the default regular page which shows latest post excerpts in reverse order, I use
home.phptemplate which uses multiple database queries to show various posts in different sections. Can that be interfering with the backup? I don't think any plugin could be modifying database queries.So are the lines one right after the other? Is every wp_posts line doubled, or just a few? Or do the lines double after every so many? Are they exactly the same? Are there any characteristics that distinguish them?
Not all the lines are doubled. Only few of them. The repetitions are not one after another. They are scattered. Each duplicate post has only one other copy. The copies are exactly the same right down to the character. I can't find any pattern as such. One set of posts is above while the other set of duplicates is below in the whole list.
I'm having the same problem but it's occurring with the comments not the posts. I tried version 2.2.2 and 2.2.3 to see if it would fix the problem but it did not.
The duplicate entries are scattered.
I'm having the same issue. The duplicate post IDs are scattered. I can't access the original database by PHPmyAdmin, though, so it's hard to say if it is in the database or is the fault of the backup plugin.
I'm using version 2.2.3 of the plugin, and WordPress 3.0.4
If anyone with this problem could send me a copy of your backup file to austin@pressedcode.com, that would help me diagnose what's going on.
I am having a serious issue whereby your plugin renamed a bunch of php files, then wiped the contents of the originals! NOT happy.
Sorry, you're having trouble, but there's absolutely no way my plugin could have done anything like that. It must be something else.
Has your site been hacked, perhaps?
RSS feed for this topic
Reply
You must log in to post.