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 (Moderator: Dave Greenberg) »
  • Migrating to new Host
Pages: [1]

Author Topic: Migrating to new Host  (Read 1788 times)

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Migrating to new Host
October 30, 2013, 03:28:12 pm
hello,

We migrated the site from a stand alone physical server to a hosting provider (HostPapa). I followed the Instructions on this page http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location
Everything seems to working fine on the drupal side, but as soon as we try to do something involving CiviCRM we get message Sorry but we are not able to provide this at the moment.

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

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Return to home page.

Can anyone help with this.....

Thanks in advance.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Migrating to new Host
October 31, 2013, 07:30:26 am
Did you remove all template cache files?

The other option is to REMOVE your civicrm.settings.php file and then install CiviCRM into a fresh, empty DB. Then you are sure CiviCRM installs and runs properly and now your civicrm.settings.php file is good.

Then just edit your civicrm.settings.php file to "point" it to your real 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.

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Migrating to new Host
October 31, 2013, 08:18:11 am
Hello Hershel,

Will try a brand new install and redirect to existing database, will let you know. Did not think of that.

Thanks..

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Migrating to new Host
October 31, 2013, 06:32:23 pm
New install and reconfigure to old database did not work.
Still getting same errors.

I have compared the database dump headers. Could it be database engine incompatibilities?
Old server:
-- MySQL dump 10.13  Distrib 5.1.66, for debian-linux-gnu (i486)
--
-- Host: localhost    Database: candowser_crm
-- ------------------------------------------------------
-- Server version   5.1.66-0+squeeze1

New server:
-- MySQL dump 10.13  Distrib 5.5.32, for Linux (x86_64)
--
-- Host: localhost    Database: canad356_civicrm
-- ------------------------------------------------------
-- Server version   5.5.32-cll

Thanks ahead of time for any help....

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Migrating to new Host
October 31, 2013, 09:54:26 pm
Here is a copy of the log for October 31.

Thank you..

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Migrating to new Host
November 01, 2013, 02:26:12 am
The problem has to do with the "DEFINER" that is in your MySQL dump. Your dump has a definer set that is invalid on the new server. You would need to edit the raw dump file and remove any DEFINER definitions and then re-import the dump.
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.

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Migrating to new Host
November 01, 2013, 09:35:07 am
The definer's in the mysqldump have been fixed using instructions from this page http://xplus3.net/2013/10/10/remove-definer-clause-mysqldump/

Created a new database and imported the dump into it.  (Went fine no errors).

Then modified civicrm.settings.php to point to new database, user and password.

Still getting the error.  "Sorry but we are not able to provide this at the moment.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc 
Return to home page.
Copy of todays log attached

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Migrating to new Host
November 02, 2013, 11:46:10 am
Now the error is FUNCTION canad356_civicrm1.civicrm_strip_non_numeric does not exist] and if you Google for FUNCTION  civicrm_strip_non_numeric does not exist you will find plenty of reports of this issue. There is one solution here http://forum.civicrm.org/index.php/topic,28652.msg123690.html#msg123690 and on page 3 of that thread also is another solution.
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.

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Migrating to new Host
November 02, 2013, 01:41:17 pm
My solution for this issue,  was to put the drupal 6 site offline.
1.   to delete Civicrm and all Civicrm directories from the site
2.   restore all the Civicrm from backup before migration
3.   create a new database and give all privileges to the existing user
4.   massage the last database dump before migration with the following command
    sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' old dump.sql > new dump.sql
5.   Restore the new database with the new dump.sql
6.   Modify the /sites/default/civicrm.settings.php to point to new database, user and password.
7.   Apply all the modifications from the following page  http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location
8.   In my case, because I don’t have access to the old server anymore, I emptied the 4 cash mentioned in the database.
9.   Copy the Confi.IDS.ini file from the /sites/default /files/civicrm/ConfigAndLog to /sites/default/files/civicrm/upload/Config.IDS.ini (Resolve all XML issues)
10.   And recreate all the triggers which is not part of the previous document using http://(site domain name)/civicrm/menu/rebuild?reset=1&triggerRebuild=1
11. Review all configurations of the site using http://(site domain name)/civicrm/admin/configtask?reset=1
12. Put the site online.
13. Test everything.... on going.

I wish to thank Hershel for all his expertise and guiding me to appropriate solution.

Thank you Hershel
« Last Edit: November 02, 2013, 03:11:00 pm by silvereagle »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Migrating to new Host

This forum was archived on 2017-11-26.