***UPDATED*** DB Technosystems Form Processor 02/09/2011

Vlastimil · Post by **Vlastimil** » Sat Jan 18, 2014 4:17 pm

Hi, i read all posts in this, but not found working solution. I made something wrong.
I need add to form random item VS, that is filled from php code.
As initial value to VS i define <?php echo $VS;?> (I try <?php echo $VSRND;?> too)
I need, by this random text stay visible in form editbox for user (this editbox i planing set to read only)
I define variable $VSRND = "RANDOM TEXT" and put the code $POST["VS"] = $VSRND; to Start od Script Custom Processing and to After Form Data Reception Custom Processing.
But after I fill for, the item VS is blank, not filled from $VSRND.
What I made wrong?

Navaldesign · Post by **Navaldesign** » Sat Jan 18, 2014 4:23 pm

Sorry, but I don't understnd what you need to do.
If the random text must be adedn a for field, why shuld you add code in the procssor ? add it directly in the form field or as a hidden field.

Vlastimil · Post by **Vlastimil** » Sat Jan 18, 2014 4:41 pm

I need add to this RANDOM text some data selected from other one typed filled, then i need add this code to form processor.

Navaldesign · Post by **Navaldesign** » Sat Jan 18, 2014 6:28 pm

Sorry, but since I don't understand what exactly you need to do, I can't be of much help.

Vlastimil · Post by **Vlastimil** » Sat Jan 18, 2014 7:52 pm

OK, many thanks for you support.

tdr · Post by **tdr** » Tue Jan 21, 2014 8:21 pm

I hope this is not too dumb a question:
I use DBTS reCAPTCHA on my forms. I'm seeing more sites these days with reCAPTCHA based on numbers versus the very difficult to read words. Will I automatically get the benefit with DBTS reCAPTCHA or does the extension need to be updated?

thanks

Navaldesign · Post by **Navaldesign** » Wed Jan 22, 2014 6:09 am

Reading posts on the net seems like Google is automating the displayed content based on evaluations made at the moment of the captcha request. I have not been able to find a way to set captcha to serve numbers, it is the recaptcha server that "decides" what to serve.

milux · Post by **milux** » Wed Jan 29, 2014 9:28 am

I have a question that probably was already asked one million times : it's possibile to use with WB 9.2 this extension ? I have tried to install it but don't see in the extension list..:

thx in advace.

Michele

Navaldesign · Post by **Navaldesign** » Wed Jan 29, 2014 9:33 am

Yes, it can be installed and used with WWB 9.2. Maybe you have installed too many extensions, so it will not appear ?

Did you install it through the Extension Manager ?

milux · Post by **milux** » Wed Jan 29, 2014 9:44 am

Navaldesign wrote:Yes, it can be installed and used with WWB 9.2. Maybe you have installed too many extensions, so it will not appear ?

Did you install it through the Extension Manager ?

Yes with the Extension Manager but I don't see it probably for too many extension..any suggestion to fix this?

Navaldesign · Post by **Navaldesign** » Wed Jan 29, 2014 7:45 pm

No, I'm afraid not. Try removing extensions that you normally don't use.

milux · Post by **milux** » Thu Jan 30, 2014 8:56 am

I have uninstalled older exensions not used and cancelled the form processor files (wbx) from the folder ../system/extension. I have reinstalled the extension from the Extension Manager but nothing change....I am a bit stressed

BaconFries · Post by **BaconFries** » Thu Jan 30, 2014 11:33 am

@ Navaldesign not hijacking your thread in anyway....@ milux the maximum extensions you can have installed in 200, if you have this then please remove as many as possible that yiou are not using. When installing extension it is always best to install from the extension manager. If you have change the path of were the extensions are stored then you will alsoneed to ensure this path is the same flor allextensions used/installed. This needs to be asked are you using a legal version of the program? have you ever used a illegal version of the program in the past if so this could explain why the extension is not working. Also I am not sure only Navaldesign can answer what version of the extension builder was used to build the extension? if it was the latest build then the extension may only work in WB9 and not earlier versions of the program.

Please also read the following urls
How to trouble shoot Web Builder Extension issues?
viewtopic.php?f=10&t=7234
What to do when extensions no longer work in version 8.5?
viewtopic.php?f=10&t=50825
Location of user content in WB8 & WB9
viewtopic.php?f=10&t=30276

milux · Post by **milux** » Thu Jan 30, 2014 12:24 pm

BaconFries wrote:@ Navaldesign not hijacking your thread in anyway....@ milux the maximum extensions you can have installed in 200, [/quote)

actually I have 55 extension installed

BaconFries wrote:If you have change the path of were the extensions are stored then you will alsoneed to ensure this path is the same flor allextensions used/installed.
I have checked : in Option/ Default Document folder is correct.

BaconFries wrote:This needs to be asked are you using a legal version of the program? have you ever used a illegal version of the program in the past if so this could explain why the extension is not working. Also I am not sure only Navaldesign can answer what version of the extension builder was used to build the extension? if it was the latest build then the extension may only work in WB9 and not earlier versions of the program.
Yes I have a legal version of the software (the 1st was version and the last version 9 purchased at 18/06/2013 (actually upgraded to 9.2). This is the only extension that I cannot install ; for all the others no problems.

BaconFries wrote: Please also read the following urls

I have read all this topics a lot time..

Thx for your support.

Vlastimil · Post by **Vlastimil** » Thu Jan 30, 2014 2:52 pm

Hi Navaldesign, I using Success URL = sucess.php and this working fine. Data from post has been stored to DB. It`s possible on this sucess.php page get again some data from form ?
I need identify this "last record", to GET data from DB and provide next functions.
I have set Copy in Session on form page to yes and Clear Session to no, but when i can get data on sucess.php using $_POST['Email'], I get always "empty" string. Can you please help me, what made I wrong?

harville · Post by **harville** » Thu Mar 27, 2014 9:30 pm

I've seen where you can send an sms text with phpmailer and I wanted to know if this is possible with this extension? I've been using this extension for some time now but I wasn't sure if this is possible. Please let me know. Thanks!

**I got it to send the text, but it doesn't display the entire message. It only displays about 7 lines and cuts the rest off. Any ideas?

Navaldesign · Post by **Navaldesign** » Fri Mar 28, 2014 10:14 am

Maybe it is a limitation of the host that actually sends the sms ?

The processor will POST (send using the POST mehod) all the data it receives from the form, so I can only guess that the receiver server limits the length of the SMS text.

Patrik iden · Post by **Patrik iden** » Wed Jun 25, 2014 6:25 pm

Hello, I updated to WWB 9.4.2 and pubiched a page that i have the form processor on, it worked before but now i get to the thank you page, so thats ok. But i dont recive any emails. Do you know of any problems whit form processor and the WWB 9.4.2? Thank you.

electrochrisso · Post by **electrochrisso** » Wed Jun 25, 2014 11:06 pm

Hi Patrik, just thought I would let you know Update WWB 9.4.3 has just been released.

Navaldesign · Post by **Navaldesign** » Thu Jun 26, 2014 4:46 am

There are no known issues with WWB 9.4.2 or other version. However, please update to the last WWB version so if you still have issues we can talk based on the same WWB version.

Patrik iden · Post by **Patrik iden** » Fri Jun 27, 2014 4:59 pm

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.

Navaldesign · Post by **Navaldesign** » Sat Jun 28, 2014 5:26 am

Try setting also the Form charset to UTF8

Patrik iden · Post by **Patrik iden** » Sat Jun 28, 2014 7:03 am

Navaldesign wrote:Try setting also the Form charset to UTF8

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?

Thank you.

traco · Post by **traco** » Mon Jun 30, 2014 3:38 pm

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

Navaldesign · Post by **Navaldesign** » Mon Jun 30, 2014 5:01 pm

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.

Navaldesign · Post by **Navaldesign** » Mon Jun 30, 2014 5:04 pm

Patrik iden wrote:
Navaldesign wrote:Try setting also the Form charset to UTF8
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?

Thank you.

I'm sorry, I don't know why this doesn't work for you.

traco · Post by **traco** » Mon Jun 30, 2014 5:27 pm

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.

which xampp settings should I check?
Thanks

Patrik iden · Post by **Patrik iden** » Mon Jun 30, 2014 5:35 pm

Do you have somthing like this somewhere in your Formprocessor code:

mysql_query('SET NAMES UTF8');

mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');

traco · Post by **traco** » Mon Jun 30, 2014 6:11 pm

@Navaldesign

Online work..

Thanks

Patrik iden · Post by **Patrik iden** » Wed Jul 02, 2014 3:14 pm

Whats the current version?

Navaldesign · Post by **Navaldesign** » Wed Jul 02, 2014 4:44 pm

Patrik iden wrote:Whats the current version?

Current version is 2.7.5.6

Vlastimil · Post by **Vlastimil** » Fri Jul 04, 2014 4:20 pm

Patrik iden wrote:
Navaldesign wrote:Try setting also the Form charset to UTF8
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?

Thank you.

I use WWB to generate pages in Czech language. We have many special characters ěščřžýáíé, ĚŠČŘŽÍÁÍÉ and more.
I have had the same problem and use in page properties and DBTS Character Set UTF-8 and all it`s OK.

harville · Post by **harville** » Mon Jul 28, 2014 3:04 am

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:

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 · Post by **Navaldesign** » Mon Jul 28, 2014 4:19 am

Please set the property "Rerwrite Captcha" to No, and republish the page.

harville · Post by **harville** » Mon Jul 28, 2014 4:29 am

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!

Vlastimil · Post by **Vlastimil** » Thu Aug 28, 2014 4:02 pm

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

Navaldesign · Post by **Navaldesign** » Thu Aug 28, 2014 4:12 pm

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.

Vlastimil · Post by **Vlastimil** » Thu Aug 28, 2014 4:19 pm

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:

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);
}

THE NEW NOT WORKING begin with

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')
{

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.

Navaldesign · Post by **Navaldesign** » Thu Aug 28, 2014 4:39 pm

Please post here the Page HTML as you can see it in WWB.

Vlastimil · Post by **Vlastimil** » Thu Aug 28, 2014 4:47 pm

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.

Navaldesign · Post by **Navaldesign** » Thu Aug 28, 2014 5:00 pm

I need to see the Page HTML, these images don't help.

Vlastimil · Post by **Vlastimil** » Thu Aug 28, 2014 5:06 pm

Sorry, i sending booth files zipped. If need, I can send project file.

kontakt.ZIP

Navaldesign · Post by **Navaldesign** » Thu Aug 28, 2014 5:32 pm

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.

Vlastimil · Post by **Vlastimil** » Thu Aug 28, 2014 5:55 pm

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.

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.

em3.gif

The generated kontakt.php is smaller as working file from WWB 9.3 - see included. Missing the class.phpmailer.php section.

kontakt_unchecked.zip

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.
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 · Post by **Navaldesign** » Thu Aug 28, 2014 10:35 pm

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).

Vlastimil · Post by **Vlastimil** » Fri Aug 29, 2014 8:13 am

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 · Post by **protectourlands** » Mon Sep 29, 2014 4:43 am

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?

Navaldesign · Post by **Navaldesign** » Mon Sep 29, 2014 5:10 am

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" ?

protectourlands · Post by **protectourlands** » Mon Sep 29, 2014 6:01 am

Oh man, that was it. After Processing Behavior. I missed it. Thank you so much.

protectourlands · Post by **protectourlands** » Wed Jan 14, 2015 10:23 pm

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.