Page MenuHomePhabricator

Error running update.php on shared db with PostgreSQL
Closed, DuplicatePublic

Description

In https://wiki.idempiere.org we have a wiki farm form multiple languages with shared users as suggested here:
https://www.mediawiki.org/wiki/Manual:Shared_database

Running maintenance/update.php on our postgres database threw errors because of keyword IGNORE found in the file extensions/UserMerge/MergeUser.php

A diff -p shows the following changes done in the source:

215,217c215,217
< 			[ 'user_groups', 'ug_user', 'options' => [ 'IGNORE' ] ],
< 			[ 'user_properties', 'up_user', 'options' => [ 'IGNORE' ] ],
< 			[ 'user_former_groups', 'ufg_user', 'options' => [ 'IGNORE' ] ],
---
> 			[ 'user_groups', 'ug_user', 'options' => [ '' ] ],
> 			[ 'user_properties', 'up_user', 'options' => [ '' ] ],
> 			[ 'user_former_groups', 'ufg_user', 'options' => [ '' ] ],

Regards,

Carlos Ruiz