DB Error

📦 Install & Upgrade Help
1

Hi.

I were adding a field in users and receive this messajes. And now SuitCRM it’s not functioning.

Help please

Error de base de datos. Por favor, consulte SuiteCRM error .log para más detalles. Fatal error: Uncaught Exception: Error de base de datos. Por favor, consulte SuiteCRM error .log para más detalles. in F:\SuiteCRM\include\utils.php:1774 
Stack trace: 
#0 F:\SuiteCRM\include\database\DBManager.php(353): sugar_die('Error de base d...') 
#1 F:\SuiteCRM\include\database\DBManager.php(328): DBManager->registerError('Retrieving reco...', 'Retrieving reco...', true) 
#2 F:\SuiteCRM\include\database\MysqliManager.php(179): DBManager->checkError('Retrieving reco...', true) 
#3 F:\SuiteCRM\include\database\MysqlManager.php(285): MysqliManager->query('SELECT users.*,...', true, 'Retrieving reco...') 
#4 F:\SuiteCRM\data\SugarBean.php(4527): MysqlManager->limitQuery('SELECT users.*,...', 0, 1, true, 'Retrieving reco...') 
#5 F:\SuiteCRM\include\SugarObjects\templates\person\Person.php(113): SugarBean->retrieve('1', true, true) 
#6 F:\SuiteCRM\modules\Users\User.php(775): Person->retrieve('1', true, true) 
#7 F:\SuiteCRM\modules\Users\authentication\SugarAuthenticate\SugarAuthenticateUser.php(138): User->retrieve('1') 
#8 F: in F:\SuiteCRM\include\utils.php on line 1774
2

  1. What is your version of SuiteCRM? And PHP?

  2. What does your web server log say? It is usually called php_errors.log, it is defined in your php.ini

3

Hi. thanks.

I read my .log and fnd “MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_spanish_ci,IMPLICIT) for operation ‘=’”

When I create this field (suite creates table users.cstm but in a different collation utf8_general_ci and utf8_spanish_ci

I fixed it in MySql and works again.

Thanks again.

4

Hi

I have the following error

Sat Aug 10 12:57:22 2019 [4290][1][FATAL] Mysqli_query failed.
Sat Aug 10 12:57:22 2019 [4290][1][FATAL] Retrieving record by id email_templates:acb5e50b-21fb-655d-93f7-5d03cb5cd015 found Query Failed: SELECT email_templates.,email_templates_cstm. FROM email_templates LEFT JOIN email_templates_cstm ON email_templates.id = email_templates_cstm.id_c WHERE email_templates.id = ‘acb5e50b-21fb-655d-93f7-5d03cb5cd015’ AND email_templates.deleted=0 LIMIT 0,1: MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_spanish_ci,IMPLICIT) for operation ‘=’

Could you please help me.

5

seems you need to check your collation, may be reset collation for table help you.
Use PHPMyAdmin or any tool to make it work.