I have an issue with Duplicate Record. In my case if a phone number is attached to an account previously submitted, I don’t want another account to be registered with the same phnoe number. One record have one phone number.
Duplicate Record Check Field = Mobile Phone (mobile_phone) when a signup is submitted or CSV record is imported, this field is checked for a duplicateDuplicate Record Preference Create a new record with the submission = Show a validation error message when the submission matches the Duplicate Record Check Field of an existing record. This also applies to importing records from a CSV file.
This is not working for me. Record are still being submited that match the phone numbers. SO check field is not checking.
The check is looking for an exact match, so to do something like this with a phone number, you need to make sure the format of the input is exactly the same…there are lots of different ways to write a phone number.
This is working in my tests here, so I’m wondering what might be different in your case. Do you have any custom code or plugins that might be altering how the plugin matches records?
Try turning plugin debugging on and clear the debugging log. When you test a signup and check the debugging log, you can see the database query that is used to find the match, this may help show where it’s going wrong. Here is an example of such a query from my tests:
[02/28/25 12:41pm] PDb_submission\matching\record::field_value_exists query: SELECT EXISTS( SELECT 1 FROM wp_participants_database p WHERE p.email = '[email protected]' AND p.id <> '0' )
I see your log. I don’t have any plugins installed other than pd.
I did the debugging log – I see how the data is captured and stored but it didn’t detect the duplicates record. I don’t know if the php version will be the issue.
This reply was modified 1 year, 3 months ago by neoktech.
This reply was modified 1 year, 3 months ago by neoktech.
OK, so to drill down on this, compare what is in that query to what is in the database. Is it checking the correct field? Is it an exact match?
If it matches, then check again that you have the match preference set to show an error when a match is detected.
Since it is working in my tests, I don’t have any other way to help you other than to check on what is going on there and hopefully you’ll be able to see what the problem is.
Is it an exact match, What in the query matches exactly whats in the database.
yes, I set the match preference to show the validation msg.
Appreciate, as my self can’t seems to find the root cause. It used to work, then one day I noticed the duplicates.. been on this issue for over an yr now. I don’t have any other plug-in, using a default wp theme. So no extras.
OK, so when you test this…it shows the validation error message but saves the new record anyway? Or does it not show a validation error at all and behaves as though the submission was valid, showing the “thanks” message?
I assume you saw no errors in the debugging log…I don’t know what the issue is, I sure can’t make it do this in my tests. Did you try re-saving the settings?
Well, I’m sorry, but I’m at the end of things I know to check. I mean if I could get the issue to show up here, I’d have a problem I could solve, but at this point all I can suggest is you try to debug it yourself.
If you have any suggestions for how I can duplicate the problem here I’d be happy to keep trying.
Appreciate, For almost a year, I have been emailing xnau support trying to figure out. My database is populated. It’s difficult to abandon or start over. If you can pass on an email alias I can work on granting you access if you have time.
I’m sorry we haven’t been able to get to why this is happening, I’d like to know myself, but I can’t log in to your site and start changing code, just not a good idea in case something goes wrong.
Reinstalling the plugin could be helpful. You wouldn’t have to start over, you can reinstall the plugin without losing any data. Of course, you should have backups made by a WP backup plugin that makes a backup of all database tables. I posted an article that explains how to reinstall, keeping all of your settings and data intact.
