Project Verification form not working for OG Projects

[WhyldWanderer]

Before the verification form was integrated into the Dapp, we used a typeform. Now the projects that applied via the old typeform do not have an application saved in the db.

There were some projects like this who recently lost their GIVbacks Eligible badge for not adding updates and now when they go to the dapp to add the update and re-apply they are getting this message:

Is there a way to allow them to fill out the form on the dapp now?
With the QF round coming up, I am aware of a few projects that might now find themselves in this same situation.

[WhyldWanderer]

I just had a thought and wanted to share it...
I wonder if this is happening because the project owner requested to change their wallet address since they first filled it out. It seems to be a common thing between the projects that have reported it.

https://giveth.io/project/dappnode
https://giveth.io/project/kawagumba-village-community-farming-project

[CarlosQ96]

It's entirely posible, I'll start checking there.

[CarlosQ96]

Creating a query to fix the userIds

[CarlosQ96]

Fixed the userIds of verification forms

[CarlosQ96]

UPDATE project_verification_form pvf
SET "userId" = p."adminUserId"
FROM project p
WHERE pvf."projectId" = p.id
AND pvf."userId" != p."adminUserId";

[divine-comedian]

@WhyldWanderer - can you validate this issue has been fixed for the related users?