CiviCRM Community Forums (archive)

I've been working pretty consistently to get this program installed on my website for about the last 3 days.  If i do manage to get it to work, its a proof of the versatility of this program (i don't have ftp access to the Godaddy website itself, I've been running an extension for joomla to upload all the files, and this is my first time really using any webcode thats not html).  Ive gotten all of the files uploaded and almost entirely configured i think, although there are some critical errors I'm running into in order to get this to work.  Right now I'm getting the following error:

backTrace
/~siteroot~/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/~siteroot~/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/~siteroot~/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/~siteroot~/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/~siteroot~/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/~siteroot~/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 256
/~siteroot~/components/com_civicrm/civicrm/packages/DB.php, connect, 556
/~siteroot~/components/com_civicrm/civicrm/packages/DB/DataObject.php, connect, 2261
/~siteroot~/components/com_civicrm/civicrm/packages/DB/DataObject.php, _connect, 2485
/~siteroot~/components/com_civicrm/civicrm/packages/DB/DataObject.php, _build_condition, 411
/~siteroot~/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 153
/~siteroot~/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 347
/~siteroot~/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 185
/~siteroot~/administrator/components/com_civicrm/admin.civicrm.php, singleton, 29
/~siteroot~/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 41
/~siteroot~/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 26
/~siteroot~/libraries/joomla/application/component/helper.php, require_once, 162
/~siteroot~/administrator/includes/application.php, renderComponent, 130
/~siteroot~/administrator/index.php, dispatch, 67

Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    [ code ] => -24
   

[message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host '%ÛHost%%' (1)]
    [type] => DB_Error
    [user_info] =>  [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host '%ÛHost%%' (1)]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host '%ÛHost%%' (1)]"]
)

I think the problem right now is with the /~siteroot~/administrator/components/com_civicrm/civicrm.settings.php file, as the line about the database is still in the blank format, as follows:

/**
 * Content Management System (CMS) Datasource:
 *
 * Update this setting with your CMS (Drupal or Joomla) database username, server and DB name. Comment it out if using CiviCRM standalone.
 * Datasource (DSN) format:
 *      define( 'CIVICRM_UF_DSN', 'mysql://cms_db_username:cms_db_password@db_server/cms_database?new_link=true');
 */
define( 'CIVICRM_UF_DSN'           , 'mysql://%%CMSdbUser%%:%%CMSdbPass%%@%%CMSdbHost%%/%%CMSdbName%%?new_link=true' );

/**
 * CiviCRM Database Settings
 *
 * Database URL (CIVICRM_DSN) for CiviCRM Data:
 * Database URL format:
 *      define( 'CIVICRM_DSN', 'mysql://crm_db_username:crm_db_password@db_server/crm_database?new_link=true');
 *
 * Drupal and CiviCRM can share the same database, or can be installed into separate databases.
 *
 * EXAMPLE: Drupal and CiviCRM running in the same database...
 *      DB Name = drupal, DB User = drupal
 *      define( 'CIVICRM_DSN'         , 'mysql://drupal:YOUR_PASSWORD@localhost/drupal?new_link=true' );
 *
 * EXAMPLE: Drupal and CiviCRM running in separate databases...
 *      Drupal  DB Name = drupal, DB User = drupal
 *      CiviCRM DB Name = civicrm, CiviCRM DB User = civicrm
 *      define( 'CIVICRM_DSN'         , 'mysql://civicrm:YOUR_PASSWORD@localhost/civicrm?new_link=true' );
 *
 */
define( 'CIVICRM_DSN'          , 'mysql://%%dbUser%%:%%dbPass%%@%%dbHost%%/%%dbName%%?new_link=true' );

I think i need to input whatever database is needed, although I'm not 100 percent sure what database i need to choose.  Do i need to take the database from the current joomla user database for the website? or do i make a database for the CiviCRM?

Thanks for the help,
Dan

(Site run on GoDaddy with Joomla version 1.5.6, and newest version of CiviCRM)

As for the part in the components/com_civicrm, i guess im confused as to where the files/ which files need to be modifies in order to connect to the database

I appreciate the assistance in getting this program to work correctly.  I managed to get past the previous error and now i receive a different (although probably related) error.  I assume that there is an error in the creation of a table somewhere, although not sure what side this comes on.  The following appears when clicking on the CivicRM home inside administration:

backTrace

/%%Siteroot%%/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/%%Siteroot%%/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/%%Siteroot%%/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/%%Siteroot%%/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
/%%Siteroot%%/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 153
/%%Siteroot%%/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 347
/%%Siteroot%%/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 185
/%%Siteroot%%/administrator/components/com_civicrm/admin.civicrm.php, singleton, 29
/%%Siteroot%%/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 41
/%%Siteroot%%/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 26
/%%Siteroot%%/libraries/joomla/application/component/helper.php, require_once, 162
/%%Siteroot%%/administrator/includes/application.php, renderComponent, 130
/%%Siteroot%%/administrator/index.php, dispatch, 67
Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    [ code ] => -18
   

[message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
  [nativecode=1146 ** Table '%%Databasename%%.civicrm_domain' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 [nativecode=1146 ** Table '%%Databasename%%.civicrm_domain' 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  config_backend, locales 
 FROM civicrm_domain
 
 [nativecode=1146 ** Table '%%Databasename%%.civicrm_domain' doesn't exist]"]
)

My apologies if this is a simple, already explained problem, but thanks for the help.
Dan