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) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Return to Single Language Error - as new post
Pages: [1]

Author Topic: Return to Single Language Error - as new post  (Read 2375 times)

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Return to Single Language Error - as new post
June 04, 2014, 04:41:37 pm
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]"]
)
« Last Edit: June 04, 2014, 04:43:08 pm by robbiemc »

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Return to Single Language Error - as new post
June 04, 2014, 11:39:08 pm
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?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Re: Return to Single Language Error - as new post
June 05, 2014, 03:34:13 am
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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Return to Single Language Error - as new post

This forum was archived on 2017-11-26.