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

[Patrick Coleman]

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/b0038819/attachment.html