Details
-
Type:
Bug
-
Status: Won't Do
-
Priority:
Important
-
Resolution: Won't Do
-
Affects Version/s: 4.7.15
-
Fix Version/s: None
-
Component/s: Internationalisation
-
Labels:
-
Versioning Impact:None (no code merged)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
In trying to upgrade from 4.6.24 to 4.7.15, I've been running into the following error:
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] =>
SELECT v.label as label ,v.name as value, v.grouping as grouping
FROM civicrm_option_value_ v,
civicrm_option_group_ g
WHERE v.option_group_id = g.id
AND g.name = 'languages'
AND g.is_active = 1 AND v.is_active = 1 ORDER BY v.weight [nativecode=1146 ** Table 'civisociet206b_0.civicrm_option_value_' doesn't exist]
[type] => DB_Error
[user_info] =>
SELECT v.label as label ,v.name as value, v.grouping as grouping
FROM civicrm_option_value_ v,
civicrm_option_group_ g
WHERE v.option_group_id = g.id
AND g.name = 'languages'
AND g.is_active = 1 AND v.is_active = 1 ORDER BY v.weight [nativecode=1146 ** Table 'civisociet206b_0.civicrm_option_value_' 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 v.label as label ,v.name as value, v.grouping as grouping
FROM civicrm_option_value_ v,
civicrm_option_group_ g
WHERE v.option_group_id = g.id
AND g.name = 'languages'
AND g.is_active = 1 AND v.is_active = 1 ORDER BY v.weight [nativecode=1146 ** Table 'civisociet206b_0.civicrm_option_value_' doesn't exist]"]
)
As you can see, it's looking for tables named "civicrm_option_value_" and "civicrm_option_group_", neither of which exit. However, looking for similarly named tables resulted in:
mysql> show tables like '%civicrm_option_value%'; +-----------------------------------------------------+ | Tables_in_civisociet206bde (%civicrm_option_value%) | +-----------------------------------------------------+ | civicrm_option_value | | civicrm_option_value_en_US | +-----------------------------------------------------+ 2 rows in set (0.00 sec) mysql> show tables like '%civicrm_option_group%'; +-----------------------------------------------------+ | Tables_in_civisociet206bde (%civicrm_option_group%) | +-----------------------------------------------------+ | civicrm_option_group | | civicrm_option_group_en_US | +-----------------------------------------------------+ 2 rows in set (0.00 sec)
So, it looks to me like an i10n settings isn't being set or picked up properly. Unfortunately, I haven't been able to find where this query is being built yet, to dig any further into it.