[Deploying Sakai] Available site types in 2.8 (or later, maybe earlier too)

Jean-Francois Leveque jean-francois.leveque at upmc.fr
Fri May 27 06:16:19 PDT 2011

Thanks, John.

I wasn't careful about what the query was doing. So project is available 
in getSiteTypes() because the default Citations Admin is a project but 
course is not because it has no instances. I've now created a course 
site and I can use Admin Site Perms for courses and projects.

I still have to deal with the fact that WorkSite Setup offers portfolio 
even if I have built without OSP. But this is less important.

Maybe we need a dynamic site type registration system.


On 27/05/2011 13:48, John Leasia wrote:
> Have you setup any course sites yet? As I recall, a fresh install
> creates a few project sites, but I don't think any course sites. So
> until you create one, you won't see any sites with that type in the
> sakai_site table.
> John
> Jean-Francois Leveque wrote:
>> In a freshly created database with almost default Sakai 2.8.0 settings,
>> I only get the following:
>> mysql> select distinct TYPE from SAKAI_SITE order by TYPE;
>> +---------+
>> | TYPE |
>> +---------+
>> | NULL |
>> | project |
>> +---------+
>> 2 rows in set (0.00 sec)
>> It looks like I've found a serious issue unless the release notes say
>> something about this.
>> J-F
>> On 26/05/2011 18:17, Zhen Qian wrote:
>>> Look at the implementation of SiteService (DbSiteService.java), it is
>>> using
>>> the following sql statement to retrieve site types:
>>> "select distinct TYPE from SAKAI_SITE order by TYPE";
>>> So it all depends on the current content in the db.
>>> However, the site types used by WorkSite Setup tool depend on the
>>> configuration settings. So even there is no project site in db now,
>>> "project" is still shown as a valid site type option.
>>> Thanks,
>>> - Zhen
>>> On Thu, 26 May 2011 18:10:28 +0200, Jean-Francois Leveque
>>> <jean-francois.leveque at upmc.fr> wrote:
>>>> Hi all,
>>>> It looks like org.sakaiproject.site.api.SiteService's getSiteTypes() is
>>>> not always returning the same values as site-manage sets into
>>>> STATE_SITE_TYPES (SiteAction.java).
>>>> Does anyone know the magic to be sure both lists of values are the
>>>> same?
>>>> J-F

More information about the production mailing list