Open Classifieds - Support

ERROR 256 Ham Radio Stop Classifieds

6 posts from 2 voices

• Started 1 year ago by Mitch
• Latest reply from Chema
• This topic is not resolved

Tags:

No tags yet.

1. Admin
   

   Need professional help for Open Classifieds?

   Get a quick answer from our development team! Just for 50 EUR, premium support and many more things.

   Posted 1 year ago
2. 

   Mitch
   Member

   Reputation:15

    

   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 />

   Posted 1 year ago #
3. 

   Chema
   Key Master

   Reputation:1,721

    

   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

   Posted 1 year ago #

4. Admin
   

   Posted 1 year ago
5. 

   Mitch
   Member

   Reputation:15

    

   I have 4.1.22-standard
   What version do I need

   Posted 1 year ago #
6. 

   Chema
   Key Master

   Reputation:1,721

    

   at leat 5, and it's not the newest, soon is going to be released the 6.0

   Posted 1 year ago #

7. Admin
   

   Posted 1 year ago
8. 

   Mitch
   Member

   Reputation:15

    

   Thank you My Servers are being upgraded at this moment so i can use this script.

   Posted 1 year ago #
9. 

   Chema
   Key Master

   Reputation:1,721

    

   ;) that's great my friend :D

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.