Page MenuHomePhabricator

"Prefix could not be added to the interwiki table" error with SQLite
Open, Needs TriagePublic

Description

Problem
Message "Prefix could not be added to the interwiki table. Possibly it already exists in the interwiki table." is dispayed when adding or changing interwiki link via Special:Interwiki and the wiki is running on SQLite.

Cause
Interwiki update statement in Interwiki_body.php is missing columns.

Fix
Changes required to file Interwiki_body.php in the function doSubmit():

		case 'edit':
			$theurl = $request->getVal( 'wpInterwikiURL' );
			$local = $request->getCheck( 'wpInterwikiLocal' ) ? 1 : 0;
			$trans = $request->getCheck( 'wpInterwikiTrans' ) ? 1 : 0;
			$data = array(
				'iw_prefix' => $prefix,
				'iw_url' => $theurl,
				'iw_local' => $local,
				'iw_trans' => $trans
			);
...to...
		case 'edit':
			$theurl = $request->getVal( 'wpInterwikiURL' );
			$local = $request->getCheck( 'wpInterwikiLocal' ) ? 1 : 0;
			$trans = $request->getCheck( 'wpInterwikiTrans' ) ? 1 : 0;
			$data = array(
				'iw_prefix' => $prefix,
				'iw_url' => $theurl,
				'iw_local' => $local,
				'iw_trans' => $trans,
				'iw_api' => '',
				'iw_wikiid' => ''
			);

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 18 2017, 1:22 PM