Jump to content

Topic on Manual talk:Orphans.php/Flow

Error: 1100 Table 'mw_text' was not locked with LOCK TABLES

4
Tenbergen (talkcontribs)

Error: 1100 Table 'mw_text' was not locked with LOCK TABLES

Got that error when trying to run this on an older wiki that now runs 1.28.0

Tenbergen (talkcontribs)

The error message also includes "Query: SELECT  page_title,old_text,old_flags  FROM `mw_page`,`mw_revision`,`mw_text`    WHERE page_is_redirect = '0' AND page_namespace = '8' AND (page_title NOT LIKE '%/%' ) AND (page_latest=rev_id) AND (rev_text_id=old_id) AND (page_len <= 10000)"

I ran the query manually it runs without error and returns five lines

Accountcreatedtext

Loginreqtitle

Monobook.css

Permissionserrorstext-withaction

Signature

Farvardyn (talkcontribs)

@Tenbergen I came here to report the same bug and I noticed it is not yet fixed after 3 years you reported! It seems, wiki people don't care about bug reports! Any solution?

Tenbergen (talkcontribs)

@Farvardyn, Since I posted this I found out that, while some extension devs really use the talk pages for bug reports, the mediawiki devs don't so much. So, posting it here is just shouting into the forest. If you want a solution, you could report it through Phabricator, their actual bug tracking tool. See How to report a bug for more info. I can't remember 3 years ago, but I think I ended up addressing this in some other way, or maybe I didn't need it at all and just posted it as a good tester would. Hope that helps! Tenbergen (talk) 17:51, 11 May 2020 (UTC)

Reply to "Error: 1100 Table 'mw_text' was not locked with LOCK TABLES"