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) »
  • Manual Upgrade of DB from 4.0 to 4.1?
Pages: [1]

Author Topic: Manual Upgrade of DB from 4.0 to 4.1?  (Read 1448 times)

mtorgler

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7.8
  • MySQL version: 5.0.91-log
  • PHP version: 5.2.17
Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 05:03:50 am
I'm trying to find information on how to manually upgrade my database from 4.0.6 to 4.1

My php became conflicted when I upgraded drupal, sotrying a new installation out but the upgrade script is throwing a 500 error that I can't find a trace on to pinpoint the issue

The clean installation works great, if I can just upgrade my database and swap them out, I would be golden.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 06:23:32 am
If you have a new install that works, then just edit sites/default/civicrm.settings.php and change the CiviCRM DB pointer to your old database and then visit

civicrm/upgrade?reset=1

to run the CiviCRM upgrader.
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.

mtorgler

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7.8
  • MySQL version: 5.0.91-log
  • PHP version: 5.2.17
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 07:16:24 am
Did that (per the installation instructions)

civicrm/upgrade?reset=1is  the page that throws the 500 error

Updated:  Here;s the url throwing the error

http://alumni.kstheta.org/civicrm/upgrade?reset=1


Quote from: Hershel on March 22, 2012, 06:23:32 am
If you have a new install that works, then just edit sites/default/civicrm.settings.php and change the CiviCRM DB pointer to your old database and then visit

civicrm/upgrade?reset=1

to run the CiviCRM upgrader.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 07:23:47 am
For a 500 error, you need to check your server logs to see the details of the error.
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.

mtorgler

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7.8
  • MySQL version: 5.0.91-log
  • PHP version: 5.2.17
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 07:56:14 am
You are correct!  I do need server logs, and I have logged a ticket with my host to see what is being thrown

But, being able to keep things within my own power, I go back to the original question

I only need to do a database update to the mySQL Schema

Is there a SQL file, or SQL inside of a PHP, that I can run in phpMyAdmin to perform the same function?

I've found the SQL in modules/civicrm/sql, can one of those be ran to accomplish what I need

mtorgler

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7.8
  • MySQL version: 5.0.91-log
  • PHP version: 5.2.17
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 22, 2012, 01:57:51 pm
This was the only error that they could find

[Thu Mar 22 14:42:32 2012] [error] [client 99.174.74.142] Premature end of script headers: index.php

mtorgler

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7.8
  • MySQL version: 5.0.91-log
  • PHP version: 5.2.17
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 23, 2012, 05:18:49 am
still could really use some help here

Here's the full list from the error logs

[Wed Mar 21 11:36:08 2012] [error] [client 64.126.7.94] Directory index forbidden by Options directive: /home/ksthetao/public_html/alumni/
[Wed Mar 21 11:36:08 2012] [error] [client 64.126.7.94] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.
[Wed Mar 21 11:36:08 2012] [error] [client 64.126.7.94] File does not exist: /home/ksthetao/public_html/alumni/favicon.ico
[Wed Mar 21 11:43:55 2012] [error] [client 64.126.7.94] Directory index forbidden by Options directive: /home/ksthetao/public_html/alumni/
[Wed Mar 21 11:43:55 2012] [error] [client 64.126.7.94] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.
[Wed Mar 21 11:46:35 2012] [error] [client 64.126.7.94] Directory index forbidden by Options directive: /home/ksthetao/public_html/torgler/
[Wed Mar 21 11:46:35 2012] [error] [client 64.126.7.94] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.
[Wed Mar 21 11:46:35 2012] [error] [client 64.126.7.94] File does not exist: /home/ksthetao/public_html/torgler/favicon.ico
[Wed Mar 21 13:00:19 2012] [error] [client 64.126.7.94] File does not exist: /usr/local/apache/htdocs/favicon.ico
[Wed Mar 21 15:25:05 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:25:05 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:25:19 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:26:47 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:28:23 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:28:23 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:29:22 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:29:22 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:31:44 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:31:44 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:35:36 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:35:36 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:45:07 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:45:07 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:45:18 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:45:18 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:50:28 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:50:28 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:13 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:13 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:24 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:24 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:26 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Wed Mar 21 15:51:27 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Thu Mar 22 09:14:15 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Thu Mar 22 09:14:15 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Thu Mar 22 09:17:34 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php, referer: http://forum.civicrm.org/index.php/topic,23976.msg100820.html
[Thu Mar 22 09:17:35 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php, referer: http://forum.civicrm.org/index.php/topic,23976.msg100820.html
[Thu Mar 22 09:50:59 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php
[Thu Mar 22 09:50:59 2012] [error] [client 64.126.7.94] Premature end of script headers: index.php

What are the big database changes between 4.0.6 and 4.1 and where is the sql for that update?

I have 600 people in the crm that I cannot lose

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Manual Upgrade of DB from 4.0 to 4.1?
March 23, 2012, 05:36:10 am
Hopefully someone else can suggest a fix, but if not, there are two other options:

1. Run the upgrade on another machine that can run it successfully.

2. Your data is not lost. You can export it from the old system and import it into the fresh CiviCRM 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.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Manual Upgrade of DB from 4.0 to 4.1?

This forum was archived on 2017-11-26.