Ah,,, Many thanks Sebastian. Stupid boy that I am......... Just as a note to others using Xampp for Windows, syntax in my.ini is: - character-set-server = utf8
OM just keeps getting better and better. Best regards David On Sep 22, 6:09 pm, "[email protected]" <[email protected]> wrote: > you've missed to set server-character-set=utf8 in your mysql server > config before installing openmeetings. > > Sebastian > > 2011/9/22 Deemac <[email protected]>: > > > > > > > > > Hi, > > > Don't know if anyone else is experiencing this when installing but I'm > > getting a java exception and the install fails > > > Windows 2k3 box, Xampp 1.7.3, r4260 > > > Install creates the database and starts populating it. It gets to > > adding ID 236 then starts on the language files. When it reaches > > Italian it throws an exception. as below. > > > Has anyone come across this Incorrect String Value and more > > importantly does anyone know how to fix? > > > Many thanks > > > David > > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: > > Incorrect string v > > alue: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1 > > {prepstmnt 16307 > > 093 INSERT INTO fieldlanguagesvalues (deleted, fieldvalues_id, > > language_id, star > > ttime, updatetime, value) VALUES (?, ?, ?, ?, ?, ?) > > [params=?, ?, ?, ?, ?, ?]} [ > > code=1366, state=HY000] > > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo > > nnectionDecorator.java:281) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo > > nnectionDecorator.java:257) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(Lo > > ggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0] > > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator > > $LoggingConnect > > ion > > $LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java: > > 1199) > > ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate > > (DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate > > (DelegatingPreparedStatement.java:291) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUp > > date(PreparedStatementManagerImpl.java:267) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndU > > pdate(PreparedStatementManagerImpl.java:118) ~[openjpa-2.1.0.jar: > > 2.1.0] > > ... 56 common frames omitted > > ERROR 09-22 16:26:46.624 Install.java 181441 405 > > org.openmeetings.servlet.output > > handler.Install [http-0.0.0.0-5080-2] - Install: > > org.springframework.orm.jpa.JpaSystemException: The transaction has > > been rolled > > back. See the nested exceptions for details on the errors that > > occurred.; neste > > d exception is <openjpa-2.1.0-r422266:1071316 fatal general error> > > org.apache.op > > enjpa.persistence.PersistenceException: The transaction has been > > rolled back. S > > ee the nested exceptions for details on the errors that occurred. > > FailedObject: > > org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues@1 > > 89c979 > > at > > org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAcces > > sExceptionIfPossible(EntityManagerFactoryUtils.java:311) > > ~[org.springframework.o > > rm-3.0.5.RELEASE.jar:3.0.5.RELEASE] > > at > > org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPos > > sible(DefaultJpaDialect.java:120) > > ~[org.springframework.orm-3.0.5.RELEASE.jar:3. > > 0.5.RELEASE] > > at > > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransac > > tionManager.java:471) ~[org.springframework.orm-3.0.5.RELEASE.jar: > > 3.0.5.RELEASE] > > > at > > org.springframework.transaction.support.AbstractPlatformTransactionMa > > nager.processCommit(AbstractPlatformTransactionManager.java:754) > > ~[org.springfra > > mework.transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE] > > at > > org.springframework.transaction.support.AbstractPlatformTransactionMa > > nager.commit(AbstractPlatformTransactionManager.java:723) > > ~[org.springframework. > > transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE] > > at > > org.springframework.transaction.interceptor.TransactionAspectSupport. > > commitTransactionAfterReturning(TransactionAspectSupport.java:393) > > ~[org.springf > > ramework.transaction-3.0.5.RELEASE.jar:3.0.5.RELEASE] > > at > > org.springframework.transaction.interceptor.TransactionInterceptor.in > > voke(TransactionInterceptor.java:120) > > ~[org.springframework.transaction-3.0.5.RE > > LEASE.jar:3.0.5.RELEASE] > > at > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > > ReflectiveMethodInvocation.java:172) > > ~[org.springframework.aop-3.0.5.RELEASE.jar > > :3.0.5.RELEASE] > > at org.springframework.aop.framework.Cglib2AopProxy > > $DynamicAdvisedInterc > > eptor.intercept(Cglib2AopProxy.java:621) > > ~[org.springframework.aop-3.0.5.RELEASE > > .jar:3.0.5.RELEASE] > > at org.openmeetings.app.data.basic.Fieldmanagment$ > > $EnhancerByCGLIB$$9df7 > > c0fe.addFieldValueByFieldAndLanguage(<generated>) > > ~[cglib-2.2.2.jar:na] > > at > > org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages( > > ImportInitvalues.java:793) ~[openmeetings.jar:na] > > at > > org.openmeetings.servlet.outputhandler.Install.handleRequest(Install. > > java:338) ~[openmeetings.jar:na] > > at > > org.apache.velocity.tools.view.VelocityViewServlet.doRequest(Velocity > > ViewServlet.java:217) [velocity-tools-view-2.0.jar:2.0] > > at > > org.apache.velocity.tools.view.VelocityViewServlet.doPost(VelocityVie > > wServlet.java:192) [velocity-tools-view-2.0.jar:2.0] > > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > > 637) [javaee- > > api-5.1.2.jar:5.1.2] > > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > > 717) [javaee- > > api-5.1.2.jar:5.1.2] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > > icationFilterChain.java:290) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > > ilterChain.java:206) [catalina-6.0.26.jar:6.0.26] > > at > > org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilte > > r(ServletRequestExFilter.java:35) [openmeetings.jar:na] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > > icationFilterChain.java:235) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > > ilterChain.java:206) [catalina-6.0.26.jar:6.0.26] > > at > > org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.jav > > a:78) [red5.jar:na] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > > icationFilterChain.java:235) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > > ilterChain.java:206) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV > > alve.java:233) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV > > alve.java:191) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica > > torBase.java:465) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j > > ava:127) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j > > ava:102) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: > > 555) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal > > ve.java:109) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav > > a:298) [catalina-6.0.26.jar:6.0.26] > > at > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java > > :852) [tomcat-coyote-6.0.26.jar:6.0.26] > > at org.apache.coyote.http11.Http11Protocol > > $Http11ConnectionHandler.proce > > ss(Http11Protocol.java:588) [tomcat-coyote-6.0.26.jar:6.0.26] > > at org.apache.tomcat.util.net.JIoEndpoint > > $Worker.run(JIoEndpoint.java:48 > > 9) [tomcat-coyote-6.0.26.jar:6.0.26] > > at java.lang.Thread.run(Unknown Source) [na:1.6.0_27] > > Caused by: org.apache.openjpa.persistence.PersistenceException: The > > transaction > > has been rolled back. See the nested exceptions for details on the > > errors that > > occurred. > > at > > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.jav > > a:2316) ~[openjpa-2.1.0.jar:2.1.0] > > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java: > > 2153) ~[op > > enjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051) > > ~[openjpa-2.1.0.jar:2.1.0] > > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java: > > 1822) ~[op > > enjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManage > > rImpl.java:609) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerIm > > pl.java:696) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateMan > > agerImpl.java:1608) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManage > > rImpl.java:1591) ~[openjpa-2.1.0.jar:2.1.0] > > at > > org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.pcGe > > tfieldlanguagesvalues_id(Fieldlanguagesvalues.java) > > ~[openmeetings.jar:na] > > at > > org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues.getF > > ieldlanguagesvalues_id(Fieldlanguagesvalues.java:44) > > ~[openmeetings.jar:na] > > at > > ... > > read more » -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
