Forums

Duplicate data

webcrea 28 Sep, 2017
Hello,

In edit mode when i save, no problem. With a new task button : it called the event "duplicate" wich call a function save_data
I try to use "Insert - duplicate key update" the new fich is created but nothing in.
in debug mode no data passed to.

Thanks
Max_admin 28 Sep, 2017
Hi Christophe,

Please add {debug:} to the "duplicate" event after the save_data function and post the debug output.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webcrea 29 Sep, 2017
Hi Max,
Thanks for your help.
You can see in debug, the duplicate task button doesn't post all fields. Maybe the button is outside the form tag...
Regards


Array
(
[option] => com_chronoconnectivity6
[view] => connection
[Itemid] => 330
[conn] => liste-sofica
[fonds_id] => 104
[event] => duplicate
[720planBAK] => R3744886473
[a146f7452dd44ccfce7d8c41201ede90] => f07375e17bfea673cf31c4c6e01c2837
[720planD] => R1415157273
[f1d49ec7bfdc9e863f230cb850acd4d2] => fbd0a84e88089a5e0d8935770af40d1a
[joomla_user_state] => logged_in
)

Array
(
[duplicate_fonds] => Array
(
[data] => Array
(
[created] => 2017-09-29 06:24:38
[user_id] => 126
)

[_success] => Data saved successfully
[log] => Array
(
[0] => INSERT INTO `arobas17_fonds_sofica` (`created`, `user_id`) values ('2017-09-29 06:24:38', '126') ON DUPLICATE KEY UPDATE `created` = '2017-09-29 06:24:38',`user_id` = '126';
)

[var] => Array
(
[created] => 2017-09-29 06:24:38
[user_id] => 126
[id] => 117
)

)

)
Max_admin 03 Oct, 2017
Hi Christophe,

So you need to find out why is that, how do you display the list ? please make sure that the form tag setting is enabled in the list view.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webcrea 03 Oct, 2017
Hi Max,

This is not from a list but from an edit form with a task button outside the form :
event : duplicate

I tried also :
Ajax checked
Dynamic task : send:#form_fonds_edit

Result : the same, insert created with only user and created date

Regards
Max_admin 04 Oct, 2017
Hi Christophe,

The "List view name" in the toolbar button settings has the correct view name ?

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webcrea 04 Oct, 2017
Hello Max,

I understood,
Toolbar button instead a task button

...with parammeters

Submit button checked
List view name : form_fonds_edit

in data save function

Write action : Insert : Duplicate key ignore

Add in Data override on Insert
id:0

if not id:0 duplicate key doesn't ignore by cc ! row updated instead inserted ... maybe a bug?

Regards
Max_admin 09 Oct, 2017
Hi Christophe,

Please add a {debug:} call and post the debug results of this save_data ? and a screenshot of the save_data settings please.

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.