Upgrade Hell 7.1.6 to 7.2.0

After spending almost a week checking for module updates and reading other upgrade horror stories before trying this out myself, I have just wasted another two days, and Nathan's valuable time restoring backups, in an attempt to make things work.

I even uninstalled all third party modules on the second run, still no luck.

INSERT INTO `sys_profile_fields` VALUES(NULL, 'FullName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, IFNULL(@iMiscBlockId, 0), IF(ISNULL(@iMiscBlockId), NULL, 1), 17, 2, 17, 2, 0, NULL, 17, 2, 17, 5, 0, NULL, 17, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);: Column count doesn't match value count at row 1

I'm wondering if Anton's Searchable Fields might have helped cause this.

His installation file requires

1. Execute SQL query (using phpMyAdmin for example)

 ALTER TABLE `sys_profile_fields` ADD `Searchable` TINYINT( 1 ) DEFAULT '1' NOT NULL  AFTER `Unique` ;

There's no uninstall notes to roll that back.

Bless him, he's quoted me $250 to upgrade something that one of his modules might have helped to stall.

Thanks to Nathan @ Zarconia for rolling it all back again so swiftly.

~~~~~~~~~~~~~~~~~~~~~
Modules I have installed
~~~~~~~~~~~~~~~~~~~~~

Profile Cover from emmetbytes
http://www.boonex.com/m/profile-cover-2013-05-21

Profile Composer from AntonLV
http://www.boonex.com/m/Profile_Composer_2010_08_11

Searchable fields from AntonLV
http://www.boonex.com/m/Searchable_fields

Premium Groups from modzzz
http://www.boonex.com/m/Premium_Groups_Events_News_Venue_Sponsors_Maps

Locations from modzzz
http://www.boonex.com/m/Locations_Events_Hotels_Transport_Eateries_Shops_Nightlife

Lodgings (Places to Stay) from modzzz
http://www.boonex.com/m/hotels

Head Injections from deano92964
http://www.boonex.com/m/Head_Injections

Affiliate/Referrals System from AntonLV
http://www.boonex.com/m/Affiliate_Referrals_System

Ultimate Points - With Levels from modzz
http://www.boonex.com/m/Ultimate_Points_With_Levels

Deanos Tools
http://www.boonex.com/m/Deanos_Tools_V1_6_Dolphin_7_0_Version

Restaurants
http://www.boonex.com/m/restaurants

Business Listings
http://www.boonex.com/m/Premium_Business_Listings

What now?

Stay with 7.1.6 or do a clean sweep; wipe everything and make a new 7.3.0 install?

I'm not sure I'm happy enough with how Dolphin and its market modules work together (or not), so maybe cut and run completely is the answer.

No wonder there are so many dead Dolphin sites around the web, there comes a point when the time and money invested needs to be ignored and a potential community builder needs to just move on.

Michel

If you need help with the upgrade let me know and i'll have a go at it.... 

Thanks for the offer, dolphin_jay.

I've looked at your 'Dolphin Upgrade Services' and website link dolphin-techs.com.

Congratulations on making a nice hosting site with your Dolphin software.

My vision is to make a content site with community features rather than a purely community-dating-sharing site and believe it is possible to do with Dolphin; if we can get it working right.

There are some things I don't like with the 7.2.0 - 7.2.1 - 7.3.0 versions and some that might make things look and feel better in the long run.

Are you familiar with the modules I have installed and would Profile Cover from emmetbytes work in an upgraded version?

Sadly, that is one area the newer Dolphin hasn't quite perfected.

I'm going to wait a little then make a new back-up. Too tired to get into it now.

Maybe dropping the Searchable column in the sys_profile_fields will help things run smoother?

ALTER TABLE `sys_profile_fields` DROP COLUMN `Searchable`;

(thanks Anton - Searchable Fields Forum)

I have a couple of those modules, but let me say the upgrade from 7.2. to 7.3 was a disaster. I also have Anton's searchable fields (7.21. version) which is a brilliant feature that came free with Elgg. It makes a world of difference to Dolphin and well worth the price.

After reading your comment, I tested Searchable Fields and it doesn't work. This doesn't surprise me because it's a fix or hack and not a module as we know them. I'm sure one or more of the hacked files have been replaced, but I haven't even bothered to check at this stage. I will download the 7.3 update if any but at this stage I'm not expecting any trouble.

I think most of the upgrade problems are database orientated. A few module uninstall packages I've played with don't have a complete SQL uninstall and a lot of junk is being left behind. I've since done a full install of Dolphin 7.3 and modules that wouldn't work with the upgrade are now working fine.

Boonex can help us overcome this problem by telling us how transfer all the important Boonex SQL code for profiles, profile fields and photos etc., from an earlier version to a completely new install. Somehow I don't think that should be too hard. Right now I'm re-entering all 50 profiles manually. Thank god it's not 5,000.

>> Right now I'm re-entering all 50 profiles manually. Thank god it's not 5,000.

How are you adding the passwords?

Are Blog Category paths working on your 7.3.0 version of Dolphin?

https://www.boonex.com/forums/topic/Blog-Category-Bug-in-Dolphin-7-3-0.htm

To test. Make a blog post, add it to a category and then click on the category link.

I'm not going to try another upgrade until that is fixed, and other issues I find while testing other sites are resolved.

Interesting that some modules that are supposedly 7.3.0 compatible are not hosted on a demo site running Dolphin 7.3.0 so we can't really know. I've even followed some demo links and get 'Module Not Found'.

Michel

I rolled back the database to remove the 'Searchable' column that could have been causing upgrade problems before.

Cleared cache, then resolved the new database errors by replacing the Searchable Fields changed files.

inc/classes/BxDolPFM.php
inc/classes/BxDolProfileFields.php
templates/base/scripts/BxBaseProfileView.php

Success of sorts......

7.1.6-7.2.0 upgrade can be applied
System SQL script was successfully executed.
The following languages will be affected for system:
- en
System language strings were successfully added.
System after update custom script was successfully executed.
The following modules will be updated:
- profiler
- pageac
- blogs
- events
- wall
- membership
- avatar
- smtpmailer
- groups
- custom_rss
- forum
- payment
- photos
- profile_customize
- sites
- facebook_connect
- wmap
- zipcodesearch
- google_search
profiler module SQL script was successfully executed.
The following languages will be affected for profiler module:
- No languages will be affected.
pageac module SQL script was successfully executed.
The following languages will be affected for pageac module:
- No languages will be affected.
blogs module SQL script was successfully executed.
The following languages will be affected for blogs module:
- No languages will be affected.
events module SQL script was successfully executed.
The following languages will be affected for events module:
- en
events module language strings were successfully added.
wall module SQL script was successfully executed.
The following languages will be affected for wall module:
- en
wall module language strings were successfully added.
membership module SQL script was successfully executed.
The following languages will be affected for membership module:
- en
membership module language strings were successfully added.
avatar module SQL script was successfully executed.
The following languages will be affected for avatar module:
- No languages will be affected.
smtpmailer module SQL script was successfully executed.
The following languages will be affected for smtpmailer module:
- No languages will be affected.

ALTER TABLE `bx_groups_main` ADD `allow_view_forum_to` varchar(16) NOT NULL AFTER `allow_post_in_forum_to`;: Duplicate column name 'allow_view_forum_to'

Stalled again.

Once again, it appears a third party module stalls everything.

Upgrade 7.2 Failed - duplicate column name; Premium Groups from modzzz.

Dolphin 7.2.0 > Not Such a Whale of a Fail

I appreciate the work that people do to make, create, and innovate while striving to upgrade and update software that hopefully makes communities great.

If it was all so easy to do, we'd all be doing it.

However, after what seems like a long hibernation sometimes we wake up and carry on with a project that sees us getting ahead of ourselves.

Sure upgrading from 7.1.6 to 7.2.0 was loaded with problems; thanks, in part, to third-party modules making database changes that Boonex didn't appear to check for.

Having dropped an extra table column created by Searchable Fields; then edited out a duplicate column name from Premium Groups; the third upgrade install completed - sort of.

But the problems don't end there.

We need to make sure we changed permissions on /inc (no upgrade notes for that) or version.inc.php (which replaces security.inc.php) might not transfer. If it does, the site still might not work if header.inc.php couldn't be properly edited.

Then the 7.1.6-7.2.0/photos_resize.php script could take a while on larger sites.

Hopefully you didn't log-out. The login might not work on a custom template but the admin back door should.

The new styles initially seemed to have messed things up hysterically, and the site appeared differently in Firefox and Internet Explorer; but could have looked awesome on a phone.

Clearing cache, recompiling languages, clearing cache again, changing templates and reloading browsers all helped to bring the new calf back to life.

I've upgraded to Dolphin 7.3.0 and things are 'sort of' working. Have a few creases to iron out and template css issues to look at to get log-in and Facebook working properly on 'my template'. Happy to see packaged template seems to be doing its job though.

I'll be going through all my modules one by one and update to the 7.3 versions; maybe even uninstalling and making a new install where needed.

Having not yet looked at the Premium Groups - Dolphin 7.2 zip, the Groups Home page is currently not working but individual groups are: http://meta-travel.com/m/groups/view/Oceania-Travel-Network

Version 7.3.0 is starting to grow on me and I hope the rest of you get to enjoy swimming with Scooter too.

Don't give up, it's a big blue ocean but fish around in the forum for answers and we can get to the bottom of our problems.

Thanks for being a great community.

Michel on Meta-Travel.com

As I pointed out in another thread, you seem to be having a problem with the Premium Groups because you have ran the SQL upgrade script but have not actually uploaded the module files. I check your site links and you seem to have completed the update properly now. For any other issues you may have with Premium Groups, please log them in the official support forum for that module.

The 7.3.0 Dolphin upgrade path also quietly alters the About Us (about_us.php) text back to its original state (but not the Abouts Us Heading); in the 7.3.0.B1-7.3.0.B2 language file.

This site is powered by BoonEx Dolphin. The rest is a mystery.

A great way to find other sites using Dolphin.

As this is not a search term you probably want people to find you on, make sure to change yours back to how you want it.

If you can't remember what you had, look in your `sys_localization_strings` table back-up.

To stop this happening again, you may want to create an About Page and link to that from your Navigation menus.

If anyone is having log-in problems on their old template, try uploading BxTemplAccountView.php from Dolphin-Patch-v.7.1.6-to-v.7.2.0-v.3\templates\tmpl_uni\scripts in to your template/scripts folder.