Details
-
Type: Bug
-
Status: Won't Do
-
Priority: Major
-
Resolution: Won't Do
-
Affects Version/s: 4.3.4
-
Fix Version/s: Unscheduled
-
Component/s: Core CiviCRM
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
Description
I tried setting the cache to 'APCcache' on two CiviCRM 4.3.4 sites today on the same server. On one site, it worked just fine. On the other site, it crashed everything with a "DB Error: no such field" error.
Digging through the log file, I found this:
#3 /usr/local/drupal7/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\nSELECT\n option_value.id as id,\n option_value.label as ...")
#4 /usr/local/drupal7/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "\nSELECT\n option_value.id as id,\n option_value.label as ...")
#5 /usr/local/drupal7/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "\nSELECT\n option_value.id as id,\n option_value.label as ...", "DB_Error", TRUE)
#6 /usr/local/drupal7/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'option_value.label' in 'field list'")
On this site, I have localization enabled. (On the site where APCcache worked fine, I do not.) I checked the option_value table, and sure enough, there is no column 'label', but rather a column 'label_en_CA'.
My guess is that this is a bug in the APCcache code and localized CiviCRM sites?
Let me know if you need more information...