Support Forums

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

Your Time: Our Time:

Getting error 1064

Featured Lock Resolved Issue
Dear,
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, http://www.nicetoyota.com i get the below error message

"
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 ') 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.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM bcuok_k2_items as a LEFT JOIN bcuok_k2_categories c ON c.id = 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)

Sifat

Sifat

Total Accepted Answers: 145
Paul Frankowski

Paul Frankowski

Total Accepted Answers: 119
Toufiq

Toufiq

Total Accepted Answers: 51
Pavel

Pavel

Total Accepted Answers: 4
A

Ales

Total Accepted Answers: 3

100+

Templates

200,000+

Community Users

Newsletter

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. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us