Open
Description
Summary
Trying to install oro commerce community edition (first installation on clean db) via oro:install throws function md5() does not exist
Steps to reproduce
composer install [successfull]
The following throws an exception instead:
bin/console oro:install --env=dev
Actual Result
Loading "main" data fixtures (language: en, formatting code: en)...
> loading Oro\Bundle\ScopeBundle\Migrations\Data\ORM\LoadDefaultScope
In AbstractPostgreSQLDriver.php line 102:
An exception occurred while executing 'INSERT INTO oro_scope (serialized_da
ta, row_hash, organization_id, user_id, localization_id, website_id, webCat
alog_id, customerGroup_id, customer_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)'
with params [null, null, null, null, null, null, null, null, null]:
SQLSTATE[42883]: Undefined function: 7 ERROR: function md5() does not exis
t
LINE 1: NEW.row_hash = MD5()
^
HINT: No function matches the given name and argument types. You might nee
d to add explicit type casts.
QUERY: NEW.row_hash = MD5()
CONTEXT: PL/pgSQL function oro_scope_fill_row_hash() line 3 at assignment
In Exception.php line 18:
SQLSTATE[42883]: Undefined function: 7 ERROR: function md5() does not exis
t
LINE 1: NEW.row_hash = MD5()
^
HINT: No function matches the given name and argument types. You might nee
d to add explicit type casts.
QUERY: NEW.row_hash = MD5()
CONTEXT: PL/pgSQL function oro_scope_fill_row_hash() line 3 at assignment
In PDOStatement.php line 117:
SQLSTATE[42883]: Undefined function: 7 ERROR: function md5() does not exis
t
LINE 1: NEW.row_hash = MD5()
^
HINT: No function matches the given name and argument types. You might nee
d to add explicit type casts.
QUERY: NEW.row_hash = MD5()
CONTEXT: PL/pgSQL function oro_scope_fill_row_hash() line 3 at assignment
Expected Result
Oro commerce installed correctly
Details about your environment
- OroCommerce Community Edition version: 5.1.0 obtained via compose create project
- PHP version: 8.2
- Database Postgres 15.1
- Env: docker via docker-compose.yml
- node and npm correctly validated (node 18.20.6 and npm 9.3.1)