CiviCRM Community Forums (archive)

Hello,
After installing from the Install Directory in Joomal1.5.8, all was going just fine, I can see the that the componet has installed in Joomal. Then when I try to enter CiviCRM it came up with this Error message below.
Can any one tell me what happened?
I installed Civicrm 3.0.alpha1-joomal.zip file.
I uninstalled my older version  2.1.4 Civicrm, I wanted to upgrade to a new version 2.2.7 before I started adding names to CiviCRM.
Any help is greatly appreciated.
Thank you, Jose Ramon


Sorry. A non-recoverable error has occurred.

--------------------------------------------------------------------------------

DB Error: no such field

Database Error Code: Unknown column 'civicrm_preferences.domain_id' in 'where clause', 1054


Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]
)




Ok, great I can't wait for the new alpha version.

Thanks
Jose

I think you need to do a clean uninstall (if you don't have any data in the system) and then reinstall.
You'll want to uninstall the component, then wipe out the civicrm_ tables, and reinstall clean. I suspect the bug is a remnant from the earlier alpha version you were originally working with.

uninstalling from the joomla interface should take care of the files. what uninstalling does not do is remove the tables, which is why you'll need to do that manually.

in your db you have a ton of tables beginning with civicrm_

FYI for anyone who may have made the same simple mistake I made:

If you get the error: [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause'] when you access the upgrade script after installing civicrm 3.x, make sure you have the correct path to the upgrade script in your browser.

I was trying to upgrade via !http://server.org/civicrm/admin/upgrade?reset=1 (should be /civicrm/upgrade?reset=1).

All attempts to access civicrm (except the upgrade path) will result in that error until you upgrade.

jamie