Details
-
Type:
Improvement
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.7
-
Fix Version/s: 1.8
-
Component/s: Core CiviCRM
-
Labels:None
Description
Currently, when installing an upgrade of civiCRM in Jooma! all of the menu items of type component which link to civicrm are set to deleted (published=-2) in the jos_menu table. THis means that each civicrm menu link needs to be recreated each time an upgrade is done.
Running the sql scrip belowt will restore the the menu items to published status, making it no longer necessary to recreate the menus manually.
/*This will take the menu links that were deleted as part of civicrm uninstall and restore them. */
/This assumes that prior to uninstalling civicrm you have trashed any deleted civicrm menus./
UPDATE `jos_menu`
SET `published` =1
WHERE `link` LIKE CONVERT( _utf8 'index.php?option=com_civicrm'
USING latin1 )
COLLATE latin1_swedish_ci
AND `published` = -2
It would make joomla! upgrading that much less of a headache to include this either as a script or as part of the install script.
Attachments
Activity
Verify for 2.0
ok added this to configure.php with the upgrade option.
However the user STILL needs to hack the file and set the upgrade flag to true so we do the foll:
1. skip database operations (the user will still need to upgrade the database manually)
2. fix joomla menus using elin's query below
would be great for joomla 1.5 to inform the installer if its an upgrade or new install. I suspect we can make this by checking if a civicrm table exists and if so avoid overwriting it etc, but i also like to keep things simple and am reluctant to make that change now.