Page MenuHomePhabricator

Error running update.php on shared db with PostgreSQL
Open, Needs TriagePublic

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

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 23 2019, 11:46 AM
Aklapper renamed this task from Error running update.php on shared db to Error running update.php on shared db with PostgreSQL.Apr 23 2019, 12:10 PM
Aklapper added a project: PostgreSQL.