After installing and enabling comment notify module, when I try to configure the settings I get the following error:

warning: array_fill(): Number of elements must be positive in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: implode(): Invalid arguments passed in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: array_keys(): The first argument should be an array in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.
user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.

If I try to save the settings, I get the following error:

in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: implode(): Invalid arguments passed in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: array_keys(): The first argument should be an array in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.
user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.
warning: array_fill(): Number of elements must be positive in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: implode(): Invalid arguments passed in /home/hsphere/local/home/eapprais/new.dast2dast.org/includes/database.inc on line 241.
warning: array_keys(): The first argument should be an array in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.
user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/user/user.module on line 502.

I have tried uninstalling the module, deleting the folder from the directory and reinstalling... simply doesn't work.

This is on a fresh install site of Drupal 6.8 upgraded to 6.9 at http://www.new.dast2dast.org

Any help would be appreciated greatly :)

Thanks in advance

Comments

desiree’s picture

desiree commented
Status: Active » Closed (fixed)

It looks like this has been fixed in 6.x-1.1-dev.

d------’s picture

d------ commented
Status: Closed (fixed) » Active

Just tried comment_notify-6.x-1.x-dev.tar.gz after uninstalling and deleting the recommended package and still getting errors...

This when the settings page is loaded:

* warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/www/xxx/includes/database.inc on line 253.
* warning: implode() [function.implode]: Invalid arguments passed in /home/www/xxx/includes/database.inc on line 253.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/www/xxx/modules/user/user.module on line 502.
* user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/www/xxx/modules/user/user.module on line 502.

and this when configuration is saved....

* warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/www/xxx/includes/database.inc on line 253.
* warning: implode() [function.implode]: Invalid arguments passed in /home/www/xxx/includes/database.inc on line 253.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/www/xxx/modules/user/user.module on line 502.
* user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/www/xxx/modules/user/user.module on line 502.
* warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/www/xxx/includes/database.inc on line 253.
* warning: implode() [function.implode]: Invalid arguments passed in /home/www/xxx/includes/database.inc on line 253.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/www/xxx/modules/user/user.module on line 502.
* user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/www/xxx/modules/user/user.module on line 502.

I have not yet tested if the module works with these errors... if it cant work this issue may have to be upgraded to critical :)

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Version: 6.x-1.1 » 6.x-1.x-dev

Based on a quick search, this seems to be a problem where the global $user isn't getting any roles assigned to it which causes problems with the core user_access function. Can you look into that?

rastarr’s picture

rastarr commented

Subscribing - getting same errors for this module

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Postponed (maintainer needs more info)

Can anyone describe how I can see this bug? It doesn't seem to appear for everyone.

j0nathan’s picture

j0nathan commented

Maybe related to #777116: Empty $account->roles causes a sql error in user_access

chissy’s picture

chissy commented

I have this error because while I was testing I created users who in turn created content, when I was done testing I deleted the users before deleting the content that they had created. This error came about because content cannot be created by anonymous users.
Try reading this article http://drupal.org/node/351920

HydroZ’s picture

HydroZ commented

Hi to all,

please check this post, for my solution, that is possibly fitting to your situations:

http://drupal.org/node/988216

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

I suggest blocking users instead of deleting them or following the solution that HydroZephalus found (which was adding user 0 back to his users table).