After updating from version 2.9 to version 2.10, the update process start with this error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'sites/all/modules/date/tests/date_test/date_test.module' for key 'PRIMARY': INSERT INTO {system} (filename, name, type, owner, info) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => sites/all/modules/date/tests/date_test/date_test.module [:db_insert_placeholder_1] => date_test [:db_insert_placeholder_2] => module [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => a:13:{s:4:"name";s:17:"Date module tests";s:11:"description";s:40:"Support module for date related testing.";s:7:"package";s:9:"Date/Time";s:7:"version";s:8:"7.x-2.10";s:4:"core";s:3:"7.x";s:6:"hidden";b:1;s:12:"dependencies";a:1:{i:0;s:4:"date";}s:7:"project";s:4:"date";s:9:"datestamp";s:10:"1491562090";s:5:"mtime";i:1491562090;s:3:"php";s:5:"5.2.4";s:5:"files";a:0:{}s:9:"bootstrap";i:0;} ) in system_update_files_database() (line 2314 of /var/www/html/modules/system/system.module).

Regards,
JOINSO

Comments

JOINSO created an issue. See original summary.

jyraya’s picture

Hello JOINSO,

I've just make the same update but I did not meet any problem like you.

Could you give more details about your Drupal instance like which modules dependent on "Date" you have?

Did you try the process again?

Regards.

JOINSO’s picture

Hi!

Finally I solved, but I don't remember how.

We can close the issue.

jyraya’s picture

Do you remember at least what has caused the error?

JOINSO’s picture

No, sorry!

Regards,
JOINSO

t_d_d’s picture

Had exactly same error when initiating update.php - after restarting all services (WAMP server) everything was ok. Weird.

jyraya’s picture

@t_d_d,

What do you have enabled as caching system linked to the DB level?

t_d_d’s picture

Update: reverted from backup, tried again and this time, error disappeard just by refreshing update.php few times (without actually updating) - after that, update was successful.

As for the caching, i dont really know. Default WAMP stack installation. Where can i find that?

DamienMcKenna’s picture

Status: Active » Closed (cannot reproduce)

The Date module isn't responsible for the {system} table; I'm glad it worked finally.