r66920 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r66919‎ | r66920 | r66921 >
Date:14:29, 26 May 2010
Author:maxsem
Status:resolved (Comments)
Tags:
Comment:
follow-up to r66892: fix update SQL on on SQLite
Modified paths:
  • /trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql (added) (history)

Diff [purge]

Index: trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
——@@ -0,0 +1,5 @@
 2+--
 3+-- Recreates the iwl_prefix for the iwlinks table
 4+--
 5+DROP INDEX /*i*/iwl_prefix;
 6+CREATE INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);
\ No newline at end of file
Property changes on: trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
___________________________________________________________________
Name: svn:eol-style
17 + native

Follow-up revisions

RevisionCommit summaryAuthorDate
r73758A few index-related fixes in SQLite DB patches, ping r66920....maxsem17:45, 25 September 2010

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r66892Followup to r65105 after discussion with Roan...reedy20:37, 25 May 2010

Comments

#Comment by Nikerabbit (talk | contribs)   16:26, 25 September 2010

Adding iwl_prefix_title_from key to table iwlinks... A database query syntax error has occurred.

The last attempted database query was: "DROP INDEX iwl_prefix " from within function "DatabaseBase::sourceFile( /www/movebox/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql )".

Database returned error "1: no such index: iwl_prefix"

#Comment by MaxSem (talk | contribs)   17:45, 25 September 2010

Fixed in r73758

Status & tagging log