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

[Jean-Francois Leveque]

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.

J-F

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