QueueMetrics forum
QueueMetrics => Running QueueMetrics => Topic started by: coolname on June 09, 2010, 09:56:41
-
I can't modify the QA for chinese language,it always show ??
-
Can you post a screenshot?
-
modify, before save (http://i3.6.cn/cvbnm/ee/9b/03/c77913f02363432af80e6eacb75a7191.jpg)
after save
(http://i3.6.cn/cvbnm/81/27/89/9f3eeafe60f078c18f23f4c52235ac29.jpg)
-
Thanks we track that as bug #1123
-
wait for your solution
-
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
-
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 -- - "
-
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
-
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.
-
i have change the field in qa_form,it's ok
-
Can you post your change you did, so it stays here as an help for future users?
-
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
-
Thanks