Joomla Templates Club 406,261 posts

[suzanna Friend suzannaJoin date: August 2014Posts: 215Downloads:63Uploads:26 Thanks: 75 Thanked: 1 times in 1 posts]

#875530

When I try to install a component I get server error 500 on the home page only, other pages work fine.

http://www.my_site.com — error 500 (see log below) http://www.my_site.com/about — works fine

The logs shows following:

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 published = 1 ORDER BY c.date DESC LIMIT 0, 5’ at line 4 SQL=SELECT c.*,u.name AS user_realname, u.username AS user_username FROM ie9bc_comment AS c LEFT JOIN ie9bc_users as u ON c.userid = u.id WHERE AND published = 1 ORDER BY c.date DESC LIMIT 0, 5

Developer of the component suggested it’s JA template and/or one of JA plugins. I’m using JA Side News, JA Slideshow Lite, and other stock setup on the University template.

Any suggestions on how to troubleshoot this or how to find which JA component is throwing the error?

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#875900

Hi @suzanna,

If problem occurs in homepage only, you can try to disable module/plugin/component used in homepage one by one and see which one causes issue.

[Author]

Posts