PDOException: SQLSTATE[IMSSP]: Tried to bind parameter number -1. SQL Server supports a maximum of 2100 parameters.: SELECT r.rid, r.pid, r.name, r.crumb_action, r.crumb_action_arguments, rag.destination as goto_destination, ral.restore_original as leave_restore, ras.handler as switch_handler, ras.arguments as switch_arguments, CASE COALESCE(r.pid, 0) WHEN 0 THEN CASE r.name WHEN 'start' THEN 0 ELSE 1 END ELSE 1 END AS start_order FROM {hansel_rule} r LEFT JOIN {hansel_rule_action_goto} rag ON rag.rid = r.rid LEFT JOIN {hansel_rule_action_leave} ral ON ral.rid = r.rid LEFT JOIN {hansel_rule_action_switch} ras ON ras.rid = r.rid ORDER BY start_order ASC, r.name ASC; Array ( [:pid] => -1 ) in _hansel_get_rules() (line 154 of D:\[...]\sites\all\modules\contrib\hansel\hansel.module).
Comments
Comment #0.0
d.novikov commentedremoved project name from the message
Comment #1
abiyub commentedi am having the similar issue can anybody look into this please.
Comment #2
damienmckennaThis isn't the only module with this query problem: #1418064: Full list of authors or keywords throws SQL Server error
I suggest reviewing the query and seeing if it can be rewritten.