Duplicate entry integrity constraint violation for l10n_update_file primary key

same here

same here

Retitling and marking #1020348: Duplicate entry as duplicate, since that looks to be the same issue on Drupal 6. Our schemas are the same, so should be the same problem.

same here

I have also had the same errors.
I deleted all entries in the table i10n_update_file, and then run an update of translations, the problems seems to be gone.

Edit:
The problems came back again for me too after a couple of cron runs :-(

I also nulled the table both Drupal installations. It did help about 2 cron runs, and then returned with another module name.

Then I executed a re-install on both Drupal installs. Result the same: It did help about 2 cron runs, and then returned with another module name.

I can confirm this problem, took me a while to figure out it was the updater.

Would be nice if this could be fixed soon

The notices are covered in #1029828: Undefined variable notices.

I think the issue you have here could easily be that you have profiles/defualt/translations/*.po files and then try to download files via l10n_update as well. I don't think it should break in this case (or any other case for that matter), but looking at the filename in the report I think that might be the case?!

Following

I created a patch, please review it. It is also solving the issue #1029828: Undefined variable notices

It would be nice to have the same patch for 6.x-1.x-dev version.

Can you explain why the existing code is broken and how does the fix improve it? Also, looks like you've included some indentation fixes where code is not actually changed, right?

There are 3 changes in the code.

1. Yes, the first change is just some indentation, no code change.
2. The $files variable is not exists in this function, I think this is a simple typo.
3. The setting of the $current variable occurs too late. If the contition is false before the assignment, then the $current variable is not set, but used below, outside of this condition too. And if the $current is not set -> PHP warning in the watchdog -> the „elseif ($current)” condition is false -> skip the case UPDATE -> case else with INSERT -> ooops.

Are we gonna have updated release with the fix ?
Or should be test the patch again ?

Patch which is provided by Zoltán Balogh #10 solved my issues.
Also there was an another side effect of this problem; update process is blocked by this problem, after applying the patch update process is working as it is before.

Thanks for the review, my patch works fine on my websites too.

what about Drupal 6? As I see in #3 this issue is aimed to cover the bug in D6 too

The patch for D6 is attached

it fixes the bug, thanks :)

Committed in http://drupal.org/cvs?commit=493598 and http://drupal.org/cvs?commit=493600. Also making a release available later today which should include this fix. Thanks!

I encountered an identical error today while enabling the commerce_feeds module:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'commerce_feeds' for key 'PRIMARY': INSERT INTO {l10n_update_project} (name, project_type, core, version, l10n_server, l10n_path, status) 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); Array ( [:db_insert_placeholder_0] => commerce_feeds [:db_insert_placeholder_1] => module [:db_insert_placeholder_2] => 7.x [:db_insert_placeholder_3] => 7.x-1.1 [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => http://ftp.drupal.org/files/translations/7.x/commerce_feeds/commerce_feeds-7.x-1.1.%language.po [:db_insert_placeholder_6] => 1 ) in drupal_write_record() (line 6851 of /Volumes/workspace/projecten/Lukas/www/drupal/includes/common.inc).

I am running l10n_update 7.x-1.0-beta2 and almost all other modules are up to date as well...
Let me know if you need more info.

I've seen errors like these in various modules, usually caused by the combination of a few of these factors: large site, slow server, heavy drupal process. The place where the error occurs is not necessarily the root of the problem. Do you have any indication that localization update is the source of this error? In this issue #569004: Add support for seek based batch import of .po files we are working on better handling large po files which may cause errors like these. But only during or immediately after importing po files.

Not really a lot of clues in that regard... It was on my local machine, and the site only has a dozen or so contrib modules installed. But perhaps my laptop was just acting weird during the process... So i can't know for sure if l10n_update is the the source of this error.
I ran the update batch manually now, and everything was OK, so I suppose it was a one-time error :)

No activity, closing the issue. Fee free to re-open if the problem persists.

I now have the same problem running a clean Drupal 7.9 install with only a few modules and content.
The problem appeared after doing some manipulations with the fullcalendar module. I created a fullcalendar view and then I deleted the fullcanlendar module file before deleting the view and checking the module off.. dum of me, but now I can't delete the view...

Clean install with 'drush make' and 'drush site-install'. If i remove l10n_update modul form the makefile everything is fine.

WD php: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'token' for key [error]
'PRIMARY': INSERT INTO {l10n_update_project} (name, project_type, core, version, l10n_server, l10n_path, status)
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); Array
(
[:db_insert_placeholder_0] => token
[:db_insert_placeholder_1] => module
[:db_insert_placeholder_2] => 7.x
[:db_insert_placeholder_3] => 7.x-1.1
[:db_insert_placeholder_4] =>
[:db_insert_placeholder_5] => http://ftp.drupal.org/files/translations/7.x/token/token-7.x-1.1.%langua...
[:db_insert_placeholder_6] => 1
)
in drupal_write_record() (line 7036 of /srv/http/zentest/includes/common.inc). [128.06 sec, 30.44 MB]

WD php: Warning: Cannot modify header information - headers already sent by (output started at [warning]
/usr/share/pear/drush/includes/output.inc:37) in drupal_send_headers() (line 1239 of
/srv/http/zentest/includes/bootstrap.inc). [128.17 sec, 30.46 MB]
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'token' for key 'PRIMARY': INSERT INTO {l10n_update_project} (name, project_type, core, version, l10n_server, l10n_path, status) 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); Array
(
[:db_insert_placeholder_0] => token
[:db_insert_placeholder_1] => module
[:db_insert_placeholder_2] => 7.x
[:db_insert_placeholder_3] => 7.x-1.1
[:db_insert_placeholder_4] =>
[:db_insert_placeholder_5] => http://ftp.drupal.org/files/translations/7.x/token/token-7.x-1.1.%langua...
[:db_insert_placeholder_6] => 1
)
in drupal_write_record() (line 7036 of /srv/http/zentest/includes/common.inc).

Drush command terminated abnormally due to an unrecoverable error. [128.17 sec, 30.44 MB] [error]

same here. i get this error with drush.
If i perform the installation manually everything works

Same here:

Clean install with 'drush make' and 'drush site-install'. If i remove l10n_update modul form the makefile everything is fine

this is fixed in dev version!
i think this is the issue with the patch #1373758: PDOException since upgrading to 7.x-5.0

@valderama,
If this is not fixed with dev, please can send me the makefile (and if applicable the profile) and I will have a look.

Had the same problem with Devel's reinstall module function on a clean install of a simple multilangual site. When reinstalling any module the error occured with v7.x-1.0-beta3 of Localization update, v7.x-1.0-beta3+4-dev fixed the error for me. Thanks a lot!

I have the same problem:

Clean install with 'drush make' and 'drush site-install'.

But it seems that the problem doesn't already exist in dev version.