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) »
  • DR Error: no such table
Pages: [1]

Author Topic: DR Error: no such table  (Read 1375 times)

rgridley

  • I’m new here
  • *
  • Posts: 17
  • Karma: 1
  • CiviCRM version: 4.5.8
  • CMS version: WordPress
  • MySQL version: 5.5.35-cll-lve - MySQL Community Server (GPL)
  • PHP version: 5.4
DR Error: no such table
January 23, 2015, 11:19:49 am
I installed CiviVolunteer extension version 4.5-1.3.3.  I am running CiviCRM version 4.5.3 on WordPress 4.1

I had no problems downloading and installing CiviVolunteer extension.  However, when I try to enable Volunteer management for an Event I get the error message - "DR Error: no such table". 

I am able to create and edit the Volunteer Roles.

Can you provide some suggestions?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DR Error: no such table
January 23, 2015, 11:21:42 am
Can you enable Administer -> System Settings -> Debugging so the error message will be more verbose?
Try asking your question on the new CiviCRM help site.

rgridley

  • I’m new here
  • *
  • Posts: 17
  • Karma: 1
  • CiviCRM version: 4.5.8
  • CMS version: WordPress
  • MySQL version: 5.5.35-cll-lve - MySQL Community Server (GPL)
  • PHP version: 5.4
Re: DR Error: no such table
January 23, 2015, 11:34:45 am
here is the detail error message:

Database Error Code: Table 'civicrm.log_civicrm_volunteer_project' doesn't exist, 1146
Additional Details:

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

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_volunteer_project (entity_table , entity_id , target_contact_id , is_active ) VALUES ('civicrm_event' ,  7 ,  1 ,  1 )  [nativecode=1146 ** Table 'civicrm.log_civicrm_volunteer_project' doesn't exist]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_volunteer_project (entity_table , entity_id , target_contact_id , is_active ) VALUES ('civicrm_event' ,  7 ,  1 ,  1 )  [nativecode=1146 ** Table 'civicrm.log_civicrm_volunteer_project' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_volunteer_project (entity_table , entity_id , target_contact_id , is_active ) VALUES ('civicrm_event' ,  7 ,  1 ,  1 )  [nativecode=1146 ** Table 'civicrm.log_civicrm_volunteer_project' doesn't exist]"]
)

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DR Error: no such table
January 23, 2015, 11:40:07 am
Hmm, really sounds like the extension didn't successfully install. I'd suggest try again. Uninstall first if necessary.
Try asking your question on the new CiviCRM help site.

rgridley

  • I’m new here
  • *
  • Posts: 17
  • Karma: 1
  • CiviCRM version: 4.5.8
  • CMS version: WordPress
  • MySQL version: 5.5.35-cll-lve - MySQL Community Server (GPL)
  • PHP version: 5.4
Re: DR Error: no such table
January 23, 2015, 11:44:17 am
I have installed and uninstalled several time with the same results.

I did turn off "Logging" and the error has gone away.  It appears that the full logging does not work properly with CiviVolunteer.  Within my database all log file are named "log_civicrm_........"  the table that was trying to be accessed was named "civicrm.log_civicrm_volunteer_project"

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: DR Error: no such table
January 23, 2015, 11:48:05 am
Yes, looking at your error message, it's clear that the error isn't about a table belong to CiviVolunteer proper but to the logging mechanism.

Coleman, I don't know much about how the logging works; is that something that's supposed to happen automagically, or are developers supposed to do something to support it?
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DR Error: no such table
January 23, 2015, 11:55:55 am
It's supposed to be automatic. rgridley now that you've got CiviVolunteer installed, try turning logging back on and see if it doesn't pick up the new tables.
Try asking your question on the new CiviCRM help site.

rgridley

  • I’m new here
  • *
  • Posts: 17
  • Karma: 1
  • CiviCRM version: 4.5.8
  • CMS version: WordPress
  • MySQL version: 5.5.35-cll-lve - MySQL Community Server (GPL)
  • PHP version: 5.4
Re: DR Error: no such table
January 23, 2015, 01:09:48 pm
I turned logging back on and the Volunteer functionality seems to be working fine.  Thanks for your guidance.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: DR Error: no such table
January 23, 2015, 05:14:55 pm
Related thread: https://forum.civicrm.org/index.php/topic,31527.0.html
Try asking your question on the new CiviCRM help site.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions »
  • CiviVolunteer (Moderators: GinkgoFJG, Michael Z Daryabeygi) »
  • DR Error: no such table

This forum was archived on 2017-11-26.