Topic: Verification 5 query button not working
Hi,
I asked about this before but got no replies. I think it should be something simple.
The 'Send to expert' button works correctly and sends an email. The 'Query' button doesn't.
Chrome developer tools tells me:
cUrl POST request failed. Please check cUrl is installed on the server and the $base_url setting is correct.
URL:http://www.zzz/index.php/services/report/requestReport?report=library/users/user_notification_response_likely.xml
Server response
{"error":"There was an SQL error: ERROR: relation \"user_email_notification_settings\" does not exist\nLINE 10: from user_email_notification_settings \n ^ - \n select case acknowledged when true then 'acknowledged' else 'unacknowledged' end as key, count(*)::varchar as value\n from notifications \n where user_id=300\n and triggered_on>now() - '1 year'::interval\n and source_type in ('C', 'V')\n group by acknowledged\n union\n select 'email_frequency', notification_frequency \n from user_email_notification_settings \n where user_id=300\n and notification_source_type='C'\n ","code":44,"file":"\/var\/www\/zzz\/indicia_warehouse\/system\/libraries\/drivers\/Database\/Pgsql.php","line":342,"trace":[]}
unknown"
and the log file has this:
Missing i18n entry general_errors.There was an SQL error: ERROR: relation "user_email_notification_settings" does not exist
LINE 10: from user_email_notification_settings
^ -
select case acknowledged when true then 'acknowledged' else 'unacknowledged' end as key, count(*)::varchar as value
from notifications
where user_id=300
and triggered_on>now() - '1 year'::interval
and source_type in ('C', 'V')
group by acknowledged
union
select 'email_frequency', notification_frequency
from user_email_notification_settings
where user_id=300
and notification_source_type='C'
for language en_GB
According to a php.info file cURL support is enabled; cURL Information 7.64.0.
$base_url is set in the Drupal settings.php file.
I have a table called notifications but I don't seem to have a table user_email_notification_settings. Is that what the problem is?
Thanks.