neogeox
Customer
I have a conflict with a code and a cache feature of vBOptimise 2.7.1
I've noticed that If I deactivate the feature (Pro) Forum Display Query Enhancement on your addon everything works well, but if this feature is active then I get a Mysql error.
I think is related with your "hack" for forumdisplay.php so I would like to ask you if you knows what could be the solution to solve this problem because I really need this working. Thank you for your support.
MYSQL ERROR
I've noticed that If I deactivate the feature (Pro) Forum Display Query Enhancement on your addon everything works well, but if this feature is active then I get a Mysql error.
I think is related with your "hack" for forumdisplay.php so I would like to ask you if you knows what could be the solution to solve this problem because I really need this working. Thank you for your support.
MYSQL ERROR
SQL:
Database error:
Invalid SQL:
SELECT COUNT(*) AS threads,
(
SELECT COUNT(*) AS newthread
FROM thread AS thread
WHERE forumid = 2
AND lastpost > 1613348783
AND open <> 10
AND sticky = 0
AND visible IN (0,1,2)
*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2)
) AS newthread
FROM thread AS thread
/*
WHERE forumid = 2
AND sticky = 0
AND visible IN (0,1,2)
*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2);
MySQL Error : 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 '*/ WHERE forumid > 0 AND sticky = 0 AND visible IN (0,1,2)
) AS newthre' at line 14
Error Number : 1064
Classname : vB_Database_MySQLi
MySQL Version : MariaDB
Last edited: