I found this error messages when anon user try to access some admin page area:
warning: array_keys() [function.array-keys]: The first argument should be an array in 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 msn_role r INNER JOIN msn_permission p ON p.rid = r.rid WHERE r.rid IN () in user.module on line 502.
I want the error messages disappear. so, i modify user.module on line 501:
from:
if (!isset($perm[$account->uid])) {
to:
if (!isset($perm[$account->uid]) && isset($account->roles)) {
and the error messages will disappear.
Maybe it help others or if anybody have another solution to disappear above error messages, please let me know.
Thanks
Comments
Comment #1
jjmackow CreditAttribution: jjmackow commentedI had this same issue, that is:
"warning: array_keys() [function.array-keys]: The first argument should be an array in user.module on line [512].
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 msn_role r INNER JOIN msn_permission p ON p.rid = r.rid WHERE r.rid IN () in user.module on line [512]."
and the resolution of altering the user.module file did work, but of course, we shouldn't be editing core, so, is this a bug in core or within the module, and if it's in core, can it be fixed there?
I am using Drupal 6.22 as opposed to the orignal reporter's version.