Cyber Monday Sale! Use DMXCYBER24 promo code for 50% OFF.

Pure PHP Upload Add-On Pack Support Product Page

Delete before Update Error

Reported 04 Sep 2012 22:17:04
3
have this problem
04 Sep 2012 22:17:04 justin dallas posted:
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!!!

Replies

Replied 05 Sep 2012 11:16:32
05 Sep 2012 11:16:32 Vulcho Vulev replied:
Hello Justin.

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

Regards: Vulcho.
Replied 05 Sep 2012 12:37:57
05 Sep 2012 12:37:57 justin dallas replied:
thanks, ive sent you an email now with the links, & the php page that is giving me errors.
Replied 05 Sep 2012 13:14:16
05 Sep 2012 13:14:16 Teodor Kuduschiev replied:
Hello Justin,

can you please contact us through our Live Support Chat?
Replied 02 Dec 2013 13:42:53
02 Dec 2013 13:42:53 Jean Pierre Valls replied:
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
Replied 24 Jan 2014 18:48:47
24 Jan 2014 18:48:47 Vitor Fernandes-Neto replied:
HI There i also get this error, does anybody know what to do?
Helpppppppp
Replied 15 Sep 2014 22:51:26
15 Sep 2014 22:51:26 Ted Matson replied:
Yes indeed, getting this error as well. Would appreciate the solution being posted here. thank you.
Replied 21 Nov 2016 20:07:32
21 Nov 2016 20:07:32 Vitor Fernandes-Neto replied:
any ideas yet??

Reply to this topic