Support Forums

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Getting error 1064

Featured Lock Resolved Issue
I need immediate help, the last thing i remember doing is was experimenting around with the module, Sp New Highlighter and then when i refreshed my webpage, i get the below error message


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 ') AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-12-12 19:1' at line 1 SQL=SELECT a.*, as categoryname, as categoryid, c.alias as categoryalias, c.params as categoryparams FROM bcuok_k2_items as a LEFT JOIN bcuok_k2_categories c ON = a.catid WHERE a.published = 1 AND a.access IN(1,1) AND a.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND a.catid IN() AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-12-12 19:16:48' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-12-12 19:16:48' ) ORDER BY a.title ASC LIMIT 0, 5
Go Back Home"

please help me fix this as i almost have my site ready for launch and dont want to have to redo it all

1 Answers

Please login to view replies.

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 219


Total Accepted Answers: 150


Total Accepted Answers: 65
Rifat Wahid Alif

Rifat Wahid Alif

Total Accepted Answers: 2

Brent Robinson

Total Accepted Answers: 1




Community Users


Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us