Error 500: Error while rebuilding database. See log file for details.

[Dimitry]

HI all,

Recently i have upgraded to 5.3.0 version , all seems to work fine, but when trying to create a new field on a custom entity i get this :


" Error 500: Error while rebuilding database. See log file for details. "

What the log contain is :


[2018-07-11 05:28:42] Espo.ERROR: API [POST]:/Admin/fieldManager/:scope, Params:Array ( [scope] => Camp ) , InputData: {"type":"bool","dynamicLogicVisible":null,"dynamic LogicReadOnly":null,"name":"test","label":"Test"," tooltipText":"","default":false,"audited":false,"r eadOnly":false,"tooltip":false} - Error while rebuilding database. See log file for details. [] []
[2018-07-11 05:28:42] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /api/v1/Admin/fieldManager/Camp [] []


Can somebody tell me what's wrong ?
Thanks.

[tanya]

Hello,
could you attach the entityDefd (custom/Espo/Custom/Resources/metadata/entityDefs/Camp.json)?
And if it's possible, attach the structure of database table 'camp'

[Dimitry]

Hi Tanya,

Please find attached files.
unfortunately i don't have the phpmyadmin on the server,so i have attached a screencap. of the entity's fields.
It doesn't have any custom relationships.
Type of the entity : Base Plus.
This entity was created yesterday on version 5.2.0 , today after upgrade i can't create any fields ..
Thank you

[tanya]

Can't reproduce....
What is the result, when you Rebuild the crm in Administration?

[tanya]

And what is your MqSQL version?

[Dimitry]

When i try to rebuild the backed from the administration panel, it says :

Error 500: Error while rebuilding database. See log file for details.

Database : MariaDB 10.2.15

[tanya]

could your check espocrm log and server error log, please.
One of the possible reason could be added feature - Full-Text Search
Administration » Entity Manager > Email > Edit > uncheck the box Full-Text Search > Save. After try to rebuild the crm.
If result is Success, try to upgrade to the newest version

[Dimitry]

Problem Solved the way you said !

Thank you beautiful Tanya
I owe u