CiviCRM Community Forums (archive)

Drupal 7.22
CiviCRM 4.3.5

Hi all

I started a post on this some time ago in localisation but it seems that not as many people view this section so fingers crossed I can find a solution here. This really is relevant because the reason behind the need to switch to single language is so I may update to the latest version of Civi...which I can't do until this issue is resolved.

I originally had a multi-language setup as we had an office in the Netherlands and a proposed office in Catalonia. This is no longer the case and I wished to revert back to a single language but in doing so an error is thrown up. The reason for wishing to revert back to single language was also due to wanting to update to the latest Civi version.

The results of the back trace and Initialization Error thrown up when returning to home page are below.

If anyone has any ideas how to resolve this please advise...really hate the thought of a completely new build.

The post in the localisation section is; http://forum.civicrm.org/index.php/topic,32969.msg140518.html#msg140518

Apologies for the double posting but I really am stuck here.

cheers
Robbie

backTrace

#0 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/ehfa/www/www/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB [nativecod...")
#4 /home/ehfa/www/www/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB [nativecod...")
#5 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB [nativecod...", "DB_Error", TRUE)
#6 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or...")
#7 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB")
#9 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB")
#10 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB")
#11 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB")
#12 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/I18n/Schema.php(210): CRM_Core_DAO->query("UPDATE civicrm_contribution_page SET intro_text = intro_text_en_GB", FALSE)
#13 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/I18n/Schema.php(138): CRM_Core_I18n_Schema::makeSinglelingualTable("en_GB", "civicrm_contribution_page")
#14 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Localization.php(312): CRM_Core_I18n_Schema::makeSinglelingual("en_GB")
#15 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Admin_Form_Setting_Localization->postProcess()
#16 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#17 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Setting_Localization), "next", "Next")
#18 /home/ehfa/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Setting_Localization), "next")
#19 /home/ehfa/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Setting_Localization), "next")
#20 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("next")
#21 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#22 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(266): CRM_Utils_Wrapper->run("CRM_Admin_Form_Setting_Localization", "Languages, Currency, Location", NULL)
#23 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#24 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#25 /home/ehfa/www/www/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:4))
#26 [internal function](): civicrm_invoke("admin", "setting", "localization")
#27 /home/ehfa/www/www/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
#28 /home/ehfa/www/www/index.php(21): menu_execute_active_handler()
#29 {main}



Initialization Error

Array
(
    [callback] => Array
        (
           

    => CRM_Core_Error
    [1] => simpleHandler
            )

       

Code: [Select]

 => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT
   option_value.id          as id,
   option_value.label       as label,
   option_value.value       as value,
   option_value.name        as name,
   option_value.description as description,
   option_value.weight      as weight,
   option_value.is_active   as is_active,
   option_value.is_default  as is_default
FROM
   civicrm_option_value_en_GB  as option_value,
   civicrm_option_group_en_GB  as option_group  WHERE option_group.id = option_value.option_group_id  AND option_group.name = 'languages' ORDER BY weight [nativecode=1146 ** Table 'ehfa_civicrm.civicrm_option_value_en_GB' doesn't exist]"]
)