DOLIBARR ENVIRONMENT
- Version: 10.0.2 (upgrade from previous version, fresh installation of 10.0.2 has no such problem)
- Operating System: CentOS 7
- Web Server: Apache/2.4.6 (CentOS)
- PHP: PHP 7.2.23
- Database: 10.4.8-MariaDB
- URL(s): /accountancy/admin/productaccount.php
Error message :
Dolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to ‘1’ to remove such notices):
Date: 20190929185349
Dolibarr: 10.0.2
Level of features: 0
PHP: 7.2.23
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips SVN/1.7.14 mod_perl/2.0.10 Perl/v5.16.3
OS: Linux www 3.10.0-514.2.2.el7.x86_64 #1 SMP Tue Dec 6 23:06:41 UTC 2016 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36
Requested URL: /accountancy/admin/productaccount.php
Modules/Applications: syslog, user, api, gravatar, ftp, geoipmaxmind, skype, externalrss, paypal, accounting, clicktodial, agenda, notification, barcode, oauth, cron, commande, don, ecm, facture, fournisseur, holiday, opensurvey, paybox, printing, salaries, societe, service, webservices, expensereport, contrat, ficheinter, supplier_proposal, incoterm, tax, loan, prelevement, margin, propal, productbatch, stock, expedition, projet, fckeditor, multicurrency, resource, categorie, mailing, bookmark, workflow, import, export, cashdesk, banque, product, mailmanspip, adherent, ldap
Database type manager: mysqli
Latest database access request error: SELECT p.rowid, p.ref, p.label, p.description, p.tosell, p.tobuy, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.tms, p.fk_product_type as product_type, aa.rowid as aaid FROM llx_product as p LEFT JOIN llx_accounting_account as aa ON p.accountancy_code_sell = aa.account_number AND aa.fk_pcg_version = ‘SG-BASE’ WHERE p.entity IN (1) AND aa.account_number IS NULL ORDER BY p.ref ASC LIMIT 26
Return code for latest database access request error: DB_ERROR_1267
Information for latest database access request error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
