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) »
  • DB Error After attempt to switch from Multi to single language
Pages: [1]

Author Topic: DB Error After attempt to switch from Multi to single language  (Read 1509 times)

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
DB Error After attempt to switch from Multi to single language
September 09, 2012, 09:16:07 am
I am running on Drupal version 7.

I attempted to switch from Multi to single language and immediately got a db error. Now whenever a new user tries to register they get a DB Error: no such table

What can I do?

Please help!

Thanks!
« Last Edit: September 09, 2012, 09:20:51 am by Johnbmtl »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 09:35:50 am
Can you post the full error message?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 09:50:40 am
Full message:

Sorry but we are not able to provide this at the moment.
DB Error: no such table

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 10:02:06 am
Can you enable debugging in CiviCRM?

http://wiki.civicrm.org/confluence/display/CRMDOC41/Debugging
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:41:06 am
When I try to enable the dBlog module I get the following:


Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_location_type_before_update before update ON civicrm_location_type FOR EACH ROW BEGIN  IF NEW.display_name_en_CA IS NOT NULL THEN IF NEW.display_name_fr_CA IS NULL THEN SET NEW.display_name_fr_CA = NEW.display_name_en_CA; END IF; ELSEIF NEW.display_name_fr_CA IS NOT NULL THEN IF NEW.display_name_en_CA IS NULL THEN SET NEW.display_name_en_CA = NEW.display_name_fr_CA; END IF; END IF; END [nativecode=1054 ** Unknown column 'display_name_en_CA' in 'NEW']
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_location_type_before_update before update ON civicrm_location_type FOR EACH ROW BEGIN  IF NEW.display_name_en_CA IS NOT NULL THEN IF NEW.display_name_fr_CA IS NULL THEN SET NEW.display_name_fr_CA = NEW.display_name_en_CA; END IF; ELSEIF NEW.display_name_fr_CA IS NOT NULL THEN IF NEW.display_name_en_CA IS NULL THEN SET NEW.display_name_en_CA = NEW.display_name_fr_CA; END IF; END IF; END [nativecode=1054 ** Unknown column 'display_name_en_CA' in 'NEW']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_location_type_before_update before update ON civicrm_location_type FOR EACH ROW BEGIN  IF NEW.display_name_en_CA IS NOT NULL THEN IF NEW.display_name_fr_CA IS NULL THEN SET NEW.display_name_fr_CA = NEW.display_name_en_CA; END IF; ELSEIF NEW.display_name_fr_CA IS NOT NULL THEN IF NEW.display_name_en_CA IS NULL THEN SET NEW.display_name_en_CA = NEW.display_name_fr_CA; END IF; END IF; END [nativecode=1054 ** Unknown column 'display_name_en_CA' in 'NEW']"]
)

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:43:36 am
I'm getting detailed messages now.
When I try to register a new user I get the following:


Base de donnée de code d'erreur: Table 'jwbabiak_civicrm.civicrm_location_type_fr_CA' doesn't exist, 1146
Détails additionnels:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT  id, name 
 FROM civicrm_location_type_fr_CA
 
 WHERE (  civicrm_location_type_fr_CA.is_active = 1 ) 
 
 
 ORDER BY name 
 [nativecode=1146 ** Table 'jwbabiak_civicrm.civicrm_location_type_fr_CA' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT  id, name 
 FROM civicrm_location_type_fr_CA
 
 WHERE (  civicrm_location_type_fr_CA.is_active = 1 ) 
 
 
 ORDER BY name 
 [nativecode=1146 ** Table 'jwbabiak_civicrm.civicrm_location_type_fr_CA' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  id, name 
 FROM civicrm_location_type_fr_CA
 
 WHERE (  civicrm_location_type_fr_CA.is_active = 1 ) 
 
 
 ORDER BY name 
 [nativecode=1146 ** Table 'jwbabiak_civicrm.civicrm_location_type_fr_CA' doesn't exist]"]
)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:44:49 am
You have English and French it seems. Was the CiviCRM install initially English and now you are adding French?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:49:31 am
Quote from: Hershel on September 09, 2012, 11:44:49 am
You have English and French it seems. Was the CiviCRM install initially English and now you are adding French?

Originally English and I had installed French afterwards and both were working.
It's when I tried switching from multi-language to single that the errors started.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:51:24 am
I have no idea. Can you try to reproduce this on the CiviCRM demo?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Johnbmtl

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 11:56:10 am

How can I de-install and then re-install CiviCRM ?

Or should I say: Can I de-install and then re-install CiviCRM ?
« Last Edit: September 09, 2012, 12:01:01 pm by Johnbmtl »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error After attempt to switch from Multi to single language
September 09, 2012, 12:34:34 pm
To deinstall:

1. Drop all CiviCRM tables from your database. If it fails the first time, just keep doing it 'til it works.
2. Remove sites/default/civicrm.settings.php
3. Install fresh normally
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • DB Error After attempt to switch from Multi to single language

This forum was archived on 2017-11-26.