Page MenuHomePhabricator

Install script for PostgreSQL broken
Closed, ResolvedPublic

Description

Author: overlordq

Description:
Patch to correct sequence

When running either maintenances script or the install:

...cu_changes already exists.
Warning: pg_query(): Query failed: ERROR: relation "cu_log_cul_id" does not exist in /home/wiki/includes/DatabasePostgres.php on line 553
...cu_log added

...log file missing, skipping log import.

the SQL for creating the table has a typo so it's trying to use an invalid sequence.


Version: unspecified
Severity: enhancement

attachment cu_log.pg.sql.patch ignored as obsolete

Details

Reference
bz13531

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:06 PM
bzimport added a project: CheckUser.
bzimport set Reference to bz13531.
bzimport added a subscriber: Unknown Object (MLST).

overlordq wrote:

Better patch

Actually, on line 811 in CheckUser_body.php:

$cul_id = $dbw->nextSequenceValue( 'cu_log_cul_id' );

So other parts need patched as well

Attached:

overlordq wrote:

Looks like was fixed in r32495.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.