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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Import of data only from 3.0.2 to 3.1
Pages: [1]

Author Topic: Import of data only from 3.0.2 to 3.1  (Read 1108 times)

tpascubarat

  • Guest
Import of data only from 3.0.2 to 3.1
May 25, 2010, 09:22:58 am
I have an established system running under 3.0.2.  When I attempted to do the upgrade, it was fraught with errors.  Mostly foreign key constraints and contact_type issues.  Is it possible for me to create a clone of this site (less the data) using 3.0.2, import just the data and then upgrade to 3.1?

Thanks

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: Import of data only from 3.0.2 to 3.1
May 25, 2010, 02:18:15 pm

WOuld also be good for you to check and investigate WHY your install is giving you those errors? Bugs in CiviCRM? using myisam instead of innodb etc?

check:

http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

on how to try to fix the FK issues

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

tpascubarat

  • Guest
Re: Import of data only from 3.0.2 to 3.1
May 25, 2010, 06:31:11 pm
After following the rebuild schema to the tee, I get this error:



unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: unknown error

    Database Error Code: Error on rename of './civicrm_temp/civicrm_custom_group' to './civicrm_temp/#sql2-3e23-b5d3' (errno: 152), 1025

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_custom_group`
DROP FOREIGN KEY `FK_civicrm_custom_group_created_id` [nativecode=1025 ** Error on rename of './civicrm_temp/civicrm_custom_group' to './civicrm_temp/#sql2-3e23-b5d3' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_custom_group`
DROP FOREIGN KEY `FK_civicrm_custom_group_created_id` [nativecode=1025 ** Error on rename of './civicrm_temp/civicrm_custom_group' to './civicrm_temp/#sql2-3e23-b5d3' (errno: 152)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_custom_group`
DROP FOREIGN KEY `FK_civicrm_custom_group_created_id` [nativecode=1025 ** Error on rename of './civicrm_temp/civicrm_custom_group' to './civicrm_temp/#sql2-3e23-b5d3' (errno: 152)]"]
)


The database is innodb.

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: Import of data only from 3.0.2 to 3.1
May 25, 2010, 08:25:44 pm

sorry, no idea what is happening and why :(

seems like a mysql error. might want to do a web search to see if u get any ideas as to why this is happening

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

tpascubarat

  • Guest
Re: Import of data only from 3.0.2 to 3.1
May 25, 2010, 10:24:44 pm
OK, but I am not sure what exactly to look for.  Is there any way, if I installed 3.0.2 onto another server that I can import just the data and then try to upgrade again?

tpascubarat

  • Guest
Re: Import of data only from 3.0.2 to 3.1
May 26, 2010, 01:11:11 pm
The latest error.  After creating a new db, following the instruction from http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades and trying again, I get the following:


Code: [Select]
Fatal error: Uncaught exception 'Exception' with message 'XML data could not be loaded. Make sure you specified the correct path.' in /home/lifemessage/xxxxxx.lifemessage.org/administrator/components
/com_civicrm/civicrm/packages/IDS/Filter/Storage.php:217 Stack trace: #0 /home/lifemessage/xxxxxxx.lifemessage.org/administrator/components/com_civicrm/civicrm/packages/IDS/Filter/Storage.php(108):
IDS_Filter_Storage->getFilterFromXML() #1 /home/lifemessage/xxxxxxx.lifemessage.org/administrator/components/com_civicrm/civicrm/packages/IDS/Monitor.php(167):
IDS_Filter_Storage->__construct(Object(IDS_Init)) #2 /home/lifemessage/xxxxxxx.lifemessage.org/administrator/components/com_civicrm/civicrm/CRM/Core/IDS.php(139):
IDS_Monitor->__construct(Array, Object(IDS_Init)) #3 /home/lifemessage/xxxxxx.lifemessage.org/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(78):
CRM_Core_IDS->check(Array) #4 /home/lifemessage/xxxxxxx.lifemessage.org/administrator/components/com_civicrm/admin.civicrm.php(49): CRM_Core_Invoke::in in /home/lifemessage/
xxxxxxx.lifemessage.org/administrator/components/com_civicrm/civicrm/packages/IDS/Filter/Storage.php on line 217


Any ideas???  All I want to do is take the raw data from a 3.0.2 version on an old site and place into a newly build site running 3.1.  Any suggestions???
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Import of data only from 3.0.2 to 3.1

This forum was archived on 2017-11-26.