EspoCRM 6.0.0 released

[dimyy]

Unfortunately the same result
Could not handle 'order' for 'Account'.; GET /Account; line: 1916, file: /home/petunicrm/public_html/application/Espo/ORM/QueryComposer/BaseQueryComposer.php [] []

[yuri]

Try

"orderBy": "CAST(json_value(account.full_info, '$.ratingData.ratingCount') AS UNSIGNED INTEGER) {direction}"

[esforim]

Hooray v6.

---

If anyone using the Real Estate extension, you need to update it to v1.4.0 before you can upgrade. But it won't let you update because you are not on v6; so you need to Uninstall it; update to v6 and re-install Extension 1.4.0

Also your system need to be on 5.9.4 before you can go to v6, so you will need to update a few time.

---

Also be careful if you are on Shared host; I got hit with an error:
SQLState[HY000] [1226] User has exceeded the 'max_user_connection".

[yuri]

You can fix the incompatibilities manually. But it'd recommend purchase a license. We offer discounts for license extending.

[enricorossa]

i also have the google extension problem. So if I uninstall the extension and update all 6 it works but then I have to buy the google extension again because 1.4.2 is not compatible and the extension's aggs expired on 2020-06-26 Right?

[yuri]

Option 1. Copy the instance to a local server an upgrade there.

Option 2. Download the upgrade package from the website, unzip it, remove the code from the beforeUpgrade script that forbids upgrading from UI. Then zip it.

[enricorossa]

Hello, trying to update to 6 the system replies that you can only update from the CLI, my problem is that I cannot access the CLI on the hosting I use, how can I update?

[dimyy]

I try change code like in the example.

Error: ORM Query: Not allowed function 'CAST'.
Is any possibility to skip ORM?

In 'select' clause all work ok

[item]

Sorry Yuri,
i have uninstalled old google extension .. and install was perfecly worked.

Thanks for all

[yuri]

Are you sure you don't have Google Integration installed?

[yuri]

There is a dozen of such incompatibilities. I hoped people would have sorted them out while betas were out.

See for example: https://github.com/espocrm/espocrm/b...nity.json#L130

It's better to create a separate topics for such ones and link it here.

[item]

Hello Yuri,
nice work .. thanks.

5.9.4 => V6

"Error: EspoCRM 6.0.0 is not compatible with Google Integration extension of a version lower than 1.4.2. Please upgrade the extension or uninstall it. Then run the upgrade command again.
"

It's because "before split extention" ... .but now we use "Outlook integration". so we don't have "Google integration"

Regards

[dimyy]

Version 5.9.4 all ok
Version 6.0.0:

"Cannot handle 'order' for 'account'"


Entity Defs JSON have:

"fullInfo": {
"name": "fullInfo",
"label": "Полная информация",
"type": "jsonObject",
"dynamicLogicVisible": null,
"dynamicLogicReadOnly": null,
"inlineEditDisabled": true,
"tooltip": false,
"isCustom": true
},

"ratingCount": {
"type": "int",
"notStorable": true,
"select": "CAST(json_value(account.full_info, '$.ratingData.ratingCount') AS UNSIGNED INTEGER)",
"readOnly": true,
"audited": false,
"tooltip": false,
"isCustom": true,
"orderBy": "ratingCount {direction}"
},

Error log record:

[2020-10-22 13:49:08] Espo.ERROR: (0) Could not handle 'order' for 'Account'.; GET /Account; line: 1916, file: /home/petunicrm/public_html/application/Espo/ORM/QueryComposer/BaseQueryComposer.php [] []

[yuri]

Hi,

Yes, it's possible. See post #8 https://forum.espocrm.com/forum/anno...beta4-released

[shalmaxb]

Hi, congratulations and thank you for the good work.

Is it possible to update from 6.0.0_beta4? or do I have to install a complete 6.0.0.?