Forum Support

Shape 5
March 28, 2024, 06:27:09 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Database error  (Read 472 times)
chiwiz
Jr. Member
**
Offline Offline

Posts: 16



« on: September 04, 2007, 01:31:35 AM »

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?
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #1 on: September 04, 2007, 06:46:47 AM »

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.
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
chiwiz
Jr. Member
**
Offline Offline

Posts: 16



« Reply #2 on: September 04, 2007, 05:29:44 PM »

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.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.