Topic on Extension talk:AutoSitemap

The bug is not in the extension, but in the legacy settings that still appears in user's LocalSettings.php: $wgAutoSitemap["exclude_namespaces"] array.

Hi! I recently upgraded to mediaWiki 1.36.1 I then upgraded AutoSitemap to 1.4, and did the /mw-config But I still get a DBQueryError. I attach the debug view here. I changed some path names to avoid revealing details of my server.

[YOFfYxh8xzsb5DpGpDwlawAAARw] /index.php?title=Wiki_page&action=submit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error 1054: Unknown column 'NS_IMAGE_TALK' in 'where clause' (localhost) Function: Wikimedia\Rdbms\DBConnRef::query Query: SELECT "Popularpages" AS type, page_id AS id, page_namespace AS namespace, page_title AS title, (MAX(rev_timestamp)) AS last_modification, rev_timestamp AS value FROM `mw_page`, `mw_revision` WHERE page_is_redirect = 0 AND rev_page = page_id AND page_namespace NOT IN (1,2,3,5,NS_IMAGE_TALK,8,9,10,11,12,13,15) GROUP BY page_id Backtrace: from /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/Database.php(1719)

1. 0 /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/Database.php(1703): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
2. 1 /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/Database.php(1678): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
3. 2 /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/Database.php(1244): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
4. 3 /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query(string, string, integer)
5. 4 /home/myusername/public_html/mywikiname/includes/libs/rdbms/database/DBConnRef.php(286): Wikimedia\Rdbms\DBConnRef->__call(string, array)
6. 5 /home/myusername/public_html/mywikiname/extensions/AutoSitemap/AutoSitemap_body.php(101): Wikimedia\Rdbms\DBConnRef->query(string)
7. 6 /home/myusername/public_html/mywikiname/includes/HookContainer/HookContainer.php(338): AutoSitemap::writeSitemap(Revision, NULL, NULL)
8. 7 /home/myusername/public_html/mywikiname/includes/HookContainer/HookContainer.php(137): MediaWiki\HookContainer\HookContainer->callLegacyHook(string, array, array, array)
9. 8 /home/myusername/public_html/mywikiname/includes/HookContainer/HookRunner.php(3270): MediaWiki\HookContainer\HookContainer->run(string, array)
10. 9 /home/myusername/public_html/mywikiname/includes/Revision/RevisionStore.php(536): MediaWiki\HookContainer\HookRunner->onRevisionInsertComplete(Revision, NULL, NULL)
11. 10 /home/myusername/public_html/mywikiname/includes/Storage/PageUpdater.php(1390): MediaWiki\Revision\RevisionStore->insertRevisionOn(MediaWiki\Revision\RevisionStoreRecord, Wikimedia\Rdbms\DBConnRef)
12. 11 /home/myusername/public_html/mywikiname/includes/Storage/PageUpdater.php(817): MediaWiki\Storage\PageUpdater->doCreate(CommentStoreComment, User, integer)
13. 12 /home/myusername/public_html/mywikiname/includes/page/WikiPage.php(2225): MediaWiki\Storage\PageUpdater->saveRevision(CommentStoreComment, integer)
14. 13 /home/myusername/public_html/mywikiname/includes/page/WikiPage.php(2080): WikiPage->doUserEditContent(WikitextContent, User, CommentStoreComment, integer, boolean, array, integer)
15. 14 /home/myusername/public_html/mywikiname/includes/EditPage.php(2361): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User, string, array, integer)
16. 15 /home/myusername/public_html/mywikiname/includes/EditPage.php(1694): EditPage->internalAttemptSave(array, boolean)
17. 16 /home/myusername/public_html/mywikiname/includes/EditPage.php(669): EditPage->attemptSave(array)
18. 17 /home/myusername/public_html/mywikiname/includes/actions/EditAction.php(71): EditPage->edit()
19. 18 /home/myusername/public_html/mywikiname/includes/actions/SubmitAction.php(38): EditAction->show()
20. 19 /home/myusername/public_html/mywikiname/includes/MediaWiki.php(531): SubmitAction->show()
21. 20 /home/myusername/public_html/mywikiname/includes/MediaWiki.php(315): MediaWiki->performAction(Article, Title)
22. 21 /home/myusername/public_html/mywikiname/includes/MediaWiki.php(913): MediaWiki->performRequest()
23. 22 /home/myusername/public_html/mywikiname/includes/MediaWiki.php(546): MediaWiki->main()
24. 23 /home/myusername/public_html/mywikiname/index.php(53): MediaWiki->run()
25. 24 /home/myusername/public_html/mywikiname/index.php(46): wfIndexMain()
26. 25 {main}

---

Josemoya (talk)

Forgot to say, disabling AutoSiteMap gets rid of this error.

SOLVED. The bug is not in the extension, but in the legacy settings that still appear in my LocalSettings.php: $wgAutoSitemap["exclude_namespaces"] = [

   NS_TALK,
   NS_USER,   
   NS_USER_TALK,
   NS_PROJECT_TALK,

/** NS_IMAGE_TALK <== CHANGE THIS WITH THE FOLLOWING LINE **/ NS_FILE_TALK,

   NS_MEDIAWIKI,   
   NS_MEDIAWIKI_TALK,
   NS_TEMPLATE,
   NS_TEMPLATE_TALK,
   NS_HELP,   
   NS_HELP_TALK,
   NS_CATEGORY_TALK

]; //default values