Last modified: 2013-09-11 22:31:50 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 T56013, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 54013 - SQL error while installing PageTriage on a test Wiki (SQLite 3.7.8)
SQL error while installing PageTriage on a test Wiki (SQLite 3.7.8)
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
PageCuration (Other open bugs)
unspecified
All All
: Unprioritized minor (vote)
: ---
Assigned To: Nobody - You can work on this!
: easy
Depends on:
Blocks: sqlite
  Show dependency treegraph
 
Reported: 2013-09-11 10:08 UTC by Rainer Rillke @commons.wikimedia
Modified: 2013-09-11 22:31 UTC (History)
2 users (show)

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


Attachments

Description Rainer Rillke @commons.wikimedia 2013-09-11 10:08:53 UTC
Creating pagetriage_tags table ...A database query error has occurred.
Query: INSERT INTO pagetriage_tags (ptrt_tag_name, ptrt_tag_desc)
 VALUES
 ('linkcount', 'Number of inbound links'),
 ('category_count', 'Category mapping count'),
 ('csd_status', 'CSD status'),
 ('prod_status', 'PROD status'),
 ('blp_prod_status', 'BLP PROD status'),
 ('afd_status', 'AFD status'),
 ('rev_count', 'Number of edits to the article'),
 ('page_len', 'Number of bytes of article'),
 ('snippet', 'Beginning of article snippet'),
 ('user_name', 'User name'),
 ('user_editcount', 'User total edit'),
 ('user_creation_date', 'User registration date'),
 ('user_autoconfirmed', 'Check if user is autoconfirmed' ),
 ('user_bot', 'Check if user is in bot group'),
 ('user_block_status', 'User block status'),
 ('user_id', 'User id'),
 ('reference', 'Check if page has references')

Function: DatabaseBase::sourceFile( /srv/www/htdocs/extensions/PageTriage/sql/PageTriageTags.sql )
Error: 1 near ",": syntax error
-----
using https://github.com/wikimedia/mediawiki-extensions-PageTriage/tree/770e697dd10703ccd8781fd555def4c0441c50fb/
Comment 1 Rainer Rillke @commons.wikimedia 2013-09-11 10:11:41 UTC
Error occurs when running update script 
$ php update.php
----
It's about http://www.mediawiki.org/wiki/Extension:PageTriage which is lacking in the component select of Bugzilla
Comment 2 Andre Klapper 2013-09-11 14:41:16 UTC
Which MediaWiki version is this about?
Comment 3 Rainer Rillke @commons.wikimedia 2013-09-11 16:59:47 UTC
The HEAD of the MASTER branch.
Comment 4 Rainer Rillke @commons.wikimedia 2013-09-11 18:03:00 UTC
And the cause for that is
http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database and http://stackoverflow.com/questions/10038759/how-to-insert-multiple-rows-into-a-sqlite-3-table which should be fairly easy to fix or to sit it out and wait until everyone sqlite has version 3.7.11
Comment 5 Gerrit Notification Bot 2013-09-11 20:11:40 UTC
Change 83917 had a related patch set uploaded by Rillke:
Use SQL that SQLite 3.7.8 understands

https://gerrit.wikimedia.org/r/83917
Comment 6 Gerrit Notification Bot 2013-09-11 22:22:29 UTC
Change 83917 merged by jenkins-bot:
Use SQL that SQLite 3.7.8 understands

https://gerrit.wikimedia.org/r/83917

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


Navigation
Links