CiviCRM Community Forums (archive)

Ok, so I'm not great at this SQL stuff. I took in some external "help" who moved my Drupal/civiCRM (2.2) install to a new server. Since then, I can no longer see the civiCRM language switch block, and it has stopped working completely by throwing "DB Error: no such table" on every page. I have (had?) a multilingual install with Swedish and Spanish enabled. The _sv_se and _es_es tables are all there, but it seems as if my install has forgotten what languages are installed? Can I set the value of $locale or $dbLocale or whatever manually somewhere?
Help!

The civicrm_domain table holds (seen through phpmyadmin) "sv_SE
es_ES". Where does it get the en_US from? Can I make it default to sv_SE? I also notice that my tables are called *_sv_se in lower-case, does that matter?

Here's the error from the administer civicrm-page:

    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'civicrm.civicrm_contribution_page_en_US' doesn't exist, 1146

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT count(civicrm_contribution_page_en_US.id) as DATAOBJECT_NUM
                FROM civicrm_contribution_page_en_US   WHERE ( is_active = 1 )  [nativecode=1146 ** Table 'civicrm.civicrm_contribution_page_en_US' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT count(civicrm_contribution_page_en_US.id) as DATAOBJECT_NUM
                FROM civicrm_contribution_page_en_US   WHERE ( is_active = 1 )  [nativecode=1146 ** Table 'civicrm.civicrm_contribution_page_en_US' 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 count(civicrm_contribution_page_en_US.id) as DATAOBJECT_NUM
                FROM civicrm_contribution_page_en_US   WHERE ( is_active = 1 )  [nativecode=1146 ** Table 'civicrm.civicrm_contribution_page_en_US' doesn't exist]"]
)


Leaving a note here in case someone else is searching for this error.  The error the original poster cites indicates that the export is from an installation that is not case-sensitive which has been imported into an installation that is case sensitive.  To fix this, clear out the imported database. Open then sql dump file and globally find and replace the language codes, such as:
Find en_us and replace with en_US
All the pairs should be xx_XX.

Save and re-import.