Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
737 views
in Q2A Core by
edited 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:"

by
Are you using the official release or did you download the repository from GitHub?
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.

...