[Pkg-mediawiki-devel] Bug#615983: Fwd: [evolvis-Bug Reports][#1377] internal error effected by moving a page in a mediawiki

[Thorsten Glaser]

Package: mediawiki
Version: 1:1.15.5-3

Just to keep track of the bug here. This is clearly a bug in
/usr/share/mediawiki/includes/Title.php as shown here:

 2703                         $dbw->insertSelect( 'page_restrictions', 'page_restrictions',
 2704                                 array(
 2705                                         'pr_page'    => $redirid,
 2706                                         'pr_type'    => 'pr_type',
 2707                                         'pr_level'   => 'pr_level',
 2708                                         'pr_cascade' => 'pr_cascade',
 2709                                         'pr_user'    => 'pr_user',
 2710                                         'pr_expiry'  => 'pr_expiry'
 2711                                 ),
 2712                                 array( 'pr_page' => $pageid ),
 2713                                 __METHOD__,
 2714                                 array( 'IGNORE' )
 2715                         );

“IGNORE” is no valid SQL.

bye,
//mirabilos
-- 
CeBIT 2011 – tarent ist dabei. Besuchen Sie uns auf der CeBIT 2011 und
lernen Sie unser neues Identity- and Accessmanagement OSIAM kennen. Wir
freuen uns auf Ihren Besuch in Halle 2, Stand D40/1. Sie wünschen ein
persönliches Gespräch? – Wenden Sie sich an sales at tarent.de.

tarent Gesellschaft für Softwareentwicklung und IT-Beratung mbH
Heilsbachstraße 24, D-53123 Bonn • http://www.tarent.de/
Tel: +49 228 52675-93 • Fax: +49 228 52675-25
HRB AG Bonn 5168 • USt-ID (VAT): DE122264941
Geschäftsführer: Boris Esser, Elmar Geese

---------- Forwarded message ----------
From: evolvis-bugreports at evolvis.org
To: noreply at evolvis.org
Date: Mon, 28 Feb 2011 16:54:48 +0100 (CET)
Subject: [evolvis-dev] [evolvis-Bug Reports][#1377] internal error effected by
    moving a page in a mediawiki

Bug Reports item [#1377] was opened at 28.02.2011 16:54 by Julia Geese
You can respond by visiting: 
https://evolvis.org/tracker/t_follow.php/1377

Status: Open
Priority: 3
Submitted By: Julia Geese (jgeese)
Assigned to: Nobody (None)
Summary: internal error effected by moving a page in a mediawiki 


Initial Comment:
At the attempt to move a page the following messages shows up. 
Nevertheless the page was moved, but there is no message about that 
part.

Interner Fehler
Aus dev Wiki
Wechseln zu: Navigation, Suche

A database error has occurred
Query: INSERT IGNORE INTO page_restrictions 
(pr_page,pr_type,pr_level,pr_cascade,pr_user,pr_expiry) SELECT 
793,pr_type,pr_level,pr_cascade,pr_user,pr_expiry FROM page_restrictions 
WHERE pr_page = '216'
Function: Title::moveTo
Error: 1 ERROR: syntax error at or near "IGNORE"
LINE 1: INSERT /* Title::moveTo Jgeese */ IGNORE INTO page_restricti...
^

Backtrace:

#0 /usr/share/mediawiki/includes/db/Database.php(616): 
DatabasePostgres->reportQueryError('ERROR: syntax ...', 1, 'INSERT 
IGNORE I...', 'Title::moveTo', false)
#1 /usr/share/mediawiki/includes/db/Database.php(1809): 
Database->query('INSERT IGNORE I...', 'Title::moveTo')
#2 /usr/share/mediawiki/includes/Title.php(2715): 
Database->insertSelect('page_restrictio...', 'page_restrictio...', 
Array, Array, 'Title::moveTo', Array)
#3 /usr/share/mediawiki/includes/specials/SpecialMovepage.php(338): 
Title->moveTo(Object(Title), true, '', true)
#4 /usr/share/mediawiki/includes/specials/SpecialMovepage.php(46): 
MovePageForm->doSubmit()
#5 [internal function]: wfSpecialMovepage(NULL, 
Object(UnlistedSpecialPage))
#6 /usr/share/mediawiki/includes/SpecialPage.php(771): 
call_user_func('wfSpecialMovepa...', NULL, Object(UnlistedSpecialPage))
#7 /usr/share/mediawiki/includes/SpecialPage.php(559): 
SpecialPage->execute(NULL)
#8 /usr/share/mediawiki/includes/Wiki.php(229): 
SpecialPage::executePath(Object(Title))
#9 /usr/share/mediawiki/includes/Wiki.php(59): 
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), 
Object(WebRequest))
#10 /usr/share/mediawiki/index.php(116): 
MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), 
Object(User), Object(WebRequest))
#11 {main}

----------------------------------------------------------------------

You can respond by visiting: 
https://evolvis.org/tracker/t_follow.php/1377

-- 
Falls Probleme auftauchen oder Sie anderweitig das Evolvis-Team 
kontaktieren müssen, lesen Sie das Impressum – 
https://evolvis.org/impress/ – oder senden Sie eine eMail an 
«webmaster ät evolvis.org».
_______________________________________________
evolvis-development mailing list
evolvis-development at lists.evolvis.org
https://evolvis.org/mailman/listinfo/evolvis-development

//mirabilos
-- 
«MyISAM tables -will- get corrupted eventually. This is a fact of life. »
“mysql is about as much database as ms access” – “MSSQL at least descends
from a database” “it's a rebranded SyBase” “MySQL however was born from a
flatfile and went downhill from there” – “at least jetDB doesn’t claim to
be a database”	(#nosec)    ‣‣‣ Please let MySQL and MariaDB finally die!