Topic on Project:Support desk

I get this error when trying to change email, or confirm email.

What should I do ?

See How to debug.

@MarkAHershberger I get a long page with details that I don't know what to do about it.

I'am copying the page (XXX instead of private information)

[Xcub4krQOu4AATR58dUAAAAM] /index.php?title=XXX MWException from line 4237 of /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/user/User.php: CAS update failed on user_touched. The version of the user to be saved is older than the current version.

Backtrace:

#0 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/libs/rdbms/database/Database.php(3815): User->{closure}(Wikimedia\Rdbms\DatabaseSqlite, string)

#1 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/user/User.php(4250): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)

#2 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/user/User.php(4692): User->saveSettings()

#3 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/user/User.php(3123): User->sendConfirmationMail(string)

#4 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specials/SpecialChangeEmail.php(176): User->setEmailWithConfirmation(string)

#5 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specials/SpecialChangeEmail.php(127): SpecialChangeEmail->attemptChange(User, string)

#6 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/htmlform/HTMLForm.php(665): SpecialChangeEmail->onSubmit(array, OOUIHTMLForm)

#7 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/htmlform/HTMLForm.php(557): HTMLForm->trySubmit()

#8 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/htmlform/HTMLForm.php(572): HTMLForm->tryAuthorizedSubmit()

#9 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specialpage/FormSpecialPage.php(184): HTMLForm->show()

#10 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specials/SpecialChangeEmail.php(61): FormSpecialPage->execute(NULL)

#11 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specialpage/SpecialPage.php(569): SpecialChangeEmail->execute(NULL)

#12 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(NULL)

#13 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)

#14 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/MediaWiki.php(860): MediaWiki->performRequest()

#15 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/MediaWiki.php(517): MediaWiki->main()

#16 /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/index.php(42): MediaWiki->run()

#17 {main}

---

Debug data:

• IP: XXX.XX.XXX.XXX
• Start request POST /index.php?title=XXXHTTP HEADERS:HOST: XXX.XXX.comCONTENT-LENGTH: 454CACHE-CONTROL: max-age=0ORIGIN: http://XXX.XXX.comUPGRADE-INSECURE-REQUESTS: 1CONTENT-TYPE: application/x-www-form-urlencodedUSER-AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.2804.97 Safari/537.36ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/png,image/apng,*/*;q=0.8,application/signed-exchange;v=b3REFERER: http://XXX.XXX.com/index.php?title=XXXACCEPT-ENCODING: gzip, deflateACCEPT-LANGUAGE: en-UK,en;q=0.9,en-US;q=0.8,en;q=0.7COOKIE: my_wiki_session=XXX; my_wikiUserID=1; my_wikiUserName=XXX; my_wikiToken=XXX
• [caches] cluster: EmptyBagOStuff, WAN: mediawiki-main-default, stash: db-replicated, message: SqlBagOStuff, session: SqlBagOStuff
• [caches] LocalisationCache: using store LCStoreDB
• [DBConnection] Wikimedia\Rdbms\LoadBalancer::openConnection: calling initLB() before first connection.
• [DBReplication] Cannot use ChronologyProtector with EmptyBagOStuff.
• [DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: using request info {"IPAddress": "XXX.XX.XXX.XXX","UserAgent": "Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/78.0.2804.97 Safari\/537.36","ChronologyProtection": false,"ChronologyPositionIndex": 0,"ChronologyClientId": null}
• [DBConnection] Wikimedia\Rdbms\LoadBalancer::openLocalConnection: connected to database 0 at 'localhost'.
• User: cache miss for user 1
• [ContentHandler] Created handler for wikitext: WikitextContentHandler
• MediaWikiGadgetsDefinitionRepo::fetchStructuredList: MediaWiki:Gadgets-definition parsed, cache entry should be updated
• User: loading options for user 1 from database.
• [SQLBagOStuff] SqlBagOStuff: connecting to [unknown]
• [SQLBagOStuff] Connection SQLite 3.28.0 will be used for SqlBagOStuff
• User::getBlockedStatus: checking...
• User: loading options for user 1 from override cache.
• [MessageCache] MessageCache::load: Loading he... local cache is empty, global cache is expired/volatile, loading from database
• Unstubbing $wgParser on call of $wgParser::firstCallInit from MessageCache->transform
• Parser: using preprocessor: Preprocessor_DOM
• Unstubbing $wgLang on call of $wgLang::_unstub from ParserOptions->__construct
• User::getBlockedStatus: checking...
• [authentication] MediaWiki\Auth\AuthManager::securitySensitiveOperationStatus: Checking ChangeEmail
• [authentication] MediaWiki\Auth\AuthManager::securitySensitiveOperationStatus: ChangeEmail is ok for 'XXX'
• [objectcache] Rejected set() for my_wiki:messages-big:0169d77dc450e5d68ffdfade720dc0be:Changeemail-text due to pending writes.
• [MessageCache] MessageCache::load: Loading en... local cache is empty, global cache is expired/volatile, loading from database
• [objectcache] Rejected set() for my_wiki:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Changeemail-text/en due to pending writes.
• UserMailer::send: sending mail to =?UTF-8?Q?XXX?= <XX@XXXXX.COM>
• Sending mail via internal mail() function
• [DBQuery] startAtomic: entering level 0 (User::saveSettings)
• [preferences] CAS update failed on user_touched for user ID '1' (replica read)
• [DBQuery] cancelAtomic: canceling level 0 (User::saveSettings)
• [exception] [Xcub4krQOu4AATR58dUAAAAM] /index.php?title=XXX MWException from line 4237 of /homepages/32/XXX/htdocs/XXX/mediawiki-1.32.2/includes/user/User.php: CAS update failed on user_touched. The version of the user to be saved is older than the current version.
• User: loading options for user 1 from database.
• User: loading options for user 1 from database.
• User: loading options for user 1 from database.

You can try to see the user_touched field of the user table and see if it has some weird value, like a date in the future, or is blank, since this can cause this issue.

@Ciencia Al Poder but how do I fix it ?

Create a new user, see what is its user_touched field, and update the user that's failing with that value.

@Ciencia Al Poder Where do I find these details, I do not find them not in schema.doc in the MediaWiki docs/ directory, and not in tables.sql in the MediaWiki maintenance/ directory

Where should I look for it ?

You should look at the database of your wiki

@Ciencia Al Poder I have no file named 'user_touched field'.

In which file should I find these details ?

This wouldn't be a file, it would be inside the database of your Wiki. A database is separate and something different from normal files and folders of your Wiki. You'll need to access the database through something like phpMyAdmin.

@Ciencia Al Poder @AhmadF.Cheema I found this post

But as I'm not a technician I do not know where to write the above method, please help me.

My wiki uses sqlite.

You can try to run it from the sql.php maintenance script. Otherwise you can try a sqlite browser like https://sqlitebrowser.org/

If you use "LastUserLogin" extension, try to disable it. For me, works :)