Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

[Solved]Upgrade from 2.3.2 to 2.4.4 Problem


Reply

7 Posts   1431 Views

Avatar
wayne

27 January 2011 at 12:55am Community Member, 14 Posts

Hi,

we've been using 2.3.2 with no real problems. Today I'm trying to upgrade to 2.4.4. I followed the upgrade instructions deleting and copy across the new folders, plus upgrading the blog module we use.
I've done a /dev/build?flush=1 a few times with no reported errors. However when I hit 'locolhost' I just get a blank page - nothing in the logs.
If I hit localhost/admin I get this error:

Unknown column 'Member.FailedLoginCount' in 'field list' (http://localhost/admin)
[26-Jan-2011 12:40:23] Error at \sapphire\core\model\MySQLDatabase.php line 525: Couldn't run query:
SELECT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName"
FROM "Member"
WHERE ("Member"."ID" = 1)
ORDER BY "Surname", "FirstName"
LIMIT 1

Unknown column 'Member.FailedLoginCount' in 'field list' (http://localhost/admin)

I there additional db scripts I need to run?

thanks
Wayne

Avatar
Willr

27 January 2011 at 4:30pm Forum Moderator, 5511 Posts

Unknown column 'Member.FailedLoginCount' in 'field list' (http://localhost/admin)

Have you rebuilt your database? That should add any required columns.

Avatar
wayne

27 January 2011 at 7:30pm Community Member, 14 Posts

As already mentioned I've done a /dev/build?flush=1

Is there another way of building the database?

Avatar
wayne

27 January 2011 at 8:25pm Community Member, 14 Posts

More to this: I see when doing /dev/build this is the output:

# Member
# Field Member.Password: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(64) character set utf8 collate utf8_general_ci)
# Field Member.AutoLoginHash: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(30) character set utf8 collate utf8_general_ci)
# Field Member.PasswordEncryption: changed to varchar(50) character set utf8 collate utf8_general_ci (from enum('none','md2','md4','md5','sha1','sha256','sha384','sha512','ripemd128','ripemd160','ripemd256','ripemd320','whirlpool','snefru','gost','adler32','crc32','crc32b','password','old_password') character set utf8 collate utf8_general_ci default 'none')
# Field Member.FailedLoginCount: created as int(11) not null default 0
# Field Member.DateFormat: created as varchar(30) character set utf8 collate utf8_general_ci
# Field Member.TimeFormat: created as varchar(30) character set utf8 collate utf8_general_ci

So its says the "Member.FailedLoginCount: created as int(11) not null default 0" is created.

However when I look at the schema of the table:

Member CREATE TABLE `Member` (
`ID` int(11) NOT NULL auto_increment,
`ClassName` enum('Member') character set utf8 default 'Member',
`Created` datetime default NULL,
`LastEdited` datetime default NULL,
`FirstName` varchar(50) character set utf8 default NULL,
`Surname` varchar(50) character set utf8 default NULL,
`Email` varchar(50) character set utf8 default NULL,
`Password` varchar(64) character set utf8 default NULL,
`RememberLoginToken` varchar(50) character set utf8 default NULL,
`NumVisit` int(11) NOT NULL default '0',
`LastVisited` datetime default NULL,
`Bounced` tinyint(1) unsigned NOT NULL default '0',
`AutoLoginHash` varchar(30) character set utf8 default NULL,
`AutoLoginExpired` datetime default NULL,
`PasswordEncryption` enum('none','md2','md4','md5','sha1','sha256','sha384','sha512','ripemd128','ripemd160','ripemd256','ripemd320','whirlpool','snefru','gost','adler32','crc32','crc32b','password','old_password') character set utf8 default 'none',
`Salt` varchar(50) character set utf8 default NULL,
`PasswordExpiry` date default NULL,
`LockedOutUntil` datetime default NULL,
`Locale` varchar(6) character set utf8 default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `AutoLoginHash` (`AutoLoginHash`),
KEY `Email` (`Email`),
KEY `ClassName` (`ClassName`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

Avatar
wayne

27 January 2011 at 8:44pm (Last edited: 27 January 2011 8:45pm), Community Member, 14 Posts

I have to say as well that the output from /dev/build seems rather shorter than it used to be. I have the impression it's not finishing and commiting the transaction (does it run in a transaction?)

Environment Builder
http://localhost/
dev→ build
Building database SS_mysite using MySQL 5.0.67-community-nt

Creating database tables
# TrackBackPing
# Field TrackBackPing.Url: changed to varchar(2048) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8 collate utf8_general_ci)
# PageComment
# SiteConfig
# Table SiteConfig: created
# Field SiteConfig.ID: created as int(11) not null auto_increment
# Field SiteConfig.ClassName: created as enum('SiteConfig') character set utf8 collate utf8_general_ci default 'SiteConfig'
# Field SiteConfig.Created: created as datetime
# Field SiteConfig.LastEdited: created as datetime
# Field SiteConfig.Title: created as varchar(255) character set utf8 collate utf8_general_ci
# Field SiteConfig.Tagline: created as varchar(255) character set utf8 collate utf8_general_ci
# Field SiteConfig.Theme: created as varchar(255) character set utf8 collate utf8_general_ci
# Field SiteConfig.CanViewType: created as enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'Anyone'
# Field SiteConfig.CanEditType: created as enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers'
# Field SiteConfig.CanCreateTopLevelType: created as enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers'
# Index SiteConfig.ClassName: created as (ClassName)
# Table SiteConfig_ViewerGroups: created
# Field SiteConfig_ViewerGroups.ID: created as int(11) not null auto_increment
# Field SiteConfig_ViewerGroups.SiteConfigID: created as int(11) not null default 0
# Field SiteConfig_ViewerGroups.GroupID: created as int(11) not null default 0
# Index SiteConfig_ViewerGroups.SiteConfigID: created as (SiteConfigID)
# Index SiteConfig_ViewerGroups.GroupID: created as (GroupID)
# Table SiteConfig_EditorGroups: created
# Field SiteConfig_EditorGroups.ID: created as int(11) not null auto_increment
# Field SiteConfig_EditorGroups.SiteConfigID: created as int(11) not null default 0
# Field SiteConfig_EditorGroups.GroupID: created as int(11) not null default 0
# Index SiteConfig_EditorGroups.SiteConfigID: created as (SiteConfigID)
# Index SiteConfig_EditorGroups.GroupID: created as (GroupID)
# Table SiteConfig_CreateTopLevelGroups: created
# Field SiteConfig_CreateTopLevelGroups.ID: created as int(11) not null auto_increment
# Field SiteConfig_CreateTopLevelGroups.SiteConfigID: created as int(11) not null default 0
# Field SiteConfig_CreateTopLevelGroups.GroupID: created as int(11) not null default 0
# Index SiteConfig_CreateTopLevelGroups.SiteConfigID: created as (SiteConfigID)
# Index SiteConfig_CreateTopLevelGroups.GroupID: created as (GroupID)
# SiteTree
# Field SiteTree.ClassName: changed to enum('SiteTree','FreeRedirect','LandingPage','Page','BlogEntry','BlogTree','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','BlogHolder','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','FreeRedirect','LandingPage','Page','GhostPage','BlogEntry','BlogHolder','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree')
# Field SiteTree.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from varchar(255) character set utf8 collate utf8_general_ci)
# Field SiteTree.Priority: created as varchar(5) character set utf8 collate utf8_general_ci
# Field SiteTree_Live.ClassName: changed to enum('SiteTree','FreeRedirect','LandingPage','Page','BlogEntry','BlogTree','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','BlogHolder','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','FreeRedirect','LandingPage','Page','GhostPage','BlogEntry','BlogHolder','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree')
# Field SiteTree_Live.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from varchar(255) character set utf8 collate utf8_general_ci)
# Field SiteTree_Live.Priority: created as varchar(5) character set utf8 collate utf8_general_ci
# Field SiteTree_versions.ClassName: changed to enum('SiteTree','FreeRedirect','LandingPage','Page','BlogEntry','BlogTree','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','BlogHolder','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','FreeRedirect','LandingPage','Page','GhostPage','BlogEntry','BlogHolder','AboutPage','AffiliateLanding','BusinessTemplate','CarouselContainer','CarouselItem','CaseStudy','ContentBox','ContentBoxLargeHorz','EnterprisePage','EventManagement','EventsPage','Features','FeaturesBox','FeaturesContent','FeaturesGeneral','FeaturesPage','FeaturesPageFree','GeneralPage','GeneralPressPage','HelpPage','HeroContent','HomePage','HomePageContent','HowTo','LandingPageTemplate','MainPage','MainPageContent','MultiTabPage','NewBizTemplate','NewFeaturesHome','NewFeaturesHomeContent','NewFeaturesMainContent','NewFeaturesPageContent','NewsletterSignUp','Packages','Powwownow','Pricing','PricingEnterprise','Pricingv2','ProductComparison','Promotion','SiteMap','Testimonial','Upgrade','Verticals','wpCaseStudies','wpFeatureOverview','wpFullFeatures','ErrorPage','RedirectorPage','VirtualPage','PressPage','BusinessTemplateMedium','PressFeatureBox','PressOverview','NewBizTemplateMedium') character set utf8 collate utf8_general_ci default 'SiteTree')
# Field SiteTree_versions.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from varchar(255) character set utf8 collate utf8_general_ci)
# Field SiteTree_versions.Priority: created as varchar(5) character set utf8 collate utf8_general_ci
# Email_BounceRecord
# QueuedEmail
# File
# Field File.Filename: changed to mediumtext character set utf8 collate utf8_general_ci (from varchar(255) character set utf8 collate utf8_general_ci)
# Group
# Field Group.HtmlEditorConfig: created as varchar(50) character set utf8 collate utf8_general_ci
# Table Group_Roles: created
# Field Group_Roles.ID: created as int(11) not null auto_increment
# Field Group_Roles.GroupID: created as int(11) not null default 0
# Field Group_Roles.PermissionRoleID: created as int(11) not null default 0
# Index Group_Roles.GroupID: created as (GroupID)
# Index Group_Roles.PermissionRoleID: created as (PermissionRoleID)
# LoginAttempt
# Member
# Field Member.Password: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(64) character set utf8 collate utf8_general_ci)
# Field Member.AutoLoginHash: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(30) character set utf8 collate utf8_general_ci)
# Field Member.PasswordEncryption: changed to varchar(50) character set utf8 collate utf8_general_ci (from enum('none','md2','md4','md5','sha1','sha256','sha384','sha512','ripemd128','ripemd160','ripemd256','ripemd320','whirlpool','snefru','gost','adler32','crc32','crc32b','password','old_password') character set utf8 collate utf8_general_ci default 'none')
# Field Member.FailedLoginCount: created as int(11) not null default 0
# Field Member.DateFormat: created as varchar(30) character set utf8 collate utf8_general_ci
# Field Member.TimeFormat: created as varchar(30) character set utf8 collate utf8_general_ci
# MemberPassword
# Permission
# PermissionRole
# Table PermissionRole: created
# Field PermissionRole.ID: created as int(11) not null auto_increment
# Field PermissionRole.ClassName: created as enum('PermissionRole') character set utf8 collate utf8_general_ci default 'PermissionRole'
# Field PermissionRole.Created: created as datetime
# Field PermissionRole.LastEdited: created as datetime
# Field PermissionRole.Title: created as varchar(50) character set utf8 collate utf8_general_ci
# Field PermissionRole.OnlyAdminCanApply: created as tinyint(1) unsigned not null default 0
# Index PermissionRole.ClassName: created as (ClassName)
# PermissionRoleCode
# Table PermissionRoleCode: created
# Field PermissionRoleCode.ID: created as int(11) not null auto_increment
# Field PermissionRoleCode.ClassName: created as enum('PermissionRoleCode') character set utf8 collate utf8_general_ci default 'PermissionRoleCode'
# Field PermissionRoleCode.Created: created as datetime
# Field PermissionRoleCode.LastEdited: created as datetime
# Field PermissionRoleCode.Code: created as varchar(50) character set utf8 collate utf8_general_ci
# Field PermissionRoleCode.RoleID: created as int(11) not null default 0
# Index PermissionRoleCode.RoleID: created as (RoleID)
# Index PermissionRoleCode.ClassName: created as (ClassName)
# Widget
# Field Widget.Enabled: created as tinyint(1) unsigned not null default 0
# WidgetArea
# FreeRedirect
# LandingPage
# Page
# BlogEntry
# Index BlogEntry_versions.RecordID_Version: changed to unique (RecordID,Version) (from (RecordID,Version))

I'm stuck on this. Otherwise I'm going to have to fall back to 2.3.2. But I really need to upgrade for the sitemap improvements/fix'es and more importantly the performance.

Avatar
wayne

27 January 2011 at 8:58pm Community Member, 14 Posts

I added all the debug flags I could find to the _config.php. At the bottom of the dev/build output I see:

Fatal error: Cannot make non static method Page::current() static in class BlogTree in C:\dev\www\blog\code\BlogTree.php on line 206

Avatar
wayne

27 January 2011 at 10:02pm Community Member, 14 Posts

So that was it. Problem is the blog code which I fixed.
So solved!