Great module and thanks for sharing it with the Drupal community. Just a quick bug report....I get the following SQL errors when I click on EDIT SUBUSERS link on the parent profile page.

don't have time to follow up with finding what's causing the problem at the moment, so I thought I would flag it up here anyway in case it hasnt been spotted yet.

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 COUNT(DISTINCT u.uid) FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid WHERE u.uid != 0 AND in /modules/user/user.admin.inc on line 145.
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 'ORDER BY u.created DESC LIMIT 0, 50' at line 1 query: SELECT DISTINCT u.uid, u.name, u.status, u.created, u.access FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid WHERE u.uid != 0 AND ORDER BY u.created DESC LIMIT 0, 50 in /modules/user/user.admin.inc on line 145.

I'm using drupal 6.15.

CommentFileSizeAuthor
#4 subuser_nopatchcore.patch547 bytesziobudda

Comments

Tom Van Schoor’s picture

Tom Van Schoor commented

Same issue.

Subscribing

Anonymous’s picture

Anonymous (not verified) commented

I see the error as well.

Drupal 6.15
Subuser 6.x-1.2

osman’s picture

osman
Location Copenhagen
commented

My configuration is the same:

Drupal 6.15
Subuser 6.x-1.2

And I do not see the error.

Have you applied the patch comes with the module as noted in INSTALL.txt?

ziobudda’s picture

ziobudda commented
StatusFileSize
new subuser_nopatchcore.patch547 bytes

Hi, this error is because you don't have applied the patch to core.

The patch to the core is necessary (i think) if you want to permit at the "creator user" to access admin/user/user page (but there is an issue abuot this feature (IMHO this is not a feature/necessity).

If you don't need this feature (or you want to create a similar page like I will do) add the patch in attachment (2 lines are the real patch, the others lines are the original code commented).

M.

blakehall’s picture

blakehall commented
Version: » 6.x-1.x-dev
Status: Active » Closed (works as designed)

As mentioned above, please read INSTALL.txt and README.txt and apply the patch as required.