Author Topic: can't modify the QA for chinese language  (Read 6222 times)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
can't modify the QA for chinese language
« on: June 09, 2010, 09:56:41 »
I can't modify the QA for chinese language,it always show ??

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #1 on: June 14, 2010, 09:59:42 »
Can you post a screenshot?

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #2 on: June 14, 2010, 10:10:58 »
modify, before save

after save

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #3 on: June 15, 2010, 14:40:36 »
Thanks we track that as bug #1123

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #4 on: June 17, 2010, 16:05:55 »
wait for your solution

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #5 on: June 18, 2010, 16:06:37 »
From what I see, most likely it's not the page having problems but the underlying MySQL instance on tables:

- qa_data
- qa_forms
- qa_forms_items

Please make sure they are all UTF-8, as per http://queuemetrics.com/faq.jsp#faq-036-internationalized-bug231


coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #6 on: June 21, 2010, 12:22:03 »
i follow the faq,and find two
1.&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8  the  & should be & in the web.xml
2.when i use a chinese character,there is a exception


"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' - at it.loway.tpf.SQL.selectScalare(SQL.java:322) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.PTValidateRecord(ptQAForms.java:167) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(PagedTransactor.java:166) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(PagedTransactor.java:85) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.doRun(ptQAForms.java:75) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:255) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:543) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:365) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:217) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - "

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #7 on: June 21, 2010, 12:23:42 »
And another logs in tomcat's log file

2010-06-21 18:16:56 StandardContext[/queuemetrics][59703F7C604948A84CF6EBC8618C0DDB] Agenti trovati/consentiti: 6/9999
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211816 Tempo totale esecuzione verbo 'qm_mostra_coda_fast_dyn': 6332 ms
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211816 Tempo totale esecuzione verbo 'qm_realtime2_ds': 8 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 22 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 29 ms
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:02 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_qa_report_input': 8 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 7 ms
2010-06-21 18:17:07 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 33 ms

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #8 on: June 25, 2010, 10:26:24 »
This is the issue:

Problema DB: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Basically either the table or its fields are still with encoding "latin1_swedish_ci" while you should turn it all to UTF-8.
This may apply to the general server settings as well - make sure it is UTF-8.


coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #9 on: June 26, 2010, 07:59:51 »
i have change the field in qa_form,it's ok

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #10 on: June 28, 2010, 10:30:37 »
Can you post your change you did, so it stays here as an help for future users?

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: can't modify the QA for chinese language
« Reply #11 on: July 10, 2010, 09:53:52 »
of course

i just follow the faq http://queuemetrics.com/faq.jsp#faq-036-internationalized-bug231
change the table qa_data、qa_forms、qa_forms_items,the only more things i do was just modify the field encode in qa_forms,you can do it under cli or phpmyadmin

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: can't modify the QA for chinese language
« Reply #12 on: July 12, 2010, 10:41:36 »
Thanks