CiviCRM Community Forums (archive)

Hi,

I am using civicrm on a own server (centos) with a dynamic public IP. The IP changed from the original when I installed it, and civi crm stopped working. So I searched for the old IP and found it in two places. First the civicrm_domain table, second the civicrm.settings.php. Meanwhile I have created a dyndns host so I don't have to change these values again. But now I get the following error:
(I have tried to search the entire forum for such an error message, but all I found was related to upgrade. Which is not my case)
Is there any other place I need to change some values? Obviously putting back the old IP is not a solution because that belongs to some else now.
The CIVICRM_DSN and CIVICRM_UF_DSN variables have localhost as a mysql server (and that has not changed)


Sorry. A non-recoverable error has occurred.
DB Error: no such table
Error Details
Database Error Code: Table 'agcdb.civicrm_contact_type_' doesn't exist, 1146
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT    c.name as child_name , c.label as child_label , c.id as child_id,
          p.name as parent_name, p.label as parent_label, p.id as parent_id
FROM      civicrm_contact_type_ c
LEFT JOIN civicrm_contact_type_ p ON ( c.parent_id = p.id )
WHERE     ( c.name IS NOT NULL )

AND   c.is_active = 1
AND   ( p.is_active = 1 OR p.id IS NULL )
 ORDER BY c.id [nativecode=1146 ** Table 'agcdb.civicrm_contact_type_' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT    c.name as child_name , c.label as child_label , c.id as child_id,
          p.name as parent_name, p.label as parent_label, p.id as parent_id
FROM      civicrm_contact_type_ c
LEFT JOIN civicrm_contact_type_ p ON ( c.parent_id = p.id )
WHERE     ( c.name IS NOT NULL )

AND   c.is_active = 1
AND   ( p.is_active = 1 OR p.id IS NULL )
 ORDER BY c.id [nativecode=1146 ** Table 'agcdb.civicrm_contact_type_' 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    c.name as child_name , c.label as child_label , c.id as child_id,
          p.name as parent_name, p.label as parent_label, p.id as parent_id
FROM      civicrm_contact_type_ c
LEFT JOIN civicrm_contact_type_ p ON ( c.parent_id = p.id )
WHERE     ( c.name IS NOT NULL )

AND   c.is_active = 1
AND   ( p.is_active = 1 OR p.id IS NULL )
 ORDER BY c.id [nativecode=1146 ** Table 'agcdb.civicrm_contact_type_' doesn't exist]"]
)

Here is the value of the config_backend field of the domain table

a:86:{s:15:"contactUndelete";s:1:"1";s:12:"versionCheck";s:1:"1";s:14:"maxAttachments";s:1:"3";s:11:"maxFileSize";s:1:"2";s:18:"recaptchaPublicKey";s:0:"";s:19:"recaptchaPrivateKey";s:0:"";s:21:"dashboardCacheTimeout";s:4:"1440";s:15:"civiRelativeURL";s:59:"/administrator/index2.php?option=com_civicrm&task=&";s:20:"userFrameworkVersion";s:6:"1.5.14";s:27:"userFrameworkUsersTableName";s:9:"jos_users";s:18:"dateformatDatetime";s:20:"%B %E%f, %Y %l:%M %P";s:14:"dateformatFull";s:11:"%B %E%f, %Y";s:17:"dateformatPartial";s:5:"%B %Y";s:14:"dateformatYear";s:2:"%Y";s:14:"dateformatTime";s:8:"%l:%M %P";s:15:"dateInputFormat";s:8:"yy-mm-dd";s:15:"timeInputFormat";s:1:"2";s:15:"fiscalYearStart";a:2:{s:1:"M";s:1:"1";s:1:"d";s:1:"1";}s:10:"lcMessages";s:5:"en_US";s:16:"makeMultilingual";s:1:"1";s:25:"monetaryThousandSeparator";s:1:".";s:20:"monetaryDecimalPoint";s:1:",";s:11:"moneyformat";s:5:"%c %a";s:16:"moneyvalueformat";s:3:"%!i";s:12:"countryLimit";a:0:{}s:13:"provinceLimit";a:0:{}s:21:"defaultContactCountry";s:4:"1099";s:15:"defaultCurrency";s:3:"HUF";s:14:"legacyEncoding";s:12:"Windows-1252";s:23:"customTranslateFunction";s:0:"";s:14:"fieldSeparator";s:1:",";s:11:"_qf_default";s:17:"Localization:next";s:21:"_qf_Localization_next";s:4:"Save";s:13:"inheritLocale";i:0;s:21:"defaultCurrencySymbol";s:2:"Ft";s:13:"languageLimit";a:1:{s:5:"en_US";i:1;}s:16:"enableComponents";a:4:{i:0;s:10:"CiviMember";i:1;s:9:"CiviEvent";i:2;s:8:"CiviMail";i:3;s:10:"CiviReport";}s:18:"enableComponentIDs";a:4:{i:0;s:1:"3";i:1;s:1:"1";i:2;s:1:"4";i:3;s:1:"8";}s:13:"userFramework";s:6:"Joomla";s:15:"configAndLogDir";s:69:"/var/www/html/nossl/agc/media/civicrm/templates_c/en_US/ConfigAndLog/";s:11:"initialized";i:0;s:15:"DAOFactoryClass";s:23:"CRM_Contact_DAO_Factory";s:17:"componentRegistry";O:18:"CRM_Core_Component":0:{}s:9:"inCiviCRM";b:0;s:5:"debug";i:0;s:9:"backtrace";i:0;s:9:"smartyDir";N;s:10:"pluginsDir";N;s:11:"templateDir";N;s:12:"resourceBase";N;s:9:"uploadDir";s:45:"/var/www/html/nossl/agc/media/civicrm/upload/";s:14:"imageUploadDir";s:57:"/var/www/html/nossl/agc/media/civicrm/persist/contribute/";s:19:"customFileUploadDir";s:45:"/var/www/html/nossl/agc/media/civicrm/custom/";s:14:"imageUploadURL";s:51:"http://84.3.69.128/media/civicrm/persist/contribute/";s:15:"currencySymbols";s:0:"";s:14:"gettextCodeset";s:5:"utf-8";s:13:"gettextDomain";s:7:"civicrm";s:24:"userFrameworkResourceURL";s:63:"http://84.3.69.128/administrator/components/com_civicrm/civicrm/";s:21:"userFrameworkFrontend";b:0;s:20:"userFrameworkLogging";b:0;s:17:"maxImportFileSize";i:1048576;s:7:"civiHRD";i:0;s:11:"mapProvider";N;s:9:"mapAPIKey";N;s:13:"geocodeMethod";s:0:"";s:12:"mapGeoCoding";i:1;s:9:"enableSSL";b:0;s:18:"fatalErrorTemplate";s:20:"CRM/common/fatal.tpl";s:17:"fatalErrorHandler";N;s:17:"maxLocationBlocks";i:2;s:15:"captchaFontPath";s:25:"/usr/X11R6/lib/X11/fonts/";s:11:"captchaFont";s:17:"HelveticaBold.ttf";s:21:"includeWildCardInName";i:1;s:18:"includeEmailInName";i:1;s:21:"includeNickNameInName";i:0;s:22:"smartGroupCacheTimeout";i:0;s:22:"defaultSearchProfileID";N;s:15:"doNotResetCache";i:0;s:24:"includeAlphabeticalPager";i:1;s:20:"includeOrderByClause";i:1;s:13:"oldInputStyle";i:1;s:14:"formKeyDisable";b:0;s:13:"verpSeparator";s:1:".";s:12:"mailerPeriod";i:180;s:16:"mailerSpoolLimit";i:0;s:16:"mailerBatchLimit";i:0;}


thanks for any help
tom

thanks for the help, it worked