Upon attempt to enable notification for user 1 I get this error:

PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined: SELECT u.uid, u.name, u.mail, n.status, n.node, n.teasers, n.comment FROM {users} u LEFT JOIN {notify} n ON u.uid = n.uid WHERE u.uid = :u.uid AND u.status = :u.status; Array ( [:u.uid] => 1 [:u.status] => 1 ) in notify_user_settings_form() (line 307 of /home/leadinc/public_html/drupal7/sites/all/modules/notify/notify.module).
Error
The website encountered an unexpected error. Please try again later.

Comments

coveryoureyes’s picture

coveryoureyes commented

I got the same error after installation and defining basic settings:

PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined: SELECT u.uid, u.name, u.mail, n.* FROM {users} u LEFT JOIN {notify} n ON u.uid = n.uid WHERE n.status = :n.status AND u.status = :u.status ORDER BY u.name; Array ( [:n.status] => 1 [:u.status] => 1 ) в функции notify_admin_users() (строка 398 в файле /home1/drevolif/public_html/fundinfo/sites/all/modules/notify/notify.module).

extrarumeno’s picture

extrarumeno commented

Subscribe

fildair’s picture

fildair commented

Same here, also having a Fatal error when cron is executed.

PDOException : SQLSTATE[HY093]: Invalid parameter number: parameter was not defined: SELECT u.uid, u.name, u.mail, n.status, n.node, n.teasers, n.comment FROM {users} u LEFT JOIN {notify} n ON u.uid = n.uid WHERE u.uid = :u.uid AND u.status = :u.status; Array ( [:u.uid] => 1 [:u.status] => 1 ) dans notify_user_settings_form() (ligne 307 dans /homez.356/padlam/www/drupal7/modules/notify/notify.module).

henrijs.seso’s picture

henrijs.seso commented
Status: Active » Closed (duplicate)

#1279232: Cannot install Notify