CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Load localised sql data error
Pages: [1]

Author Topic: Load localised sql data error  (Read 4839 times)

Jorisvt

  • Guest
Load localised sql data error
May 09, 2007, 04:58:03 am
When importing the localised civicrm_data.nl_NL.mysql after first importing the civicrm_41.mysql I get the folowing error:

Error

SQL query:

INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved )
VALUES (
@domain_id , 'Kind van', 'Kind van', 'Kind relatie', 'Individual', 'Individual', 0
);

MySQL said: Documentation
#1062 - Duplicate entry 'Kind van-1' for key 2


What to do?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Load localised sql data error
May 09, 2007, 12:07:00 pm

There is an error in the civicrm_data.nl_NL.mysql file. This might be due to a transalation error in the system


'Child of' and 'Sibling of' have both been translated to the same nl string 'Kind Van' and hence u get the error

For a quick fix, edit the data file and fix or delete line 4098 depending on if the translation is right/wrong. I'll ask piotr to take a look at it and come up with a solution. If the translation is wrong, can u please goto translations.civicrm.org and fix the nl translations

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Load localised sql data error
May 10, 2007, 12:50:16 am
I fixed this by dropping the sibling mis-translations (my Dutch superpowers courtesy of freedict.com).

The SQL file should be fixed in the next 1.7 tarballs build.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Jorisvt

  • Guest
Re: Load localised sql data error
May 14, 2007, 01:40:16 am
I edited the file and now I get the following error:

Error

SQL query:

/******************************************************* * * civicrm_county (!! TBD) * * Look at importing county tables (re: Advokit) * *******************************************************/ INSERT INTO civicrm_country( id, name, iso_code )
VALUES (
"1001", "Afghanistan", "AF"
);

MySQL said: Documentation
#1062 - Duplicate entry '1001' for key 1


When I remove this line the error occurs on value "1002", ...etc
How can I adjust the file so the upload will succeed?

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Load localised sql data error
May 14, 2007, 01:52:10 am
The civicrm_41.mysql file does DROP TABLE IF EXISTS civicrm_county – it you’re setting up your database, you should run both these files together (just remember that the civicrm_41.mysql file drops the tables, so if you have anything of importance there, you should back it up).
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Jorisvt

  • Guest
Re: Load localised sql data error
May 14, 2007, 03:21:47 am
How do I run these file together? I can only upload one file in Phpmyadmin.

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Load localised sql data error
May 14, 2007, 04:19:38 am
By ‘together’ I meant ‘one after another’, so before any civicrm_data.nl_NL.mysql run you must run civicrm_41.mysql (which deletes and recreates the tables).
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Jorisvt

  • Guest
Re: Load localised sql data error
May 14, 2007, 04:21:35 am
That's the exact order I followed. And still I get the errors.

I'll try again...

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Load localised sql data error
May 14, 2007, 04:49:19 am
That’s strange; the civicrm_41.mysql file does drop the tables. You can always try deleting the tables yourself, of course.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Load localised sql data error

This forum was archived on 2017-11-26.