Since I installed Drupal 5.6 and after the update to 5.7,
when a new user registers, the following error message appears...

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 /*/*/public_html/nil/includes/database.mysql.inc on line 172

I checked the issues, but could not find one with the "FROM role r"

Due I'm a beginner, I would be very happy to get some help on this matter, so that I can learn how to solve it...

Thanks in advance...

Manfred

Comments

dragongold’s picture

dragongold commented

Just find out that there are 4 errors connected with the user module...

just to turn off the error messages on the screen does not realy suddisfy me...

my error messages all from Location: http://www.to-be-sharing.org/nil/en/user/register

Message

array_keys() [function.array-keys]: The first argument should be an array in /*/*/public_html/nil/modules/user/user.module on line 378.

Message

array_fill() [function.array-fill]: Number of elements must be positive in /*/*/public_html/nil/modules/user/user.module on line 379.

Message

implode() [function.implode]: Bad arguments. in /*/*/public_html/nil/modules/user/user.module on line 379.

Message

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 /*/*/public_html/nil/includes/database.mysql.inc on line 172.

Hopefully someone can help me with this...

Manfred

dragongold’s picture

dragongold commented
Component: user system » user.module

I guess I adressed it wrong, so I change the post to user.module

hannesh’s picture

hannesh commented

A similar problem here, only it apperas on admin/content/comment/settings page and i can leave comments on nods.
Help needed!

I disabled all extra modules, still no change. Tried some suggestions with user.module after forum search, no help. Does not seem to work for me: http://drupal.org/node/165642
Any clue?

Migrated from Joomla with this script http://drupal.org/node/207258

ainigma32’s picture

ainigma32 commented
Status: Active » Postponed (maintainer needs more info)

Looks like dragongold's issue was solved in 5.8

@hannesh Can you confirm this issue is still current (using 5.12) ?

- Arie

hannesh’s picture

hannesh commented

i'm using 6.x now.

ainigma32’s picture

ainigma32 commented
Status: Postponed (maintainer needs more info) » Fixed

Ok, I'll set this to fixed then.

- Arie

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.