[
http://opencast.jira.com/browse/MH-8335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=28874#comment-28874
]
David Horwitz commented on MH-8335:
-----------------------------------
Initial test of the 1.3 mysql ddl script looks good. There is 1 error affecting
the DDL:
Internal Exception: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Code: 1267
Call: SELECT text, language, weight, count, stop_word FROM dictionary WHERE
((text = ?) AND (language = ?))
bind => [ASEBĒS, es]
Query: ReadAllQuery(name="Word.get" referenceClass=Word sql="SELECT text,
language, weight, count, stop_word FROM dictionary WHERE ((text = ?) AND
(language = ?))")
2012-01-11 12:21:01 WARN (DictionaryScanner:89) - Unable to add word 'ΤΕΚΤΩΝ'
to the es dictionary:
Internal Exception: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Code: 1267
> Refactor MH DB tables
> ---------------------
>
> Key: MH-8335
> URL: http://opencast.jira.com/browse/MH-8335
> Project: Matterhorn Project
> Issue Type: Task
> Components: Architecture & Services
> Affects Versions: 1.3, Trunk
> Reporter: Greg Logan
> Assignee: Tobias Wunden
> Priority: Critical
> Fix For: 1.3
>
> Attachments: example.sql, MH-8335-withoutIngest.diff
>
>
> We have a pair of proposals which need to be implemented into the database.
> This should be done as part of 1.3, however if they can be slipped back to
> 1.4 if necessary.
> Proposal #1:
> http://opencast.3480289.n2.nabble.com/Database-naming-scheme-proposal-td6857022.html
> Proposal #2:
> http://opencast.3480289.n2.nabble.com/DB-Nighmares-proposal-td6934468.html
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________