Forums

Data not save properly in Database

mat_rapit 20 Nov, 2012
Hye and Thanks for this awesome app.
I've using it around 3 months ago and it works perfectly
but
for the last 2 day, it have give me some problem.
There are blank data in my database, and i dont understand where it come from.
its look like my form doing 'autosave' even the user not clicked submit button yet.
the cache in global configuration are OFF.
Please help and guide me.
Thanks!
GreyHead 20 Nov, 2012
Hi mat_rapit,

Please see this FAQ for some suggestions.

Bob
mat_rapit 23 Nov, 2012
Hye,
i've try one of the suggestion from FAQ where i put form validation but its still happen.
What i found today, this blank form are coming from 1 pc that always by user. other pc are ok.
tonight im going to see that pc but before that, i hope you can give me some advice what to look inside that pc.
one more thing, i also have using php code to retrieve data from Db to show on my website.
Will this code give me probs?
here the code:
MAKLUMAT TERBARU LOG KONTI

{source}<?php
mysql_connect("localhost","xxxxx","xxxxxx") or die(mysql_error());
echo "Sambungan Ke MySQL - OK!<br /><hr />";
mysql_select_db("corner_db") or die(mysql_error());
echo "Sambungan Ke Data - OK!<br /><hr />";
$query = "SELECT * FROM s4fi8_chronoforms_data_xxxx ORDER BY `cf_id` DESC LIMIT 0 , 2";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
echo $row['segmen'] . " *** " . $row['nama'] . " *** " . $row['tarikh'];
    echo "<br />";
    echo $row['waktu1'] . " *** " . $row['Rancangan1'] . " *** " . $row['Punca1'] . " *** " . $row['Catatan1'] . " *** " . $row['Juruhebah1'];
    echo "<br />";
    echo $row['waktu2'] . " *** " . $row['rancangan2'] . " *** " . $row['punca2'] . " *** " . $row['catatan2'] . " *** " . $row['juruhebah2'];
    echo "<br />";
    echo $row['waktu3'] . " *** " . $row['rancangan3'] . " *** " . $row['punca3'] . " *** " . $row['catatan3'] . " *** " . $row['juruhebah3'];
    echo "<br />";
    echo $row['waktu4'] . " *** " . $row['rancangan4'] . " *** " . $row['punca4'] . " *** " . $row['catatan4'] . " *** " . $row['juruhebah4'];
    echo "<br />";
    echo $row['waktu5'] . " *** " . $row['rancangan5'] . " *** " . $row['punca5'] . " *** " . $row['catatan5'] . " *** " . $row['juruhebah5'];
    echo "<br />";
    echo $row['waktu6'] . " *** " . $row['rancangan6'] . " *** " . $row['punca6'] . " *** " . $row['catatan6'] . " *** " . $row['juruhebah6'];
    echo "<br />";
    echo $row['waktu7'] . " *** " . $row['rancangan7'] . " *** " . $row['punca7'] . " *** " . $row['catatan7'] . " *** " . $row['juruhebah7'];
    echo "<br />";
    echo $row['waktu8'] . " *** " . $row['rancangan8'] . " *** " . $row['punca8'] . " *** " . $row['catatan8'] . " *** " . $row['juruhebah8'];
    echo "<br />";
    echo $row['waktu9'] . " *** " . $row['rancangan9'] . " *** " . $row['punca9'] . " *** " . $row['catatan9'] . " *** " . $row['juruhebah9'];
    echo "<br />";
    echo $row['waktu10'] . " *** " . $row['rancangan10'] . " *** " . $row['punca10'] . " *** " . $row['catatan10'] . " *** " . $row['juruhebah10'];
    echo "<br />";
    echo $row['waktu11'] . " *** " . $row['rancangan11'] . " *** " . $row['punca11'] . " *** " . $row['catatan11'] . " *** " . $row['juruhebah11'];
    echo "<br />";
    echo $row['waktu12'] . " *** " . $row['rancangan12'] . " *** " . $row['punca12'] . " *** " . $row['catatan12'] . " *** " . $row['juruhebah12'];
    echo "<br />";
    echo $row['waktu13'] . " *** " . $row['rancangan13'] . " *** " . $row['punca13'] . " *** " . $row['catatan13'] . " *** " . $row['juruhebah13'];
    echo "<br />";
    echo $row['waktu14'] . " *** " . $row['rancangan14'] . " *** " . $row['punca14'] . " *** " . $row['catatan14'] . " *** " . $row['juruhebah14'];
    echo "<br />";
    echo $row['waktu15'] . " *** " . $row['rancangan15'] . " *** " . $row['punca15'] . " *** " . $row['catatan15'] . " *** " . $row['juruhebah15'];
    echo "<br />";
    }
?>{/source}



im using soucerer extension to put this code in article. the "xxxx" means im hiding it.
FYI: im try to disable this code for a while but the probs still happen.
Thanks!
GreyHead 23 Nov, 2012
Hi mat_rapit,

I don't have any suggestions beyond those in the FAQ

The database tables you create in ChronoForms are just normal database tables; if your MySQL works then it's OK. I don't know anything about the Sorcerer extension.

Bob
mat_rapit 23 Nov, 2012
Everything work fine now! i found the shoutbox module that i install same day this prob happen and today im disabling it in form page. Its ajax base shoutbox and im pretty sure its have something with it own cache and effecting the form.
True or not...i dont know but im disabling it and now everything fine.
This topic is locked and no more replies can be posted.