I have had issues with all created roles showing up on the list.. as discussed on: http://drupal.org/node/490412

I took the advice to try the Dev version and have now been presented with this warning message

user warning: Table 'mydatabase.autoassignrole_page' doesn't exist query: SELECT rid, path, display, title, weight FROM autoassignrole_page in /home/me/domains/mydomain.co.uk/public_html/sites/all/modules/autoassignrole/autoassignrole.module on line 31.

I tried removing the module and emptying the database then reinstalling the Dev version and I am still faced with the same errors.

Comments

cyberswat’s picture

cyberswat commented
Title: user warning: Table 'mydatabase.autoassignrole_page' doesn't exist query: SELECT rid, path, display, title, weight FROM... » autoassignrole_page Table not created on install
cyberswat’s picture

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

I've verified both AAR tables are dropped and created when using the dev version by performing a complete uninstall via the admin interface (q=admin/build/modules/uninstall) and then re-installing the module.

ck9’s picture

ck9 commented

Also had this problem, and can confirm that the error is fixed by disabling the module, uninstalling, then reinstalling.

cyberswat’s picture

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

Status: Fixed » Closed (fixed)

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

junro’s picture

junro commented

Hello, I've got the same problem, try the dev version because of #490412: All created roles show in the registration page.

I had like all of you:
user warning: Table 'mydatabase.autoassignrole_page' doesn't exist query: SELECT rid, path, display, title, weight FROM autoassignrole_page in /home/me/domains/mydomain.co.uk/public_html/sites/all/modules/autoassignrole/autoassignrole.module on line 31.

and I read on the module page:
If your following along with the beta releases it is going to be best for you to completely uninstall before installing the latest version as I am not writing updates between beta releases.

So no upgrade path... well ok.

So, I need to uninstall and reinstall the module... ok

My question is, what about the table? about my configuration? I've got so many roles already created...

Does uninstall the module erase the all in the database too?? and will need to all recreated my roles?

Thanks :)

coloryan’s picture

coloryan commented

It dumped my auto assign features, but they're easy enough to reset. If you're extremely concerned about uninstalling it, here's the table that I exported the table from the database:

--
-- Table structure for table `autoassignrole_page`
--

CREATE TABLE IF NOT EXISTS `autoassignrole_page` (
`rid` int(11) NOT NULL,
`display` text NOT NULL,
`path` varchar(255) NOT NULL,
`menu` varchar(255) NOT NULL,
`title` text NOT NULL,
`description` longtext,
`format` tinyint(4) default NULL,
`weight` tinyint(4) default '0',
PRIMARY KEY (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `autoassignrole_page`
--