Jump to:

4938 Posts in 16688 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » [Solved]Upgrade from 2.3.2 to 2.4.4 Problem

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

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

Page: 1
Go to End
Author Topic: 1410 Views
  • wayne
    Avatar
    Community Member
    14 Posts

    [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

    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

  • Willr
    Avatar
    Forum Moderator
    5508 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

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

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

  • wayne
    Avatar
    Community Member
    14 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

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

    Is there another way of building the database?

  • wayne
    Avatar
    Community Member
    14 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

    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

  • wayne
    Avatar
    Community Member
    14 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

    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.

  • wayne
    Avatar
    Community Member
    14 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

    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

  • wayne
    Avatar
    Community Member
    14 Posts

    Re: [Solved]Upgrade from 2.3.2 to 2.4.4 Problem Link to this post

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

    1410 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.