autoassignrole_page Table not created on install
jamesmcd - June 19, 2009 - 12:53
| Project: | Auto Assign Role |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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.

#1
#2
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.
#3
Also had this problem, and can confirm that the error is fixed by disabling the module, uninstalling, then reinstalling.
#4
#5
Automatically closed -- issue fixed for 2 weeks with no activity.
#6
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 :)
#7
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`
--