Invalid Affiliate ID

[Steph Enriquez]

Hi There,

Our websites experience server errors last week that we had to roll back to recover our websites. Unfortunately, the affiliate members that are registered within that week have been deleted. Can we still restore that lost data? esp. the Affiliate IDs.

Because when we found out that the data has been deleted, we re-registered those members instead since Monday, Nov. 22, 2021. There’s one member that registered again but the data or info is not stored on the plugin’s records. Our Affiliate Manager was tracking the registered members via email to verify the registration then this error appeared: https://snipboard.io/RLK9AE.jpg

Does that mean it’s duplicated or the link in the email is expiring?

Regards,
Steph

[Shadow Labs]

@steph-enriquez, We don’t really know what was deleted or restored. Please open the “wpam_affiliates” table from your database and check if the user ID for each affiliate matches the correct user on your site.

[Steph Enriquez]

Hi @Shadow Labs,

Is it possible to create an affiliate ID on the database? because some of the IDs are missing https://prnt.sc/20w5plu

I also wonder why the record has gaps, considering we let our members register again after the website’s restore.

[Shadow Labs]

@steph-enriquez, Can you please explain who these members are and how they were created? Are you referring to affiliates?

When an affiliate registers our plugin also creates a new WordPress user account for it (if a user account doesn’t exist with the same email address).

[Steph Enriquez]

Hi Shadow Labs

Those are our affiliate members. We created a registration page so they can apply easily. But after the website restore, we noticed that the affiliate IDs have gaps/skipped a number. That’s why I’m asking if it’s possible to manually add an affiliate on the database itself? so the skipped numbers can be used by a new member?

because if we add it manually on the WordPress site we’re thinking it might be skipped again.

Let me know if I explained it clearly.

Thank you.

[Shadow Labs]

Thanks. The ID is generated in the database automatically (the plugin has no control over it). I believe you can directly edit it in the database. But you cannot assign a fix ID when creating an affiliate from the plugin’s interface.

[Author]

Posts