I installed today this new version on a new site. I goto this error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_client' for key 'PRIMARY' at:
xxxx/install.php?profile=l10n_install&locale=nl

After re-issuing the sites settingspage all continued.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

asrob’s picture

Status: Active » Postponed (maintainer needs more info)

Hi promes,

I've just installed it and everything is fine. Could you give us more info?

PROMES’s picture

The site is running on a shared server at a hostingcompany.
PHP: 5.3.2
database: MySQL
server: Apache/2.2.14 (Ubuntu)
memory-limit: 512M

timlie’s picture

Same here:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_client' for key 'PRIMARY' at:
xxxx/install.php?profile=l10n_install&locale=nl

Installing beta10 does work...

pax0r’s picture

I have the same error for me...
Ubuntu 11.10
Apache/2.2.20 (Ubuntu)
MySQL 5.1.61-0ubuntu0.11.10.1
The same Drupal version
Installing not localized version goes without any problems

EDIT: When I did not enter my key for updating localizations then alls goes ok

asrob’s picture

Status: Postponed (maintainer needs more info) » Active

Hi!

Thank you guys! You are right, this is an active issue. pax0r gave a possible workaround, http://drupal.org/node/1434122#comment-5689516. I'm trying to find what the reason of bug is.

ktdann’s picture

Okay, Im also getting the same error. My setup is :-
Ubuntu 10.04 LTS
Apache/2.2.14 (Ubuntu)
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
Using Drupal : 7.x-1.0-beta11

Although pax0r gave a possible workaround, http://drupal.org/node/1434122#comment-5689516, it didn't work for me. I tried unchecking the checkbox such that UI will actually hide the key input box but no go.

I simply reloaded the page after the error and apparently install continues and finish as success.
BUT, did it really succeed? Don't know.... Any ideas?

guidot’s picture

Lighttpd 1.4.30 and MySQL 5.1.61 (debian squeeze), PHP 5.2.6 (lenny)

Drush (4.5) seems to be more talkative:

$ drush site-install l10n_install --locale=de --db-url=mysql://dbuser:dbpassword@localhost:3306/dbname --site-name=example --site-mail=site@example.org --account-name=adminname --account-pass=adminpassword --account-mail=admin@example.org install_configure_form.site_default_country=DE
You are about to DROP your 'dbname' database and then CREATE a new one. Do you want to continue? (y/n): y
ERROR 1044 (42000) at line 1: Access denied for user 'dbuser'@'localhost' to database 'dbname'
No tables to drop.    [ok]
Starting Drupal installation. This takes a few seconds ...     [ok]
WD php: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_install' for key 'PRIMARY': INSERT INTO    [error]
{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] => l10n_install
    [:db_insert_placeholder_1] => module
    [:db_insert_placeholder_2] => 7.x
    [:db_insert_placeholder_3] => 7.x-1.0-beta11
    [:db_insert_placeholder_4] => 
    [:db_insert_placeholder_5] => http://ftp.drupal.org/files/translations/7.x/l10n_install/l10n_install-7.x-1.0-beta11.%language.po
    [:db_insert_placeholder_6] => 1
)
 in drupal_write_record() (line 6975 of /path/to/drupal/includes/common.inc).
Cannot modify header information - headers already sent by (output started at /usr/share/php/drush/includes/drush.inc:917) bootstrap.inc:1239    [warning]
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_install' 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] => l10n_install
    [:db_insert_placeholder_1] => module
    [:db_insert_placeholder_2] => 7.x
    [:db_insert_placeholder_3] => 7.x-1.0-beta11
    [:db_insert_placeholder_4] => 
    [:db_insert_placeholder_5] => http://ftp.drupal.org/files/translations/7.x/l10n_install/l10n_install-7.x-1.0-beta11.%language.po
    [:db_insert_placeholder_6] => 1
)
 in drupal_write_record() (line 6975 of /path/to/drupal/includes/common.inc).
Drush command terminated abnormally due to an unrecoverable error.    [error]

BTW: The access denied error does not seem to be a problem (the dbuser has all rights except grant), database and tables have been created succesfully.

tstoeckler’s picture

Coming from #1481824: l10n_install cannot be installed via Aegir.
Installing via Aegir I also got an integrity constraint error (while inserting into {system} though, not {l10n_update_project}).
Installing manually worked.
On Debian 6.

fl3a’s picture

@see #1567372: Integrity constraint violation during Aegir installation , think this is a l10_update issue, so corresponding patch is attached there.

JimDeLaHunt’s picture

Version: 7.x-1.0-beta11 » 7.x-1.0-beta17

I encountered this error when installing the Localized Drupal Distribution, release l10n_install 7.x-1.0-beta17 . Updating version to 7.x-1.0-beta17.

For me, deleting the contents of the text box holding the Localization Server API key worked around this problem. That is, from the page reporting the error, I clicked the browser's Back button, deleted the API key from its text box, re-entered the admin password, clicked the [Save and Continue] button, and the installation completed.

-enzo-’s picture

I have the same issue with l10n_install-7.x-1.0-beta19

pankajsubedi’s picture

Well guys i was having same problem but i tried one thing it helped me alot.
Firstly keep the field of Localization field empty and when you finally install you site then go to http://www.yoursitename.com/#overlay=user/1/edit
and paste your Localization API .
It works

TJM’s picture

I have the same issue with l10n_install-7.x-1.0-beta20
Even though the the Localization Server API key was unchecked. Yet, the error appeared: drupal SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_client' for key 'PRIMARY'
However, with page refresh, and the install continued OK.

Drunoober’s picture

Same problem :(

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_client' for key 'PRIMARY'

I posted in the following discussions... regarding a issue which might me related to this one:

https://drupal.org/node/2031839

hopefully this helps cheers.

Sk8erPeter’s picture

I can confirm this problem. When trying to install l10n_install via Drush, I get the same results like guidot did in #7, and the same when trying to install Drupal via browser:

l10n_install Integrity constraint violation

System info in short:
Windows 8 x64, IIS 8, FastCGI PHP 5.3.24, MySQL Community Server 5.1.70-community-log.

jaydee1818’s picture

Same here:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'l10n_client' for key 'PRIMARY'

Occurred while setting up Localized Drupal Distribution ( https://drupal.org/project/l10n_install ) on my Acquia Dev Desktop local environment.

asrob’s picture

Issue summary: View changes

Rolled out a new beta. I hope I will be able to testi it soon.

asrob’s picture

Version: 7.x-1.0-beta17 » 7.x-1.0-beta29
Status: Active » Fixed

I've tested it at simplytest.me and it looks good to me that's why I changed it to fixed. If you think it's still present, you can feel free to reopen it.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.