Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Some Q2A plugins are not compatible with PhP 7 and MySQL 5.7

+3 votes
asked Feb 9 in Plugins by htabar
edited Feb 9 by htabar

Hi There,

I updated PHP 5.6 to 7 and MySQL 5.5 to 5.7.

Everything was fine in the older versions, however since I updated the server some plugins such as: Custom 404 page, gregorian2jalali face problems. Some pages goes blank and the Inspect Element, Console section nothing shows. up. For example, if I activate gregorian2jalali plugin, User Profie page doesn't show up.

Also in the Custom 404 page plugin, the following error comes up in 404 pages:

A Question2Answer database query failed when generating this page. A full description of the failure is available in the web server's error log file.

There was a related question for an earlier problem here: When adding page link, database query error occurs.

In the Apache Error Log, a message similar to this message comes up:

PHP Question2Answer MySQL query error 1146: Table 'qa.qa_options' doesn't exist - Query: (SELECT 'options' AS selectkey, title, content FROM qa_options) UNION ALL (SELECT 'time', 'db_time', UNIX_TIMESTAMP(NOW()))

Also, there was an earlier problem here at this question: is there a way to manually create the database tables ?

Now that the plugin is not updated, how I can fix this problem ?


Q2A version: 1.7.4
commented Feb 9 by ProThoughts
are you using below plugin? I dont think anyone tested q2a with PHP 7 and MySQL 5.7.
commented Feb 12 by Scott
I don't see anything in the code that would break on PHP 7 or MySQL 5.7.

What is the "gregorian2jalali plugin"? Do you have a link?
commented Feb 12 by htabar
Answer to  ProThoughts:  No, I didn't use this plugin, but once I used this plugin, problem was solved. Thanks Bro

Answer to Scott: search for: Gregorian 2 Jalali in this page: https://github.com/q2a/q2a.github.io/blob/master/addons/index.md

Or, you can download it from the following link

Please log in or register to answer this question.