Bug 702210 - Cannot translate from Zanata GUI
Cannot translate from Zanata GUI
Status: CLOSED NOTABUG
Product: Zanata
Classification: Community
Component: Component-Logic (Show other bugs)
1.3-alpha-1
i386 Linux
high Severity high
: ---
: ---
Assigned To: zanata-dev-internal
Ding-Yi Chen
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2011-05-05 01:00 EDT by Kenichi Takemura
Modified: 2014-08-04 18:03 EDT (History)
3 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2011-05-05 03:13:24 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:


Attachments (Terms of Use)

  None (edit)
Description Kenichi Takemura 2011-05-05 01:00:46 EDT
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 01:06:42 EDT
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 01:14:25 EDT
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 03:13:24 EDT
I was mistaken.

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