702210 – Cannot translate from Zanata GUI

Bug 702210 - Cannot translate from Zanata GUI

Summary: Cannot translate from Zanata GUI

Keywords:
Status:	CLOSED NOTABUG
Alias:	None
Product:	Zanata
Classification:	Retired
Component:	Component-Logic
Sub Component:
Version:	1.3-alpha-1
Hardware:	i386
OS:	Linux
Priority:	high
Severity:	high
Target Milestone:	---
Target Release:	---
Assignee:	zanata-dev-internal
QA Contact:	Ding-Yi Chen
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2011-05-05 05:00 UTC by Kenichi Takemura
Modified:	2014-08-04 22:03 UTC (History)
CC List:	3 users (show)
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2011-05-05 07:13:24 UTC
Embargoed:

Attachments	(Terms of Use)

Description Kenichi Takemura 2011-05-05 05:00:46 UTC

Description of problem:

Translation to JK languages fails due to a SQL error

Caused by: java.sql.SQLException: Incorrect string value: '\xEC\xA3\xBC\xEC\x9A\x94...' for column 'content' at row 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
	... 117 more


Version-Release number of selected component (if applicable):
Zanata version 1.3-alpha-1 (20110330-1649). 

How reproducible:
100%

Steps to Reproduce:
1. Create a project
2. Import po files
3. Translate into JK languages and click save
  
Actual results:
Failed to translation update.

Expected results:
Should be successful what's wrong?!

Additional info:

Comment 1 Sean Flanigan 2011-05-05 05:06:42 UTC

More of the log, please.  The exception stacktrace should mention org.zanata at some point.

Also, please check that you created the database with 'DEFAULT CHARACTER SET utf8', and that your zanata-ds.xml specifies UTF-8.

What string did you enter?

Comment 2 Kenichi Takemura 2011-05-05 05:14:25 UTC

oops.

mysql> SHOW CREATE DATABASE zanata;
+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
| zanata   | CREATE DATABASE `zanata` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-------------------------------------------------------------------+


I will try again.

Comment 3 Kenichi Takemura 2011-05-05 07:13:24 UTC

I was mistaken.

Note You need to log in before you can comment on or make changes to this bug.