1053 Posts in 383 Topics by 376 members
| Go to End | Next > | |
| Author | Topic: | 1652 Views |
-
No Viewer Group after upgrade

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
-
Re: No Viewer Group after upgrade

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.
-
Re: No Viewer Group after upgrade

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.0Did you happen to extend the MemberLoginForm or do some other stuff with permissions ?
-
Re: No Viewer Group after upgrade

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.
-
Re: No Viewer Group after upgrade

27 January 2009 at 11:56pm
Are you sure you flushed all caches and upgraded the entire system ?
-
Re: No Viewer Group after upgrade

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?
-
Re: No Viewer Group after upgrade

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 ?
-
Re: No Viewer Group after upgrade

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
| 1652 Views | ||
| Go to Top | Next > |



