[Building Sakai] Profile2 v1.1 released
Steve Swinsburg
s.swinsburg at lancaster.ac.uk
Tue May 5 02:32:00 PDT 2009
Hi James,
Thanks for trying it out. As for the spelling differences, its fully
internationalised so you can modify ProfileApplication.properties and
change as you please, or create your own US variant
(ProfileApplication_en_US.properties I believe) and it will pick it up
(in PROFILE2/tool/src/java/uk/ac/lancs/e_science/profile2/tool/).
I think I know what the issue is regarding the exception. Did you take
a fresh checkout of Profile2 v1.1 and build that, or did you have an
older version installed previously?
If you had an older version, did you get rid of the older version in
TOMCAT/shared/lib? Would be good to take a look in there and just
double check there are no duplicates of sakai-profile2-api-VERSION.jar
There is also a DB upgrade that needs to be run manually between
versions (in PROFILE2/docs/database).
If it was completely fresh (no db tables from an older version either)
and/or you performed the upgrade successfully, could you have a look
in the database tables and give me the structure of
PROFILE_PREFERENCES_T?
Mine looks like:
mysql> describe PROFILE_PREFERENCES_T;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| USER_UUID | varchar(36) | NO | PRI | NULL | |
| EMAIL_REQUEST | bit(1) | NO | | NULL | |
| EMAIL_CONFIRM | bit(1) | NO | | NULL | |
| TWITTER_ENABLED | bit(1) | NO | | NULL | |
| TWITTER_USERNAME | varchar(255) | YES | | NULL | |
| TWITTER_PASSWORD | varchar(255) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
Previously there was a field called EMAIL, but its been split into the
above two fields.
cheers,
Steve
---
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
On 5 May 2009, at 01:47, James Marca wrote:
> 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.
>
> _______________________________________________
> 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"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090505/5f732dc5/attachment.bin
More information about the sakai-dev
mailing list