Topic on Extension talk:Replace Text

ReplaceText 1.4.1 (8dd0719) breaks with Error: 22P02

1
SH73 (talkcontribs)

Dear Mediawiki-Community,


I'm getting this error after upgrading to Mediawiki 1.31.1:


[72b54eb34fc4319361df967a] /Spezial:ReplaceText Wikimedia\Rdbms\DBQueryError from line 1457 of /WIKI/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT page_namespace,page_title,page_id,page_len,page_is_redirect,page_latest,page_content_model FROM "page" WHERE page_id = 'edit_pages' LIMIT 1  

Function: Title::newFromID

Error: 22P02 FEHLER: ungültige Eingabesyntax für ganze Zahl: »edit_pages«

LINE 1: ...age_content_model FROM "page" WHERE page_id = 'edit_page...

^

Backtrace:

#0 /WIKI/includes/libs/rdbms/database/Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, string, string, string)

#1 /WIKI/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, string, string, string, boolean)

#2 /WIKI/includes/libs/rdbms/database/Database.php(1653): Wikimedia\Rdbms\Database->query(string, string)

#3 /WIKI/includes/libs/rdbms/database/Database.php(1730): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)

#4 /WIKI/includes/Title.php(422): Wikimedia\Rdbms\Database->selectRow(string, array, array, string)

#5 /WIKI/extensions/ReplaceText/src/SpecialReplaceText.php(264): Title::newFromID(string)

#6 /WIKI/extensions/ReplaceText/src/SpecialReplaceText.php(119): SpecialReplaceText->createJobsForTextReplacements()

#7 /WIKI/extensions/ReplaceText/src/SpecialReplaceText.php(71): SpecialReplaceText->doSpecialReplaceText()

#8 /WIKI/includes/specialpage/SpecialPage.php(522): SpecialReplaceText->execute(NULL)

#9 /WIKI/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(NULL)

#10 /WIKI/includes/MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)

#11 /WIKI/includes/MediaWiki.php(861): MediaWiki->performRequest()

#12 /WIKI/includes/MediaWiki.php(524): MediaWiki->main()

#13 /WIKI/index.php(42): MediaWiki->run()

#14 {main}


The wiki runs with PostgreSQL 11 and PHP 7.0.33. I've also seen this error on Version 1.32 and above. I've already executed the script update.php without errors.


This is my Create-Table:


CREATE TABLE WIKI.page

(

    page_id integer NOT NULL DEFAULT nextval('WIKI.page_page_id_seq'::regclass),

    page_namespace integer NOT NULL,

    page_title character varying(255) COLLATE pg_catalog."default" NOT NULL,

    page_restrictions text COLLATE pg_catalog."default",

    page_is_redirect smallint NOT NULL DEFAULT 0,

    page_is_new smallint NOT NULL DEFAULT 0,

    page_random real NOT NULL DEFAULT random(),

    page_touched timestamp with time zone,

    page_latest integer NOT NULL,

    page_len integer NOT NULL,

    titlevector tsvector,

    page_content_model text COLLATE pg_catalog."default",

    page_links_updated timestamp with time zone,

    page_lang text COLLATE pg_catalog."default",

    CONSTRAINT page_pkey PRIMARY KEY (page_id)

)

WITH (

    OIDS = FALSE

)

TABLESPACE pg_default;


Is there some advice?

Many thanks.


Reply to "ReplaceText 1.4.1 (8dd0719) breaks with Error: 22P02"