Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Mauro Anceschi
Web Content is temporarily unavailable
November 16, 2009 3:34 AM
Answer

Mauro Anceschi

Rank: New Member

Posts: 11

Join Date: June 19, 2009

Recent Posts

Hi!

When we use the assets publisher with chinese language we get this error when saving the page:

"Web Content is temporarily unavailable"

server:SUSE 10 Enterprise
LR: Liferay 5.2.3 with Tomcat 5.5

Any idea/suggestion?


Regards, Mauro
Aritz Galdos
RE: Web Content is temporarily unavailable
November 16, 2009 3:40 AM
Answer

Aritz Galdos

Rank: Expert

Posts: 405

Join Date: May 15, 2007

Recent Posts

Hi..

The error messages of the stack trace would be helpful.

Could you post them?
Mauro Anceschi
RE: Web Content is temporarily unavailable
November 16, 2009 5:46 AM
Answer

Mauro Anceschi

Rank: New Member

Posts: 11

Join Date: June 19, 2009

Recent Posts

13:50:01,568 ERROR [JDBCExceptionReporter:101] Data truncation: Data too long for column 'content' at row 1
13:50:01,585 ERROR [jsp:165] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91)
at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.updateImpl(JournalArticlePersistenceImpl.java:499)
at com.liferay.portlet.journal.service.persistence.JournalArticlePersistenceImpl.update(JournalArticlePersistenceImpl.java:462)
at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.updateArticle(JournalArticleLocalServiceImpl.java:1943)
at com.liferay.portal.mirage.aop.MirageInvoker.invoke(MirageInvoker.java:47)
at com.liferay.portal.mirage.aop.ContentInvoker.invoke(ContentInvoker.java:47)
at com.liferay.portal.mirage.service.ContentServiceImpl.process(ContentServiceImpl.java:247)
at com.liferay.portal.mirage.service.ContentServiceImpl.updateContent(ContentServiceImpl.java:228)
at com.liferay.portal.spring.aop.LogAdvice.invoke(LogAdvice.java:73)
at com.liferay.portal.mirage.aop.JournalArticleLocalServiceAdvice.doInvoke(JournalArticleLocalServiceAdvice.java:71)
at com.liferay.portal.mirage.aop.BaseMirageAdvice.invoke(BaseMirageAdvice.java:47)
at com.liferay.portlet.journal.service.impl.JournalArticleServiceImpl.updateArticle(JournalArticleServiceImpl.java:267)
at com.liferay.portlet.journal.service.JournalArticleServiceUtil.updateArticle(JournalArticleServiceUtil.java:229)
at com.liferay.portlet.journal.action.EditArticleAction.updateArticle(EditArticleAction.java:513)
at com.liferay.portlet.journal.action.EditArticleAction.processAction(EditArticleAction.java:109)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:180)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:197)
at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:98)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:57)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:632)
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
Aritz Galdos
RE: Web Content is temporarily unavailable
November 16, 2009 5:54 AM
Answer

Aritz Galdos

Rank: Expert

Posts: 405

Join Date: May 15, 2007

Recent Posts

Here is the key
13:50:01,568 ERROR [JDBCExceptionReporter:101] Data truncation: Data too long for column 'content' at row 1


Does this line say something to you? What db are you using? Oracle? MySql?


For example, in my oracle DBs, this fild is a CLOB whereas in MySQL DBs it is a LONGTEXT

By the way, what is the charset of your tables?
Mauro Anceschi
RE: Web Content is temporarily unavailable
November 16, 2009 6:15 AM
Answer

Mauro Anceschi

Rank: New Member

Posts: 11

Join Date: June 19, 2009

Recent Posts

MySQL 5

charset:latin1_swedish_ci


I've changed the field:content of the table JournalArticle to UTF8 and now it works.....
..do I need to change all the lportal tables ????


Thanks
Aritz Galdos
RE: Web Content is temporarily unavailable
November 16, 2009 6:15 AM
Answer

Aritz Galdos

Rank: Expert

Posts: 405

Join Date: May 15, 2007

Recent Posts

It looks likelly to be the reason...

I think you sould use UTF8 encoding instead of latin
Mauro Anceschi
RE: Web Content is temporarily unavailable
November 16, 2009 6:33 AM
Answer

Mauro Anceschi

Rank: New Member

Posts: 11

Join Date: June 19, 2009

Recent Posts

Do you know the mysql command to do that for all the tables of lportal??

thanks
Aritz Galdos
RE: Web Content is temporarily unavailable
November 16, 2009 6:44 AM
Answer

Aritz Galdos

Rank: Expert

Posts: 405

Join Date: May 15, 2007

Recent Posts

Hi..

Have a look at this post

;)

and BE CAREFUL and make a back up emoticon
Mauro Anceschi
RE: Web Content is temporarily unavailable
November 16, 2009 7:31 AM
Answer

Mauro Anceschi

Rank: New Member

Posts: 11

Join Date: June 19, 2009

Recent Posts

Thanks! :-)
Lisa Simpson
RE: Web Content is temporarily unavailable
November 16, 2009 1:28 PM
Answer

Lisa Simpson

Rank: Liferay Legend

Posts: 2034

Join Date: March 5, 2009

Recent Posts

In theory, the script that creates the Mysql db when you start liferay should be setting it to UTF8.
Gabriel Bustos Padilla
RE: Web Content is temporarily unavailable
March 24, 2014 1:22 AM
Answer

Gabriel Bustos Padilla

Rank: Junior Member

Posts: 63

Join Date: March 6, 2013

Recent Posts

Hi! I have the same problem with the introduction of chinese characters in a webcontent. The version of LR is the 6.2, a community version. I supposed that this bug would be fixed in the new version :-( which table is what I have to modify to UTF8 into the lportal database?

thanks in advance