Buy Now
Sign in

Problem with insert query

univ , October 01 at 12:25
U
univ
hi,
hi get by email all completed forms debug.
this is my regular insert query:

​​
​ [_success] => Data saved successfully​
​ [log] => Array​
​ (​
​ ​
​​
​ [0] => INSERT INTO `cth_chronoforms_mytable` (`cf_created`, `cf_created_by`, `codice_fiscale`, `codice_fiscale_calcolato`, `nome`, `cognome`, `sesso`, `data_nascita`, `comune_nascita`, )values ...............​
​​
​​
​​
​this is my random insert query​
​​
​​
​​
​ [_success] => Data saved successfully​
​ [log] => Array​
​ (​
​ [0] => INSERT INTO `cth_chronoforms_mytable` (`cf_created`, `cf_created_by`) values ('2018-09-28 10:37:07', '0');​
​ )​
​​
​ [var] => Array​
​ (​
​ [cf_created] => 2018-10-01 10:20:44​
​ [cf_created_by] => 0​
​ [codice_fiscale] => BLABLALBLABLA​
​ [codice_fiscale_calcolato] => BLABLALBLABLA​
​ [nome] => BLABLALBLABLA​
​ [cognome] => BLABLALBLABLA​
​ [sesso] => F​
​ [data_nascita] => BLABLALBLABLA​
​ [comune_nascita] => BLABLALBLABLA​
​​
healyhatman
......... And? what's the problem?
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
U
univ
In the DB i'have empty record with only two field (cf_created and cf_created_by) and in the debug i'have all data completed .
I would like to know how i s possible that insert query has only two field.
healyhatman
1) Clear chronoforms cache
2) Make sure your database fields are the right data type
3) Post a screenshot of your save data action
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
U
univ
About cache i use tihis script before save. ​
<?php$cache = JFactory::getCache('com_chronoforms');$cache->clean();?> 
Data type with more of 3000 saved record i think that it's right. So i check it I did not find anything unusual.
U
univ
action.png
healyhatman
So I can't actually see what's in your save data action buddy.
And you shouldn't need to be cleaning the cache every time.
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
U
univ
Hi,
What's do you need about action buddy?
there are problem if i delete cache everytime?
healyhatman
You're saying there's a problem with your save data action, but haven't actually shown what's in it.
And cache is supposed to help speed your site up, defeats the purpose of you delete it every time you make a request
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman