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

Database Error Code: Unknown column 'label__' in 'field list', 1054

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 4.3.1
    • Fix Version/s: None
    • Component/s: CiviMember
    • Labels:

      Description

      Hello,

      First, I am running version 3.3.1, which was not an option above. Our organization is in the process of setting up membership renewals for 2014, and I seem to be having a couple different issues related to this.

      First, when I go to alter our membership types in order to update them with the current information, I receive the error code posted below.

      Secondly, our memberships run by calendar year, and we would like all renewals after November 1 to start January 1 of the following year. Currently, even though I believe I have this set-up correctly with a fixed period start day of 101 and fixed period rollover day of 1101, members currently renewing are receiving confirmation of a 2013 calendar year membership, not 2014. Any assistance or insight you could provide would be greatly appreciated.

      Best,
      Rachel Bishop

      Database Error Code: Unknown column 'label__' in 'field list', 1054
      Additional Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT id, label__
      FROM civicrm_relationship_type

      WHERE ( civicrm_relationship_type.id = 0 )

      [nativecode=1054 ** Unknown column 'label__' in 'field list']
      [type] => DB_Error
      [user_info] => SELECT id, label__
      FROM civicrm_relationship_type

      WHERE ( civicrm_relationship_type.id = 0 )

      [nativecode=1054 ** Unknown column 'label__' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, label__
      FROM civicrm_relationship_type

      WHERE ( civicrm_relationship_type.id = 0 )

      [nativecode=1054 ** Unknown column 'label__' in 'field list']"]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rachel@wafederation.com Rachel Bishop
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: