[Building Sakai] Can't add new course site?

[Zhen Qian]

So you are using MySQL. 

Not an expert there, either. I think you can change the definition of the ACADEMIC_SESSION_ID column to be auto_increment and use last_insert_id() to find out the next value.

FYI, here is the link for the MySQL script to populate the cm_acdemic_session table, with the id specified:

https://source.sakaiproject.org/svn/msub/umich.edu/ctools/ctools-providers/trunk/coursemanagement/impl/src/sql/mysql/academic_session.sql

Thanks,

- Zhen

On Jul 20, 2011, at 10:48 AM, Patrick Coleman wrote:

> Hi Zhen,
> 
> Thanks for replying. I'm not an expert on MySQL so I'm not sure. So can I run these statements without
> worrying if they have some strange effect?
> 
> Pat.
> 
> On Jul 20, 2011, at 10:43 AM, Zhen Qian wrote:
> 
>> Patrick:
>> 
>> Do you have sequence created as CM_ACADEMIC_SESSION_S? Like this:
>> 
>> --  This is to drop and redefine CM_ACADEMIC_SESSION_S, and create a trigger based on 
>> DROP SEQUENCE CM_ACADEMIC_SESSION_S;
>> 
>> CREATE SEQUENCE CM_ACADEMIC_SESSION_S 
>> START WITH 36
>> increment by 1
>> nomaxvalue;
>> 
>> Thanks,
>> 
>> - Zhen
>> 
>> 
>> On Jul 20, 2011, at 10:32 AM, Patrick Coleman wrote:
>> 
>>> I got an error with that insert?
>>> 
>>> insert into CM_ACADEMIC_SESSION_T values ( CM_ACADEMIC_SESSION_S.NEXTVAL,1,'admin',SYSDATE,'admin',SYSDATE,'201103',  
>>>    -> 'FALL 2011',  'FALL 2011',  '01-JUL-11',  '31-DEC-11',1);
>>> ERROR 1054 (42S22): Unknown column 'CM_ACADEMIC_SESSION_S.NEXTVAL' in 'field list'
>>> 
>>> 
>>> Pat.
>>> 
>>> On Jul 20, 2011, at 9:39 AM, Liu, Peter wrote:
>>> 
>>>> Pat,
>>>> 
>>>> You need first populate some data into the course-management table by inserting the row data as followings (for example) and then you will have a semester choice for the dropdown list.
>>>> 
>>>> Cheers,
>>>> Peter
>>>> 
>>>> - - - - - - - - - - - - 
>>>> insert into CM_ACADEMIC_SESSION_T values ( CM_ACADEMIC_SESSION_S.NEXTVAL,1,'admin',SYSDATE,'admin',SYSDATE,'201103',  
>>>> 			'FALL 2011',  'FALL 2011',  '01-JUL-11',  '31-DEC-11',1);
>>>> 
>>>> 
>>>> 
>>>> -----Original Message-----
>>>> From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Patrick Coleman
>>>> Sent: Wednesday, July 20, 2011 7:55 AM
>>>> To: sakai-dev at collab.sakaiproject.org
>>>> Subject: [Building Sakai] Can't add new course site?
>>>> 
>>>> 
>>>> Hi,
>>>> 
>>>> When I go into "Worksite Setup" and hit new to add a site I get 3
>>>> selections.
>>>> 
>>>> Course Site
>>>> Project Site
>>>> Portfolio Site
>>>> 
>>>> The Course site has a drop down box to select Academic Term but there is
>>>> nothing
>>>> in the drop down box and it won't let me continue with a new course site.
>>>> 
>>>> Does anyone know why there are no selections? I'm running Sakai 2.6
>>>> 
>>>> Thanks.
>>>> 
>>>> Pat
>>>> -- 
>>>> View this message in context: http://old.nabble.com/Can%27t-add-new-course-site--tp32098574p32098574.html
>>>> Sent from the Sakai - Development mailing list archive at Nabble.com.
>>>> 
>>>> _______________________________________________
>>>> sakai-dev mailing list
>>>> sakai-dev at collab.sakaiproject.org
>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>> 
>>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>> 
>>> Patrick Coleman
>>> patcoleman at me.com
>>> 301-651-9573
>>> 
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>> 
>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>> 
>>> 
>> 
> 
> Patrick Coleman
> patcoleman at me.com
> 301-651-9573
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110720/655ee6ec/attachment.html