[Building Sakai] Profile2 v1.1 released

James Marca jmarca at translab.its.uci.edu
Mon May 4 17:47:11 PDT 2009


Steve,

this looks like a very promising tool

I am testing it out on Sakai 2.5.4.  I followed all of your
instructions on the Profile2 page (excellent docs, by the way!)

First, a trivial comment...we here in the states spell favourite
without the 'u'.

Second, I seem to have hit a bug.  When clicking on the "preferences"
tab, I get an error:

May 4, 2009 5:23:57 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1364, SQLState: HY000
May 4, 2009 5:23:57 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Field 'EMAIL' doesn't have a default value
May 4, 2009 5:23:57 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:575)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy45.createDefaultPreferencesRecord(Unknown Source)
        at uk.ac.lancs.e_science.profile2.tool.pages.MyPreferences.<init>(MyPreferences.java:49)
        at uk.ac.lancs.e_science.profile2.tool.pages.BasePage$5.onClick(BasePage.java:113)
        at org.apache.wicket.markup.html.link.Link.onLinkClicked(Link.java:214)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

... blah blah blah ...

Caused by: java.sql.BatchUpdateException: Field 'EMAIL' doesn't have a default value
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1213)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:912)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
...


I get a similar dump in logs when I click on "Privacy" option, except
substitute "PROFILE" for "EMAIL" in the above error dump, and the root
of the error in the uk.ac.lancs... namespace  is

        at $Proxy45.createDefaultPrivacyRecord(Unknown Source)
        at uk.ac.lancs.e_science.profile2.tool.pages.MyPrivacy.<init>(MyPrivacy.java:50)
        at uk.ac.lancs.e_science.profile2.tool.pages.BasePage$3.onClick(BasePage.java:95)


Oh, and I fired up Sakai with auto.ddl set to true, as recommended in the
docs.  I'm not sure if this is a bug or I missed a configuration somewhere.  

James

On Mon, Apr 06, 2009 at 04:39:43PM +0100, Steve Swinsburg wrote:
> 
> Hi everyone,
> 
> I am very pleased to announce the 1.1 release of Profile2 for Sakai.
> 
> Profile2 is a complete re-development of the existing Profile tool in  
> Sakai and brings social networking to Sakai2. A Facebook-like  
> interface for editing your profile, comprehensive privacy controls,  
> post status updates including Twitter integration, searching for  
> people with common interests and adding them as a connection, are what  
> Profile2 is all about.
> 
> Over 23 fixes and new features are incorporated into this release  
> including: improved Twitter integration, email and event publishing,  
> full control over the configuration, improved AJAX processing, and  
> full support for 2.4.x, 2.5.x and the 2.6.x releases of Sakai.
> 
> More information, including screenshots and installation instructions  
> for all three Sakai flavours are available on Confluence here:
> http://confluence.sakaiproject.org/confluence/display/PROFILE/Profile2
> 
> For the full list of features and fixes for the release, please see  
> the issue Navigator for Profile2 in the Sakai Jira:
> http://jira.sakaiproject.org/jira/secure/IssueNavigator.jspa?reset=true&pid=10500&fixfor=11410
> 
> 
> regards,
> 
> Steve Swinsburg
> Portal Systems Developer
> Centre for e-Science
> Lancaster University
> Lancaster
> LA1 4YT
> 
> email: s.swinsburg at lancaster.ac.uk
> phone: +44 (0) 1524 594870
> 
> 
> 
> 
> 
> 
> 



> _______________________________________________
> 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"

-- 
James E. Marca, PhD
Researcher
Institute of Transportation Studies
AIRB Suite 4000
University of California
Irvine, CA 92697-3600
jmarca at translab.its.uci.edu
(949) 824-6287

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



More information about the sakai-dev mailing list