array_keys(): error in user.module

Posted by Fusion_Sushi on February 10, 2006 at 9:13pm

warning: array_keys(): The first argument should be an array in Drive\Path\modules\user.module on line 339.

warning: implode(): Bad arguments. in Drive\Path\modules\user.module on line 339.

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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in Drive\Path\\includes\database.mysql.inc on line 118.

Comments

I use CVS update from 4.6.5

Posted by lllkkk on February 20, 2006 at 12:30pm

I use CVS update from 4.6.5 .I got the same error in
?q=admin/comment/configure
and

* warning: array_keys(): The first argument should be an array in /var/www/localhost/htdocs/drupal/modules/user.module on line 339.
* warning: implode(): Bad arguments. in /var/www/localhost/htdocs/drupal/modules/user.module on line 339.
* 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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/www/localhost/htdocs/drupal/includes/database.mysql.inc on line 118.
* warning: array_keys(): The first argument should be an array in /var/www/localhost/htdocs/drupal/modules/user.module on line 339.
* warning: implode(): Bad arguments. in /var/www/localhost/htdocs/drupal/modules/user.module on line 339.
* 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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/www/localhost/htdocs/drupal/includes/database.mysql.inc on line 118.

anonymous user still cannot leave a comment ,although I have
setup them can in "?q=admin/access".

-----------------------------------------------------------------------
my drupal site http://www.kylinx.net/

INSERT INTO `users_roles` (

Posted by lllkkk on February 21, 2006 at 4:39am

INSERT INTO `users_roles` ( `uid` , `rid` )
VALUES (
'0', '1'
);
 INSERT INTO `users` ( `uid` , `name` , `pass` , `mail` , `mode` , `sort` , `threshold` , `theme` , `signature` , `created` , `access` , `status` , `timezone` , `language` , `picture` , `init` , `data` , `login` )
VALUES (
'0', '', '', '', '0', '0', '0', '', '', '0', '0', '0', NULL , '', '', '', NULL , '0'
) ;

will be OK! :)

-----------------------------------------------------------------------
my drupal site http://www.kylinx.net/

I have the same problem and

Posted by The Webmaster Centre on February 21, 2006 at 11:11pm

I have the same problem and have tried your suggestion as above but without success. Do you have any other suggestions that I could try?

Regards

Patrick Nelson
UK Nottingham Web Designers: The Webmaster Centre
Follow me on Twitter

Maybe you can check role

Posted by lllkkk on February 25, 2006 at 5:23am

Maybe you can check role table,and make sure you have

rid     name
1       anonymous user

-----------------------------------------------------------------------
my drupal site http://www.kylinx.net/

Thanks lllkkk,

Posted by The Webmaster Centre on February 26, 2006 at 4:54pm

Thanks lllkkk,

But I traced the problem to another module as per this post.

Regards

Patrick Nelson
UK Nottingham Web Designers: The Webmaster Centre
Follow me on Twitter

Yep, it's private messaging that's messing up

Posted by thomherfs on March 1, 2006 at 10:42pm

The private messaging module, when enabled and set to provide a message link in posts, causes this error. The database fix listed above has no effect on it.

Is anyone working on the private messaging module? For a community-oriented website, this is a pretty basic need.

beta5 similar issue - fresh install

Posted by knockingsoul on March 6, 2006 at 9:21pm

I just installed beta5 on a brand new dev server
and I am getting these errors as well.

running drupal 4.7.0 beta 5
PHP 5
MYSQL 5

I am new to drupal community to maybe I just don't know what I am doing. Should I just go ahead and install the stable version instead?

Hubert

Solution

Posted by jdw23 on April 8, 2006 at 2:34am

Go to administer-->access control and set permissions for the private_msg module for at least one user.

hey ya'll; where exactly

Posted by smikey on August 7, 2006 at 9:42pm

hey ya'll; where exactly should i stick this bit of code? thnks...

INSERT INTO `users_roles` ( `uid` , `rid` )
VALUES (
'0', '1'
);
INSERT INTO `users` ( `uid` , `name` , `pass` , `mail` , `mode` , `sort` , `threshold` , `theme` , `signature` , `created` , `access` , `status` , `timezone` , `language` , `picture` , `init` , `data` , `login` )
VALUES (
'0', '', '', '', '0', '0', '0', '', '', '0', '0', '0', NULL , '', '', '', NULL , '0'
) ;