Problem after 0.5.5 upgrade


(Sherwood) #1

I upgraded but now when I go to log in I get the Database Upgrade Required page
I click upgrade Piwik and get Piwik has been successfully updated! Page
When I click Continue to Piwik I get the Database Upgrade Required page again
Any help would be great


(vipsoft) #2

Can you dump the contents of the piwik_option table?

select * from piwik_option;

(Sherwood) #3

[quote=vipsoft @ Mar 21 2010, 12:48 AM]Can you dump the contents of the piwik_option table?

select * from piwik_option;

[/quote]

This what you were after?

Generation Time: Mar 20, 2010 at 08:55 PM
-- Server version: 5.0.37
-- PHP Version: 5.2.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `8709_adbatpwik`
--

-- --------------------------------------------------------

--
-- Table structure for table `piwik_option`
--

CREATE TABLE IF NOT EXISTS `piwik_option` (
  `option_name` varchar(64) NOT NULL,
  `option_value` longtext NOT NULL,
  `autoload` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`option_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `piwik_option`
--

INSERT INTO `piwik_option` (`option_name`, `option_value`, `autoload`) VALUES
('version_core', '0.5.5', 1),
('version_CoreAdminHome', '0.5.5', 1),
('version_Login', '0.5.5', 1),
('version_UsersManager', '0.5.5', 1),
('version_SitesManager', '0.5.5', 1),
('version_Installation', '0.5.5', 1),
('UpdateCheck_LatestVersion', '0.5.5', 0),
('UpdateCheck_LastTimeChecked', '1269127696', 1),
('version_CorePluginsAdmin', '0.5.5', 1),
('version_CoreHome', '0.5.5', 1),
('version_API', '0.5.5', 1),
('version_Widgetize', '0.5.5', 1),
('version_LanguagesManager', '0.5.4', 1),
('version_Actions', '0.5.5', 1),
('version_Dashboard', '0.5.5', 1),
('version_MultiSites', '0.5.5', 1),
('version_Referers', '0.5.5', 1),
('version_UserSettings', '0.5.5', 1),
('version_UserCountry', '0.5.5', 1),
('version_VisitsSummary', '0.5.5', 1),
('version_VisitFrequency', '0.5.5', 1),
('version_VisitTime', '0.5.5', 1),
('version_VisitorInterest', '0.5.5', 1),
('version_ExampleAPI', '0.1', 1),
('version_ExamplePlugin', '0.1', 1),
('version_ExampleRssWidget', '0.1', 1),
('version_ExampleFeedburner', '0.1', 1),
('version_Provider', '0.5.5', 1),
('version_Feedback', '0.5.4', 1),
('version_CoreUpdater', '0.5.5', 1),
('version_DBStats', '0.5.5', 1),
('version_Goals', '0.5.5', 1),
('version_Live', '0.5.5', 1),
('lastPurge_piwik_archive_blob_2010_02', '1267396915', 0),
('lastPurge_piwik_archive_blob_2010_01', '1267396934', 0),
('lastPurge_piwik_archive_blob_2010_03', '1267396916', 0);

(vipsoft) #4

Thanks.

The LanguagesManager and Feedback plugin versions didn’t get bumped. (Did you deactivate these plugins?)

Update the piwik_option table, setting these two to 0.5.5. That should get you past the database upgrade screen.


(Sherwood) #5

I think I may have disabled them

updated them and works fine now

Thank you


(vipsoft) #6

If you’re up to it, could you change those two back to ‘0.5.4’ in the piwik_option table, and see if this patch fixes it? http://dev.piwik.org/trac/changeset/1969

Thanks.


(Sherwood) #7

Sorry for the delay
That patch fixed it


(jack mark) #8

[quote=vipsoft @ Mar 21 2010, 02:39 AM]Thanks.

The LanguagesManager and Feedback plugin versions didn’t get bumped. (Did you deactivate these plugins?)

Update the piwik_option table, setting these two to 0.5.5. That should get you past the database upgrade screen.[/quote]

Thank you for this comment. I fully agree with you.


(genrock) #9

Yes, I agree as well.