aC forum: Problem: role_permissions table is missing

Post #4 by Ilija Studen

Ilija Studen — Fri, 06 Jun 2008 11:07:00 CDT

Only reason that I see is that you haven't upgraded other activeCollab files properly but I still need to check to see what exactly is wrong.

Post #3 by igoo

igoo — Fri, 06 Jun 2008 11:05:28 CDT

thanks for the fast response, i have sent the email.

I'm not sure how this was cuased because im using the upgrade folder from the latest 1.1.1 download package so why is it even trying to look for that table if it was dropped?

thanks for the assistance

Post #2 by Ilija Studen

Ilija Studen — Fri, 06 Jun 2008 10:30:27 CDT

role_permissions table is not required for activeCollab 1.1 and later. It's data is moved into roles table and upgrade script drops it as part of the upgrade process. If your activeCollab requires it than you haven't properly upgraded your code. Please send us your FTP parameters to support@a51dev.com and we'll check your setup.

Post #1 by igoo

igoo — Fri, 06 Jun 2008 10:07:16 CDT

I have been following the various beta upgrades and am now up to speed on version 1.1.1 the only problem is that for the last couple of upgrades i get an error which says that the acx_role_permissions table is missing.

Although the upgrade seems to work okay i am sure that the absense of this table will be causing unforseen problems (some of my older task lists are now missing from within projects for one)

Somewhere along the line i think i must have missed an upgrade to the database structure which included the creation of this table

can anyone send my an sql dump of their role_permissions table so i can try and fit it into my database.

thanks very much for anyone who can help.