+1.888.407.5769
+707.234.5769

SYNTAX ERROR 1064

Quote:

A Database Error OccurredError Number: 1064
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 'ORDER BY RAND() LIMIT 0, 5' At Line 6
SELECT * FROM Jem_content_articles WHERE (Jem_content_articles.Content_tags LIKE '%News%'AND Content_type = '1' AND Date_published <=1368173871 AND (Category_id = '1' OR Category_id > '6') AND Jem_content_articles.Status = '1' ORDER BY RAND() LIMIT 0, 5


When i open my content>>customers review page>> the above error shows!

How and where did my setting went wrong as a result of this message?

How to rectify this issue asap?

JROX Staff Posted a reply 5 years ago

this is a bug.

submit a ticket to the help desk for this.

stellavxu399 Posted a reply 5 years ago

Hi already submitted to support and my tickets are 34857,35053 to 35055.

Please check. THanks.

JROX Staff Posted a reply 4 years ago

Thanks. this has been addressed via help desk.

LATEST NEWS

Scanned and Verified

Security Seal
Certified by Trust Guard
Privacy Verified Seal
Business Seal