if the _role table has a "shared" prefix, as set in the settings.php of the site, the module will not function properly and will give an error message to the effect that the defaultsiteprefix_role.columnname cannot be accessed: this is because the module is looking for a _role table column with the default table prefix for the site.
THIS PATCH DOES THE FOLLOWING:
alters on 6 lines the sql query syntax such that it is prefixed correctly on a multi-site installation.

CommentFileSizeAuthor
join_role_multi-site_patch_file.patch.zip961 bytesspiritkarma

Comments

francoud’s picture

francoud commented

As fas as I know, the module, and version 6.1.6, already works in a "prefixed" database:

http://drupal.org/node/758924

Do you really STILL have problems with 6.1.6 version??

spiritkarma’s picture

spiritkarma commented

Yes. The only version we have ever used is 6.x-1.6. And there are those several places that seem to be responsible for this error. I see now that node that you fixed some of them, but I have a 3-site multi, and these errors come up on all sites. Also, it's a near production site, so things are working pretty smoothly-- so I don't think it's a misconfigured multi-site. (We are not using a vhosts file at the moment, but I don't see why that would affect this.)
Cheers.

BenK’s picture

BenK commented

Subscribing

francoud’s picture

francoud commented
Assigned: Unassigned » francoud

I'll do my best to apply the proper correction to version 6 in the next days.

Version 7 should work fine in a prefixed db.

francoud’s picture

francoud commented
Status: Needs review » Fixed

You should now find a fixed version in 6.x-1.x-dev. If i'll receive good feedbacks, i'll promote it to a new stable version.

Status: Fixed » Closed (fixed)

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

francoud’s picture

francoud commented

6.x-1.7 and 7.x-1.0 should fix the problem.