Return to Single Language Error - as new post

[robbiemc]

Drupal 7.22
CiviCRM 4.3.5

Hi

I started a post on this some time ago but not had chance to follow things up by running a backtrace...finally got round to it and as the original post was more than 30 days old thought it best to start a new topic.

The original post was; http://forum.civicrm.org/index.php/topic,31304.msg138912.html#msg138912

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.

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]"]
)


[Erik Hommel]

The error suggest that the one of the columns in the civicrm_contribution_page should be changed, and this seems to be a core bug. I am afraid the only option left to you is to solve the bug, and then try again? I would imagine there is not a lot of experience with switching from multi-language to single-language. So I would mentally prepare for some additional hickups?

[robbiemc]

Hi Eric

Thanks for the quick response...unfortunately this is well beyond my skill set so I will wait with fingers crossed that someone else sees this post who has experienced the same and can point to a solution.

Otherwise it looks like a fresh build which would be extremely painful.

Robbie