4.6.10 to 4.7.1 upgrade woes

Question

**UPDATE #5: See new answer at bottom. It's a fix!

**UPDATE #4: Decided do a clean install of 4.7.1 and see if I can point it to a working 4.7.1 backup database. I suppose I need to follow Kurund's wisdom on this, eh? https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin

~~~~~

**UPDATE #3: Well, it's been a nasty Mercury in retrograde these past couple of weeks. Or Murphy's Law has been acting like a troll. Had a power outage last night that exceeded the UPS runtime and this sandbox didn't gracefully shutdown. Ugh! Got it back up except...

4.7.1 gave me a blank screen again. Cleared the cache, checked all settings. All was intact except now missing a few files and folders. Ugh! Tried to reinstall it from Joomla Install-from-Folder function but that now gives me a blank page (500 error). I then decided to uninstall 4.7.1 and reinstall a fresh package but same results. It stopping after 30% of the folder/files are being installed.

I checked the database again, too. Noticed that in table

civicrm_domain
config_backend

field is gone

Any ideas?

~~~~~~~

**UPDATE #2: I was finally able to upgrade after starting with a good 4.6.10 database backup. Then again in table

civicrm_domain.config_backend

marked that field column to NULL, and made sure the version number was set back to 4.6.10.

Then reading through the documentation again, deleted

~/media/civicrm/ConfigAndLogs/Config.IDS.ini

and

~/media/civicrm/templates_c/en_US

I then performed the 4.7.1 install again and it worked.

~~~~~~

**UPDATE #1: Seems there is an error of corrupted table creation in the log files. http://pastebin.com/KajmZuC1

There is an old bug by core developers on this supposedly fixed but here it is again. https://issues.civicrm.org/jira/browse/CRM-9493**

---

I actually have a dead upgrade now from 4.6.10 to 4.7.1 on Joomla 3.4.8. I am still running PHP 5.4 if that makes a difference considering the warnings during the upgrade.

After initial upgrade, I got a system error message on pop-up and where the notice is at the bottom of the container next to the CiviCRM version number. The error was that no Crons were recorded. I opened Scheduled Events and it showed all active Crons having just been run.

Next, I Cleared Caches but on this settings page the paths were missing from the HTML. I decided to hit the Reset Paths button and then everything went blank.

Front and backends are completely blank now. All paths in civicrm.settings.php and civicrm.config.php are correct including MySQL settings.

Here is the latest entries in the ConfigAndLogs log file. http://pastebin.com/KajmZuC1

Also, "No mailboxes have been configured for Email to Activity Processing" but this shouldn't break the upgrade.

Please advise.

Answer 1

I got CiviCRM to come back by manually entering the paths manually into the CiviCRM Settings Overrides in civicrm.settings.php file. There were some more error but at least CiviCRM came back for me. It is obvious that the Reset Paths is causing problem and it might have to do with the way UpdateConfigBackend is calling a URL for GettingStarted.php. I am not a developer but they all seem to be linked. I shared what I actually did in this posting at the bottom: 4.6.12 to 4.7.1 upgrade causes problems with directories, update paths and clear cache 4.6.12 to 4.7.1 upgrade causes problems with directories, update paths and clear cache

Answer 2

I'm going to add this as an answer because it is what fixed my site after many days of troubleshooting, several sandboxes and multiples of restores.

First off, I use Joomla so Akeeba Backup extension is a savior. Totally worth the subscription to use the Pro version but the free one works just as well.

Now, what became obvious to me was that if hitting the Reset Paths button broke CiviCRM then where are those paths stored. Initially we all thought in the files, right? Hudson Essex Terraplane Club chose to use the override in

civicrm.settings.php

which works but is not a fix. It's a workaround.

So, I started to dig deeper after Catorghans (above) suggested a table was corrupt and repair may work. Of course, this was the culprit. Everything in a CiviCRM web form gets stored somewhere, right? But, repairing the table wasn't the issue.

NOTE: At this point I'm thinking this is not platform specific thus is a bug. So this should apply no matter what CMS you are using.

Here is my thought process: As Hudson and I reported, the Resource Paths broke when clicking on the Reset Resource Paths button in Administration Settings=>Clear Cache area. Then Catorghans suggested a broken table. Then the error message that

civicrm_setting

table error of "not found". So, let's look in the table. Ah-Ha! All the fields that would contain these setting were flagged NULL! This means they were empty. Of course! If the place CiviCRM looks for its Resource URL Paths, no less, it's settings is empty then it has to be an obvious sign.

I then opened up one of the working sandboxes. It doesn't matter which version because for this table the developers probably wouldn't change it that drastically. But, even if they did it would be pretty standard database development to stick with more or less the same convention. At least, that is what intuition tells me.

So, I began to enter in copies of data from a working instance. Viola! It Works! Just in time to leave for CiviDay with Neil Planchon and friends in Oakland, CA.

Immediately do a backup!

Answer 3

A corrupt table could explain this. I would repair it. First repair and see if it works already. If not, restore the backup, make sure table is still fixed (or repair again) and upgrade again.

If you have access to phpMyAdmin, you can select all tables at the bottom and then choose "repair tables".

If you do not have phpMyAdmin, but you have access to ssh then you can use mysqlrepair (or mysqlcheck -r), see more at http://linuxcommand.org/man_pages/mysqlcheck1.html

If you have neither you should ask your hoster to do a repair for all tables.

Good luck.