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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Upgrading SilverStripe /

Ask questions about upgrading SilverStripe to the latest version.

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

No Viewer Group after upgrade


Go to End


14 Posts   3153 Views

Avatar
fordy

Community Member, 46 Posts

27 January 2009 at 9:54pm

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

Community Member, 501 Posts

27 January 2009 at 10:36pm

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

Community Member, 791 Posts

27 January 2009 at 10:43pm

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

Community Member, 46 Posts

27 January 2009 at 11:01pm

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

Community Member, 791 Posts

27 January 2009 at 11:56pm

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

Avatar
fordy

Community Member, 46 Posts

27 January 2009 at 11:59pm

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

Community Member, 791 Posts

28 January 2009 at 12:13am

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

Community Member, 46 Posts

28 January 2009 at 12:25am

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