Privacy: Information Requests: Confirmation tokens are not recognized Topic is solved

[crolidge]

Dear members,
I have an error on my J5 installation.

When an user submits his/her confirmation token (received on their inbox) on the Confirm Request page, they always get this error notice: "Your information request confirmation failed. There are no information requests for this email addres requiring confirmation".
In other words, they cannot confirm their requests since the token is not recognized.

I just found that if I go to the database table _privacy_requests and I update a request's Status to 1, only then the confirmation token is validated and the requests Actions appear (Export, Download, Delete).

What might be happening?
Should I allow Registered users group access to the "User - Joomla API Token" plugin?

Please help me. Thanks.
Carlos

[Per Yngve Berg]

Is there a Default Value on the Database Column?

[crolidge]

Dear Per,
I am not sure.
I just made a dummy Export Data request, and its row in the database table shows nothing in status column. I believe that means "null"?
I attach here an image of my table.

table_image.jpg

As the request status progresses, it acquires different status. In my table, 1 means Invalid and 2 Completed. These complete status were done by me manually because I cannot get it automatic. I need to go into the table and update the status to "1" so that the Action buttons show in the Admin dashboard.
Any hints on what is causing this and how to solve?
Thanks in advance!

[Per Yngve Berg]

You have to look at the Definition og the Column.

[crolidge]

Dear Per,
I went into phphMyAdmin, and checked the table structure.
The status has Type tinyint and Defalt value "0".
Attached goes an image of my table structure.
Should I change something here?
I think that would be odd. Isn't Joomla itself supposed to keep the table structures as required?

Regards,

[ceford]

Your table structure is the same as mine. It seems to work for me. My pending requests have a status of 0.

I looked at the code - the problem arises on line 48 of components/com_privacy/srcController/RequestController.php where $return = $model->confirmRequest($data); is returning an Exception.

Did you get an email when you did your own test? I did and the link to the confirmation page worked. So it all works for me.

I do not know what is wrong!

[crolidge]

Dear Ceford,
Yes I did receive an email after my test and the code is the same as yours.
Now it worked for me and I just found out that I misinterpreted the buttons. I need to click on the requester's email address to progress to "Complete" (status 2). And the reason why I have many Pending/Invalidated requests seems to be because of my extensive usage of test users with fake addresses.
In other words everything seems to be working normally, so I will close this ticket for now.
Thanks guys for your great and quick help!