E-Mail verification / Database storage

Hi,

i tried to use the new E-Mail-Verification but i can't get it to work:

"Parse error: syntax error, unexpected '-', expecting '{' in /home/wmsounds/public_html/v2/components/com_chronocontact/chronocontact.php(45) : eval()'d code on line 3

Fatal error: Call to a member function bind() on a non-object in /home/wmsounds/public_html/v2/components/com_chronocontact/plugins/cf_email_verification.php(284) : eval()'d code on line 13"

I don't know what's wrong, maybe someone could pls be so kind a post a tutorial how to get mail verification to work? Because this plugin is a lon awaited feature so chronoforms is able to handle newsletter double check back verification.

Hi xpla,

Please check the field-names in your form - one or more of them probably contains a hyphen and this is what causes the first error and I suspect that the second one is a result of the first.

Replace the hyphen '-' with an underscore and rename the correcponding table column using PHPMyAdmin (or delete and re-create the table if that's simpler).

Bob

Thank you! Now data is stored in the database but e-mail verification doesn't work (plugin not the javascript validation). I get the mail which i defined in the verification plugin but no backlink to click on it😟 I added a tinyint field to the database.

`jos_chronoforms_newsletter` (
`cf_id` int(11) NOT NULL auto_increment,
`uid` varchar(255) NOT NULL default '',
`recordtime` text NOT NULL,
`ipaddress` text NOT NULL,
`cf_user_id` text NOT NULL,
`name` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`verify` tinyint(4) default NULL,
PRIMARY KEY (`cf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

Sorry i managed to get the link ( {vlink} ) but he redirects me to the form itself and no change in the database takes place.

Got it to work! 😀 😀 😀 😀 :mrgreen: :mrgreen: :mrgreen: :mrgreen: :mrgreen:

Hi xpla,

Great :-)

Bob

@XPLA - How did you get this to work. I am having the same issue... Link takes me back to the form page. The link looks like this

http://www.mydomain.com/index.php?option=com_chronocontact&chronoformname=newform&task=beforeshow&uid=

Can you please advise?

Thanks

I had a hyphen (-) which i didn't recognized. After changing this it worked.