CiviCRM Community Forums (archive)

Server Info
Joomla 1.5.9
PHP 5.2.8
Apache 2.2.11 (Unix)

On the same server, but a different site.  CiviCRM 2.2 beta 2 installs correctly.  When I access CiviCRM from administrator, I receive this error:

-----------
Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 [nativecode=1054 ** Unknown column 'locales' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 [nativecode=1054 ** Unknown column 'locales' 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  config_backend, locales 
 FROM civicrm_domain
 
 [nativecode=1054 ** Unknown column 'locales' in 'field list']"]
)
[/code]

I checked and there is no locales column in the 'civicrm_domain' table.  Below is the information for that table in my instance. 

Field   Type   Null   Default   Comments
id   int(10)   No        Domain ID
name   varchar(64)   Yes    NULL    Name of Domain / Organization
description   varchar(255)   Yes    NULL    Description of Domain.
email_name   varchar(255)   Yes    NULL    The default email name that is used in the from address for all outgoing emails
email_address   varchar(255)   Yes    NULL    The default email address that is used as the from address for all outgoing emails
email_domain   varchar(64)   Yes    NULL    The domain from which outgoing email for this domain will appear to originate
email_return_path   varchar(64)   Yes    NULL    The domain from which outgoing email for this domain will appear to originate
config_backend   text   Yes    NULL    Backend configuration.
version   varchar(   Yes    NULL    The civicrm version this instance is running
loc_block_id   int(10)   Yes    NULL    FK to Location Block ID. This is specifically not an FK to avoid circular constraints

Ok, great.  I've added the locales field and now get this when I click on any link:

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

Database Error Code: Table 'digistic_lucasprk.civicrm_menu' doesn't exist, 1146

Tried uninstalling and get the error below.  Think i'm going to delete the tables from phpmyadmin and remove the civicrm folders in administrator, components and media.  Would that be a full uninstall?

Sorry. A non-recoverable error has occurred.
DB Error: constraint violation

Database Error Code: Cannot delete or update a parent row: a foreign key constraint fails, 1217

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => DROP TABLE IF EXISTS civicrm_event [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => DROP TABLE IF EXISTS civicrm_event [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TABLE IF EXISTS civicrm_event [nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]"]
)
[/quote]


there should be a file in your distribution called: sql/civicrm_drop.mysql

you can use that to drop all the tables in your db

lobo