Hi there - im using the Delete before Update function as per normal - but, when I use the component (ie: add the Delete before Update script) - I keep getting the 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 '' at line 1"

If I remove the behaviour, my form works & updates fine (but, doesnt delete) - what can be causing this error?

Please help!!!

Hello Justin.

Can you please provide me with link to the problem page ?
Here is my e-mail:

Regards: Vulcho.

thanks, ive sent you an email now with the links, & the php page that is giving me errors.

Hello Justin,

can you please contact us through our Live Support Chat?

Hello Vulcho
I have the same problem,
I tested without the server behavior 'Delete before update. I have no error message.
I add the server behavior 'Delete before update', the error appears.

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 '' at line 1"

I use, Pure Php Version 3.0.2 Upload 3 and Pure PHP Upload Add-On Pack 1.0.10
Have you progress in the resolution

Thank's
Regards
Jpierre

HI There i also get this error, does anybody know what to do?
Helpppppppp

Yes indeed, getting this error as well. Would appreciate the solution being posted here. thank you.

any ideas yet??