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
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

cyberswat - June 19, 2009 - 14:23
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

#2

cyberswat - June 19, 2009 - 14:31
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.

#3

ck9 - June 24, 2009 - 04:20

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

#4

cyberswat - June 24, 2009 - 10:28
Status:postponed (maintainer needs more info)» fixed

#5

System Message - July 8, 2009 - 10:30
Status:fixed» closed

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

#6

Junro - July 22, 2009 - 23:06

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

coloryan - August 20, 2009 - 12:58

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`
--

 
 

Drupal is a registered trademark of Dries Buytaert.