Does not work when combined with captcha

  • bulgin23
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0

bulgin23 created the topic: Does not work when combined with captcha

Hello.
I was able to get breezing forms to use the following code in submit pieces:
$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
$submittedtoken = ff_getSubmit('bfQuickMode869794');
$db->setQuery("Select url From xxxx_xxxx WHERE token =".$submittedtoken );
$urlToRedirect = $db->loadResult();
JFactory::getApplication()->redirect("$urlToRedirect");

But when I ad captcha I get errors 1064.

Joomla cache is off and not running.

Cleared browser cache and same error.

As well, when I enter the wrong token (for testing) the form redirets to my localhost root folder (I am testing on a localhost).

I would like any errors to be redirected to another page or show an error without causing difficulty.
#234541
  • Posts: 5688
  • Karma: 118
  • Thank you received: 526

MarioPuco replied the topic: Does not work when combined with captcha

Hi,

What version of BF are you using ?
Also are you adding ReCaptha 2.0 or regular Captcha ?

Regards;
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#234552
  • bulgin23
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0

bulgin23 replied the topic: Does not work when combined with captcha

Thank you Mario Puco,

I am using breezing forms Free (build 931) and using regular Captcha.

right now I'm trying to troubleshoot two problems: the captcha issue stated in this thread as well as the forms simply not working with the script in submit pieces:
$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
$submittedtoken = ff_getSubmit('bfQuickModexxxxxxx');
$db->setQuery("Select url From xxxxx_token WHERE token =".$submittedtoken );
$urlToRedirect = $db->loadResult();
JFactory::getApplication()->redirect($urlToRedirect, 'parent');

The above *was* working but when I introduced regular captcha, it breaks. Right now I'm just trying to get the above script to work without captcha.

Thank you.
#234567
  • bulgin23
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0

bulgin23 replied the topic: Does not work when combined with captcha

Is there some way to debug this? I've been trying from the breezing forms admin panel to troubleshoot this but need some more in-depth view at what is happening behind the scene. I keep receiving the same error over and over and nothing has really changed since it was working:
1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
#234568
  • Posts: 5688
  • Karma: 118
  • Thank you received: 526

MarioPuco replied the topic: Does not work when combined with captcha

Hi,

Before any further steps, can you please send me the URL to your form so I can check it out please ?

Rgds,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#234569
  • bulgin23
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0

bulgin23 replied the topic: Does not work when combined with captcha

Hi Mario,

Thanks for helping out. It's on a localhost machine that would be difficult to provide access.

Is there some other way to get you the code you are looking for?
#234570
Moderators: ForumSupporttomeperica
Time to create page: 0.076 seconds

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99€

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here