search

atrocore / atrocore

AtroCore is an open-source Data Platform, Data Management and Master Data Management (MDM) software, which can be used to quickly create any business application.
https://atrocore.com
GNU General Public License v3.0
118 stars 38 forks source link

Error from Rebuild database #845

Open 69zainka69 opened 1 year ago

69zainka69 commented 1 year ago

Error from Rebuild database. In data/logs/*.log I see:" [2023-09-14T07:27:13.150359+00:00] Log.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'sku' cannot be part of FULLTEXT index in /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72 [2023-09-14T07:27:15.863870+00:00] Log.ERROR: API [POST]:/api/v1/Admin/fieldManager/:scope, Params:Array ( [scope] => ProductAsset ) , InputData: {"type":"bool","dynamicLogicVisible":null,"dynamicLogicReadOnly":null,"name":"isMainImageProte","label":"IsMainImageProte","labelRuRu":"IsMainImageProte","tooltipText":null,"tooltipLink":null,"isMultilang":false,"default":false,"audited":false,"readOnly":false,"tooltip":false} - Error while rebuilding database. See log file for details. [] []

What i can do?

AnnZast commented 1 year ago

Hello. Is this error still valid?

rdzouk commented 4 months ago

The problem is that all columns of a FULLTEXT index must have the same collation. You have to check all fulltext column on the product table in your database. Upgrading the system to the last version of pim will also solve this issue.