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   2038 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, 787 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, 787 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, 787 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