When trying to add canned text field to comments fields on admin/structure/types/manage/article/comment/fields it gives:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1: SELECT name, label FROM {canned_texts} WHERE name IN (); Array ( ) in canned_texts_options_list() (line 150 of /home/username/sites/all/modules/canned_texts/canned_texts.module).

Comments

nickonom created an issue. See original summary.

nickonom’s picture

nickonom commented

In fact, it doesn't matter if it's comment or node template as I tried to add canned text to nodes and got the same error.

nickonom’s picture

nickonom commented
Status: Active » Closed (duplicate)

I've just found another report for this #1943678: SQL error if no field values selected, so let's concentrate on one issue.