Thread Starter
VP
(@studio500)
Here’s one of the error codes from the new user.
WordPress database error: [Unknown column ‘request_id’ in ‘field list’]
SELECT COUNT(request_id) as requests_made FROM wp_gdpr_requests WHERE email = ‘stu*****@dr.com’ AND request_time > NOW() – INTERVAL 1 DAY
It doesn’t change even when I alter the number of allowed requests.
Thread Starter
VP
(@studio500)
Lastly, I also tried with a temp user i’ve had on my site for a while.
Here’s the result
WordPress database error: [Unknown column ‘request_id’ in ‘field list’]
SELECT COUNT(request_id) as requests_made FROM wp_gdpr_requests WHERE email = ‘stu****@****.com’ AND request_time > NOW() – INTERVAL 1 DAY
WordPress database error: [Unknown column ‘http_user_agent’ in ‘field list’]
INSERT INTO wp_gdpr_requests SET email = ‘stu888889@hotmail.com’, status = ‘0’, http_user_agent = ‘Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/**.0.**59.**1 Safari/***.36’, http_accept_language = ‘en-US,en;q=0.9′, server_addr = ’77.***.***.**’, remote_addr = ‘**.***.***.240’, confirmation_string = ‘JF1C*****5MMAL***VZAO1DCGP3JD’, request_time = ‘2018-05-27 21:51:30’, request_type = ‘1’, timestamp = ‘152***7890’
WordPress database error: [Unknown column ‘request_id’ in ‘where clause’]
UPDATE wp_gdpr_requests SET code = ‘0***922**2300’ WHERE request_id = 0