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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Install Error A non-recoverable error
Pages: [1]

Author Topic: Install Error A non-recoverable error  (Read 2527 times)

southern

  • Guest
Install Error A non-recoverable error
June 15, 2009, 06:04:11 pm
I have done a clean install on a newly installed Joomla! 1.5.10 website.  The database is 5.0.67.  When I installed it, I got to the completion page and got the following message:

CiviCRM
CiviCRM component files have been UPGRADED succesfully.

Please run the CiviCRM Database Upgrade Utility now. This utility will check your database and perform any needed upgrades.

When I run this utility or click on the configuration link, I get the following error:

"Sorry. A non-recoverable error has occurred.

DB Error: no such table

Database Error Code: Table 'darerudis.civicrm_contribution' doesn't exist, 1146

Return to home page."

With the following code listed below it

"Error Details:

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

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT count(civicrm_contribution.id) as DATAOBJECT_NUM
                FROM civicrm_contribution   WHERE ( is_test = 0 )  [nativecode=1146 ** Table 'darerudis.civicrm_contribution' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT count(civicrm_contribution.id) as DATAOBJECT_NUM
                FROM civicrm_contribution   WHERE ( is_test = 0 )  [nativecode=1146 ** Table 'darerudis.civicrm_contribution' 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 count(civicrm_contribution.id) as DATAOBJECT_NUM
                FROM civicrm_contribution   WHERE ( is_test = 0 )  [nativecode=1146 ** Table 'darerudis.civicrm_contribution' doesn't exist]"]
)
"

Any help would be great.  Thanks in advance.

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Install Error A non-recoverable error
June 15, 2009, 06:21:08 pm
can you get into mysql and see if the civicrm tables were created? they would all have the civicrm_ prefix.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

southern

  • Guest
Re: Install Error A non-recoverable error
June 16, 2009, 08:24:57 pm
Here is a list of the civicrm tables that are now included in my MySQL database.

civicrm_acl
   civicrm_acl_cache
   civicrm_acl_entity_role
   civicrm_activity
   civicrm_activity_assignment
   civicrm_activity_target
   civicrm_cache
   civicrm_case
   civicrm_case_activity
   civicrm_case_contact
   civicrm_component
   civicrm_contact
   civicrm_contribution_page
   civicrm_contribution_recur
   civicrm_contribution_type
   civicrm_contribution_widget
   civicrm_country
   civicrm_currency
   civicrm_custom_field
   civicrm_custom_group
   civicrm_dedupe_rule
   civicrm_dedupe_rule_group
   civicrm_discount
   civicrm_domain
   civicrm_email
   civicrm_entity_file
   civicrm_entity_tag
   civicrm_file
   civicrm_grant
   civicrm_group
   civicrm_group_contact_cache
   civicrm_group_nesting
   civicrm_group_organization
   civicrm_im
   civicrm_location_type
   civicrm_log
   civicrm_mailing
   civicrm_mailing_bounce_pattern
   civicrm_mailing_bounce_type
   civicrm_mailing_component
   civicrm_mailing_event_bounce
   civicrm_mailing_event_confirm
   civicrm_mailing_event_delivered
   civicrm_mailing_event_forward
   civicrm_mailing_event_opened
   civicrm_mailing_event_queue
   civicrm_mailing_event_reply
   civicrm_mailing_event_subscribe
   civicrm_mailing_event_trackable_url_open
   civicrm_mailing_event_unsubscribe
   civicrm_mailing_group
   civicrm_mailing_job
   civicrm_mailing_spool
   civicrm_mailing_trackable_url
   civicrm_mail_settings
   civicrm_mapping
   civicrm_mapping_field
   civicrm_membership
   civicrm_membership_block
   civicrm_membership_log
   civicrm_membership_status
   civicrm_membership_type
   civicrm_menu
   civicrm_msg_template
   civicrm_note
   civicrm_openid
   civicrm_openid_associations
   civicrm_openid_nonces
   civicrm_option_group
   civicrm_option_value
   civicrm_payment_processor
   civicrm_payment_processor_type
   civicrm_pcp
   civicrm_pcp_block
   civicrm_phone
   civicrm_pledge_block
   civicrm_preferences
   civicrm_preferences_date
   civicrm_premiums
   civicrm_premiums_product
   civicrm_price_field
   civicrm_price_set
   civicrm_price_set_entity
   civicrm_product
   civicrm_project
   civicrm_relationship
   civicrm_relationship_type
   civicrm_saved_search
   civicrm_state_province
   civicrm_subscription_history
   civicrm_tag
   civicrm_task
   civicrm_task_status
   civicrm_tell_friend
   civicrm_timezone
   civicrm_uf_match
   civicrm_worldregion

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Install Error A non-recoverable error
June 18, 2009, 07:42:03 am
Well, the short answer is that as the error message suggests, and as your list of tables confirms, the civicrm_contribution table does not currently exist in your db.

Why it wasn't created, or if it was created and later dropped, is the question.

If you're comfortable working with dbs, you could re-run the sql that creates the civi tables. It's located in the sql subfolder in the Civi package: civicrm.mysql

That script will drop all existing civi tables and recreate them. You might want to just grab the create table text for that one table instead.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Install Error A non-recoverable error

This forum was archived on 2017-11-26.