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

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.

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 ?

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.

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

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

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

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 ?

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