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
Auto-assigned to maintainer wen@FreeBSD.org
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