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

[Patrick Coleman]

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