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) »
  • What is the best way to upgrade 1.8 to the newest 1.8 should I just
Pages: [1]

Author Topic: What is the best way to upgrade 1.8 to the newest 1.8 should I just  (Read 3047 times)

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 11:32:11 am
follow the 1.7 to 1.8 instructions?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 03:57:40 pm
The 1.7 to 1.8 instructions can only be used if you're upgrading a 1.7 installation / DB. There is no "upgrade" path for alpha installs of 1.8. If this is going to be a production site - you should either start from scratch w/ new 1.8 beta install OR upgrade a copy of a 1.7 site.

It is our policy not to change DB schema once we hit beta - so you will not have this issue when upgrading 1.8 beta to newer beta releases and to 1.8 final. For Drupal installs, you'll just need to untar the latest download on top of the existing site.
« Last Edit: July 26, 2007, 04:39:06 pm by Dave Greenberg »
Protect your investment in CiviCRM by  becoming a Member!

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 04:18:06 pm
But on a previous post I was told this
Quote
The 1.7 to 1.8 upgrade script (sql/civicrm_upgradedb_v1.7_v1.8_41.mysql) was missing a required INSERT of payment processor type data. This has been corrected in the latest 1.8 revisions (as of yesterday I believe). This problem would definitely cause the error you're reporting - so I'm suspecting the site was upgraded (rather than a clean install).

We should be announcing a 1.8 beta which will have the fixes in the next 24 hours - so if possible would be best to redo the upgrade using a new beta tarball.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 04:42:31 pm
I'm a bit confused by your question. My post which you quoted below said...
"so if possible would be best to redo the upgrade using a new beta tarball."

So you can either "redo your 1.7 to 1.8 upgrade" using the new beta tarball. Or you can install a new instance of the 1.8 beta from scratch.
Protect your investment in CiviCRM by  becoming a Member!

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 05:13:42 pm
Well things are not going well but maybe there is a cached file or?
I deleted my civi apha db and created the civi beta db
But the moment I go into civicrm to sync users this happens
Top line
warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /var/www/modules/civicrm/CRM/Core/Error.php on line 173.
Then
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  103 , 'civicrm_contact,103' ,  107 ,  20070726195803 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`web15_db3/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  103 , 'civicrm_contact,103' ,  107 ,  20070726195803 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`web15_db3/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  103 , 'civicrm_contact,103' ,  107 ,  20070726195803 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`web15_db3/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`))]"]
)

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: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 05:22:39 pm

Not sure why u r seeing the mysqli error, i'll take another look at the code

However you are triggering the  error because of an old session. You should clean your session table and cache as documented in the install/upgrade instructions

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

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: What is the best way to upgrade 1.8 to the newest 1.8 should I just
July 26, 2007, 05:44:50 pm
that worked.  Sorry about that.

Thanks for your time!!!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • What is the best way to upgrade 1.8 to the newest 1.8 should I just

This forum was archived on 2017-11-26.