Hans Dijkema

Results 46 comments of Hans Dijkema
trafficstars

```php 'version' => '5.9.4', ```

I tried again today... ``` [2021-02-02 14:00:13] Espo.INFO: Installation process [60195aec488da45ee]: Start "init" step. [] [] [2021-02-02 14:00:15] Espo.INFO: Installation process [60195aec488da45ee]: End "init" step. [] [] [2021-02-02 14:00:16] Espo.INFO:...

Could this be this problem? > "In MariaDB 10.2 and later, the DYNAMIC row format is the default row format. If your tables were originally created on one of these...

Oke, I'll look into it. First I'll try to make the tables 'dynamic' and see what happens....; currently they're all in 'compact' format. [espocrm-tables-5.9.4.pdf](https://github.com/espocrm/espocrm/files/5917505/espocrm-tables-5.9.4.pdf)

I altered the tables to dynamic ```sql alter table email_account row_format=dynamic; alter table inbound_email row_format=dynamic; ``` And now following result: ``` Current version is 5.9.4. EspoCRM will be upgraded to...

And upgrading to 6.1.2 also went oke ``` www-data@gilgad:~/homcrm$ php command.php upgrade Current version is 6.0.10. EspoCRM will be upgraded to version 6.1.2 now. Enter [Y] to continue. Y Downloading......

I tested 6.1.2, now it works fine. I'd advice to create an update script to change the tables from 'compact' to the 'dynamic' format, which is default from mariadb 10.2...

> I'm not sure that upgrade has something to do with this. It might by a coincidence. Could it be due to the fact that I installed espocrm on an...

> I'm using MariaDB as well (v10.3.24), can you share a how-to to change the table @hdijkema ? Would like to try to see if it resolve my slow search/index...

Could it be made available as a 'readonly view'?