[Building Sakai] YAFT TABLE YAFT_FORUM_GROUP

[Coetzee, Nico]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.

Hi Adrian

We currently have a problem on our develeopment server, I am not sure if there is something wrong with our sakai installation (maybe with our CourseManagementService) or something wrong with yaft

When we try to add a new Yaft forum, it does a statement in impl/src/java/org/sakaiproject/yaft/impl/sql/DefaultSqlGenerator.java

for(Group group : forum.getGroups())
   {
    PreparedStatement addGroupsStatement = connection.prepareStatement("INSERT INTO YAFT_FORUM_GROUP VALUES(?,?)");
    addGroupsStatement.setString(1,forum.getId());
    addGroupsStatement.setString(2,group.getId());

    statements.add(addGroupsStatement);
   }
  }

We have no entries in YAFT_FORUM_GROUP and it gets no values in forum.getGroups() so it trying to insert null values into the table.

Where is the groups comming from?

If we (UNISA) is not using groups is there a way to disable this feature?

Thanks


________________________________________
From: Adrian Fish [a.fish at lancaster.ac.uk]
Sent: 08 July 2011 10:56 AM
To: Coetzee, Nico
Subject: Re: SAKAIDEV Upgrade

Hi Nico,

Yes, it should be the equivalent of mysql bigint(20) is, which I think
is NUMBER (10,0). My trouble is I know next to nothing about Oracle :(

Cheers,
Adrian.

On 08/07/2011 09:11, Coetzee, Nico wrote:
> This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
> ________________________________
>
> Hi Adrian
>
> Can you please check YAFT_DISCUSSION table on Oracle,  according to the script it has a column GRADEBOOK_ASSIGNMEN_ID but the type is BIGNUMBER(10,0)(20) which does not exist, should it be NUMBER (10,0)?
>
> Thanks
>
> On 12 May 2011, at 10:43 AM, Adrian Fish wrote:
>
> Good morning Nico,
>
> Whoops. Stupid search and replace operator error :(
>
> I've attached a fixed version and updated in the tag.
>
> Cheers,
> Adrian.
>
> On 12/05/2011 07:07, Nico Coetzee wrote:
>
>
> Begin forwarded message:
>
> From: "Mokonyama, Mpedi"<mokonmm at unisa.ac.za<mailto:mokonmm at unisa.ac.za>>
> Date: 11 May 2011 4:18:37 PM SAST
> To: "Coetzee, Nico"<Coetzeen at unisa.ac.za<mailto:Coetzeen at unisa.ac.za>>
> Cc: "Seopa, Mohale"<MSeopa at unisa.ac.za<mailto:MSeopa at unisa.ac.za>>
> Subject: SAKAIDEV Upgrade
>
> Please confirm the following statement as I get errors:
>
> CREATE TABLE YAFT_FORUM_GROUP (FORUM_ID CHAR(36) NOT NULL
>                                                       ,GROUP_ID VARCHAR2(36) NOT NULL
>                                                       ,CONSTRANUMBER(10,0) yaft_forum_group_pk PRIMARY KEY (FORUM_ID,GROUP_ID));
>
> Thanks
>
>
> Mpedi M Mokonyama (Ms)
> Deputy Director: Data/Database Management and Applications Solutions
> UNISA ICT Department
> Cas Van Vuuren Building 5-97
> Tel : 012 429 3707
> mokonmm at unisa.ac.za<mailto:mokonmm at unisa.ac.za>
>
>
>
> Nico Coetzee
> Designer Developer
> ICT
> Unisa Main Campus
> Preller Street
> Pretoria
> Tel: +27 (012) 429-4661
> Fax : 0862756913
>
>

--
==================================
Adrian Fish
Software Engineer
Centre for e-Science
Bowland Tower South C Floor
Lancaster University
Lancaster
LA1 4YW
email: a.fish at lancaster.ac.uk

http://confluence.sakaiproject.org/display/YAFT/Yaft
http://confluence.sakaiproject.org/display/CLOG/Home
http://confluence.sakaiproject.org/display/BBB/Home