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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Database Error Code: Unknown column 'label__' in 'field list', 1054
Pages: [1]

Author Topic: Database Error Code: Unknown column 'label__' in 'field list', 1054  (Read 1098 times)

rachelwb

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 3.3.1
  • CMS version: drupal
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.27
Database Error Code: Unknown column 'label__' in 'field list', 1054
November 24, 2013, 03:19:31 pm
I am in the process of setting up membership renewals for 2014, and I seem to be having a couple different issues related to this.

First, 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.

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

In 2011, we paid a web developer to update CiviCRM, and until we're able to locate another developer to update for us again (which I believe will solve this issue), does anyone have suggestions for fixes I could try given our current version?

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

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

Code: [Select]
=> -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']"]

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'label__' in 'field list', 1054
November 24, 2013, 03:41:53 pm

by any chance do u have or did u ever enable multi-lingual? seems like the query has been munged with bad multi-lingual data

how long have u had this issue?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

rachelwb

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 3.3.1
  • CMS version: drupal
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.27
Re: Database Error Code: Unknown column 'label__' in 'field list', 1054
November 24, 2013, 04:29:50 pm
I am not sure if we have ever enabled multi-lingual. I believe this issue has been going on since our CiviCRM update in 2011, but it has not come to light until now.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'label__' in 'field list', 1054
November 24, 2013, 04:51:13 pm

I would investigate and fix that sooner rather than later.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

rachelwb

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 3.3.1
  • CMS version: drupal
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.27
Re: Database Error Code: Unknown column 'label__' in 'field list', 1054
November 25, 2013, 07:17:45 pm
Is that something I might be able to investigate and fix myself? (not being a developer/programmer of any sort, but fairly tech-savvy...) If so, I would appreciate any insight on how to do so.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'label__' in 'field list', 1054
November 26, 2013, 06:30:40 am

i think u might need to dig into some code for this, since the column "label__" does not seem right. I suspect the query is being rewritten by the multi-lingual piece with some bad data.

CRM/Core/I18n/Schema.php, function rewriteQuery

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Database Error Code: Unknown column 'label__' in 'field list', 1054

This forum was archived on 2017-11-26.