Bug 702210

Summary: Cannot translate from Zanata GUI
Product: [Retired] Zanata Reporter: Kenichi Takemura <ktakemur>
Component: Component-LogicAssignee: zanata-dev-internal <zanata-dev-internal>
Status: CLOSED NOTABUG QA Contact: Ding-Yi Chen <dchen>
Severity: high Docs Contact:
Priority: high    
Version: 1.3-alpha-1CC: ebaak, sflaniga, zanata-bugs
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-05-05 07:13:24 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

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.