Some PostgreSQL functions in the CE release

oroinc / orocommerce

Main OroCommerce package with core functionality.

http:///www.orocommerce.com/

Other

193 stars 84 forks source link

Some PostgreSQL functions in the CE release #162

Closed gplanchat closed 1 year ago

gplanchat commented 1 year ago

Hello,

Since version 5.1 and at least commit 62b2b7125207c2b8969c8f6173d8aef3926cd2cb, there are raw SQL queries containing functions specific to PostgreSQL, and not present in MySQL.

string_agg
array_agg

This produces 500 errors on a fresh install of OroCommerce CE 5.1.0 while navigating to the products grid in the back-office.

gplanchat commented 1 year ago

Answer : MySQL support was dropped since version 5.1 https://doc.oroinc.com/backend/setup/system-requirements/#software