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) »
  • Discussion »
  • Extensions »
  • CiviVolunteer (Moderators: GinkgoFJG, Michael Z Daryabeygi) »
  • installing it gives DB_Error: no such field
Pages: [1]

Author Topic: installing it gives DB_Error: no such field  (Read 1062 times)

Joachim124

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5.beta
  • CMS version: Drupal7
  • MySQL version: 5.0
  • PHP version: 5.0
installing it gives DB_Error: no such field
September 24, 2014, 02:02:53 am
I run Drupal7 civicrm 4.5 stable
the system is a single installation
i installed the files manually as described in  http://wiki.civicrm.org/confluence/display/CRMDOC/Extensions
Administrator > System Settings > Manage Extentions
 theres  CiviVolunteer on the list
--> Install - Screen (Version 4.5-1.3.2 stable)
>> Install
---------------------------------------------------------------------------
Error  Sorry but we where not able to provide this at the moment
DB Error: not such field
Return to home page
----------------------------------------------------------------------------

Dan C

  • I post frequently
  • ***
  • Posts: 179
  • Karma: 17
  • CiviCRM version: All
  • CMS version: Joomla 2.5 and 3.X, Drupal 7, Wordpress 3.7 and up
  • MySQL version: 5.1.7 and up
  • PHP version: 5.3.5 and up
Re: installing it gives DB_Error: no such field
September 24, 2014, 05:49:16 am
Can you go into the CiviCRM logs and the full error, that will tell us more about the query being run that is crashing.  In Drupal the logs are typically found in \sites\default\files\civicrm\ConfigAndLog
CrusonWeb - Web Development, Implementation, and Support.  Specializing in CiviCRM and Joomla (although also knowledgable in Wordpress and Drupal as well).

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: installing it gives DB_Error: no such field
September 24, 2014, 02:07:05 pm
Are you running a multilingual install? My guess is that this is the problem: https://issues.civicrm.org/jira/browse/VOL-70. There are some suggestions in there about how to work around the problem, but it would be great if we could get funding for this to fix the problem for everyone.
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.

Joachim124

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5.beta
  • CMS version: Drupal7
  • MySQL version: 5.0
  • PHP version: 5.0
Re: installing it gives DB_Error: no such field
September 29, 2014, 09:49:38 am
so I was away three days  ;-) !
I found the log but I'm not sure what to do !

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: installing it gives DB_Error: no such field
September 29, 2014, 10:02:36 am
Are you running a multilingual system?
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.

Joachim124

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5.beta
  • CMS version: Drupal7
  • MySQL version: 5.0
  • PHP version: 5.0
Re: installing it gives DB_Error: no such field
September 29, 2014, 03:37:30 pm
Not yet - I thought about it . Is multilingual difficult ??

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: installing it gives DB_Error: no such field
September 30, 2014, 11:27:50 am
I don't have much experience with multilingual, but there are known issues installing CiviVolunteer on multilingual CiviCRM. Enabling multilingual alters the database structure of CiviCRM, and at present CiviVolunteer isn't prepared to handle those changes.

This stack trace suggests there's a problem running a query that looks like this:
Code: [Select]
INSERT IGNORE INTO `civicrm_option_value` (`option_group_id`, `label`, `value...")
The error suggests that civicrm_option_value is missing the label column. What's the output of this SQL query?

DESCRIBE `civicrm_option_value`;
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.

Joachim124

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5.beta
  • CMS version: Drupal7
  • MySQL version: 5.0
  • PHP version: 5.0
Re: installing it gives DB_Error: no such field
October 16, 2014, 02:52:29 am
I don't use multilingual - so what can I do to avoid the error - should I add n additional field in the structure

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: installing it gives DB_Error: no such field
October 16, 2014, 07:43:06 am
Quote from: GinkgoFJG on September 30, 2014, 11:27:50 am
The error suggests that civicrm_option_value is missing the label column. What's the output of this SQL query?

DESCRIBE `civicrm_option_value`;

If your civicrm_option_value table is damaged, then I expect you'll experience issues all over CiviCRM and not just with CiviVolunteer. I think it's important to get at the root of your problem to understand what went wrong and correct it (or start over). If we just apply a bandaid to solve this problem without resolving the root issue you may find yourself covered with bandaids before you know it. Is this a fresh install of CiviCRM 4.5 or are you upgrading from a previous version?
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.

Joachim124

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.5.beta
  • CMS version: Drupal7
  • MySQL version: 5.0
  • PHP version: 5.0
Re: installing it gives DB_Error: no such field
October 21, 2014, 09:55:39 am
It's a fresh installation (with an upgrade) - I didn't do a lot with that . Do you recommend to install it again ?

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions »
  • CiviVolunteer (Moderators: GinkgoFJG, Michael Z Daryabeygi) »
  • installing it gives DB_Error: no such field

This forum was archived on 2017-11-26.