Jump to:

1135 Posts in 1984 Topics by 403 members

Upgrading SilverStripe

SilverStripe Forums » Upgrading SilverStripe » No Viewer Group after upgrade

Ask questions about upgrading SilverStripe to the latest version.

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

Page: 1 2
Go to End
Author Topic: 1818 Views
  • fordy
    Avatar
    Community Member
    46 Posts

    No Viewer Group after upgrade Link to this post

    Hi,

    I upgraded to 2.3 and have got the following error message when trying to log in.

    User Error] Couldn't run query: SELECT `SiteTree_ViewerGroups`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `SiteTree_ViewerGroups` ON `SiteTree_ViewerGroups`.GroupID = `Group`.ID WHERE (`SiteTree_ViewerGroups`.SiteTreeID = 1) GROUP BY `Group`.ID Table 'web231-oxton.SiteTree_ViewerGroups' doesn't exist

    When i do dev/build, it says the table is created ( Table SiteTree_ViewerGroups: created ) but there is no table in the DB.

    I can't find why the dev script is not updating

    Ed

  • dio5
    Avatar
    Community Member
    501 Posts

    Re: No Viewer Group after upgrade Link to this post

    I think Viewer Group is obsolete or has been changed in 2.3.

    I vaguely remember a forum post by Fuzz10 where he had a problem with it... I'll see if I can find it.

  • Fuzz10
    Avatar
    Community Member
    786 Posts

    Re: No Viewer Group after upgrade Link to this post

    Yeah... in 2.3 the column Viewsgroups has become obsolete (it became a many to many relationship). This breaks the backwards-compatibility.

    See this page :
    http://doc.silverstripe.com/doku.php?id=upgrading:2.3.0

    Did you happen to extend the MemberLoginForm or do some other stuff with permissions ?

  • fordy
    Avatar
    Community Member
    46 Posts

    Re: No Viewer Group after upgrade Link to this post

    Hi guys,

    thanks for the replies. I havent extended the logins. It is a pretty simple installation.

    I had a look in the docs. It said if i do dev/build, it will update but it doesnt udate the database.

    Maybe the problem is there.

  • Fuzz10
    Avatar
    Community Member
    786 Posts

    Re: No Viewer Group after upgrade Link to this post

    Are you sure you flushed all caches and upgraded the entire system ?

  • fordy
    Avatar
    Community Member
    46 Posts

    Re: No Viewer Group after upgrade Link to this post

    yeah, i am using ?flush=1 and the silverstripe-cache is empty.

    How do i know if that folder is being used for cache?

  • Fuzz10
    Avatar
    Community Member
    786 Posts

    Re: No Viewer Group after upgrade Link to this post

    it should fill up with files after you call a page... ;)

    Can you force the system in DEV mode if it is not already before running the /flush..

    What modules do you have installed ?

  • fordy
    Avatar
    Community Member
    46 Posts

    Re: No Viewer Group after upgrade Link to this post

    Ok,

    so the cache is now full.

    I have got flickrservice, maps and userforms modules.

    I have paste bin'd my dev/build output - http://pastebin.com/m311daf1a

    1818 Views
Page: 1 2
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.