Upgrade problems

I was on 7.2.1 and tried upgrading using the 7.3.0 cumulative patch which seems to have 4 stages.

The first two stages seemed to work ok.

The 3rd stage 7.3.0.B2-7.3.0.RC is where it went wrong.

I had the following error;

INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES('category_auto_app_bx_sounds', 'on', @iKatID, 'Autoapprove categories of sounds', 'checkbox', '', '', 2, ''),('bx_sounds_allowed_exts', 'mp3 wav', @iKatID, 'Allowed extensions', 'digit', '', '', 3, ''),('bx_sounds_max_file_size', '32', @iKatID, 'Maximum size of one file (in Megabytes)', 'digit', '', '', 4, ''),('bx_sounds_profile_album_name', '{nickname}''s sounds', @iKatID, 'Default profile album name', 'digit', '', '', 5, ''),('bx_sounds_mode_index', 'last', @iKatID, 'Default sort on main index page
(if enabled in the template)', 'select', '', '', 10, 'last,top'),('bx_sounds_number_index', '9', @iKatID, 'How many sounds show on main index page', 'digit', '', '', 12, ''),('bx_sounds_number_home', '12', @iKatID, 'How many sounds show on sounds home page', 'digit', '', '', 14, ''),('bx_sounds_number_all', '12', @iKatID, 'How many sounds show on browse sounds page', 'digit', '', '', 16, ''),('bx_sounds_number_top', '3', @iKatID, 'How many sounds show in featured, top, and similar sections', 'digit', '', '', 18, ''),('bx_sounds_number_related', '3', @iKatID, 'Number of related sounds by user', 'digit', '', '', 20, ''),('bx_sounds_number_previous_rated', '3', @iKatID, 'Number of previous rated sounds', 'digit', '', '', 22, ''),('bx_sounds_number_albums_home', '3', @iKatID, 'How many albums show on sounds home page', 'digit', '', '', 24, ''),('bx_sounds_number_albums_browse', '9', @iKatID, 'How many albums show on browse albums page', 'digit', '', '', 26, ''),('bx_sounds_number_view_album', '3', @iKatID, 'How many sounds show on view album page', 'digit', '', '', 28, ''),('bx_sounds_file_width', '600', @iKatID, 'Width of sound player (in pixels)', 'digit', '', '', 34, ''),('bx_sounds_file_height', '600', @iKatID, 'Height of sound player (in pixels)', 'digit', '', '', 35, ''),('bx_sounds_uploader_switcher', 'html5,record', @iKatID, 'Available uploaders', 'list', '', '', 38, 'html5,regular,record');: Duplicate entry 'category_auto_app_bx_sounds' for key 'PRIMARY' 

Any suggestions please?

yes there is.  And I see that Boonex did not fix the patch

OK see that you found https://www.boonex.com/forums/topic/Upgrade-Error-.htm

Can you start over from backups?

And the cumulative patch was not a good ideal in my opinion but it did save time for Boonex.

If you can not start over, you should be able to continue with a little work.

If nothing else, Boonex could put notices up of known issues with the upgrades.

Thank you for your response geek_girl.

I was able to find a work around, if you can call it that.

1. I had to restore my database using a copy I had backed up before starting the upgrade.
2. I uninstalled the two modules that were giving me grief (videos and sounds)
3. I was then able to proceed through all the steps of the upgrade.

Luckily I never used the sounds module so there was no loss there and videos was barely used by the members of my site so hopefully there will be no negative feedback.

All in all, a slightly hectic day using the trial & measure method which could have been avoided if the patch had been fixed.

 That is against Boonex policy.