***UPDATED*** DB Technosystems Form Processor 02/09/2011
- Patrik iden
-
- Posts: 479
- Joined: Wed Mar 24, 2010 9:07 pm
- Location: Sweden
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hello, i having a problem when i setup the form processor to save form data to Databse, i use ÅÄÖ åäö in some of the fields, but in databse i dont get åäö i get strage carracters like i have an address that shoul read Sågvägen but in DB it reads like this: SÃ¥gvägen.
I have UTF8 in webpage so that the page will show åäö, so i also set the form processor to utf8 and in WWB form i also set utf8.
Any ideas please?
Thank you.
I have UTF8 in webpage so that the page will show åäö, so i also set the form processor to utf8 and in WWB form i also set utf8.
Any ideas please?
Thank you.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Try setting also the Form charset to UTF8
www.dbtechnosystems.com
- Patrik iden
-
- Posts: 479
- Joined: Wed Mar 24, 2010 9:07 pm
- Location: Sweden
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?Navaldesign wrote:Try setting also the Form charset to UTF8
Thank you.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi,
I have problem sending email. I followed to the letter all pdf document and in particular the paragraph "The Form and its settings".
I have enabled debug mode and got below log :
thanks in advance
Notice: Undefined index: POST in C:\xampp\htdocs\Prova\index.php on line 17
Notice: Use of undefined constant RecursiveMkdir - assumed 'RecursiveMkdir' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 2
Notice: Use of undefined constant ValidateEmail - assumed 'ValidateEmail' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 11
Notice: Use of undefined constant array_trim - assumed 'array_trim' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 19
Notice: Use of undefined constant report_error - assumed 'report_error' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 33
Notice: Use of undefined constant rewrite_captcha - assumed 'rewrite_captcha' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 64
Notice: Use of undefined constant allowurls - assumed 'allowurls' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 90
Notice: Use of undefined constant WriteToFile - assumed 'WriteToFile' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 97
Notice: Use of undefined constant WriteToMySQL - assumed 'WriteToMySQL' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 151
Notice: Use of undefined constant db_connect - assumed 'db_connect' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 205
Notice: Use of undefined constant get_labels - assumed 'get_labels' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 222
Notice: Use of undefined constant create_entry - assumed 'create_entry' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 235
Notice: Use of undefined constant update_record - assumed 'update_record' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 264
Notice: Use of undefined constant get_record_from_db - assumed 'get_record_from_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 300
Notice: Use of undefined constant check_unique_in_db - assumed 'check_unique_in_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 316
Notice: Use of undefined constant check_pass_strength - assumed 'check_pass_strength' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 334
Notice: Use of undefined constant getRealIpAddr - assumed 'getRealIpAddr' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 348
Notice: Use of undefined constant post - assumed 'post' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 367
Notice: Use of undefined constant check_credit_card - assumed 'check_credit_card' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 395
Notice: Use of undefined constant date_default_timezone_set - assumed 'date_default_timezone_set' in C:\xampp\htdocs\Prova\index.php on line 48
Notice: Undefined variable: total_attach_size in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 187
Notice: Undefined index: department in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 195
Notice: Undefined index: in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 196
Notice: Undefined variable: department_names in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 197
Notice: Undefined variable: dep_mailtos in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 205
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 220
Notice: Undefined variable: logo_valign in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 35
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 76
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 160
Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1471
Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1475
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 360
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php:205) in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 460
I have problem sending email. I followed to the letter all pdf document and in particular the paragraph "The Form and its settings".
I have enabled debug mode and got below log :
thanks in advance
Notice: Undefined index: POST in C:\xampp\htdocs\Prova\index.php on line 17
Notice: Use of undefined constant RecursiveMkdir - assumed 'RecursiveMkdir' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 2
Notice: Use of undefined constant ValidateEmail - assumed 'ValidateEmail' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 11
Notice: Use of undefined constant array_trim - assumed 'array_trim' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 19
Notice: Use of undefined constant report_error - assumed 'report_error' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 33
Notice: Use of undefined constant rewrite_captcha - assumed 'rewrite_captcha' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 64
Notice: Use of undefined constant allowurls - assumed 'allowurls' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 90
Notice: Use of undefined constant WriteToFile - assumed 'WriteToFile' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 97
Notice: Use of undefined constant WriteToMySQL - assumed 'WriteToMySQL' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 151
Notice: Use of undefined constant db_connect - assumed 'db_connect' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 205
Notice: Use of undefined constant get_labels - assumed 'get_labels' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 222
Notice: Use of undefined constant create_entry - assumed 'create_entry' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 235
Notice: Use of undefined constant update_record - assumed 'update_record' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 264
Notice: Use of undefined constant get_record_from_db - assumed 'get_record_from_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 300
Notice: Use of undefined constant check_unique_in_db - assumed 'check_unique_in_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 316
Notice: Use of undefined constant check_pass_strength - assumed 'check_pass_strength' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 334
Notice: Use of undefined constant getRealIpAddr - assumed 'getRealIpAddr' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 348
Notice: Use of undefined constant post - assumed 'post' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 367
Notice: Use of undefined constant check_credit_card - assumed 'check_credit_card' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 395
Notice: Use of undefined constant date_default_timezone_set - assumed 'date_default_timezone_set' in C:\xampp\htdocs\Prova\index.php on line 48
Notice: Undefined variable: total_attach_size in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 187
Notice: Undefined index: department in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 195
Notice: Undefined index: in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 196
Notice: Undefined variable: department_names in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 197
Notice: Undefined variable: dep_mailtos in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 205
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 220
Notice: Undefined variable: logo_valign in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 35
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 76
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 160
Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1471
Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1475
Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 360
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php:205) in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 460
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Is the script running on a web server or on a local system (xampp) ?
If running on a local system, there is not much I can do, as mail sending issues may depend on your xampp settings.
If running on a local system, there is not much I can do, as mail sending issues may depend on your xampp settings.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Patrik iden wrote:I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?Navaldesign wrote:Try setting also the Form charset to UTF8
Thank you.
I'm sorry, I don't know why this doesn't work for you.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
which xampp settings should I check?Is the script running on a web server or on a local system (xampp) ?
If running on a local system, there is not much I can do, as mail sending issues may depend on your xampp settings.
Thanks
- Patrik iden
-
- Posts: 479
- Joined: Wed Mar 24, 2010 9:07 pm
- Location: Sweden
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Do you have somthing like this somewhere in your Formprocessor code:
mysql_query('SET NAMES UTF8');
mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');
mysql_query('SET NAMES UTF8');
mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
@Navaldesign
Online work..
Thanks
Online work..
Thanks
- Patrik iden
-
- Posts: 479
- Joined: Wed Mar 24, 2010 9:07 pm
- Location: Sweden
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Whats the current version?
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Current version is 2.7.5.6Patrik iden wrote:Whats the current version?
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I use WWB to generate pages in Czech language. We have many special characters ěščřžýáíé, ĚŠČŘŽÍÁÍÉ and more.Patrik iden wrote:I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?Navaldesign wrote:Try setting also the Form charset to UTF8
Thank you.
I have had the same problem and use in page properties and DBTS Character Set UTF-8 and all it`s OK.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hello, for some reason when I publish a new form it works fine the first time ONLY. if I refresh the page or go back to the page with the form, my entire website gets shifted down and right above the website some php code is displayed:
It will only go away if I republish the page. Then as soon as I've submitted the form (which does work), it will not work again. The php code is right back at the top of the page. Any idea as to what I am doing wrong? Thanks!
Here is the page in case you want to see first hand: http://www.harvilleappliancerepair.com/ ... equest.php
Code: Select all
'; exit; } } ?>
It will only go away if I republish the page. Then as soon as I've submitted the form (which does work), it will not work again. The php code is right back at the top of the page. Any idea as to what I am doing wrong? Thanks!
Here is the page in case you want to see first hand: http://www.harvilleappliancerepair.com/ ... equest.php
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Please set the property "Rerwrite Captcha" to No, and republish the page.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thank you Navaldesign! It's been a while since I've used web builder. I must be getting rusty. I thought saying yes to that option was required if you were using the WB Captcha?
Thanks for getting back so quickly!
Thanks for getting back so quickly!
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi, i have problem with WWB 9.4.4 version. When i today change one page (without form) and compile new all web pages, my emails is working only in text mode - the e-mail is send not from DPTS Form Processor, but probably from standard WWB feature. The kontakt.php page with this e-mail is not changed.
Last i edit this pages at 04/2014 with in this thime actual version 9.4.0.
I try this on another site and situation is the same - when I compile this page in new version, the e-mail is send not use DBTS, but only in plain text. Any idea to correct this? When i convert my source file to new version, it`s not easy way to back to version 9.4.0.
Original page in WWB 9.3.0 DBTS OK http://malovanekravaty.cz/kontakt.php
The same page new compiled in WWB 9.4.4 DBTS not working http://malovanekravaty.cz/TEST/kontakt.php
Last i edit this pages at 04/2014 with in this thime actual version 9.4.0.
I try this on another site and situation is the same - when I compile this page in new version, the e-mail is send not use DBTS, but only in plain text. Any idea to correct this? When i convert my source file to new version, it`s not easy way to back to version 9.4.0.
Original page in WWB 9.3.0 DBTS OK http://malovanekravaty.cz/kontakt.php
The same page new compiled in WWB 9.4.4 DBTS not working http://malovanekravaty.cz/TEST/kontakt.php
Last edited by Vlastimil on Thu Aug 28, 2014 4:13 pm, edited 1 time in total.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Please check your page again. Make sure the form is processed by DBTS Form Processor and not by the built in form processor, check the properties and publish the page again.
There are no known issues with v. 9.4.4 , DBTS Form Processor works fine with this version.
There are no known issues with v. 9.4.4 , DBTS Form Processor works fine with this version.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thaks for response, I check this pages two times, I must rebuild my pages from backup, after new compilation.
I made sample for you - I get the source in WWB 9.3, open this in 9.4.4, sawe in this version and compile again.
Original 9.3 - DBTS working OK: http://malovanekravaty.cz/kontakt.php
New in WWB 9.4.4 http://malovanekravaty.cz/TEST/kontakt.php
I don;t made any next changes, don`t instal another extensions to WWB, only made update to new version.
When I inspect the kontakt.php page, the order of code included in this page from DBTS is different.
The "OLD WORKING" begin with:
THE NEW NOT WORKING begin with
I test another project and the situation is the same - when I open 9.3.0 version file in 9.4.4 and compile again, e-mail is send only in plain text in all forms without any changes. I testing in all cases the project old/new on the same domains to eliminate environment.
I made sample for you - I get the source in WWB 9.3, open this in 9.4.4, sawe in this version and compile again.
Original 9.3 - DBTS working OK: http://malovanekravaty.cz/kontakt.php
New in WWB 9.4.4 http://malovanekravaty.cz/TEST/kontakt.php
I don;t made any next changes, don`t instal another extensions to WWB, only made update to new version.
When I inspect the kontakt.php page, the order of code included in this page from DBTS is different.
The "OLD WORKING" begin with:
Code: Select all
<?php
// This script was created by DBTECHNOSYSTEMS.com ----
// © DBTechnosystems.com http://www.dbtechnosystems.com
// You may use this script but please leave author details here
// DBTS Form Processor Extension version 2.7.5.6
ini_set('display_errors', 1);
$version = "2.7.5.6";
error_reporting(0);
if(session_id() == ""){
session_start();
}
if("Working Mode" == "Debug Mode"){
error_reporting(E_ALL);
}
Code: Select all
<?php
require_once 'class.phpmailer.php';
function ValidateEmail($email)
{
$pattern = '/^([0-9a-z]([-.\w]*[0-9a-z])*@(([0-9a-z])+([-\w]*[0-9a-z])*\.)+[a-z]{2,6})$/i';
return preg_match($pattern, $email);
}
if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['formid'] == 'form1')
{
Last edited by Vlastimil on Thu Aug 28, 2014 4:40 pm, edited 1 time in total.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Please post here the Page HTML as you can see it in WWB.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
New opened and saved project in WWB 9.4.4
Old working project from 16/2/2014 made in WWB version 9.3.0 opened in WWB 9.4.4 (after open this i get message about old file version)
Update - the useless big screenshots has been deleted.
Old working project from 16/2/2014 made in WWB version 9.3.0 opened in WWB 9.4.4 (after open this i get message about old file version)
Update - the useless big screenshots has been deleted.
Last edited by Vlastimil on Fri Aug 29, 2014 8:14 am, edited 1 time in total.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I need to see the Page HTML, these images don't help.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Sorry, i sending booth files zipped. If need, I can send project file.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Your form is processed by the built in form processor. Uncheck the "Use built in form Processor" checkbox in form properties and set the rest of the properties as required.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
When I uncheck this, the HTML mail is comming, but all user typed forms data is missing. Contain all other informations, that is set in DBTS properties - Logo Image, Labels, HTML Body Start and HTML Body End. The generated kontakt.php is smaller as working file from WWB 9.3 - see included. Missing the class.phpmailer.php section. This "Use built in form Processor" is checked in all my project created from WWB 8 to 9.3. and work - in Advanced is Mail Engine set to mail. Maybe change in WWB 9.4? How I add form data to e-mail? You can try this new version with "unchecked version" on http://www.malovanekravaty.cz/TEST/index.html - copy of this email is send to you to entered E-mail.Navaldesign wrote:Your form is processed by the built in form processor. Uncheck the "Use built in form Processor" checkbox in form properties and set the rest of the properties as required.
Stay on version 9.3 it`s not possible in all projects, I made many changes from last five months with version 9.4 (unfortunately I don`t made changes in form to find this problem). Change more than hundred forms in all projects and republish is not good idea and many work, but better as stay on 9.3. But i hope, that you find, where is problem. Many thanks for you help.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
When you unchecked the "Use built in form processor" the encoding type was automatically changed to "text/plain" . Set it to be "Multipart / form data" otherwise the data is not passed to the script.
Please read the DBTS Form Processor manual.
From the manual:
The Form and its settings:
DBTS Form Processor does NOT create the form for you!
You need to create a form in your page using the WB Form Wizard or the WB form
tools. Once you have created the form, make sure to respect the following
settings:
The form page MUST be published as PHP.
The form action MUST be set to be “<?php echo basename(__FILE__);?>
The form encoding type MUST be “multipart/form-data”
The submit button MUST be named “submit” though its value can be anything
(like “Send”, “Send Info Now” or anything else).
Please read the DBTS Form Processor manual.
From the manual:
The Form and its settings:
DBTS Form Processor does NOT create the form for you!
You need to create a form in your page using the WB Form Wizard or the WB form
tools. Once you have created the form, make sure to respect the following
settings:
The form page MUST be published as PHP.
The form action MUST be set to be “<?php echo basename(__FILE__);?>
The form encoding type MUST be “multipart/form-data”
The submit button MUST be named “submit” though its value can be anything
(like “Send”, “Send Info Now” or anything else).
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thanks, I found problěm - WWB from 8 to 9.3 version accept checked "Use built in form processor" and generate code for DBTS and this work OK, although this was my mistake in this settings. With 9.4.4 this functionality has been generating code proces changed (generated code is in different order) and DBTS stop working - the email is send using standard WWB functionality. But when i uncheck Use built in form processor" in 9.4.4 version, the showed form action code <?php echo basename(__FILE__);?> wil be deleted. I don`t know why, maybe during converting file from 9.3 version to 9.4 is set in this "something wrong", but when I set this again, all works OK. Many thanks for you excellent support and extension.
- protectourlands
-
- Posts: 426
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
George, I'm having an issue that I just cannot figure out. The form processor is working great, except it will not go to the success page. It keeps returning to the form.php page. I've tried using http:// in the success field of the extension. I've tried ./ and no prefix. I just cannot get it to go to the success page. Otherwise it works perfectly. The auto responder, form results email, etc all work flawlessly.
What could I be I missing?
What could I be I missing?
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Did you correctly set the property "D. Behaviour" --> After Processing Behaviour" to "Redirect" ? Or maybe you have accidentally set it to "Display the page without refresh" ?
www.dbtechnosystems.com
- protectourlands
-
- Posts: 426
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Oh man, that was it. After Processing Behavior. I missed it. Thank you so much.
- protectourlands
-
- Posts: 426
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I'm having trouble getting the table into the database I set up on this GoDaddy hosting. After I publish, the database in phpMyAdmin shows no tables found. I have Create Table and Add Columns set to yes, and have triple checked the host, name, un, pw.
Are there any common errors made that I can check? i cannot figure out why no tables are being built.
Are there any common errors made that I can check? i cannot figure out why no tables are being built.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Of course, without seeing exactly your settings, it is hard to say what is going on.
However, you can set the "Functioning mode" to "Debug" and see what errors are reported by the script.
However, you can set the "Functioning mode" to "Debug" and see what errors are reported by the script.
www.dbtechnosystems.com
- protectourlands
-
- Posts: 426
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
OK I'm all set. I cannot explain this, but I deleted the database and started over with a new one. Now everything is working perfectly.
What an amazing extension. Thank you George.
What an amazing extension. Thank you George.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
From your description, most probably the user you had created for the previous database didn't have permissions to create the table.
www.dbtechnosystems.com
- protectourlands
-
- Posts: 426
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
You're probably right. I just went in, deleted the database and started all over by setting up a new one. I may have done something different in the second.
Definitely user error!
Thanks George
Definitely user error!
Thanks George
Adding info from a form to a page
I've got a form that I use for personal use that does calculations so I can give someone a quote by just entering certain numbers into a form (example: Shirt price: $2.50, ink colors: 2, quantity: 50, profit margin: 50%, etc.) and when I click the submit button it displays the quote for me, along with my estimated profit. What I'd like to do next is add a button that when clicked it will open a generic quote form like: Hello John, your quote would be (here is where the quote from the other form would display) for x amount of shirts. I would then type in their email address and click send to send them the generated quote that was put into the second form.
Here is the link to my cost calculator if it will help give you a better idea. http://www.harvilledesign.com/harvilled ... stcal.html
I'm guessing this is where I would use either the Behavior section or the Further Posting section, but I'm at a loss of what I'm actually supposed to do with that. Any help would be much appreciated! Thanks!
Here is the link to my cost calculator if it will help give you a better idea. http://www.harvilledesign.com/harvilled ... stcal.html
I'm guessing this is where I would use either the Behavior section or the Further Posting section, but I'm at a loss of what I'm actually supposed to do with that. Any help would be much appreciated! Thanks!
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
At the moment your form only estimates an amount. I didn't see any "action" meaning that there is no further processing of the form data.
However, If I have correctly understood, you would like the visitor first to estimate through the first form, then (he) would click the button to receive the mail with the quote ? With, or without the details ?
In all cases, you either need to use events (to make appear the final "submit" button and set the value of some hidden fields) or you should use a two step (=two pages) format, where the second page receives the data from the first and the second submits the received data.
This requires some changes in your form to combine the estimate with a submission, which at the moment you don't have.
However, If I have correctly understood, you would like the visitor first to estimate through the first form, then (he) would click the button to receive the mail with the quote ? With, or without the details ?
In all cases, you either need to use events (to make appear the final "submit" button and set the value of some hidden fields) or you should use a two step (=two pages) format, where the second page receives the data from the first and the second submits the received data.
This requires some changes in your form to combine the estimate with a submission, which at the moment you don't have.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I'm sorry, I must have given you the wrong idea of what I was trying to say. The form in the link is for my personal use only. There would be no visitors. I use it to formulate quotes for clients. Currently that's all it does. What I would like to do is to add a button that when I click it, it takes me to a new page that has the final quote information from the first form contained in a generic response that I can email to my clients. This would cut out the step of me having to go to my email account and manually typing a quote response to my customer. Does this make sense? Sorry for the confusion.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Yes, that's better.
So you can use the form you already have created, and use a "submit" button to send the info to the email address you will be typing. You can use the DBTS Form Processor to send the mail to your customer. However, the "Get Estimate" button should not be a "submit" button, but a "onclick" one, that will trigger the Javascript function to complete the calculations and fill in the fields, then a separate "submit" button can send the mail. In the DBTS Form Processor you can set the "Autoresponder" properties section to send the mail to the customer.
So you can use the form you already have created, and use a "submit" button to send the info to the email address you will be typing. You can use the DBTS Form Processor to send the mail to your customer. However, the "Get Estimate" button should not be a "submit" button, but a "onclick" one, that will trigger the Javascript function to complete the calculations and fill in the fields, then a separate "submit" button can send the mail. In the DBTS Form Processor you can set the "Autoresponder" properties section to send the mail to the customer.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I'm having some trouble getting the form to work like I want it to. I added a submit button to the form, but I don't know the best way to make the form remember the field values to display them on the second page.
Here is the link to my test first page: http://www.harvilledesign.com/harvilled ... _quote.php
Here is the second page that contains the email portion. This page will send an email correctly, but it's not filling in the text with the selected field values from the first page. http://www.harvilledesign.com/harvilled ... tquote.php. I also would love to be able to use the "Client's Name" field to automatically plug into the text below as well if possible.
The second page has this text which contains php:
I'm sure this isn't correct, but I can't find any useful info about this through multiple internet searches.
Here is the link to my test first page: http://www.harvilledesign.com/harvilled ... _quote.php
Here is the second page that contains the email portion. This page will send an email correctly, but it's not filling in the text with the selected field values from the first page. http://www.harvilledesign.com/harvilled ... tquote.php. I also would love to be able to use the "Client's Name" field to automatically plug into the text below as well if possible.
The second page has this text which contains php:
Code: Select all
<p name="message">Hello! Here is your requested shirt quote for a <?php echo $_POST["inkcolors"]; ?> color print on <?php echo $_POST["qty"]; ?> shirts.
The shirts would be <?php echo $_POST["wb_pricepershirt"]; ?> each for sizes Youth-Adult XL (2XL/3XL add $2 per shirt).<br>
The total, including any screen charges, shipping, and/or tax would be <?php echo $_POST["wb_clienttotal"]; ?>.<br>
Thanks! I hope to hear back from you soon.</p>
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
You are "POST"ing the data from the first to the second page. A thatpoint, what are your settings for the DBTS Form Processor ? Probably the processor send the mails (or does whatever you have set it to do) and then reloads the page, but at that point no $_POST superglobal exists anymore, so nothing is displayed within your text.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I sent you the file (from your web contact form) so you could have all the info you need if you have the time to help. Thanks!
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi Navaldesign, I finally got it working! However, some of the data from the first form is in a table, not a field. How would I be able to copy the value from the table to display in the second page like the fields do? Thanks.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Add, in the form, a hidden field with the same data as the table.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
The only problem with that is the table is empty until I click the Get Estimate button, which then populates the empty tables with the calculations (javascript in the header). If they were static values that would work great (I just tried that as a test and worked great). I'm sorry to keep bothering you, but I'm so close to having this working. Thanks again!
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
If no redirect can take place, most probably there is something that is "echo"ed in the browser before the redirect takes place.
Please post here the PHP code as you can see it WWB.Also please set the Captcha Rerwite to "No" as this is no longer valid, and publish the page and test before posting the code here.
Please post here the PHP code as you can see it WWB.Also please set the Captcha Rerwite to "No" as this is no longer valid, and publish the page and test before posting the code here.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I will need FTP access to your site.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi Navaldesign, is there anyway to have the form results post without the label attached? Such as a text area just display the message without first saying "Message:" or whatever you named the input field? Thanks.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Only by modifying the email templates: admin_email.php and auto_email.php which you can find in the dbts_includes folder on the server.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Check the file permissions, should be 644
Folder should be 755
In all cases, this can only be a permissions issue.
Folder should be 755
In all cases, this can only be a permissions issue.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Yes, there is a limitation depending on the PHP version running on your server. Usualy 20.
To increase it you would need to change the php.ini file to increase the value of the
max_file_uploads
parameter. You can do this if your hosting company allows local php.ini files. If not, you can ask them if they can do it for you.
To increase it you would need to change the php.ini file to increase the value of the
max_file_uploads
parameter. You can do this if your hosting company allows local php.ini files. If not, you can ask them if they can do it for you.
www.dbtechnosystems.com