Last modified: 2009-08-09 17:39:58 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 T22144, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 20144 - Error in database with Special:RevisionDelete
Error in database with Special:RevisionDelete
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Revision deletion (Other open bugs)
1.16.x
All All
: Normal normal (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-08-09 13:08 UTC by Bertrand GRONDIN
Modified: 2009-08-09 17:39 UTC (History)
0 users

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


Attachments

Description Bertrand GRONDIN 2009-08-09 13:08:18 UTC
When lauching this feature Special:RevisionDelete, an error in database is occured :

    SELECT log_type,log_action,log_user,log_namespace,log_title,log_params,log_comment,log_id,log_deleted,log_timestamp,user_name,user_editcount,ts_tags FROM `gdnlogging` FORCE INDEX (PRIMARY) INNER JOIN `grondin`.`gdnuser` ON ((user_id=log_user)) INNER JOIN `gdnlog_search` FORCE INDEX (ls_field_val) ON ((ls_log_id=log_id)) LEFT JOIN `gdntag_summary` ON ((ts_log_id=log_id)) WHERE log_type = 'delete' AND log_action = 'event' AND ls_field = 'log_id' AND ls_value = '7' AND log_namespace = '-1' AND log_title = 'Journal/block' AND (user_id = log_user) GROUP BY ls_log_id ORDER BY log_timestamp DESC LIMIT 26 

depuis la fonction « IndexPager::reallyDoQuery (LogPager) ». MySQL a renvoyé l’erreur « 1176 : Key 'ls_field_val' doesn't exist in table 'gdnlog_search' (localhost) ».
Comment 1 Aaron Schulz 2009-08-09 17:39:58 UTC
You are missing the index...the updaters are fine.

Run "CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id);" where "/*_*/" is your DB prefix.

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


Navigation
Links