Forums

Not posting to database on registration or CB plugin

spletcher 30 Jan, 2009
I've studied Chronoforms for a month now and used it successfully for connecting to the database and emailing form data.

I've just now tried to use the plugins for CB and Joomla registration. The way I understand it from going carefully through all tutorials is that you do not connect it with a database table, but just have the plugin enabled and choose the corresponding fields for each table field.

With CB plugin, I can never get anything to post to the table (jos_comprofiler) , although it will email me to the email with the template that I setup. I've never had it email to the user and the admin as it says it will within the plugin setup when you're selecting which fields correspond to which.

With doing a quick registration form and trying to use the Joomla registration plugin, I got it to send a email to the "newly registered user" once, however the link to confirm the user's registration didn't unblock the user. The admin got no email. Also after setting up the automatic email response, I never got it to register anyone successfully again.

Are these common problems with the plugins?

One other question, when it works successfully as a CB registration page, do I need to use both CB plugin and Joomla registration plugin - given that some of the fields are stored in the jos_users table and some in the jos_comprofiler table?

It seems my main issues are getting it to send the emails within the plugin section (the ones I setup always come) and also posting the data to the database.

Any help utilizing this description?

Stan 😀
GreyHead 30 Jan, 2009
Hi spletcher,

I'm not a CB user - but I have taken a look at Max's code in the CB Registration plugin this morning.

It looks to me as though you need to add the extra fields first in CB so that they appear in the jos_comprofiler table.

Then when you initialise the plugin it will read the table and add the extra fields into the plugin configuration so that you can link the new CB fields with the fields in your ChronoForms form.

I hope that this helps a bit.

Bob
spletcher 01 Feb, 2009
Bob,

This was already done before. So when I did this, I had no problem linking all the extra fields to the jos_comprofiler table. The issue was that nothing actually posted to the table.

I guess essentially my question was whether the plugin is supposed to take care of the linking to the table for you and you don't need to actually "connect a table" also. Somehow it isn't quite doing it.

I was looking over hiring someone to finish this up for me in your forum, but couldn't tell if there are folks that have plenty of time to do this sort of thing or if I'm just as well to post this to Joomlancers. I'm also trying to submit the info in the same registration page to an outside database with a submit URL (form action) as you may see in anothe post I just left.


Thanks,

Stan
GreyHead 01 Feb, 2009
Hi Stan,

As far as I can see it should all be included - this code is from the PlugIn and appears to be writing back to the correct table
$database->setQuery( "INSERT INTO #__comprofiler (".implode(",",$fields2).") VALUES  ('".$user->get('id')."','".$user->get('id')."','".implode("','",$fields3)."');" );

Bob
This topic is locked and no more replies can be posted.