Buy Now
Sign in

Problem with insert query

univ , October 01 2018
U
univ 35
October 01 2018 #380567
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 5.6
October 02 2018 #380572
......... 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

You can now copy+paste code from forums
U
univ 35
October 02 2018 #380577
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 5.6
October 02 2018 #380579
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

You can now copy+paste code from forums
U
univ 35
October 02 2018 #380583
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 35
October 02 2018 #380584
action.png
healyhatman 5.6
October 03 2018 #380590
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

You can now copy+paste code from forums
U
univ 35
October 10 2018 #380697
Hi,
What's do you need about action buddy?
there are problem if i delete cache everytime?
healyhatman 5.6
October 10 2018 #380699
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

You can now copy+paste code from forums