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.

Upgrading SilverStripe

Ask questions about upgrading SilverStripe to the latest version.

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

No Viewer Group after upgrade

Go to End

14 Posts   1968 Views


27 January 2009 at 9:54pm Community Member, 46 Posts


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



27 January 2009 at 10:36pm Community Member, 501 Posts

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.


27 January 2009 at 10:43pm Community Member, 787 Posts

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 :

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


27 January 2009 at 11:01pm Community Member, 46 Posts

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.


27 January 2009 at 11:56pm Community Member, 787 Posts

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


27 January 2009 at 11:59pm Community Member, 46 Posts

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

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


28 January 2009 at 12:13am Community Member, 787 Posts

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 ?


28 January 2009 at 12:25am Community Member, 46 Posts


so the cache is now full.

I have got flickrservice, maps and userforms modules.

I have paste bin'd my dev/build output -

Go to Top