***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 Navaldesign, I'm building a website for someone who is using GoDaddy as the host and I cannot get the form to send to their gmail account. I keep getting the error message: SMTP Error: Could not connect to SMTP host.
I'm doing the same thing I've always done that has worked for other hosting companies, but GoDaddy is giving me issues. Do you have any suggestions? I've been trying to figure it out on my own with no luck. My client needs the form working asap and is bugging me about it. Any help would be great. Thanks!
I'm doing the same thing I've always done that has worked for other hosting companies, but GoDaddy is giving me issues. Do you have any suggestions? I've been trying to figure it out on my own with no luck. My client needs the form working asap and is bugging me about it. Any help would be great. Thanks!
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
The message indicates that the script can't connect to the gmail mail servers. Please check your settings.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I've got the client's GoDaddy email address as the "From", my Gmail address as the Admin email (temporarily to make sure it works then I'll change to his Gmail address),
Mail Engine: SMTP
SMTP Secure Server Connection: tls (have also tried ssl)
SMTP Host: smtp.gmail.com
SMTP Port: 465 (also tried 587)
SMTP Username: My Gmail address (for testing purposes) - also tried his username
SMTP Password: My Password (for testing purposes) - also tried his password
Is there anything else in the settings that would cause the error? Thanks
Mail Engine: SMTP
SMTP Secure Server Connection: tls (have also tried ssl)
SMTP Host: smtp.gmail.com
SMTP Port: 465 (also tried 587)
SMTP Username: My Gmail address (for testing purposes) - also tried his username
SMTP Password: My Password (for testing purposes) - also tried his password
Is there anything else in the settings that would cause the error? Thanks
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi,
Using DBTS,After form processing I set redirect to other page.. So it redirect to a new Windows/tab..
Is there an option to set redirect in parent frame (_parent) using DBTS form Processor?
Thanks
Using DBTS,After form processing I set redirect to other page.. So it redirect to a new Windows/tab..
Is there an option to set redirect in parent frame (_parent) using DBTS form Processor?
Thanks
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
@traco: _parent is used to open the "thankyou" page in the parent page when the form page is displayed in an i-frame. However, this is not possible. You will need to modify the code yourself, or use the DBTS Custom Processing property and use Javascript to make the thankyou page open in the parent page.
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
harville wrote:I've got the client's GoDaddy email address as the "From", my Gmail address as the Admin email (temporarily to make sure it works then I'll change to his Gmail address),
Mail Engine: SMTP
SMTP Secure Server Connection: tls (have also tried ssl)
SMTP Host: smtp.gmail.com
SMTP Port: 465 (also tried 587)
SMTP Username: My Gmail address (for testing purposes) - also tried his username
SMTP Password: My Password (for testing purposes) - also tried his password
Is there anything else in the settings that would cause the error? Thanks
I'm sorry but I have no clue. If this working fine on other hosting companies, it can only be a limitation of GD, which unfortunately I don't know.
www.dbtechnosystems.com
Extra hidden fields
Hey,
I'm wondering if it is possible to have a little assistance with this extension.
I am using the form processor within a logged in members area on my website to save and upload a member profile with a picture.
This all works great, and I have the member info and image saved to mysql db and the image stores to a folder.
The issue I am having is I want to be able to add the username from the logged in session as a hidden field to the form.
I can echo the username to the page and i can see it displaying so I know the session value has been stored onto the form page.
For testing I echoed the username to an editbox to see if I could store it that way but that doesn't work either.
NB - I have tried creating a random variable start of page html and echoed that to an editbox and that is not storing to db either. So it would seem to be an issue with additional php code.
Any help or pointers would be most appreciated
I'm wondering if it is possible to have a little assistance with this extension.
I am using the form processor within a logged in members area on my website to save and upload a member profile with a picture.
This all works great, and I have the member info and image saved to mysql db and the image stores to a folder.
The issue I am having is I want to be able to add the username from the logged in session as a hidden field to the form.
I can echo the username to the page and i can see it displaying so I know the session value has been stored onto the form page.
For testing I echoed the username to an editbox to see if I could store it that way but that doesn't work either.
NB - I have tried creating a random variable
Code: Select all
<?php $test = 1;?>
Any help or pointers would be most appreciated
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Echoing the username on the page doesn't mean that it is also passed over with the rest of the form data.
The easiest way to do it is to add a hidden field in the form and give it the following as value:
<?php echo $_SESSION['username'];?>
Of course, in order to store it in the database table, there MUST EXIST a column in the table named "username".
However, if you are using the DBTS Form Processor as you say, it would be enough to set the property "Add columnsautomatically" to "Yes" in the database settings section, and the processor will create the column for you and store there the username.
The easiest way to do it is to add a hidden field in the form and give it the following as value:
<?php echo $_SESSION['username'];?>
Of course, in order to store it in the database table, there MUST EXIST a column in the table named "username".
However, if you are using the DBTS Form Processor as you say, it would be enough to set the property "Add columnsautomatically" to "Yes" in the database settings section, and the processor will create the column for you and store there the username.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thanks for the reply - I managed to get it working with your help - Operator error Thanks heaps
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi
Could you let me know why my Success Page is not working anymore
http://www.glendower.co.uk/success.php
Could you let me know why my Success Page is not working anymore
http://www.glendower.co.uk/success.php
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Change the Success page to html from php and it should work.
Brian
Brian
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi Brian,lummis wrote:Change the Success page to html from php and it should work.
Brian
why do I need to change to HTML as the Form Page/ Error Page works fine in PHP and the Success Page works as in the form gets emailed to me just the page doesn't display.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
I am sure that George (Naval Design) can give you the reason why it is likely to work, but from experience and seeing similar queries on the forum responded to by Pablo it is usually the answer! It has something to do with the way that the form processor works but I don't know the technicalities. I am presuming that your Success page does not have any php code so as an html page it will work. If you have got php code in the Success page then you may need to think of another way - perhaps a success page in html with a redirect after say 10 seconds to the php page.
Brian
Brian
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
If you try to open the success page in your browser, it displays a 500 server error.
So it has nothing to do with the processor.
I suggest you take a look at the success page file permissions on the server. On Linux hosting, it should usually be 644.
Also, there should be no form in the success page.
Of course, if you have other PHP code in the success page, it could also be an issue of a code error.
Create a simple page (it doesn't matter whether it is HTML or PHP) and change, in the processor, the success page to be the new one.
If it displays correctly, the issue stands with your page.
So it has nothing to do with the processor.
I suggest you take a look at the success page file permissions on the server. On Linux hosting, it should usually be 644.
Also, there should be no form in the success page.
Of course, if you have other PHP code in the success page, it could also be an issue of a code error.
Create a simple page (it doesn't matter whether it is HTML or PHP) and change, in the processor, the success page to be the new one.
If it displays correctly, the issue stands with your page.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
George what is the latest version of this extension? Does it support 11?
Running WYSIWYG Web Builder since 2007...
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Last version: 2.7.5.7
Yes, works fine with v.11
Yes, works fine with v.11
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thanks George, also will it work with Recaptcha V2?
http://www.wysiwygwebbuilder.com/recaptchav2.html
http://www.wysiwygwebbuilder.com/recaptchav2.html
Running WYSIWYG Web Builder since 2007...
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
It should work with the standard WWb Recaptcha 2 but I have not tried it.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Cheers will give it a try. Are you going to recompile this extension with the latest EXT Builder as recommend by Pablo?
Running WYSIWYG Web Builder since 2007...
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
When / if a new version comes out.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
viewtopic.php?f=1&t=72086Navaldesign wrote:When / if a new version comes out.
Running WYSIWYG Web Builder since 2007...
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Your settings seem correct, however the error message should NOT be an URL but a simple text message.
Edit, publish again, refresh your browser and test.
Edit, publish again, refresh your browser and test.
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
Please remove the code you have added, it is not needed, then publish and try again.
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
Hello, Do the Form Processor work with PHP version 5 and 7?
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
As far as I know (haven't tested) it does.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
WB12.1.1
Is there a way to number the emails Like a reference number.
Is there a way to number the emails Like a reference number.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
It will require some custom coding.
You may have a look at how this is done in the Webshop Plus and apply the same through the "Custom coding" properties of the processor. Some PHP knowledge is required.
You may have a look at how this is done in the Webshop Plus and apply the same through the "Custom coding" properties of the processor. Some PHP knowledge is required.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
WB12.1.1
OK I am looking at it.
OK I am looking at it.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
If I add this to the value of an edit box <?php echo mt_rand(100000, 999999);?> I get a random number. but I am working on doing better then this.
like in sequence.
And is there a way to move the edit box from the bottom to the top. I changed the tab order and moved it to the top. but in the email it still shows at the bottom.
like in sequence.
And is there a way to move the edit box from the bottom to the top. I changed the tab order and moved it to the top. but in the email it still shows at the bottom.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
To get sequence numbers, you need to keep track of each email number.
You can do this by storing and retrieving the last number from a database or file stored on the server.
This is what Webshop Plus does (stores the last order number on the server, and then retrieves it when a new order is made).
If you look at how this is done in Webshop Plus, you can apply exactly the same solution.
It will be enough using a hidden field (instead of an editbox) to "echo" the number and receive it with the mail details.
You can do this by storing and retrieving the last number from a database or file stored on the server.
This is what Webshop Plus does (stores the last order number on the server, and then retrieves it when a new order is made).
If you look at how this is done in Webshop Plus, you can apply exactly the same solution.
It will be enough using a hidden field (instead of an editbox) to "echo" the number and receive it with the mail details.
www.dbtechnosystems.com
- protectourlands
-
- Posts: 443
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Hi George
Where can we download the latest version of this extension?
Where can we download the latest version of this extension?
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
The version available through the Extension Manager is the latest one.
www.dbtechnosystems.com
- protectourlands
-
- Posts: 443
- Joined: Sat May 24, 2008 2:16 am
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Perfect! Thank you. This is a great extension.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
wb12
Quick Question when I add form processor to a page that has layout grid using the form option it sends the form but no information.
if I add it to a page with just a regular form it works fine.
Quick Question when I add form processor to a page that has layout grid using the form option it sends the form but no information.
if I add it to a page with just a regular form it works fine.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
wb12
Ok I got it working but I don't no what was wrong.
Ok I got it working but I don't no what was wrong.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
George, I tried to update the Form Processor extension (mine was still at 2.6.0) but the update failed. I then removed the extension to try a clean install but the downloaded failed again. I am not sure if it has any significance but the latest version according to the Extension Manager is 2.7.5.7 whilst your Change Log says the latest is 2.7.5.6
Brian
EDIT - Having closed WB12 and then reopened, the updated file has been loaded. It must have been a glitch in the system.
Brian
EDIT - Having closed WB12 and then reopened, the updated file has been loaded. It must have been a glitch in the system.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Unfortunately the updated extension has not solved my initial problem as hoped. My host has just upgraded it's servers to PHP7 and this appears to have caused the DBTS Form Processor to fail. I have tried both PHP5 and PHP7 in the Page Properties without success.
Having enabled the debugger I have received the following:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php:208 Stack trace: #0 /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php(154): db_connect() #1 /home/********/public_html/********.org.uk/dbts_includes/dbts_formprocessor.php(247): WriteToMySQL('********...', 'localhost', '********', '********', 'clothing', Array, Array, 'Yes', 'Yes') #2 /home/********/public_html/********.org.uk/clothing_order_form.php(233): include('/home/********/...') #3 {main} thrown in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php on line 208
I have a very basic knowledge of PHP/MySQL but I am wondering whether the problem lies with the mysql_connect function in the includes_dbtsfunctions folder - should this be mysqli_connect with PHP7?
Having enabled the debugger I have received the following:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php:208 Stack trace: #0 /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php(154): db_connect() #1 /home/********/public_html/********.org.uk/dbts_includes/dbts_formprocessor.php(247): WriteToMySQL('********...', 'localhost', '********', '********', 'clothing', Array, Array, 'Yes', 'Yes') #2 /home/********/public_html/********.org.uk/clothing_order_form.php(233): include('/home/********/...') #3 {main} thrown in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php on line 208
I have a very basic knowledge of PHP/MySQL but I am wondering whether the problem lies with the mysql_connect function in the includes_dbtsfunctions folder - should this be mysqli_connect with PHP7?
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Obviously your server has switched to mysqli.
However it is not that simle, as all functions have to be updated for mysqli.
However it is not that simle, as all functions have to be updated for mysqli.
www.dbtechnosystems.com
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
That's what I thought, George. It looks as though I will have to change to the built in Form Processor although I am having some problems setting that up - hopefully Pablo will come to my rescue if needed. Many thanks.
Brian
Brian
Recaptcha V2 with DBTS
Has anybody been able to integrate Pablo's reCAPTCHA v2 extension with DBTS form processor?
I use both DBTS form processor and DBTS preview, and I really would like to avoid having to rebuild it from scratch as it is not a short form. But with reCAPTCHA v1 now deprecated, I really need to remove DBTS reCAPTCHA and would rather not. Yes, I could do some kind of different "are you human" test, but if anybody has been able to integrate the v2 extension with DBTS I would be keen to hear how you did it!
Thanks
I use both DBTS form processor and DBTS preview, and I really would like to avoid having to rebuild it from scratch as it is not a short form. But with reCAPTCHA v1 now deprecated, I really need to remove DBTS reCAPTCHA and would rather not. Yes, I could do some kind of different "are you human" test, but if anybody has been able to integrate the v2 extension with DBTS I would be keen to hear how you did it!
Thanks
Last edited by tdr on Sat Apr 07, 2018 9:01 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
I have not tried it but, knowing how the script structure is, I think there should be no issues. It will simply work independently from the DBTS Form Processor.
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
Hi, i just put it in the form, and in DBTS settings i have this for E.Captcha:
WWW Captcha rewrite = No
Recaptcha Force Verification = No
Recaptcha private key = Empty
Use reverse captcha = No
WWW Captcha rewrite = No
Recaptcha Force Verification = No
Recaptcha private key = Empty
Use reverse captcha = No
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Thanks Patrik! I've tried this and now have some minor issues where if the person clicks submit button before passing the reCAPTCHA challenge, the error handling is lost. With DBTS form processor I could control most of this. I'm thinking if I could disable the submit button and then enable it when successfully passed the robot test. I've seen some scripting examples online which might help, but I can't figure out how to insert the data-callback example as per below. Any ideas would be much appreciated as I'm a novice on the scripting side.
<form>
<div class="g-recaptcha" data-sitekey="YOUR_PRIVATE_KEY" data-callback="recaptchaCallback"></div>
<button type="submit" class="btn btn-default hidden" id="btnSubmit">Submit</button>
</form>
<script>
function recaptchaCallback() {
var btnSubmit = document.getElementById("btnSubmit");
if ( btnSubmit.classList.contains("hidden") ) {
btnSubmit.classList.remove("hidden");
btnSubmitclassList.add("show");
}
}
</script>
- Patrik iden
-
- Posts: 479
- Joined: Wed Mar 24, 2010 9:07 pm
- Location: Sweden
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
Well, i just set a error page in the Recaptcha settings.
I also have the same error page set in the DBTS error page settings.
I also have the same error page set in the DBTS error page settings.
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
My host service has updated PHP to version 7 and DBTS Form Processor do not work with my database. Is there a solution for this matter or a new version available?. The latest one I have is 2.7.5.x (according to the documentation)-
Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011
This probably won't help but have you set the PHP version in Page Properties > Advanced to PHP5-PHP7?
EDIT: I've just seen some posts about this issue (on previous page to this!) and it looks like the extension doesn't work for PHP7.
It's regarding the MySQLi new formats.
EDIT: I've just seen some posts about this issue (on previous page to this!) and it looks like the extension doesn't work for PHP7.
It's regarding the MySQLi new formats.