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) »
  • DB Error
Pages: [1]

Author Topic: DB Error  (Read 4553 times)

joseramonjr

  • Guest
DB Error
August 09, 2009, 06:42:04 pm

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
            )

       
Code: [Select]
=> -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']"]
)



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: DB Error
August 09, 2009, 06:52:02 pm
That's a bug that will be fixed in the next alpha version. See this thread for details and a fix:
http://forum.civicrm.org/index.php/topic,9191.msg39707.html#msg39707
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

joseramonjr

  • Guest
Re: DB Error
August 10, 2009, 08:25:42 am
Ok, great I can't wait for the new alpha version.

Thanks
Jose

joseramonjr

  • Guest
Re: DB Error
September 29, 2009, 07:38:44 pm
Hello, I did a new install with civiCRM 2.2.9, 3.0 alph3  and I got the following error. I had no problems getting it to install, then when I went to the componet it gave me this error.

Any help would be greatful.
Jose


Error Details:


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

       
Code: [Select]
=> -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']"]
)

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: DB Error
September 29, 2009, 07:45:35 pm
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.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

joseramonjr

  • Guest
Re: DB Error
September 29, 2009, 07:58:26 pm
ok. Thanks I will try that.
But how will I know if I have clean uninstall? What other files will be left over that I have to delete?

Jose

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: DB Error
September 29, 2009, 08:27:48 pm
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.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

joseramonjr

  • Guest
Re: DB Error
September 29, 2009, 08:33:49 pm
I uninstalled civiCRM but I could not find the civicrm_table.  I deleted every thing that I could find for crm but I did not see that _table file.
Where do I find that civicrm_table file?

Thanks, Jose

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: DB Error
September 29, 2009, 08:56:15 pm
in your db you have a ton of tables beginning with civicrm_
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

joseramonjr

  • Guest
Re: DB Error
September 29, 2009, 09:25:16 pm
OH, great I got it to install correctly and it is working.

Thanks for all the help.

Jose

jamie

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 6
Re: DB Error
November 18, 2009, 09:23:45 am
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

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

This forum was archived on 2017-11-26.