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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • getting CRM core error when moving the website to a new server
Pages: [1]

Author Topic: getting CRM core error when moving the website to a new server  (Read 929 times)

asphpguy

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal 7.15
  • MySQL version: 5.5
  • PHP version: 5
getting CRM core error when moving the website to a new server
February 21, 2013, 03:45:45 pm
Hi guys
I'm trying to move a Drupal based website with civiCRM plugin to a new server. I've moved all directories/files and database. I'm keeping to get "Initialization Error: [nativecode=1146 ** Table 'mysite.civicrm_domain' doesn't exist]" error just on the very first touch to the home page. I searched for a few hours but got nowhere because this error doesn't even let me to get in to the admin area and disable or uninstall civiCRM for a fresh install. I tried to change the status of civicrm to 0 in the system db table (on the basis of one of the solutions offered on the net) but no success. Error still is there and bugs me! Can anybody help please?

kharding

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 4
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 7
  • MySQL version: Recent
  • PHP version: 5.3.16
Re: getting CRM core error when moving the website to a new server
February 21, 2013, 03:49:45 pm
Have your database access settings changed (ie, database name, username, password) and have you updated those in the settings file?

Did you follow these instructions: http://wiki.civicrm.org/confluence/display/CRMDOC42/Moving+an+Existing+Installation+to+a+New+Server+or+Location ?

asphpguy

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal 7.15
  • MySQL version: 5.5
  • PHP version: 5
Re: getting CRM core error when moving the website to a new server
February 21, 2013, 04:19:48 pm
Yes. I did. Here are the files altered:
A) /sites/default/civicrm.settings.php:
A.1. define( 'CIVICRM_UF_DSN'           , 'mysql://my-user-name:my-pass@my-db-address/my-db-name?new_link=true' );
A.2. define( 'CIVICRM_DSN'           , 'mysql://my-user-name:my-pass@my-db-address/my-db-name?new_link=true' );
A.3. $civicrm_root = '/home/my-web-dir/public_html/sites/all/modules/contrib/civicrm';
A.4. define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/home/my-web-dir/public_html/sites/default/files/civicrm/templates_c/' );
A.5. define( 'CIVICRM_UF_BASEURL'      , 'new-site-url/' );
however I don't know what to do with this one:
A.6. define( 'CIVICRM_SITE_KEY', 'some-alpha-numeric-chars' );
Should it be replace by any other numbers?
--------------------------------
B) /sites/default/settings.php
B.1. Database info (DB_name, username, pass, host, port)

Is there anything else that I should take care of? This was all I could find thru a Goggle search.


kharding

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 4
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 7
  • MySQL version: Recent
  • PHP version: 5.3.16
Re: getting CRM core error when moving the website to a new server
February 21, 2013, 05:54:00 pm
Hmm.  Somewhere, Civi is reporting that it cannot find the required table on the database. Did that data get migrated over properly?

Do you have backups of the database?

Eileen's suggestions in this migration guide (http://wiki.civicrm.org/confluence/display/CRMDOC42/Moving+an+Existing+Installation+to+a+New+Server+or+Location) is to clear out the DB completely and get a fresh working install going on the new server and then moving *most* of the data into the database.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: getting CRM core error when moving the website to a new server
February 22, 2013, 06:36:28 am
Quote from: asphpguy on February 21, 2013, 04:19:48 pm

Is there anything else that I should take care of? This was all I could find thru a Goggle search.

As suggested above, you should install fresh to get your settings file right. Rename civicrm.settings.php and then install a fresh copy of CiviCRM into a different database.

Then once it's working, edit the good civicrm.settings.php file and change the DB connect details to your migrated DB.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

asphpguy

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal 7.15
  • MySQL version: 5.5
  • PHP version: 5
Re: getting CRM core error when moving the website to a new server
February 22, 2013, 11:20:58 am
Thank you guys for your help and forgive me if I didn't mention this on my first post:
1) The problem is that 'civicrm_domain' table doesn't exist even on the original live server but everything is still working quite well over there! Why is that? Why it doesn't need that table on the live original server but throws this error out when I try to move it to a new server?
2) How can I install a new version of civiCRM on the new server when I am not able to get into the admin area? I cannot even reach the home page because of that annoying error.
3) I read all instructions on wiki.civicrm.org (CRMDOC42/Moving+an+Existing+Installation+to+a+New+Server+or+Location ?) as Kharding pointed to. The first step mentioned here is: "Disable but do not uninstall CiviCRM in your CMS". How can I do this when I can't get into the admin area? Is there any way to do this manually by manipulating data inside the database or on the files or.....?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: getting CRM core error when moving the website to a new server
February 22, 2013, 01:09:57 pm

i dont think 1 can be true for any instance of civicrm

civicrm_domain is very much like the bootstrap table for civi

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: getting CRM core error when moving the website to a new server
February 25, 2013, 01:15:37 am
Quote from: asphpguy on February 22, 2013, 11:20:58 am
2) How can I install a new version of civiCRM on the new server when I am not able to get into the admin area? I cannot even reach the home page because of that annoying error.

I wrote above "rename civicrm.settings.php." That's how you do it. Did you try that?

Quote from: asphpguy on February 22, 2013, 11:20:58 am
3) I read all instructions on wiki.civicrm.org (CRMDOC42/Moving+an+Existing+Installation+to+a+New+Server+or+Location ?) as Kharding pointed to. The first step mentioned here is: "Disable but do not uninstall CiviCRM in your CMS". How can I do this when I can't get into the admin area? Is there any way to do this manually by manipulating data inside the database or on the files or.....?

If for some reason, the above does not get you back into your site, then you can disable the CiviCRM module directly in the system table of the Drupal database.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

asphpguy

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal 7.15
  • MySQL version: 5.5
  • PHP version: 5
Re: getting CRM core error when moving the website to a new server
March 01, 2013, 02:23:50 pm
Guys,
thanks all of you to help me to work this out. Actually there was a separated database for civiCRM on the old server which I didn't know about it. Donold opened my eyes on it :D
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • getting CRM core error when moving the website to a new server

This forum was archived on 2017-11-26.