Getting this error on a new install. Received multiple emails on same error.
<b>SQL/DB Error</b> <br />(1064) in line 56 error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(DAY,H.hitTime,now())<=7 and (P.idCategory=1 or P.idCategory in (select idCateg' at line 6 <br/>Query: SELECT count(P.idPost) cont,P.idPost,P.title,
(select friendlyName from oc_categories where idCAtegory=P.idCategory Limit 1) fcategory,
P.type FROM oc_posts P
inner join oc_postshits H
on P.idPost=H.idPost
where P.isConfirmed=1 and P.isAvailable=1 and TIMESTAMPDIFF(DAY,H.hitTime,now())<=7 and (P.idCategory=1 or P.idCategory in (select idCategory from oc_categories where idCategoryParent=1))
group by P.idPost,P.title,P.idCategory,P.type
order by 1 desc Limit 5 <br/>File: /openclassifieds/index.php<br />PHP 5.2.12 (Linux)<br />
Aborting...<br />This is because your MY Sql server is not tha latest version and doesn't support the DAY,H.hitTime,now())<=7
Can you try to execute this query in the query analizer?
thanks
I have 4.1.22-standard
What version do I need
at leat 5, and it's not the newest, soon is going to be released the 6.0
Thank you My Servers are being upgraded at this moment so i can use this script.
;) that's great my friend :D
You must log in to post.