After installing the module and creating a new template, i got this message :
user warning: Unknown column 'n.language' in 'where clause' query: SELECT * FROM send_template st WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) ORDER BY name ASC

I found the problem, caused by a call to db_rewrite_sql without telling the $primary_table so the primary table is assumed to be node.
See the patch attached.

--
Samuel

CommentFileSizeAuthor
send_db_rewrite.patch505 bytessamuelsov

Comments

mcdruid’s picture

mcdruid commented

was seeing the same error with i18n installed, and the patch seems to fix it for me - thanks

ricovandevin’s picture

ricovandevin commented

Patch worked fine for me too. Thanks!

Module maintainers please commit patch to the next release.

allie micka’s picture

allie micka
she/her
commented
Status: Needs review » Fixed

Committed. Thanks a lot, samuelsov!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

saiprasad kandavalli’s picture

saiprasad kandavalli commented

Hi guys, i am facing the same problem i saw the patch.

if ($active_only) {
$sql[0] .= " WHERE status = 1";
}
- $sql[0] = db_rewrite_sql($sql[0] . tablesort_sql($sort));
+ $sql[0] = db_rewrite_sql($sql[0] . tablesort_sql($sort), 'send_template');

if ($pager_limit) {
$res = call_user_func_array('pager_query', $sql);

How to insert this????? In which file???