[Building Sakai] Using YAFT with Sakai 2.6.2 demo

[Steve Swinsburg]

Hi Mike,

This is because the YAFT tables haven't been created. I'm not sure how the demo distribution handles new tools being dropped into it. How did you install YAFT? 

The tables should be created at startup if auto.ddl=true in sakai.properties, which it is by default, it might be the actual install/deployment of YAFT that is the issue.

cheers,
Steve



On 25/06/2010, at 4:39 AM, Mike Chale wrote:

> I'm trying to evaluate YAFT by running it in the Sakai 2.6.2 demo, but have been
> getting errors related to the database.  I'm wondering if this is a common
> problem with the demo's HypersonicSQL database.  Any advice is appreciated.
> 
> Server: PC running Windows 7 Enterprise, 64-bit
> 
> Errors: HTTP 500 returned to the browser
> 
> Tomcat log (excerpts):
> ERROR main org.sakaiproject.yaft.impl.YaftPersistenceManager
> ERROR http-8080-Processor20 org.sakaiproject.yaft.impl.YaftPersistenceManager
> - Caught exception whilst getting preferences
>    java.sql.SQLException: Table not found in statement 
>    [SELECT * FROM YAFT_PREFERENCES]
> ERROR http-8080-Processor25 org.sakaiproject.yaft.impl.YaftPersistenceManager
> - Caught exception whilst getting discussion unsubscribers.
>   java.sql.SQLException: Table not found in statement 
>   [SELECT DISCUSSION_ID FROM YAFT_DISCUSSION_UNSUBS]
> ERROR http-8080-Processor19 org.sakaiproject.yaft.impl.YaftPersistenceManager
> - Caught exception whilst getting forum unsubscribers.
>   java.sql.SQLException: Table not found in statement 
>   [SELECT FORUM_ID FROM YAFT_FORUM_UNSUBS]
> ERROR http-8080-Processor22 org.sakaiproject.yaft.impl.YaftPersistenceManager
> - Caught exception whilst getting fora.
>   java.sql.SQLException: Table not found in statement [SELECT * FROM YAFT_FORUM]
> 
> I can provide the full log, if necessary (619 lines, 54k in size).
> 
> Thank you,
> -Mike
> 
> _______________________________________________
> 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"