CiviCRM Community Forums (archive)

From the list of events created by goign to CivCRM/Events/Manage events.

I click on an event name and get

Sorry. A non-recoverable error has occurred.
DB Error: no such table
Error Details

Return to home page.

This happens with all events.

The URL that it tries to go to is http://website/administrator/?option=com_civicrm&task=civicrm/event/info&id=150&reset=1

If I click on "configure"/"info and settings" it works fine. Goes to

http://website/administrator/?option=com_civicrm&task=civicrm/event/manage/eventInfo&reset=1&action=update&id=150

Joomla 1.7, CiviCRM 4.0.7 (yes I know there are later versions but we need a stable website before we can upgrade  )

Hope this source helps

Seems to be implying that Table 'busclub-joomla.civicrm_acl' doesn't exist. I've inspected the database with phpmyadmin and it's right. That table doesn't exist. What's happened to it and how do i get it back?

Cheers

<div id="crm-container" lang="en" xml:lang="en">
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css);</style>
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/extras.css);</style>
  <script type="text/javascript" src="/administrator/components/com_civicrm/civicrm/js/jquery/jquery.crmaccordions.js"></script>
<div class="messages status">  <div class="icon red-icon alert-icon"></div>
 <span class="status-fatal">Sorry. A non-recoverable error has occurred.</span>
    <div class="crm-section crm-error-message"></div>
            <hr style="solid 1px" />
        <div class="crm-section crm-error-message">DB Error: no such table</div>
                <div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block">
         <div class="crm-accordion-header">
          <div class="icon crm-accordion-pointer"></div>
           Error Details         </div><!-- /.crm-accordion-header -->
         <div class="crm-accordion-body">
                                        <div class="crm-section">Database Error Code: Table 'busclub-joomla.civicrm_acl' doesn't exist, 1146</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           

• =&gt; CRM_Core_Error
[1] =&gt; handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>  SELECT      civicrm_acl.*
                        FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                            AND     civicrm_acl.entity_id      = 1 [nativecode=1146 ** Table 'busclub-joomla.civicrm_acl' doesn't exist]
    [type] => DB_Error
    [user_info] =>  SELECT      civicrm_acl.*
                        FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                            AND     civicrm_acl.entity_id      = 1 [nativecode=1146 ** Table 'busclub-joomla.civicrm_acl' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT      civicrm_acl.*
                        FROM        civicrm_acl  WHERE   civicrm_acl.entity_table   = 'civicrm_contact'
                            AND     civicrm_acl.entity_id      = 1 [nativecode=1146 ** Table 'busclub-joomla.civicrm_acl' doesn't exist]"]
)
</pre></p><p></p></div>
                     </div><!-- /.crm-accordion-body -->
        </div><!-- /.crm-accordion-wrapper -->
        <p><a href="http://joomla/administrator/" title="Main Menu">Return to home page.</a></p>
</div>
</div>
<script type="text/javascript">
cj(function() {
   cj().crmaccordions();
});
</script>



Is busclub-joomla your CiviCRM DB?

yes it is

Are there a bunch of other civicrm_ tables there?

No there aren't - only the ones for busclub-joomla

I keep 30 days worth of backups, but it's not on any of them. I'll try getting it back by reinstalling CiviCRM over the current installation (I've got a test system that doesn't matter if it get's trashed).

If that doesn't work, what do I need to do to manually re-create it and what information would be populated in there?

You tried installing into a fresh DB? civicrm_acl is a standard table so it should be there.

Try this:

CREATE TABLE `civicrm_acl` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ACL Name.',
  `deny` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'ID of the object possessing this ACL',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke','Search') COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` int(10) unsigned DEFAULT NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
  `is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this property active?',
  PRIMARY KEY (`id`),
  KEY `index_acl_id` (`acl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


That's fixed it. Also found out what had happened & it must have happened many months back. That table was excluded from the backup (I suspect it shoudl have been acl_cache) and when we did a recovery a few months back after a server crash, it wasn't restored. Strange that re-installing CiviCRM over the current system didn't re-create it though