You should make the "Types" checkboxes field required as if the user does not select any type, it will result in a SQL error later (in autocomplete field for example)

ReponseTexte: PDOException : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (LOWER(n.title) LIKE LOWER('%t%')) AND (n.language IN  ('fr', 'und')) 
LI' at line 1: SELECT n.nid AS nid, n.title AS title
FROM 
{node} n
WHERE  (n.type IN  ()) AND (LOWER(n.title) LIKE LOWER(:string)) AND (n.language IN  (:db_condition_placeholder_0, :db_condition_placeholder_1)) 
LIMIT 10 OFFSET 0; Array
(
[:string] => %t%
[:db_condition_placeholder_0] => fr
[:db_condition_placeholder_1] => und
)
in nodequeue_api_autocomplete() (line 1788 in /sites/all/modules/nodequeue/nodequeue.module).

Comments

amateescu’s picture

Status: Active » Fixed
StatusFileSize
new697 bytes

Yeah, I wanted to fix this for a long time. We should allow the user insert nodes from every content type if he didn't specify one.

Fixed in 7.x-2.x with the attached patch.

http://drupalcode.org/project/nodequeue.git/commit/2a8be38

Status: Fixed » Closed (fixed)

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