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
Can you dump the contents of the piwik_option table?
select * from piwik_option;
[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);
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.
I think I may have disabled them
updated them and works fine now
Thank you
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.
Sorry for the delay
That patch fixed it
[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.
Yes, I agree as well.