Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12866

Enabling APCcache gives DB Error: no such field error

    Details

    • 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...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              balleyne Blaise Alleyne
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: