The Send API page (/admin/settings/send) contains the following error:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT * FROM send_template LEFT JOIN support_ticket st ON n.nid = st.nid WHERE ( st.client IN (29,15,28,5,30,10,16,18,25,31,22,26,8,7,23,19,1,12,3,14,4,24,2,11,9,32,20,6,27,17,13) OR st.client IS NULL) AND ( status = 1) in on line .

warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /var/home/sites/site.com/www/mysite/includes/database.mysql.inc on line 321.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /var/home/sites/site.com/www/mysite/includes/database.mysql.inc on line 321.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /var/home/sites/site.com/www/mysite/includes/database.mysql.inc on line 321.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /var/home/sites/site.com/www/mysite/includes/database.mysql.inc on line 321.
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /var/home/sites/site.com/www/mysite/includes/database.mysql.inc on line 321.

Comments

Sean-Khan’s picture

Sean-Khan commented

I got similar error, although the first error was different:

* user warning: Unknown column 'n.language' in 'where clause' query: SELECT DISTINCT * FROM mysite_send_template WHERE (n.language ='fi' OR n.language ='' OR n.language IS NULL) AND ( status = 1) in on line .

I'm using a multilingual site.

allie micka’s picture

allie micka
she/her
commented
Status: Active » Closed (duplicate)

This is one of two things:

* A duplicate of #642946 - in which case you should follow up there.
* A conflict with another module. Send doesn't yet support or acknowledge any "language" settings, so yeah, that won't work. Additionally, the "support_ticket" table is not included or referenced from Send, so you should try and take this up with another module if it's referencing these tables.

Thanks!