Macrotone Blogs

Macrotone blogs upon Joomla, our products and other matters.
Font size: +

Problem upgrading Joomla 1.7.3 to 2.5 Beta Resolved

A standard Joomla install of the upgrade package was used:

The following errors were reported:

        JInstaller: :Install: Error SQL DB function failed with error number 1060
        Duplicate column name 'sitename' SQL=ALTER TABLE `u6r3h_languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
        SQL =

        ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;

        Files Update: SQL error file DB function failed with error number 1060
        Duplicate column name 'sitename' SQL=ALTER TABLE `u6r3h_languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;
        SQL =

        ALTER TABLE `#__languages` ADD COLUMN `sitename` varchar(1024) NOT NULL AFTER `metadesc`;

Consequently:


    Table 'u6r3h_languages' does not have index 'idx_image'. (From file 1.7.4-2011-11-19.sql.)
    Table 'u6r3h_languages' does not have index 'idx_langcode'. (From file 1.7.4-2011-11-19.sql.)
    Table 'u6r3h_update_sites' does not have index 'last_check_timestamp'. (From file 2.5.0-2011-12-06.sql.)
    Table 'u6r3h_menu' should not have index 'idx_client_id_parent_id_alias'. (From file 2.5.0-2011-12-24.sql.)
    Table 'u6r3h_menu' does not have index 'idx_client_id_parent_id_alias_language'. (From file 2.5.0-2011-12-24.sql.)
    Table 'u6r3h_updates' does not have index 'infourl'. (From file 2.5.0-2012-01-10.sql.)

    Database schema version (in #__schemas): 1.7.1-2011-09-20.
    Database driver: mysqli.
    55 database changes were checked successfully.
    13 database changes did not alter table structure and were skipped.

Fortunately release 2.5 provides an easy way to resolve the database issues.  On the Extension manager install page there is a Database tab.  This provides a 'fix'' button that we used to get the following:

Database structure is reported as up to date.
    Database schema version (in #__schemas): 2.5.0-2012-01-10.
    Database driver: mysqli.
    61 database changes were checked successfully.
    13 database changes did not alter table structure and were skipped.

Clicking on Discover tab, and looking for updates finds two pages of updates, with many duplicates:

    Captcha - ReCaptcha    Plugin                3 times
    Content - Smart Search    Plugin                3 times
    Joomla! extensions updates notification icon    Plugin     3 times    
    Joomla! update notification icon        Plugin    3 times
    Smart Search            Component        1 time
    Smart Search - Categories    Plugin        3 times
    Smart Search - Contacts        Plugin        3 times
    Smart Search - Content        Plugin        3 times
    Smart Search - Newsfeeds    Plugin        3 times
    Smart Search - Weblinks        Plugin        3 times
    Smart Search Module        Module        1 time
    System - Highlight        Plugin        3 times
    System - Language Code        Plugin         3 times

Choosing one of the items i.e. the smart search component to install (or any other specific items at all) gives a message about choosing a selection from the list even though the smart search component is marked as selected in the check box.

It seems to be impossible to select an individual item (or several) to install.

With the beta 1 release I saw the same items but clicked them all and then Install, resulting in each of the plugins getting installed multiple (3) times.  It is obviously not clever enough to check itself.  This is very messy since there is no easy way to uninstall the multiple items.  Yes you can uninstall one of the three occurrences but the remaining two can not be uninstalled since the first uninstall of the plugin removed the manifest (XML) file.

Attempts at performing a re-install of the upgrade package doesn't get one any further, only a few different error messages.

        Refresh Manifest Cache failed: Extension is not currently installed.
..

Repeated 13 times

  Error on updating manifest cache: (type, element, folder, client) = (plugin, joomlaupdate, joomlaupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, extensionupdate, extensionupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, recaptcha, recaptcha, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, languagecode, languagecode, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, joomlaupdate, joomlaupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, extensionupdate, extensionupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, recaptcha, recaptcha, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, languagecode, languagecode, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, joomlaupdate, joomlaupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, extensionupdate, extensionupdate, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, recaptcha, recaptcha, 0)
Error on updating manifest cache: (type, element, folder, client) = (plugin, languagecode, languagecode, 0)

Choosing to rediscover missing addons generates the same list as previously.

As mentioned above attempts at trying to select one or more items to install (from the Discovery window doesn't work, but I have discovered a work around.

By selecting the top 'check box' and then removing the tick marks from the multiple items such that they are only marked once (even though they occur 3
times) you can then click the install button and the items get installed.

Refresh the cache and continue with other items until all are installed. We did this for all the pages and in every case you have to tick the top (all) check box and un-select what is not required.

If you do not remove the tick marks the plug-ins gets installed multiple (3 times since they show up 3 times) as explained above.

Looking at the installed items shows the 2.5.0 components and an updated system.

Joomla PHP White Page Error
Technical Article links
 
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries