I have just installed this module and after un taring it and enabling through the site builder I get this error;

user warning: Table 'xxxxxxxxxxx.og_default_roles' doesn't exist query: SELECT nid,rid,`revoke` FROM og_default_roles in /var/www/libdrupal-5.7/includes/database.mysqli.inc on line 151.

I'm guessing this is because the install is not setting up the table correctly, hope you can help because this is the perfect module for what I want to do with group based forums.

Comments

tarluk’s picture

Ok now that I'm looking at this when I have slept, you can work round really easily by hand creating the table using phpmyadmin (or equivalent) so I now have the module working, I'm just guessing there is a small bug in the og_defualut_roles.install. hope that helps

tarluk’s picture

A copy of my og_defualt_roles.install

/**
 * @file OG Default Roles install file
 */

/**
 * Implementation of hook_install()
 */
function og_default_roles_install() {
  db_query("
    CREATE TABLE {og_default_roles} (
      nid int(11) unsigned not null,
      rid int(11) unsigned not null,
      revoke tinyint(1) not null default 0,
      PRIMARY KEY (nid,rid)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
  );
}

/**
 * Implementation of hook_uninstall()
 */
function og_default_roles_uninstall() {
  db_query("DROP TABLE IF EXISTS {og_default_roles}");
}
Josh Benner’s picture

Assigned: Unassigned » Josh Benner
Priority: Normal » Critical
Status: Active » Fixed

install was failing on some mysql installs but should be fixed in 1.1

Anonymous’s picture

Status: Fixed » Closed (fixed)

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