Jump to content

thewebsmiths

Members
  • Content count

    35
  • Joined

  • Last visited

Everything posted by thewebsmiths

  1. thewebsmiths

    1064 - You have an error in your SQL syntax;

    Geoffrey, You are my hero! Thankyou :o)
  2. thewebsmiths

    1064 - You have an error in your SQL syntax;

    Just discovered that if I write a review as a customer the error goes away in reviews (once there is a review) then reappears when the review is deleted. Unfortunately don't know how to bypass the admin section to add a special to see if the same thing happens there.
  3. thewebsmiths

    1064 - You have an error in your SQL syntax;

    Hi guys, I have a similar issue, revisited a clients site some time after hand over and the specials and reviews sections give me the following errors when in admin: SPECIALS: 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 '-10, 10' at line 1 select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -10, 10 [TEP STOP] REVIEWS: 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 '-10, 10' at line 1 select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -10, 10 [TEP STOP] Not sure if even relevant, but there were products with quotes in titles, descriptions and id's, all now removed. Also viewed and installed your Magic Quotes Compatibility Layer Fix Geoffrey. I fear my ability has now been surpassed by my ambition! Any help gratefully received ;o) Steve
  4. Hi Darren, Tried the original images again, even tried outputting them in differing gif formats, nothing seems to do away with it, even setting images required to false didn't clear it, the only way to clear it is to switch off image magic. I was kind of hoping to find where the images are specified so I could change them to a jpg or do away with them altogether, we have a secodary logo which would look really nice there, but of course it has to be a jpg and the code wants a gif. It's not the first time I've wanted to know where they are specified as the method used to date to get rid of the standard images (replacing them with transparent gifs with differing file names) is a bit of a pain, if I knew where to go I'd just take em out. I did find the reference in the coding, but it cleared sub pages but not the home page so I stuck it back again as it's only really the homepage thats giving me an issue now. Cheers Steve
  5. Cheers Darren, I'd already considered that to be an option, the only issue I have with that is the table_background_... gif's at page top, I have previously replaced all these with a transparent 1x1 gif, but they all show as errors now. Where do I go to remove these or to set them as a 1x1 jpg same colour as background? Ideally I could find the file where they are all defined and either set to 1x1 jpg as mentioned or above, or even use a small logo instead (jpg of course :o) Regards Steve
  6. Hi guys I have installed image magic on a unix machine and have no gifs showing, I have tried replacing some sample product image with jpg's and all works fine. It appears to be just the gifs that are causing the problem, have I done something wrong or is there a fix. When I turn off image magic all images appear, but with it on only the jpg's, any ideas? The test site is at www.mulberrysinteriors.co.uk/shop Any help greatly appreciated as I need some sleep
×