Shape 5

I have just loaded the template on an old site and it all functions well, except that at the bottom of every page there appears an error message, copied below:

DB function failed with error 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 'Yoga Room)) AND (('2007-09-04' <= publish_down_date OR publish_down_date = ' at line 4 SQL=SELECT jos_artbanners.* FROM jos_artbanners, jos_artbanners_categories, jos_artbanners_clients WHERE 1 AND (jos_artbanners.tid IN (2) OR jos_artbanners.id IN (1) OR jos_artbanners.cid IN (Lismore Yoga Room)) AND (('2007-09-04' <= publish_down_date OR publish_down_date = '0000-00-00') AND '2007-09-04' >= publish_up_date AND ((reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%2%')) AND '16:46:32' >= publish_up_time AND ('16:46:32' <= publish_down_time OR publish_down_time = '00:00:00') AND access <= '0' AND state = '1' AND jos_artbanners.tid = jos_artbanners_categories.id AND jos_artbanners_categories.published = 1 AND jos_artbanners.cid = jos_artbanners_clients.cid AND jos_artbanners_clients.published = 1 ) ORDER BY last_show ASC, msec ASC

I have unpublished everything associated with artbanners and turned off every module I can, but cannot get rid of this message. It only happens on this template, but I cannot find how to solve it. Any suggestion?

Hi, if you've unpublished the jos_artbanners module also try deleting all the files associated to it. My guess would be that the module has some bad files and was published to a position that your other templates did not have, explaining why it only appears with this template. Let me know if you can delete those files. Also can you post the url of your site? Thank you.

spot on

i deleted the component and, as you said, located and unpublished the position and all works perfectly.

great template, great service, thank you.