Duplicate Record

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.

sure I have Require attribute

pattern::[0-9]{3}[0-9]{3}[0-9]{4}

if you miss this format ypu can submit data. But two numbers the same exact will still get submitted.

I tried with email, still gets submitted, duplicated

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 3 days, 21 hours ago by neoktech.
• This reply was modified 3 days, 21 hours 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.

thanks again.

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?

It does not show any valadation message it just submit the data.

Are you doing this as an administrator on the backend? There is a setting that allows the admin to save records and skip validation.

front-end, the PD Sign-up shortcode form.

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.

But thanks again. For your time taken.

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.

Reinstalling a WordPress Plugin