+- Form Tools (https://forums.formtools.org)
+-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8)
+--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16)
+--- Thread: Submission History doesn't work after using Form Backup (/showthread.php?tid=1054)
Submission History doesn't work after using Form Backup - axel - Jan 25th, 2011
I tired to copy a form using the Form Backup and then the Submission History doesn't enable it self on the new form. In fact there is no new tables for it in the database.
Is this normal? Or have I done something terribly wrong again?
Thank you! :3
RE: Submission History doesn't work after using Form Backup - Hannes - Jan 25th, 2011
Hi Axel,
the same here.
I think it is for privacy reason that you always have to confirm the activation of tracking in the module.
I myself prefere to have it this way to not waste to much mysql resources...
Is it a problem for you application?
Cheers,
Hannes
RE: Submission History doesn't work after using Form Backup - axel - Jan 26th, 2011
Hey Hannes,
I have activated tracking for the cloned forms, however I don't think it understands to build the new table for the submission history. Even when history is disabled, there is a table kept in the DB from what it looks like.
My question would be then if there is someway for Submission History to be aware of Form Backup so it knows to create those new tables when form backup makes a copy.
RE: Submission History doesn't work after using Form Backup - Hannes - Jan 29th, 2011
Hey Alex,
ok, now i get you. Sorry, I did not check it in detail...
What you want is are the options "copy submissions history" and "enable submission history by default".
which should be visible in "form backup" module when "submission history" is actived for the form that is to be backuped.
Right?
I guess for the moment you need to set the history db manually in mysql.
Cheers,
Hannes
RE: Submission History doesn't work after using Form Backup - russellfeeed - May 24th, 2011
Okay, I figured a way to create the history table, after you have used Form Backup. However you need to edit the Submission History code:
Edit formtools/modules/submission_history/global/code/actions.php
Change
PHP Code:
switch ($_POST["action"])
{
case "create_history_table":
$form_id = $_POST["form_id"];
$form_info = ft_get_form($form_id);
$form_name = preg_replace("/\"/", '\"', $form_info["form_name"]);
list($success, $message) = sh_create_history_table($form_id);
$json = "{ \"success\": \"$success\", \"form_id\": \"$form_id\", \"form_name\": \"$form_name\" }";
echo $json;
break;
to
PHP Code:
switch ($_REQUEST["action"])
{
case "create_history_table":
$form_id = $_REQUEST["form_id"];
$form_info = ft_get_form($form_id);
$form_name = preg_replace("/\"/", '\"', $form_info["form_name"]);
list($success, $message) = sh_create_history_table($form_id);
$json = "{ \"success\": \"$success\", \"form_id\": \"$form_id\", \"form_name\": \"$form_name\" }";
echo $json;
break;
i.e. you're changing the $_POST to $_REQUEST
Then hit this URL using your browser:
Code:
http://www.yourdomain.com/formtools/modules/submission_history/global/code/actions.php?action=create_history_table&form_id=<yourformid>RE: Submission History doesn't work after using Form Backup - Ben - Jun 3rd, 2011
Hey guys,
Thanks for letting me know about this. You're totally right: the two modules aren't working properly together. I'll fix this up.
- Ben
RE: Submission History doesn't work after using Form Backup - Ben - Jul 8th, 2011
Hey guys,
Just a heads up. I released two new versions of the script - 1.0.4 for the 2.0.x Core branch and 1.1.0 for the 2.1.x branch. Both are now compatible with the Submission History module and fix a couple of other issues that were reported.
See: http://modules.formtools.org/form_backup/download.php
Thanks again for letting know!
- Ben