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
Reply

14 Posts   1968 Views

Avatar
fordy

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

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

Avatar
dio5

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.

Avatar
Fuzz10

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 :
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 ?

Avatar
fordy

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.

Avatar
Fuzz10

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

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

Avatar
fordy

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?

Avatar
Fuzz10

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 ?

Avatar
fordy

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

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

Go to Top