I have been using Suite CRM just for a day so I am not quite familiarized with it yet.
As I have been tasked to add all employees of my company, I am trying to be able to categorize/distinguish between them depending on whether someone is a developer or a tester. I suppose this has nothing to do with Roles and Groups, as from my understanding those are related to security issues and not to simply being able to navigate through my resources.
Simply put, I want to find out if for example, I am able to mark Sally as part of my 4-people team of developers and when she is already assigned to a task, I want to see that i still have 75% of my developers resources available.
If this is helpful, we are using version 7.11.8, Sugar Version 6.5.25 (Build 344)
This can be as simple as using a text field (or a dropdown with a list of possible values) to distinguish them. Then these can be used in filters and reports.
Or you can group users in one of several ways. Maybe this will help:
Thank you for your help!
I started creating a dropdown menu value in order to be able to assign the value Tester or Developer to my users, but after saving my changes the suite crashed and I am not able to log back in.
Is it possible to take a look at the logs?
Let me know if there are other logs you need too!
I removed your attachment since it contained most of your admin’s database password (it was the argument in a function that appeared in the stack trace of one of the errors). I recommend that you change that password now anyway, for safety. Also make sure you scan your logs for sensitive information before publishing them online.
Anyway, I don’t think the problem has anything to do with the dropdown, it has to be because of some database changes. Either the password has changed and needs to be updated in config.php, or that german collation isn’t working.
I think the recommended collation for te SuiteCRM database is always utf8_general_ci, though you can try searching these forums for other posts from international users to make sure.
When you can login, I recommend upgrading to the latest version, it will fix some of the other errors I see in your logs. If you go for 7.11.10 I recommend you download the package that is on the site since today, we made a minor fix there since it was released a few days ago.
Problem is, I really have no idea how to log in again as I always get the same error message (the one I attached). You mentioned something about changed password in the config.php file, to which password are you referring? And how can I check the collation settings? Sorry if the questions sound silly, I recently started working as a Project Manager and no one here can help me as no one has ever used Suitecrm here before.
Could you maybe help me with that??
The password mentioned by PGR is of the database. If you have cPanel access to your Hosting where suitecrm is installed, you can change the password for the DB user and then update that new password in the config.php file where the label says
'db_password' =>
If you check the file, suitecrm.log in the Root folder of crm installation, do you see any FATAL errors? Can you also check the permissions for cache and custom folders?
Where do you mean I have to change the password for the DB user (before changing it in the config.php file)? In the DBManager.php file?
I am attaching screenshots of the access rights, it is in German though. (Vollzugriff= Full access, Lesen,Ausfuhren= Read, execute, Andern=modify. Hope this helps!)
The suitecrm has many FATAL errors and they seem to be related with the access rights of the users.
[FATAL] User update error: Temp User is not retrieved at ID 1, boolean given
Fri Oct 11 13:25:59 2019 [6116][-none-][FATAL] Email address save error
Fri Oct 11 13:26:08 2019 [6116][1][FATAL] User update error: Temp User is not retrieved at ID seed_jim_id, boolean given
Fri Oct 11 13:26:08 2019 [6116][1][FATAL] Email address save error
Fri Oct 11 13:26:09 2019 [6116][1][FATAL] Email address save error
Fri Oct 11 13:30:00 2019 [6116][1][FATAL] log call at: modules/EmailMan/tpls/config.tpl:465 - styleChecked is not set
Fri Oct 11 13:30:21 2019 [6116][1][FATAL] SugarPHPMailer encountered an error: An outgoing mail server is not configured to send emails. Please configure an outgoing mail server or select an outgoing mail server for the mail account that you are using in Settings >> Mail Account.
Fri Oct 11 13:30:21 2019 [6116][1][FATAL] SugarPHPMailer encountered an error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
Fri Oct 11 13:30:21 2019 [6116][1][FATAL] SugarPHPMailer encountered an error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
Fri Oct 11 13:45:40 2019 [6116][1][FATAL] Email address save error
Fri Oct 11 13:46:46 2019 [6116][1][FATAL] Email address save error
Fri Oct 11 13:49:53 2019 [6116][6e7763f6-71c5-6cf7-9473-5da06bb0cf12][FATAL] Email address save error
Thank you for your reply! I can log in (theoretically, right now no one can log in) as an admin as well as a user.
At the login screen I get “Database failure. Please refer to suitecrm.log for details”
And at the logs I get are:
Tue Nov 5 08:37:03 2019 [12512][-none-][FATAL] FAILED LOGIN:attempts[1], ip[172.16.31.210], username[doksa.adm]
and
Tue Nov 26 12:03:38 2019 [13260][-none-][FATAL] Retrieving record WHERE user_name = ‘doksa.admin’ AND deleted=0: Query Failed: SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE user_name = ‘doksa.admin’ AND deleted=0 LIMIT 0,1: MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_german2_ci,IMPLICIT) for operation ‘=’