Support Online : 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

Kawshar Ahmed - Senior Staff

More than a month ago #Permalink
Can't see the error because your site is offline.
Suggestion: Please install the quickstart pack again and let us know.

There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 109


Total Accepted Answers: 61
Mehtaz Afsana Borsha

Mehtaz Afsana Borsha

Total Accepted Answers: 26
Ofi Khan

Ofi Khan

Total Accepted Answers: 11
Rashida Rahman

Rashida Rahman

Total Accepted Answers: 8




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