Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
42 views
ago in Q2A Core by
edited ago by

Hi,

Nginx throws this error. Everything works through Apache. I think that it’s the encoding, but I don’t know where to fix it. 

Upd: I use the official release. There was no such problem on the previous hosting. I looked at the database - everything is displayed normally.

Upd2: Found out that the error is only on php 7.1. On php 7.0 everything works.

Thanks.

2020/01/14 12:16:25 [error] 1418#1418: *3704 FastCGI sent in stderr: "PHP message: PHP Question2Answer MySQL query error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AN'сделать' word=$ COLLATE utf8_bin LIMIT 1) ORDER BY postcreat0d20DESC L' at line 1 - Query: SELECT qa_posts.postid, qa_posts.categoryid, qa_posts.type, LEFT(qa_posts.type, 1) AS `basetype`, INSTR(qa_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qa_posts.type, '_QUEUED')>0 AS `queued`, qa_posts.acount, qa_posts.selchildid, qa_posts.closedbyid, qa_posts.upvotes, qa_posts.downvotes, qa_posts.netvotes, qa_posts.views, qa_posts.hotness, qa_posts.flagcount, qa_posts.title, qa_posts.tags, UNIX_TIMESTAMP(qa_posts.created) AS `created`, qa_posts.name, qa_categories.title AS `categoryname`, qa_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qa_posts.catidpath1, qa_posts.catidpath2, qa_posts.catidpath3, qa_posts.categoryid) AS `categoryids`, qa_uservotes.vote AS `uservote`, qa_uservotes.flag AS `userflag`, qa" while reading response header from upstream, , request: "GET /?qa=tag/%D1%81%D0%B4%D0%B5%D0%BB%D0%B0%D1%82%D1%8C HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:"

ago by
Are you using the official release or did you download the repository from GitHub?
ago by
Found out that the error is only on php 7.1. On php 7.0 everything works.

Please log in or register to answer this question.

...