EspoCRM 5.9.0 released

[yuri]

Enhancements:

• Navbar: Additional 'Show more' delimiter for tabs #1637
• Layouts: Bottom Panels layout instead of Relationships #1654
• Layouts: Ability to hide certain detail view panels under 'show more' #1653
• Layouts: 'Show more' delimiter for bottom and side panels layouts #1629
• Email Templates: Supporting handlebars (expiremental) #1677
• Emails: Creating documents from attachments #1650
• API: Ability to get attachment contents #1676
• Formula: record\findRelatedMany function #1682
• Formula: string\replace function #1679
• Formula: ext\pdf\generate, generating PDF #1675
• Formula: ext\email\applyTemplate, applying email template #1674
• Formula: ext\email\send function, sending email via formula #1672
• Formula: record\relate supporting list if IDs #1665
• Formula: record\create & record\update functions #1664
• Layouts: Different layouts for teams & portals #1627
• Meetings: Scheduler #1655
• Contacts: 'Has Portal User' read-only boolean field #1697
• WebSocket: Refreshing detail view when record is updated #1640
• 2FA: Parameter to force users to set up 2 factor authentication #1634
• 2FA: Field showing whether 2FA is configured for user #1633
• Currency field: 'Only default currency' parameter #1621
• Settings: Email address autocomplete scopes #1683
• Stream: Post preview #1620
• Stream: Ability to paste images from clipboard #1699
• Console: Printing current version #1689
• Console: Installing & uninstalling extensions #1688

Improvements:

• Merge records: Showing read-only fields if their values are different #1685
• Import: Ability to save parameters as default #1671
• Contacts: Supporting autocomplete for account role #1668
• Layout Manager: Confirmation dialog on leaving out if layout is not saved #1663
• Layouts accessible from Entity Manager #1662
• Relationship panels: When select records for one-to-many relationship, only records that are not related to any record are listed #1659
• Emails: Ability to use group email account as a system account #1657
• Emails: Subject displayed in muted color if email is in trash #1646
• Emails: Showing paperclip icon on side panel if there's an attachment #1644
• Showing confirmation dialog on closing or refreshing page if form is not saved #1648
• Configurable default ajax timeout parameter #1645
• Sales Pipeline dashlet: Team filter #1636
• Sales Pipeline dashlet: Funnel chart #1635

Changes:

• Roles: Allowing empty assigned user for API users w/o assignment permission #1691

All issues: https://github.com/espocrm/espocrm/m...ne/88?closed=1

[item]

Thank you Yuri .. wonderfull
just for info ..just after upgrade ..version is old. "rien de grave"

php command.php upgrade

Current version is 5.8.5.

EspoCRM will be upgraded to version 5.9.0 now. Enter [Y] to continue.

Y

Downloading...

Upgrading... This may take a while...

Upgrade is complete. Current version is 5.8.5.

php command.php upgrade

Current version is 5.9.0.

There are no available upgrades. 

[Marcus]

Just upgraded, was a none issue using the command.php upgrade! I can't tell a difference, which is frankly a good thing. Great work!

[telecastg]

Just upgraded and ran into the infamous eternal "loading" message with nothing but the copyright notice displaying....

Error corrected after performing these steps and everything is running smoothly.

1) Upgraded my data\config.php script:
BEFORE

'globalSearchEntityList' => 'Account,Contact,Lead,Opportunity',

AFTER

'globalSearchEntityList' => [
'Account',
'Contact',
'Lead',
Opportunity',
],

2) Did "hard" rebuild from CLI with command "php rebuild.php"

I hadn't modified the data\config.php script for a while, so this syntax might have been changed before and I just didn't notice, but just in case someone else has this issue, the fix is very simple.

Looking forward to exploring and taking advantage of the upgrades, thanks Espo Team !

[telecastg]

Thanks item !, I was not aware of this change, but will update my custom modules and entities. I checked the new source code and found a lot of Espo.define statements in the core crm module. Could you post the link to Github where you saw these changes ?

[item]

Hello @telecstg
i follow "commit", "issue closed" (where ehancement are do by Yuri and Tarasm)..
sample : https://github.com/espocrm/espocrm/c...09f9643fadc08d
all Espo.define => define

it's more easy to understand there.. when new ehancement, you can see all modified/added files

Regards

[telecastg]

Thanks so much, I will check them out.

[esforim]

EDIT: Solutions found. Used CLI and/or Enable PDO in PHP Configurations. See below for "How-to".


Those are some nice set of feature and enhancement. Eager to use but cannot. Getting this error when trying to install through Admin panel if anyone got suggestion how to fix.

[2020-05-16 11:47:02] Espo.WARNING: Cron is not run because it's disabled with 'cronDisabled' param. [] []
[2020-05-16 11:47:15] Espo.INFO: Installation process [5ebfd2a978034e60b]: Start "init" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: End "init" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: Start "copyBefore" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: End "copyBefore" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: Start "beforeInstallScript" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: End "beforeInstallScript" step. [] []
[2020-05-16 11:47:56] Espo.INFO: Installation process [5ebfd2a978034e60b]: Start "copy" step. [] []
[2020-05-16 11:48:01] Espo.WARNING: Cron is not run because it's disabled with 'cronDisabled' param. [] []
[2020-05-16 11:48:15] Espo.INFO: Installation process [5ebfd2a978034e60b]: End "copy" step. [] []
[2020-05-16 11:48:15] Espo.INFO: Installation process [5ebfd2a978034e60b]: Start "rebuild" step. [] []
[2020-05-16 11:48:15] Espo.WARNING: E_WARNING: Error while sending QUERY packet. PID=5058 {"code":2,"message":"Error while sending QUERY packet. PID=5058","file":"/home/crm/application/Espo/Core/DataManager.php","line":209,"context":{"config":"[object] (Espo\\Core\\Utils\\Config: {})","pdo":"[object] (PDO: {})","query":"SHOW VARIABLES LIKE 'ft_min_word_len'","sth":[]}} []
[2020-05-16 11:48:15] Espo.ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. [] []
[2020-05-16 11:48:15] Espo.INFO: Installer: Restore previous files. [] []
[2020-05-16 11:48:50] Espo.ERROR: Database rebuild failure, details: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. [] []
[2020-05-16 11:48:50] Espo.ERROR: (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /api/v1/Admin/action/runUpgrade; line: 170, file: /home/crm/application/Espo/Core/Upgrades/Actions/Base.php [] []
[2020-05-16 11:49:01] Espo.WARNING: Cron is not run because it's disabled with 'cronDisabled' param. [] []

Manage to learn how to use SSH (future incoming tutorials).
But got this error:

Current version is 5.8.5.
EspoCRM will be upgraded to version 5.9.0 now. Enter [Y] to continue.
y
Downloading...
Upgrading... This may take a while...Hangup

The downloading took a while to start. From the logs file it seem that the CLI method working better than the GUI method, it manage to create a couple of table and field. I'm not sure if it because I enable "PDO" in my PHP setting or it because CLI is the method to be successfully, (although it is slower from my experience). In the Error Logs I notice PHP PDO, so I went into My PHP Configuration on my Shared Hosting and enable anything that say PDO.

Anyway after waiting for a good 5 minutes fearing that never ending "This may take a while............" that ...... never seem to stop I manage to get this message:

-bash-4.2$ php command.php upgrade
Current version is 5.8.5.
EspoCRM will be upgraded to version 5.9.0 now. Enter [Y] to continue.
y
Downloading...
Upgrading... This may take a while...............
Upgrade is complete. Current version is 5.9.0.
You have the latest version.

Now I just hope there is no error because I tend to skip the "Backup" step.

[yuri]

Upgrade can take even longer. Usually creating new database indexes takes the most of time.

[esforim]

Going through these update and opening the issue # will explain it quite fairly.One part I don't know how to use is this one.

• Layouts: Bottom Panels layout instead of Relationships #1654 - How to use this one? I can't seem to find where it is. Is it Admin\Layout Sets Default Set Edit Layouts ? But it blank for me. Or is it only name change? Previously it was call Relationship

Also look like EspoCRM update/upgrade the documentation. Looking good but lots of dead link in some of these issue where it link to Documentation: For example:https://github.com/espocrm/espocrm/issues/1675 https://github.com/espocrm/documenta...extpdfgenerate

All documentation is now here: https://docs.espocrm.com/

Opening https://www.espocrm.com/documentation/ will also redirect you to that page.

[yuri]

In Administration > Layouts. Do you have Bottom Panels layout. It should combine relationship panels and stream panel.

[telecastg]

I also like the upgraded documentation, great improvement.

[esforim]

https://forum.espocrm.com/forum/announcements/58363-espocrm-5-9-0-released?p=58427#post58427

I can see bottom Layout in each individual Entity, so it just a name change? But you mention it Combine Relationship and Stream Panel so it also an merge then.

Update: Nevermind, I looked into it. So basically Stream layout got removed and get converted into a drag-able field where you can Display or Hide for each entity.

Cool.

Now that I updated, don't have the previous version to make a comparison to so not quite sure what it previously looked like.

[esforim]

Been getting "Bad Server Response" error lately after the update, not sure if it cause my host is restricted so it causing error or my update has partially failed.

The error is:

Server side error 200: SQLSTATE[HY000] [1226] User 'u_crm' has exceeded the 'max_user_connections' resource (current value: 15)

From the error it look like I need to increase the max_user_connections, which is odd. it is already at 15. I'm the only user online at the moment and using it.

[Bernhard]

Hi, I am running Espo CRM on a Windows server and after the update there was only a white page, saying Espo CRM. The Chrome Console showed many 500 Errors. It looks like the update did overwrite my web.config file. There are Mime Types for JSON and WOFF defined and IIS does not like these. So I removed the two lines and all is working great now. Thanks.

The two lines are:
<!--<mimeMap fileExtension=".json" mimeType="application/json" />

<mimeMap fileExtension=".woff" mimeType="application/font-woff" />-->

[esforim]

Hi, I am running Espo CRM on a Windows server and after the update there was only a white page, saying Espo CRM. The Chrome Console showed many 500 Errors. It looks like the update did overwrite my web.config file. There are Mime Types for JSON and WOFF defined and IIS does not like these. So I removed the two lines and all is working great now. Thanks.

Please share which two lines so other people can use it if they run into same error.

[Bernhard]

These are the two lines I needed to remove / comment:
<mimeMap fileExtension=".json" mimeType="application/json" />
<mimeMap fileExtension=".woff" mimeType="application/font-woff" />

[esforim]

Thank Bernhard.

[esforim]

Thank Bernhard.

[Sab0tajue]

The map window in the entry in the sidebar disappeared. In the developer panel, I have such errors. Such a problem is observed only in the "Counterparties" section. In others, everything works stably.

DevTools failed to load SourceMap: Could not load content for chrome-extension://gighmmpiobklfepjocnamgkkbiglidom/include.preload.js.map: HTTP error: status code 404, net::ERR_UNKNOWN_URL_SCHEME
DevTools failed to load SourceMap: Could not load content for chrome-extension://gighmmpiobklfepjocnamgkkbiglidom/include.postload.js.map: HTTP error: status code 404, net::ERR_UNKNOWN_URL_SCHEME
DevTools failed to load SourceMap: Could not load content for https://#/purify.min.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE

[item]

Hello,

purify.min.js.map and another one .. is a bug in "library" .. you need just delete a line in the library .. sample for :
client/lib/purify.min.js:
delete this line : //# sourceMappingURL=purify.min.js.map

this is not a espoCrm issue

[Sab0tajue]

Hello,

purify.min.js.map and another one .. is a bug in "library" .. you need just delete a line in the library .. sample for :
client/lib/purify.min.js:
delete this line : //# sourceMappingURL=purify.min.js.map

this is not a espoCrm issue

I removed but the map element still does not display. What should I do?