Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+4 votes
in Plugins by
edited ago by

Before asking a question, I searched for related questions. A similar problem was posted before, but it has not been resolved. (Another related question)

I tried to solve it by myself, but the problem was still not solved.I describe this question and my findings, hoping to get a reply from the community.

1.  The picture intuitively reflects part of the proble. Comments are already posted and also generate the warning that your submission appears to be a duplicate.

2. Considering that it is possible that the plugin affects the normal work of the website. I deleted all the plugins, the warning disappeared, and the website returned to normal work.

3. I tried to run the plugin one by one, and finally found that the plugin of q2apro-on-site-notifications-master caused the failure. Since this plugin is very important for my website, I tested it in more depth.

4. This plugin only generates warnings for Chinese answers and comments. English answers and descriptions are normal. It may be related to multibyte encoding of chinese characters.

5. This is my error log:

 [error] 21206#0: *47740 FastCGI sent in stderr: "PHP message: PHP Question2Answer MySQL query error 1366: Incorrect string value: '\xEF...\x09f...' for column 'params' at row 1 - Query: INSERT INTO qa_eventlog (datetime, ipaddress, userid, handle, cookieid, event, params) VALUES (NOW(), '', '2', '娑夎胺鍥?, NULL, 'in_c_answer', 'postid=248 parentid=243 parenttype=A parent=array(46) questionid=242 question=array(46) thread=array(0) content=娓╁皵锛?骞村亣鏄緸鑱岀殑瀵肩伀绱... format= text=娓╁皵锛?骞村亣鏄緸鑱岀殑瀵肩伀绱... categoryid= name= notify=1 email=')" while reading response header from upstream, client: 175.***.**.***, server: heidongwang.top, request: "POST / HTTP/2.0", upstream: "fastcgi://unix:/tmp/php-cgi-73.sock:", host: "www.****.top", referrer: "https://www.****.top/242?state=comment-243&show=243"

I am not very good at English, there may be some grammatical errors. If you can’t understand it, tell me, I ’m happy to explain it.

Q2A version: Q2A 1.8.4
This is very strange. I found that when the number of characters in Chinese is less than 13, there is no warning. When the number of characters in Chinese is greater than 13, the warning appears.
Is it the wrong direction? When deleting the on-site-notifications plugin, the website is normal and there is no error warning. the error warning only appears when the plugin is installed.
I'm not sure that create table was success? Since the table is already present are you deleting and then adding again? What's the output of
Show CREATE TABLE `qa_eventlog` ?

The reason why that plugin causes failure is it turns on event log. It is actually the eventlogger which is causing the failure. But wherever the duplicate message is coming from -- it is a bug. It should have instead reported server error. Are you using any plugin to avoid duplicate submissions?
I have made great efforts and tried many ways, but it has not been resolved. I gave up.Thank you for your patient reply, thank you

Please log in or register to answer this question.