[Building Sakai] Can't add new course site?
Patrick Coleman
patcoleman at me.com
Wed Jul 20 07:59:43 PDT 2011
Thanks for the help
On Jul 20, 2011, at 10:57 AM, Zhen Qian wrote:
> 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
>>
>
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/2b9348aa/attachment.html
More information about the sakai-dev
mailing list