Loading

[SOLVED] no admin access at all

Get help with problems, or report & discuss bugs in Collabtive

[SOLVED] no admin access at all

Postby tws4mobile » 31.05.2016, 18:41

As the admin for our team, I logged in and changed one of the team members role to Admin as we will both be administering projects now. However, when I logged out, my own admin access is gone. When I tried to login as the team member I assigned, she has no Admin access either. Now nobody has Admin access and none of us can administer anything. How do we restore Admin access for someone?
tws4mobile
 
Posts: 2
Joined: 31.05.2016, 18:37

Re: no admin access at all

Postby tws4mobile » 02.06.2016, 20:49

We went in and tried the solution offered in this post but it did not fix the problem.

viewtopic.php?f=11&t=17291

The backup we restored was from prior to having this issue but we still have no admins.

We are very anxious to get a resolution for this as we need to manage our projects!

Thanks
Cynthia
tws4mobile
 
Posts: 2
Joined: 31.05.2016, 18:37

Re: no admin access at all

Postby Eva » 14.06.2016, 23:09

Hi Cynthia,

I just sent you a mail, hope you'll receive it.
We will look into this issue for you.
Project Management the way you like it: Collaborative - Open Source - Free

facebook.com/Collabtive
twitter.com/Collabtive
xing.com/companies/collabtive
linkedin.com/company/collabtive
User avatar
Eva
 
Posts: 1471
Joined: 01.01.2008, 23:31
Location: Saarbrücken, Germany

Re: no admin access at all

Postby Pamal » 14.11.2016, 12:30

Hi Eva,

I am also facing the same problem as Cynthia. All admin users are now normal users. Cannot perform any activity on any of the projects. Can you please let me know how to get admin rights back?

Thanks!
Pamal.
Pamal
 
Posts: 5
Joined: 14.11.2016, 12:27

Re: no admin access at all

Postby Pamal » 16.11.2016, 11:07

Can someone please help me urgently as I need to get this up and running ASAP.

Thanks in advance!
Pamal.
Pamal
 
Posts: 5
Joined: 14.11.2016, 12:27

Re: no admin access at all

Postby Eva » 28.11.2016, 18:07

We have finally found the bug's cause and fixed it:
https://github.com/philippK-de/Collabti ... 95644dc84c

If you have already encountered this problem, you will additionally need to correct the user roles directly in the MySQL database.
For those of you who don't know these technicalities, feel free to ask for support via mail to collabtive@o-dyn.de
We will fix this for you!

Sorry for the invoncenience. :oops:
Project Management the way you like it: Collaborative - Open Source - Free

facebook.com/Collabtive
twitter.com/Collabtive
xing.com/companies/collabtive
linkedin.com/company/collabtive
User avatar
Eva
 
Posts: 1471
Joined: 01.01.2008, 23:31
Location: Saarbrücken, Germany

Re: no admin access at all

Postby Pamal » 29.11.2016, 01:07

Hi Eva,

Thanks for the fix!

May I please know how to download the version with latest fixes that solves admin rights problem? The latest version I see on Collabtive download page is version 3.0 released in October 10, 2016.

Regards,
Pamal.
Pamal
 
Posts: 5
Joined: 14.11.2016, 12:27

Re: no admin access at all

Postby Eva » 30.11.2016, 16:12

We didn't release a new version for this bugfix. A release requires a lot more work than just a bugfix, so this will still take a while.
But you can get the bug fixed by changing this file:

./include/class.roles.php

These are the requires changes, starting in line 141:

- $insStmt = $conn->prepare("UPDATE roles_assigned SET user = ? WHERE role = ?");
+ $insStmt = $conn->prepare("UPDATE roles_assigned SET role = ? WHERE user = ?");
+ $ins = $insStmt->execute(array($role, $user));
} else {
$insStmt = $conn->prepare("INSERT INTO roles_assigned (user,role) VALUES (?,?)");
+ $ins = $insStmt->execute(array($user, $role));
}
- $ins = $insStmt->execute(array($user, $role));

Or just replace the file on your server with the newer version you can download here:

https://raw.githubusercontent.com/phili ... .roles.php


Please let us know, if you encounter any difficulties.
Project Management the way you like it: Collaborative - Open Source - Free

facebook.com/Collabtive
twitter.com/Collabtive
xing.com/companies/collabtive
linkedin.com/company/collabtive
User avatar
Eva
 
Posts: 1471
Joined: 01.01.2008, 23:31
Location: Saarbrücken, Germany

Re: no admin access at all

Postby Pamal » 06.12.2016, 09:36

Thanks for that!

It looks like the problem is solved now.

Thanks again!
Pamal.
Pamal
 
Posts: 5
Joined: 14.11.2016, 12:27

Re: [SOLVED] no admin access at all

Postby Pamal » 07.12.2016, 12:12

Hi Eva,

I've replaced the class.roles.php file with the new one and was able to login in and out 5-6 times without a problem. But when I tried to login today, my credentials are not working. I created 3 admin users and all three users have the same problem. Password reset via email doesn't work either.

Can you please check and let me know what can be done?

Regards,
Pamal.
Pamal
 
Posts: 5
Joined: 14.11.2016, 12:27

Next

Return to Problems and Bugs

Who is online

Users browsing this forum: No registered users