mySQL errors. Does this module require 4.1?
Andrupal - June 18, 2006 - 02:27
| Project: | Cpanel Integration |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I am running mySQL 4.0.25-standard with cPanel build 10.8.2-RELEASE 83
When I add a new user with the module enabled, I get the following errors:
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 /home/schoo14/public_html/beta/includes/database.mysql.inc on line 120.
implode(): Bad arguments. in /home/schoo14/public_html/beta/modules/user.module on line 349.
array_keys(): The first argument should be an array in /home/schoo14/public_html/beta/modules/user.module on line 349.

#1
I actually had my site moved to a server with 4.1, in part, with the hope it would solve this issue.
I'm still getting the above error when new users are added with cpanel module enabled.
I'm also getting an "error creating cpanel email account" in the watchdog when I modify a user's profile to create an email account.
Is this a bug or a configuration issue or both wrapped into one?
#2
I am getting the same error, this was all a clean install, using X theme, etc etc, everything appears like it should work. Any suggestions would be appreciated
warning: array_keys(): The first argument should be an array in /home/fallofch/public_html/modules/user.module on line 349.
warning: implode(): Bad arguments. in /home/fallofch/public_html/modules/user.module on line 349.
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 /home/fallofch/public_html/includes/database.mysql.inc on line 120.