Normal users can't see account details

[jmcalderond]

Hi everyone!!!,

I got something that's been dogging me around for a while and it's that normal
users can't get to see account details, but when I set any normal user as administrator
this issue is not a problem anymore because the account details can be seen by
this user, but the fact is that any normal user can't have an administrator profile!!!

What can I be missing for this issue to be happening??
Am using the 5.0.0a version in a wamp platform.

Got something else to say: There's an error shown when these details can't be seen,
it's sort of an SQL error beacuse I get to see a SQL statement, but when the profile of
the user is changed to administrator, this error disappears and the details are shown.
This SQL error I mention, is refering to one the modules I created.

This is the error message:
Error running count query for Account List: Query Failed SELECT count(*) c FROM tll_vehiculos INNER JOIN team_memberships team_memberships ON tll_vehiculos.team_id = team_memberships.team_id AND team_memberships.user_id = '325cdc92-c6ea-4cae-cad6-46ceb51a8666' AND team_memberships.deleted=0 INNER JOIN tll_vehiculos_accounts ON (tll_vehiculos.id=tll_vehiculos_accounts.tll_vehic ulos_ida AND tll_vehiculos_accounts.accounts_idb= '4de6bedd-eecb-5173-0d74-47a0e5df44e5') where ( tll_vehiculos_accounts.deleted=0 AND tll_vehiculos.deleted=0) AND tll_vehiculos.deleted=0 )::MySQL error 1054:


I hope that my explanation is clear for you guys!!!

Thank you all

Juan Miguel

[pblag]

Hi All!

We have the same issue with new email client i guess that it id security problem but if someone can help it would be great.

When user is not admin than there is no email folders in the email client.

Version 5.0.0b

Please take a look to the screen shoot.

[jmcalderond]

Hello again,

I saw these lines in the file sugarcrm.txt

This is the error I get to see when being a normal user, and here I can't see account details

04/29/08 12:56:11,176 [2532] FATAL SugarCRM - MySQL error 1054:

Now, I haven't realize before that when having admin profile I was also having an error which
is the one that follows, anyway here I do see the account details I can't when being a
normal user, why??, I don't know!!

04/29/08 12:59:49,580 [2532] FATAL SugarCRM - Error fetching relationship from cache users_holidays

Is this some kind of bug??

Juan Miguel

[DragonflyMaster]

Hi Juan Miguel,
have you tried the Repair Roles function inside Admin section?

About pblag's post, I don't know if the issue is the same.

[jmcalderond]

Hi DragonflyMaster,

No, I haven't but I did it after you mention it, I also tried the repair indexes function
but the problem persists.

Does anyone have any other suggestions to help me out with this??

Juan Miguel

[francisco.daza]

Hi DragonflyMaster,

I did what you said, clearing data cache and rebuilding relationships, but nothing!!, the problem is
still there, my normal users still can't see the account details.

Do you have any other suggestions about it??

Regards!!

Juan Miguel

[DragonflyMaster]

Pick one of your user's name and inside Admin->Role Management->Create Role: name the role and assign it the selected user.
Then from the table with all modules in, enable all actions for Accounts and save.
Log in Sugar as the above mentioned user and cross your fingers...

[jmcalderond]

Hey DragonflyMaster,

...Gee man!!!!, I don't believe this!!, nothing of what I've tried or what I've been suggested to do works,
and I'm still stuck there.

Do you think that would be some sort of bug???

Thank you anyway!!

[jmcalderond]

I still want to ask if anyone of you people has had this kind of annoying issue solved???

Thank you all for your suggestions!!!

Juan Miguel

[DragonflyMaster]

I still want to ask if anyone of you people has had this kind of annoying issue solved???

Thank you all for your suggestions!!!

Juan Miguel

Sorry man,
I shot all my bullets on this