Bug 196022 - www/mediawiki124: SQL error on remote PostgreSQL 9.3 server
Summary: www/mediawiki124: SQL error on remote PostgreSQL 9.3 server
Status: Closed Feedback Timeout
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: Wen Heping
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-16 10:55 UTC by O. Hartmann
Modified: 2015-05-02 07:15 UTC (History)
0 users

See Also:
bugzilla: maintainer-feedback? (wen)


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description O. Hartmann 2014-12-16 10:55:43 UTC
Installing port www/mediawiki124 on FreeBSD 10.1-RELEASE-p1 fails when the PostgreSQL 9.3 server (most recently installed from ports) is on a remote host. There occurs no error using FreeBSD CURRENT/FreeBSD 10.1-RELEASE-p1, when the PostgreSQL 9.3 server is on the same host as the Apache 2.4/MediaWiki resides.

ERROR:  syntax error at or near "IGNORE" at character 108
STATEMENT:  INSERT /* DatabaseBase::sourceFile( /usr/local/www/mediawiki/maintenance/update-keys.sql ) 10.1.1.100 */ IGNORE INTO "public"."updatelog"
         SELECT 'filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql' AS ul_key, null as ul_value
         UNION SELECT 'image-img_major_mime-patch-img_major_mime-chemical.sql', null
         UNION SELECT 'oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', null
         UNION SELECT 'user_groups-ug_group-patch-ug_group-length-increase-255.sql', null
         UNION SELECT 'user_former_groups-ufg_group-patch-ufg_group-length-increase-255.sql', null
         UNION SELECT 'user_properties-up_property-patch-up_property.sql', null
Comment 1 Bugzilla Automation freebsd_committer freebsd_triage 2014-12-16 10:55:43 UTC
Auto-assigned to maintainer wen@FreeBSD.org
Comment 2 Wen Heping freebsd_committer freebsd_triage 2014-12-20 03:52:24 UTC
I updated www/mediawiki124 to 1.24.1 just now, in upstream changelog there is:
(bug T74834) Make 1.24 branch directly installable under PostgreSQL.

Would you try again and test it ?

Thanks !

wen