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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Migration Issues
Pages: [1]

Author Topic: Migration Issues  (Read 860 times)

prakharcse

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.2.13
  • CMS version: Drupal 7
  • MySQL version: 4.5.6
  • PHP version: 5.0
Migration Issues
February 06, 2014, 09:43:27 pm
Hi

I have migrated civicrm 3.2 to civicrm 4.2.13 from d6 to d7 . I have migrated successfully. But  some links are broken inside the crm and showing following error

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.

For example page like
?q=civicrm/member&reset=1
?q=civicrm/event&reset=1
etc. are showing same error.

Also going through configandlog of civicrm i found following errors:

Feb 06 00:56:55  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT MAX(id) FROM civicrm_sms_provider WHERE is_active = 1 [nativecode=1146 ** Table 'final.civicrm_sms_provider' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT MAX(id) FROM civicrm_sms_provider WHERE is_active = 1 [nativecode=1146 ** Table 'final.civicrm_sms_provider' 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 MAX(id) FROM civicrm_sms_provider WHERE is_active = 1 [nativecode=1146 ** Table 'final.civicrm_sms_provider' doesn't exist]"]
)

Please Help me out of this.
« Last Edit: February 06, 2014, 10:12:21 pm by prakharcse »

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Migration Issues
February 07, 2014, 01:53:28 am
Did you migrate step by step? There is a link on migration D6 -> D7 and Civi at the same time:
https://civicrm.org/blogs/spidersilk/best-practices-upgrading-drupal-6-7-and-civicrm-3-4-same-time
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

prakharcse

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.2.13
  • CMS version: Drupal 7
  • MySQL version: 4.5.6
  • PHP version: 5.0
Re: Migration Issues
February 07, 2014, 01:56:28 am
Yes I have performed migration same way as mentioned in that blog.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Migration Issues
February 07, 2014, 01:59:33 am
Hmm most cases I have heard off when tables where not there where caused by not following the incremental path when upgrading. I assume all your database rights were OK so tables could have been created?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

prakharcse

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.2.13
  • CMS version: Drupal 7
  • MySQL version: 4.5.6
  • PHP version: 5.0
Re: Migration Issues
February 07, 2014, 02:17:31 am
Is there any other way to get rid from this error.

balleyne

  • I’m new here
  • *
  • Posts: 14
  • Karma: 1
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: Migration Issues
February 07, 2014, 02:30:24 pm
Are you sure it's 4.2.13?

In your first message ( http://forum.civicrm.org/index.php/topic,31553.msg135193.html#msg135193 ), you said:
Quote
I am migrating d6 to d7 same time i have to migrate civicrm 3.2 to civicrm 4.4.3

But in this thread, you said:
Quote
I have migrated civicrm 3.2 to civicrm 4.2.13 from d6 to d7

And, then, in your first post to the other thread, you said the error message was:
Quote
Your database is marked with an unexpected version number: 4.4.3. The v4.2.13 codebase may not be compatible with your database state.

So...
  • Assuming you followed in instructions the same way as mentioned in the blog, which version of CiviCRM did you actually upgrade to under Drupal 6? 4.2.13 or 4.4.3?
  • When you moved from D6 to D7, are you sure that you changed from the D6 version of CiviCRM to the same corresponding D7 version of CiviCRM? (i.e. civicrm-4.2.13-drupal6 => civicrm-4.2.13-drupal OR civicrm-4.4.3-drupal6 => civicrm-4.4.3-drupal)

It seems like you may have mixed up the versions during your process... See Hershel's recommendations here as well, for getting a fresh copy of the correct code: http://forum.civicrm.org/index.php/topic,31565.msg135223.html#msg135223


As Erik mentioned, this is often a problem with the upgrade path, I think. I'm pretty sure that the table civicrm_sms_provider does not exist in CiviCRM 3.2 (I don't see any reference to it in the CiviCRM 3.2 codebase when I search the entire codebase for "sms_provider", nor do I see it in the database of an operational 3.2 CiviCRM installation.) My guess is that this table (and likely some others?) should have been created at some point during the proper incremental upgrade path...

Did you follow the official upgrade documentation, in particular around running the CiviCRM Upgrade Script e.g. for 4.4.x
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+4.4+-+Drupal+6#UpgradeDrupalSitesto4.4-Drupal6-9.RuntheUpgradescript
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+4.4+-+Drupal+7#UpgradeDrupalSitesto4.4-Drupal7-10.RuntheUpgradescript

Note that this is not the same as Drupal's update.php. Also, I'm not sure whether it'd be safe or wise to just run that at this point, as I'm not sure what the current state of the CiviCRM installation is like... not sure what to suggest, beyond making backups before trying anything in case you need to revert.

Hope that helps...
« Last Edit: February 07, 2014, 02:32:44 pm by balleyne »

prakharcse

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 4.2.13
  • CMS version: Drupal 7
  • MySQL version: 4.5.6
  • PHP version: 5.0
Re: Migration Issues
February 10, 2014, 05:55:23 am
hi balleyne,

Actually now i am upgrading 3.4.4 to 4.2.13 civicrm. Now when I start upgrading the version of civicrm on drupal6  it gives me error which i am sharing with you in this  post. Also when i enable the debugger of civicrm then on error pages i got following db errors.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Migration Issues
February 23, 2014, 04:01:28 pm
So, the first screen shot is telling you it is about to do some clean ups on your data which you might like to read about & renew. These include things like more than one membership linked to one contribution.  Did you click on the link to do the cleanup?

I think if I were you I would upgrade to 4.1, possibly do those cleanups, get your db all backed up. Update the UF_NAME setting in your civicrm.settings.php and then proceed.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Migration Issues

This forum was archived on 2017-11-26.