Message is either: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'schedule_id' at row 1: INSERT INTO {backup_migrate_schedules} (schedule_id, name, source_id, destination_id, profile_id, keep, period, enabled, cron) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => 8a6d72119fbe3b9f24207ac6b6d4da83 [:db_insert_placeholder_1] => Untitled Schedule [:db_insert_placeholder_2] => db [:db_insert_placeholder_3] => scheduled [:db_insert_placeholder_4] => default [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 86400 [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => 0 ) in drupal_write_record() (line 7194 of /[path-to-install]/includes/common.inc)

or

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'c2557031d9e37c9655932cb2733c631a' for column 'schedule_id' at row 1: INSERT INTO {backup_migrate_schedules} (schedule_id, name, source_id, destination_id, profile_id, keep, period, enabled, cron) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => c2557031d9e37c9655932cb2733c631a [:db_insert_placeholder_1] => Untitled Schedule [:db_insert_placeholder_2] => db [:db_insert_placeholder_3] => scheduled [:db_insert_placeholder_4] => default [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 86400 [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => 0 ) in drupal_write_record() (line 7194 of /[path-to-install]/includes/common.inc).

I am using Drupal 7.28 and Backup and migrate 7.x-2.8 using default settings, attempting to create a schedule.

Comments

ronan’s picture

ronan CreditAttribution: ronan commented
Status: Active » Postponed (maintainer needs more info)

Did you downgrade from the 3.x branch at any point? Do you have any outstanding database updates? If neither of these things is a factor, you may have to uninstall and reinstall the module.

gillarf’s picture

gillarf CreditAttribution: gillarf commented

No database updates outstanding but I think I may have tried a couple of versions of the module.

OK, i'll uninstall and then try to reinstall.

ronan’s picture

ronan CreditAttribution: ronan commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Thanks. Reopen if that doesn't solve the problem.

LBGreg’s picture

LBGreg CreditAttribution: LBGreg commented

Same problem. uninstall/reinstall via drush did not solve. Any updates? Did uninstall/reinstall work for others? Problem on 7.28 w/ 2.8 as well. Might have done downgrade from 3.0.

gillarf’s picture

gillarf CreditAttribution: gillarf commented

I did solve it in the end though it was not straightforward.

Uninstalling the module did not remove all the tables (maybe because I downgraded?!). So I deleted the tables manually in the database and reinstalled. All worked fine. Not ideal, but it worked for me.