CiviCRM Community Forums (archive)

Using Civicrm 3.0.1
I have done a test (export & import) just before setting civicrm to multi language and it works fine.

I set civicrm to multi language - export - then import to empty database and I get the following error.

#1050 - Table 'civicrm_address_en_US' already exists

This means that the import code does not drop views before trying to recreate them.

If the export was full, you can try dropping and recreating the database, then import.

If I may hijack this thread, since It's about multi-language imports: i ran into issues while mysql was trying to import the trigger statements. The bug only happens with sql exports generated by phpmyadmin (latest stable, 2.11.8 ). Exporting using the mysql command line works fine.

Here is the error when I try to import a dump generated by phpmyadmin:

ERROR 1146 (42S02) at line 1899: Table 'civimltest.v' doesn't exist

The code which caused this is:

CREATE TRIGGER `civimltest`.`civicrm_contact_before_insert` BEFORE INSERT ON `civimltest`.`civicrm_contact`
 FOR EACH ROW BEGIN IF NEW.first_name_fr_FR IS NOT NULL THEN SET NEW.first_name_en_US = NEW.first_name_fr_FR; ELSEIF NEW.first_name_en_US IS NOT NULL THEN SET [...]
THEN SELECT v.label_en_US INTO @suffix FROM civicrm_option_value v JOIN civicrm_option_group g ON (v.option_group_id = g.id) [...]

Full query here: http://paste2.org/p/618954

When using mysqldump, it uses the following form:
/*!50003 SET @SAVE_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`myuser`@`%` */ /*!50003 TRIGGER `civicrm_contact_before_insert` BEFORE INSERT ON `civicrm_contact`  [...]

After import, when I check "show triggers", it does list me the triggers, so it seems to import correctly.

It's not a major issue since our system generates daily backups using the command line tool, I just wanted to report the issue in case others also run into it.

EDIT: in fact, it seems like a known bug which has been fixed in the 3.x branch of phpmyadmin: http://sourceforge.net/tracker/index.php?func=detail&aid=2825919&group_id=23067&atid=377408

matt (bgm on #civicrm)