Last modified: 2014-01-03 19:04:26 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61233, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59233 - Database error when moving protection settings with pages when SQLite is used as a backend
Database error when moving protection settings with pages when SQLite is used...
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.23.0
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: sqlite
  Show dependency treegraph
 
Reported: 2014-01-02 22:54 UTC by Jackmcbarn
Modified: 2014-01-03 19:04 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Jackmcbarn 2014-01-02 22:54:59 UTC
Using a SQLite backend, when a page with protection settings is moved, the following error occurs:

    Query:
    INSERT IGNORE INTO page_restrictions (pr_page,pr_type,pr_level,pr_cascade,pr_user,pr_expiry) SELECT 47,pr_type,pr_level,pr_cascade,pr_user,pr_expiry FROM page_restrictions WHERE pr_page = '20'
    Function: Title::moveTo
    Error: 1 near "IGNORE": syntax error

Backtrace:

#0 C:\xampp\htdocs\core\includes\db\Database.php(1077): DatabaseBase->reportQueryError('near "IGNORE": ...', 1, 'INSERT IGNORE I...', 'Title::moveTo', false)
#1 C:\xampp\htdocs\core\includes\db\Database.php(2907): DatabaseBase->query('INSERT IGNORE I...', 'Title::moveTo')
#2 C:\xampp\htdocs\core\includes\Title.php(3805): DatabaseBase->insertSelect('page_restrictio...', 'page_restrictio...', Array, Array, 'Title::moveTo', Array)
#3 C:\xampp\htdocs\core\includes\specials\SpecialMovepage.php(528): Title->moveTo(Object(Title), true, '', true)
#4 C:\xampp\htdocs\core\includes\specials\SpecialMovepage.php(100): MovePageForm->doSubmit()
#5 C:\xampp\htdocs\core\includes\specialpage\SpecialPage.php(679): MovePageForm->execute(NULL)
#6 C:\xampp\htdocs\core\includes\SpecialPageFactory.php(487): SpecialPage->run(NULL)
#7 C:\xampp\htdocs\core\includes\Wiki.php(298): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#8 C:\xampp\htdocs\core\includes\Wiki.php(596): MediaWiki->performRequest()
#9 C:\xampp\htdocs\core\includes\Wiki.php(460): MediaWiki->main()
#10 C:\xampp\htdocs\core\index.php(49): MediaWiki->run()
#11 {main}
Comment 1 Gerrit Notification Bot 2014-01-03 15:29:35 UTC
Change 105190 had a related patch set uploaded by Umherirrender:
Call Database::makeInsertOptions from Database::insertSelect

https://gerrit.wikimedia.org/r/105190
Comment 2 Umherirrender 2014-01-03 15:39:54 UTC
Just for reference: I have no sqlite to test my change on that DBMS, but the change does not break mysql and now the same things is done with the options as in Database::insert, so that should fix this problem on sqlite (when merged).
Comment 3 Gerrit Notification Bot 2014-01-03 19:01:22 UTC
Change 105190 merged by jenkins-bot:
Call Database::makeInsertOptions from Database::insertSelect

https://gerrit.wikimedia.org/r/105190
Comment 4 Umherirrender 2014-01-03 19:04:26 UTC
successfully merged - fix was confirmed by bug reporter on gerrit

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links