Can't login to GUI of SuiteCRM 7.7 after adding custom field to Users module in Studio

💬 General Discussion
10

I fixed the problem :slight_smile:

When I added custom field to Users module table users_cstm change Collation to “utf8_polish_ci” whereas users table has collection of “utf8_general_ci”.
And some of php scripts issues:
SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1
what makes an error i mysql:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_polish_ci,IMPLICIT) for operation ‘=’

Thats why I couldn’t loged in.

mysql> show full columns from users;
+---------------------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field                     | Type         | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |
+---------------------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| id                        | char(36)     | utf8_general_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| user_name                 | varchar(60)  | utf8_general_ci | YES  | MUL | NULL    |       | select,insert,update,references |         |
| user_hash                 | varchar(255) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
| system_generated_password | tinyint(1)   | NULL            | YES  |     | NULL    |       | select,insert,update,references |         |
| pwd_last_changed          | datetime     | NULL            | YES  |     | NULL    |       | select,insert,update,references |         |


mysql> show full columns from users_cstm;
+-----------------+---------------+----------------+------+-----+---------+-------+---------------------------------+---------+
| Field           | Type          | Collation      | Null | Key | Default | Extra | Privileges                      | Comment |
+-----------------+---------------+----------------+------+-----+---------+-------+---------------------------------+---------+
| id_c            | char(36)      | utf8_polish_ci | NO   | PRI | NULL    |       | select,insert,update,references |         |
| test_c         | char(36)      | utf8_polish_ci| YES  |     | NULL    |       | select,insert,update,references |         |
+-----------------+---------------+----------------+------+-----+---------+-------+---------------------------------+---------+

After changeig:

ALTER TABLE users_cstm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

I can log in to CRM :slight_smile:

Probably the same problem was with unavailable quotas after adding custom field to Product Line module… Probably encofing also changed to utf8_polish_ci.

1 Like