Intermittent not updating database

Hi there,

A short while back I reported I have issues with chronoforms not updating my datbase table after upgrading Joomla to 1.5.7, which I seemed to resolve by switching off GZIP.
http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=3&t=11086&p=16057#p16037

I've just had it reported to me that on a couple of occasions, one of my users has submitted a chrono form, but the database didn't get updated. The email part of the form worked though.

I have no idea how to start debugging this one. I tested the form again with the user on his own laptop (Vista and IE7), and that time it worked, but since then it's failed again.

Can you give me any ideas where to start looking, as I'm at a complete loss!

Hi Jim,

turn on DEBUG at the general tab of the form and let me know the debug output! make sure the form is connected to the table and the DB connection is ON.

Regards
Max

Hi Max,

I'm pleased to report that I've finally discovered what is causing this issue. The form updated the database fine, unless someone has entered a ' character in one of the fields, the same as in another thread:
http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=3&t=11422

The debug screen wasn't an awful lot of help, until I realised that the alert box wasn't appearing showing the database error.
View source showed me the problem:

<script> alert('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' , 'test2' , '1' , '1' , 'a' , '2' , '1' , 'b' , '3' , '1' , 'c' , '4' , '0' ,' at line 2 SQL=INSERT INTO jos_chronoforms_4 VALUES  (
'' , 'IMTBlMzcxOTE3MDA3','2008-11-27 - 12:14:19', '91.195.83.3' , '24/11/2008' , 'League' , 'test1's' , 'test2' , '1' , '1' , 'a' , '2' , '1' , 'b' , '3' , '1' , 'c' , '4' , '0' , 'd' , '5' , '1' , 'e' , '1' , '1' , 'b' , '2' , '1' , 'c' , '3' , '1' , 'd' , '4' , '1' , 'e' , '5' , '0' , 'a' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '8' , '4' , '0' , '2' , 'no 8 balls' , 'XXX@yahoo.co.uk' , 'test result form' , '0' , '0' , '0' , '1' , '0' , '0' , '0' , '0' , '0' , '1' , '' , '' , '' , '' , '');'); window.history.go(-1); </script>

Can you confirm that V3.0 stable fixes the problem with single quotes in fields into the datebase? I've been holding off on the update as I believe it is not possible to migrate forms from V2.5 to V3.

Thanks,
Jim

Hi Jim,

it does fix it, its alittle different in dealing with database saving too!

Regards
Max

Thanks for the confirmation. 😀

I'm going to attempt to recreate my form on V3 on my test server now. It looks like its going to be complicated linking it up to my existing database table, as I have 75 fields in my database, and a few more form fields in the form! 😲

Jim

Hi Jim,

you will see that database saving is a piece of cake in V3.0

Regards
Max