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

[Jean-Francois Leveque]

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