Hello,
I'm running Joomla! 1.5 and it looks like it's CFv3.2
A couple months ago our email validation forms started submitting duplicate entries on two separate lines in our DB. I have tried to force the UID column to be unique but that then creates an error with the validation process and stops it from working all together.
I have just been letting it go and setup a cron job to move the single entry to a clean table but it is now time to actually deal with the problem.
We had been copying old forms using email validation and adjusted them to the new subject matter so there was no need to change any of the settings, but like I said that about 2 months ago the copied forms started submitting duplicate entries.
I have tried starting from scratch and the fresh form continues to have the same problem the moment I turn on the email validation plugin.
Any ideas? Please let me know if you need more details.
Thank you.
Adrien
I'm running Joomla! 1.5 and it looks like it's CFv3.2
A couple months ago our email validation forms started submitting duplicate entries on two separate lines in our DB. I have tried to force the UID column to be unique but that then creates an error with the validation process and stops it from working all together.
I have just been letting it go and setup a cron job to move the single entry to a clean table but it is now time to actually deal with the problem.
We had been copying old forms using email validation and adjusted them to the new subject matter so there was no need to change any of the settings, but like I said that about 2 months ago the copied forms started submitting duplicate entries.
I have tried starting from scratch and the fresh form continues to have the same problem the moment I turn on the email validation plugin.
Any ideas? Please let me know if you need more details.
Thank you.
Adrien
Hi Adrien,
Just to check, this is the Validation plug-in that sends a link out to the User to confirm their address?
I don't remember how this works in detail, it should just look for the token and then update the status on that record. If you turn debug on and try a validation can you see the MySQL query that is being generated? Updating the record usually means getting the id with one query and then running another using the id to update the status.
Bob
Just to check, this is the Validation plug-in that sends a link out to the User to confirm their address?
I don't remember how this works in detail, it should just look for the token and then update the status on that record. If you turn debug on and try a validation can you see the MySQL query that is being generated? Updating the record usually means getting the id with one query and then running another using the id to update the status.
Bob
This topic is locked and no more replies can be posted.
