+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: API (https://forums.formtools.org/forumdisplay.php?fid=17)
+--- Thread: Posting to db but no Thank You or Email sent SOLVED (/showthread.php?tid=2368)
Posting to db but no Thank You or Email sent SOLVED - pilsnermonkey - Feb 4th, 2013
I'm having a problem with redirecting to my thankyou page.
Form was set up via API. It's the second form in this FT installation. The code I'm using on the form and thank you is exactly the same as the first form which works flawlessly and sends email response & adds database entry. Both live in the same folder; that folder is in the root of my public_html/ folder.
1st form php:
<?php
require_once("/home/mywebsite/public_html/formtrtret/global/api/api.php");
$fields = ft_api_init_form_page(3); $params = array(
"submit_button" => "submit",
"next_page" => "../retreat/thankyou.php",
"form_data" => $_POST,
"file_data" => $_FILES,
"finalize" => true
);
ft_api_process_form($params);
?>
2nd form php:
<?php
require_once("/home/mysebsite/public_html/formtrtret/global/api/api.php");
$fields = ft_api_init_form_page(5); $params = array(
"submit_button" => "submit",
"next_page" => "../retreat/thankyoucontact.php",
"form_data" => $_POST,
"file_data" => $_FILES,
"finalize" => true
);
ft_api_process_form($params);
?>
BOTH forms are adding form data to database. The 1st form redirects to thank you page and sends email. The 2nd form does not redirect or send email. Just shows a blank page and the URL remains on the form page (contact.php).
1st thankyou.php code:
<?php
require_once("/home/mywebsite/public_html/formtrtret/global/api/api.php");
$fields = ft_api_init_form_page(3);
ft_api_clear_form_sessions(3);
?>
2nd thankyoucontact.php code:
<?php
require_once("/home/mywebsite/public_html/formtrtret/global/api/api.php");
$fields = ft_api_init_form_page(5);
ft_api_clear_form_sessions(5);
?>
Both email responses were set up exactly the same in FT. I always clear cache by visiting thankyoucontact.php and then refreshing browser. I also clear my browser cache. I just can't get the thankyoucontact.php to load or get my email results. The php code is at the very top of all pages. Both forms are active. I can view the thankyoucontact.php in browser. I deleted the form once and recreated it through the API add external form function and am getting the same result. I've changed the path to thankyoucontact.php many times in the php code but no luck. (I can't see how it could be path related because the path on form 1 is exactly the same and it works just fine.) Form ID's are correct. 2nd form is actually simpler than 1st form ... just 3 text boxes and one text field plus submit. Submit code identical on both forms.
I'm stumped. I just can't see my error. The page html & php code look fine to me.
When viewing page source on blank page following the form submission, all I can see is:
1
There is no html visible. Just the number 1 on the first line of the page source.
error.php in my FT folder shows:
<?php
require_once("global/session_start.php");
$page_vars = array();
$page_vars["page_url"] = ft_get_page_url("error");
$page_vars["source"] = "error_page";
$page_vars["message_type"] = isset($_SESSION["ft"]["last_error_type"]) ? $_SESSION["ft"]["last_error_type"] : "";
$page_vars["message"] = isset($_SESSION["ft"]["last_error"]) ? $_SESSION["ft"]["last_error"] : "";
$page_vars["error_debug"] = isset($_SESSION["ft"]["last_error_debug"]) ? $_SESSION["ft"]["last_error_debug"] : "";
ft_display_page("error.tpl", $page_vars);
error_log shows this:
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: pdo_sqlite: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: SQLite: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: pdo_mysql: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: uploadprogress: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/ixed.5.2.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/ixed.5.2.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: imagick: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/intl.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/intl.so: cannot open shared object file: No such file or directory in Unknown on line 0
[04-Feb-2013 14:01:31] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/bbcode.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/bbcode.so: cannot open shared object file: No such file or directory in Unknown on line 0
Form Tools version 2.2.5
PHP version 5.2.17
MySQL version 5.1.63
[system_check tool did find some orphan db files: 2 @ id field 18, 2 @ 19]
Can anyone suggest any fixes. I'm boggled.
RE: Posting to db but no Thank You or Email sent (with error codes) - pilsnermonkey - Feb 6th, 2013
Solved:
I had malformed form elements on my form and within Form Tools as follows:
<input name="Phone_Number:" type="text" />
needs to be: <input name="Phone_Number" type="text" />
**Note: no ":" (colon) allowed in input name. Illegal character!
also:
<input name="E-Mail_Address" type="text" />
needs to be:
<input name="E_Mail_Address" type="text" />
**no "-" (dash) allowed. Illegal character!
Since this is a simple form, I just deleted the old form (because it deserved to die!), created a new form and made sure the auto fill process in Form Tools "Add Form" process found no illegal characters. Made sure my form input 'name' elements on my form matched the auto-fill "Form Field" values in Form Tools admin.
You can find the Form Tools "Form Field" values by going to:
Form Tools Admin > Forms > Edit (pencil & paper icon) > Fields tab > Form Field column.
Make sure the Form Fields in Form Tools contain no illegal characters. Make sure the form element input names on your form match the Form Fields in Form Tools admin.
Whew! Liking this product better every single day.
Thanks for looking. Hope this might help someone else.
RE: Posting to db but no Thank You or Email sent SOLVED - Joe - Feb 8th, 2013
Awesome! Thanks for posting the solution. I'm sure it will be helpful to other members.
Cheers,
Joe