Forums

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 's Information

That is what I am getting and No there is nothing behind the "Information"

I am getting this with I use the "Transform Form" button.

And I am also having a problem with the tool tips..... It loads the Tool tips under the Txt Boxes to see and example go to

http://www.hotheadzmarine.com/index.php?option=com_chronocontact&Itemid=20

Hi Tim,

The 's Information is probably coming from Your boat's information and I'd guess it's a result of something not being escaped. Try temporarily removing the ' and see if the errro goes away. If it does then there's probably a ChronoForms bug. I'm sure Max will fix that in the next release.

I can't see the ToolTip problem in either IE7 or FF3? Which browser do you see it with - can you post a screen shot please?

Bob

The tool tip was my stupidity. I have NoScript for FF and I didn't allow the site past it. And when i remove it I get this

        * 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 's The Year of Your Boat to be moved

 ' at line 1 SQL=UPDATE jos_chrono_contact SET html='
Please fill out this form to receive your custom quote.  

Great, bug exists, I fixed it for the next release!

Regards
Max

Glad I could Help, Find a Bug..... Now be a good bug killer....lol

Yeah🙂 please don't hesitate to post about any more!

Regards
Max

I'm receiving the same error, "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"

Is there a temporary workaround until the next release?

Hi ryanmac,

Is that the complete error report? Usually there's a bit more with the SQL statement in it.

Bob

Hi ryanmac,

Which version do you have ?

Regards
Max