Undefined Offset: 0 in backup_migrate_item -> get_id()

D7.21.

I have been using the Backup and Migrate module to do hosted site updates (backing up from a hosted test site and restoring to a hosted production site) for many months without many issues. This past weekend, however, the database did not restore properly on my prod site, and parts of the site, including the Configuration menu, were not available to me.

I asked the hosting service to drop the MySQL tables in the prod site's database and restore them from the test site's db. (This worked the one time before when an identical thing happened). The site now worked and allowed me into the Config menus, but going into the Backup and Migrate utility produced a screen containing above error repeated 20 times or so. This prevented me from using the Backup and Migrate utility. Unfortunately, the hosting company had also hosed the dev site's db so it was no longer available for them to do another restore attempt.

I used phpMyAdmin to export the troubled prod site's db and re-imported it into the test site. Now both sites worked, but both had the Undefined Offset messages, and I could not use Backup and Migrate on either.

Just for completeness, I imported that database once more, this time into a local version of the site on my PC, and again the error messages appeared, so there is no doubt that they traveled with the db.

I have used the MySQL cleanup utils (mysqlcheck, mysqlanalyze, mysqloptimize) on the local copy of the db, but they all complete without errors, showing nothing wrong with the db.

I have other test sites, where I have begun making modifications not yet migrated to the prod site. My next step will be to use one of those test sites to back out of those new modifications and recreate the production site's version, then use phpMyAdmin to drop the troubled db and import what should be an error-free version. However, I am interested to see if anyone else has had a similar experience, and what was done to diagnose and correct the problem.

Thanks...

Peter