Posted by tarluk on February 13, 2008 at 1:10pm
Jump to:
| Project: | OG Default Roles |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Josh Benner |
| Status: | closed (fixed) |
Issue Summary
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
#1
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
#2
A copy of my og_defualt_roles.install
<?php
/**
* @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}");
}
?>
#3
install was failing on some mysql installs but should be fixed in 1.1
#4
Automatically closed -- issue fixed for two weeks with no activity.