Topic on Project:Support desk

Michelle la (talkcontribs)

I've inherited a mediawiki backup (database and files). I've been told (and tried) to restore the database - and update the LocalSettings.php accordingly. Sadly, that doesn't seem to work. The original owner says that that a restore of the db won't work as they customised it so heavily their backup won't restore the usual way. Apparently, this is to do how they setup authentication to a system that is now defunct.

I understand that wiki stores the wiki text in the db table called database_text. And that it maybe possible to construct an SQL query that exports the raw text to an output. My theory is if I have the raw wiki mark-up I can copy and paste into the new mediawiki and upload the images and get the content back.

There's a long and shaggy story to how I got into this position - but basically the content is many months of work I donated to a NFP who have since abandoned the project, and aren't prepared or able to stand-up the old system to allow access in another way...

Finally, I'm by no means a wiki or MySQL guru so please be gentle. I found a sample SQL query online but try as I may - I can't get it to work.

SELECT `old_text` FROM `mw_text` WHERE `old_id` IN (

SELECT `rev_text_id` FROM `mw_revision` LEFT JOIN `mw_page` ON `page_latest` = `rev_id` WHERE `page_title` LIKE ( '%title_of_the_page%' ) )

Anyway help greatly appreciated...

Best Wishes

Michelle

TheDJ (talkcontribs)
Michelle la (talkcontribs)

Sadly, I don't have functional MediaWiki system from which to do the export....

Ciencia Al Poder (talkcontribs)

Even if heavily customized, you should be able to install MediaWiki (better if you have the original installation files and LocalSettings.php) and be able to export the contents or even upgrade to a newer MediaWiki version. If your tables start with "mw_" then you should set "mw_" as the table prefix.

Michelle la (talkcontribs)

I've tried restoring the DB. Changing the permissions and updating the LocalSettings file - and all get back is

MediaWiki internal error.

Original exception: [02948211dab68ebdb37f7be5] 2018-02-07 13:55:28: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Exception caught inside exception handler.

Set $wgShowExceptionDetails = true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information.

AhmadF.Cheema (talkcontribs)

So have you inserted the following "at the bottom of LocalSettings.php to show detailed debugging information"?

$wgShowExceptionDetails = true;
$wgShowDBErrorBacktrace = true;
Michelle la (talkcontribs)

I did. But it wasn't clear to me where this debugging info would be found - and it didn't seem to have any effect. Where would I find this debugging info?

2001:16B8:101D:FC00:5496:F47A:A881:74F (talkcontribs)

After you have added the two lines to the bottom of LocalSettings.php, you should do the same again, which you have already done before. Now, at the place where it said "MediaWiki internal error" you should now find more information, e.g. an exact error message or maybe even a stacktrace. That is what we are interested in!

Michelle la (talkcontribs)

Okay will give that another try and report back :)

Michelle la (talkcontribs)

So I tried a couple approaches after enabling Exception Detail and Backtrace

Attempt One:

  1. Create user and grant privileges
  2. Update LocalSettings.php to point to restore DB, and username/password

That failed - all get is:

MediaWiki internal error.

Original exception: [a7b80677ac84e6a3abfb34ed] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1149 of /opt/bitnami/apps/mediawiki/htdocs/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_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1

Function: WikiPage::pageData

Error: 1146 Table 'vmug-wiki.page' doesn't exist (localhost:3306)

Backtrace:

#0 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)

#2 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1411): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)

#3 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(331): Wikimedia\Rdbms\Database->selectRow(string, array, array, string, array)

#4 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(350): WikiPage->pageData(Wikimedia\Rdbms\DatabaseMysqli, array, array)

#5 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(386): WikiPage->pageDataFromTitle(Wikimedia\Rdbms\DatabaseMysqli, Title, array)

#6 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(470): WikiPage->loadPageData()

#7 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(511): WikiPage->exists()

#8 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(232): WikiPage->getContentModel()

#9 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(219): WikiPage->getContentHandler()

#10 /opt/bitnami/apps/mediawiki/htdocs/includes/actions/Action.php(96): WikiPage->getActionOverrides()

#11 /opt/bitnami/apps/mediawiki/htdocs/includes/actions/Action.php(154): Action::factory(string, WikiPage, RequestContext)

#12 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(155): Action::getActionName(RequestContext)

#13 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(768): MediaWiki->getAction()

#14 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(523): MediaWiki->main()

#15 /opt/bitnami/apps/mediawiki/htdocs/index.php(43): MediaWiki->run()

#16 {main}

Exception caught inside exception handler: [a7b80677ac84e6a3abfb34ed] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1149 of /opt/bitnami/apps/mediawiki/htdocs/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_title,page_latest FROM `page` WHERE page_is_redirect = '0' AND page_namespace = '8' AND (page_title NOT LIKE '%/%' ESCAPE '`' ) AND (page_len > 10000)

Function: MessageCache::loadFromDB(en)-big

Error: 1146 Table 'vmug-wiki.page' doesn't exist (localhost:3306)

Backtrace:

#0 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)

#2 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(512): Wikimedia\Rdbms\Database->select(string, array, array, string)

#3 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(426): MessageCache->loadFromDB(string, NULL)

#4 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(350): MessageCache->loadFromDBWithLock(string, array, NULL)

#5 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(991): MessageCache->load(string)

#6 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(920): MessageCache->getMsgFromNamespace(string, string)

#7 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(888): MessageCache->getMessageForLang(LanguageEn, string, boolean, array)

#8 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/MessageCache.php(828): MessageCache->getMessageFromFallbackChain(LanguageEn, string, boolean)

#9 /opt/bitnami/apps/mediawiki/htdocs/includes/Message.php(1275): MessageCache->get(string, boolean, LanguageEn)

#10 /opt/bitnami/apps/mediawiki/htdocs/includes/Message.php(842): Message->fetchMessage()

#11 /opt/bitnami/apps/mediawiki/htdocs/includes/Message.php(934): Message->toString(string)

#12 /opt/bitnami/apps/mediawiki/htdocs/includes/OutputPage.php(950): Message->text()

#13 /opt/bitnami/apps/mediawiki/htdocs/includes/OutputPage.php(997): OutputPage->setHTMLTitle(Message)

#14 /opt/bitnami/apps/mediawiki/htdocs/includes/OutputPage.php(2478): OutputPage->setPageTitle(string)

#15 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionRenderer.php(124): OutputPage->prepareErrorPage(string)

#16 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionRenderer.php(54): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#17 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionHandler.php(75): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#18 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionHandler.php(130): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#19 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(550): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)

#20 /opt/bitnami/apps/mediawiki/htdocs/index.php(43): MediaWiki->run()

#21 {main}

Michelle la (talkcontribs)

So I decide to run the php update.php - as it suggest there was a problem with the schema...

That produced this output...

bitnami@debian:~/apps/mediawiki/htdocs/maintenance$ php update.php

MediaWiki 1.30.0 Updater

Your composer.lock file is up to date with current dependencies!

Going to run database updates for vmug-wiki

Depending on the size of your database this may take a while!

Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0

Turning off Content Handler DB fields for this part of upgrade.

...ipblocks table does not exist, skipping new field patch.

...ipblocks table does not exist, skipping new field patch.

Creating interwiki table ...done.

Adding default interwiki definitions ...[ce881387246825dfc7e40a28] [no req]   Wikimedia\Rdbms\DBQueryError from line 1149 of /opt/bitnami/apps/mediawiki/htdocs/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: REPLACE INTO `interwiki` (iw_prefix,iw_url,iw_local,iw_api) VALUES

('acronym','http://www.acronymfinder.com/~/search/af.aspx?string=exact&Acronym=$1',0,''),

('advogato','http://www.advogato.org/$1',0,''),

('arxiv','http://www.arxiv.org/abs/$1',0,''),

('c2find','http://c2.com/cgi/wiki?FindPage&value=$1',0,''),

('cache','http://www.google.com/search?q=cache:$1',0,''),

('commons','https://commons.wikimedia.org/wiki/$1',0,'https://commons.wikimedia.org/w/api.php'),

('dictionary','http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1',0,''),

('doi','http://dx.doi.org/$1',0,''),

('drumcorpswiki','http://www.drumcorpswiki.com/$1',0,'http://drumcorpswiki.com/api.php'),

('dwjwiki','http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1',0,''),

('elibre','http://enciclopedia.us.es/index.php/$1',0,'http://enciclopedia.us.es/api.php'),

('emacswiki','http://www.emacswiki.org/cgi-bin/wiki.pl?$1',0,''),

('foldoc','http://foldoc.org/?$1',0,''),

('foxwiki','http://fox.wikis.com/wc.dll?Wiki~$1',0,''),

('freebsdman','http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1',0,''),

('gentoo-wiki','http://gentoo-wiki.com/$1',0,''),

('google','http://www.google.com/search?q=$1',0,''),

('googlegroups','http://groups.google.com/groups?q=$1',0,''),

('hammondwiki','http://www.dairiki.org/HammondWiki/$1',0,''),

('hrwiki','http://www.hrwiki.org/wiki/$1',0,'http://www.hrwiki.org/w/api.php'),

('imdb','http://www.imdb.com/find?q=$1&tt=on',0,''),

('kmwiki','http://kmwiki.wikispaces.com/$1',0,''),

('linuxwiki','http://linuxwiki.de/$1',0,''),

('lojban','http://www.lojban.org/tiki/tiki-index.php?page=$1',0,''),

('lqwiki','http://wiki.linuxquestions.org/wiki/$1',0,''),

('meatball','http://www.usemod.com/cgi-bin/mb.pl?$1',0,''),

('mediawikiwiki','https://www.mediawiki.org/wiki/$1',0,'https://www.mediawiki.org/w/api.php'),

('memoryalpha','http://en.memory-alpha.org/wiki/$1',0,'http://en.memory-alpha.org/api.php'),

('metawiki','http://sunir.org/apps/meta.pl?$1',0,''),

('metawikimedia','https://meta.wikimedia.org/wiki/$1',0,'https://meta.wikimedia.org/w/api.php'),

('mozillawiki','http://wiki.mozilla.org/$1',0,'https://wiki.mozilla.org/api.php'),

('mw','https://www.mediawiki.org/wiki/$1',0,'https://www.mediawiki.org/w/api.php'),

('oeis','http://oeis.org/$1',0,''),

('openwiki','http://openwiki.com/ow.asp?$1',0,''),

('pmid', 'https://www.ncbi.nlm.nih.gov/pubmed/$1?dopt=Abstract',0,''),

('pythoninfo','http://wiki.python.org/moin/$1',0,''),

('rfc','https://tools.ietf.org/html/rfc$1',0,''),

('s23wiki','http://s23.org/wiki/$1',0,'http://s23.org/w/api.php'),

('seattlewireless','http://seattlewireless.net/$1',0,''),

('senseislibrary','http://senseis.xmp.net/?$1',0,''),

('shoutwiki','http://www.shoutwiki.com/wiki/$1',0,'http://www.shoutwiki.com/w/api.php'),

('squeak','http://wiki.squeak.org/squeak/$1',0,''),

('tmbw','http://www.tmbw.net/wiki/$1',0,'http://tmbw.net/wiki/api.php'),

('tmnet','http://www.technomanifestos.net/?$1',0,''),

('theopedia','http://www.theopedia.com/$1',0,''),

('twiki','http://twiki.org/cgi-bin/view/$1',0,''),

('uncyclopedia','http://en.uncyclopedia.co/wiki/$1',0,'http://en.uncyclopedia.co/w/api.php'),

('unreal','http://wiki.beyondunreal.com/$1',0,'http://wiki.beyondunreal.com/w/api.php'),

('usemod','http://www.usemod.com/cgi-bin/wiki.pl?$1',0,''),

('wiki','http://c2.com/cgi/wiki?$1',0,''),

('wikia','http://www.wikia.com/wiki/$1',0,''),

('wikibooks','https://en.wikibooks.org/wiki/$1',0,'https://en.wikibooks.org/w/api.php'),

('wikidata','https://www.wikidata.org/wiki/$1',0,'https://www.wikidata.org/w/api.php'),

('wikif1','http://www.wikif1.org/$1',0,''),

('wikihow','http://www.wikihow.com/$1',0,'http://www.wikihow.com/api.php'),

('wikinfo','http://wikinfo.co/English/index.php/$1',0,''),

('wikimedia','https://wikimediafoundation.org/wiki/$1',0,'https://wikimediafoundation.org/w/api.php'),

('wikinews','https://en.wikinews.org/wiki/$1',0,'https://en.wikinews.org/w/api.php'),

('wikipedia','https://en.wikipedia.org/wiki/$1',0,'https://en.wikipedia.org/w/api.php'),

('wikiquote','https://en.wikiquote.org/wiki/$1',0,'https://en.wikiquote.org/w/api.php'),

('wikisource','https://wikisource.org/wiki/$1',0,'https://wikisource.org/w/api.php'),

('wikispecies','https://species.wikimedia.org/wiki/$1',0,'https://species.wikimedia.org/w/api.php'),

('wikiversity','https://en.wikiversity.org/wiki/$1',0,'https://en.wikiversity.org/w/api.php'),

('wikivoyage','https://en.wikivoyage.org/wiki/$1',0,'https://en.wikivoyage.org/w/api.php'),

('wikt','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php'),

('wiktionary','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php')

Function: Wikimedia\Rdbms\Database::sourceFile( /opt/bitnami/apps/mediawiki/htdocs/maintenance/interwiki.sql )

Error: 1054 Unknown column 'iw_api' in 'field list' (localhost:3306)

Backtrace:

#0 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(3325): Wikimedia\Rdbms\Database->query(string, string)

#2 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(3274): Wikimedia\Rdbms\Database->sourceStream(unknown type, NULL, NULL, string, NULL)

#3 /opt/bitnami/apps/mediawiki/htdocs/includes/installer/DatabaseUpdater.php(673): Wikimedia\Rdbms\Database->sourceFile(string)

#4 /opt/bitnami/apps/mediawiki/htdocs/includes/installer/MysqlUpdater.php(406): DatabaseUpdater->applyPatch(string, boolean, string)

#5 /opt/bitnami/apps/mediawiki/htdocs/includes/installer/DatabaseUpdater.php(472): MysqlUpdater->doInterwikiUpdate()

#6 /opt/bitnami/apps/mediawiki/htdocs/includes/installer/DatabaseUpdater.php(436): DatabaseUpdater->runUpdates(array, boolean)

#7 /opt/bitnami/apps/mediawiki/htdocs/maintenance/update.php(204): DatabaseUpdater->doUpdates(array)

#8 /opt/bitnami/apps/mediawiki/htdocs/maintenance/doMaintenance.php(92): UpdateMediaWiki->execute()

#9 /opt/bitnami/apps/mediawiki/htdocs/maintenance/update.php(249): require_once(string)

#10 {main}

Ciencia Al Poder (talkcontribs)

In the first attempt, it tries to access the table "vmug-wiki.page". If the page table is missing, running update.php will just make things worse. Please restore the backup again.

You should query your database directly and see what's the name of the database, and what's the name of the tables (if they have any common prefix). Then, set the configuration settings appropriately to allow MediaWiki select the right table names.

2A02:C7F:9C0A:5A00:1554:239:1E7D:A5BE (talkcontribs)

I have this running in a virtualbox VM so I restore the DB again using:

mysql -u root -pYvovd7jsHmkJ  bitnami_mediawiki < DATABASE-vmug-wiki.sql

I'm not really sure I understand the restore process which doesn't help me. When I first did this I expected the restore to overwrite the contents of bitnami_mediawiki. However, looking at PhpAdmin it seems to create a new database called vmug-wiki...

It's shame you can't upload a screen grab to these pages... Anyway I've uploaded a screengrab of PhpAdmin to my blog:

http://www.michellelaverick.com/db.png

I'm wondering if I am doing the db restore correctly in the first place?

Best Wishes

Michelle

Ciencia Al Poder (talkcontribs)

You can upload temporary images to http://snag.gy/

The restore is correct. The tables have a common prefix "wiki_". You should set in LocalSettings:

$wgDBprefix = 'wiki_';
Michelle la (talkcontribs)

I granted privileges to a user called someuser/somepass

Okay, so updated the LocalSetting.php with the following settings:

$wgDBtype           = "mysql";

$wgDBserver         = "localhost:3306";

$wgDBname           = "vmug-wiki";

$wgDBuser           = "someuser";

$wgDBpassword       = "somepass";

# MySQL specific settings

$wgDBprefix         = "wiki_";

That produced this trace:

MediaWiki internal error.

Original exception: [c21f8d75abb7a1837794a9da] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1149 of /opt/bitnami/apps/mediawiki/htdocs/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_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `wiki_page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1

Function: WikiPage::pageData

Error: 1054 Unknown column 'page_links_updated' in 'field list' (localhost:3306)

Backtrace:

#0 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)

#2 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1411): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)

#3 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(331): Wikimedia\Rdbms\Database->selectRow(string, array, array, string, array)

#4 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(350): WikiPage->pageData(Wikimedia\Rdbms\DatabaseMysqli, array, array)

#5 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(386): WikiPage->pageDataFromTitle(Wikimedia\Rdbms\DatabaseMysqli, Title, array)

#6 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(470): WikiPage->loadPageData()

#7 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(511): WikiPage->exists()

#8 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(232): WikiPage->getContentModel()

#9 /opt/bitnami/apps/mediawiki/htdocs/includes/page/WikiPage.php(219): WikiPage->getContentHandler()

#10 /opt/bitnami/apps/mediawiki/htdocs/includes/actions/Action.php(96): WikiPage->getActionOverrides()

#11 /opt/bitnami/apps/mediawiki/htdocs/includes/actions/Action.php(154): Action::factory(string, WikiPage, RequestContext)

#12 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(155): Action::getActionName(RequestContext)

#13 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(768): MediaWiki->getAction()

#14 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(523): MediaWiki->main()

#15 /opt/bitnami/apps/mediawiki/htdocs/index.php(43): MediaWiki->run()

#16 {main}

Exception caught inside exception handler: [c21f8d75abb7a1837794a9da] /Main_Page Wikimedia\Rdbms\DBQueryError from line 1149 of /opt/bitnami/apps/mediawiki/htdocs/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_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title FROM `wiki_page` WHERE (page_namespace = '1' AND page_title = 'Main_Page') OR (page_namespace = '4' AND page_title IN ('Privacy_policy','About','General_disclaimer') )

Function: LinkBatch::doQuery (for Skin::preloadExistence)

Error: 1054 Unknown column 'page_content_model' in 'field list' (localhost:3306)

Backtrace:

#0 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /opt/bitnami/apps/mediawiki/htdocs/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)

#2 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/LinkBatch.php(210): Wikimedia\Rdbms\Database->select(string, array, string, string)

#3 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/LinkBatch.php(138): LinkBatch->doQuery()

#4 /opt/bitnami/apps/mediawiki/htdocs/includes/cache/LinkBatch.php(127): LinkBatch->executeInto(LinkCache)

#5 /opt/bitnami/apps/mediawiki/htdocs/includes/skins/Skin.php(267): LinkBatch->execute()

#6 /opt/bitnami/apps/mediawiki/htdocs/includes/skins/Skin.php(147): Skin->preloadExistence()

#7 /opt/bitnami/apps/mediawiki/htdocs/skins/Vector/SkinVector.php(70): Skin->initPage(OutputPage)

#8 /opt/bitnami/apps/mediawiki/htdocs/includes/skins/SkinTemplate.php(248): SkinVector->initPage(OutputPage)

#9 /opt/bitnami/apps/mediawiki/htdocs/includes/OutputPage.php(2442): SkinTemplate->outputPage()

#10 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionRenderer.php(135): OutputPage->output()

#11 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionRenderer.php(54): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#12 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionHandler.php(75): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#13 /opt/bitnami/apps/mediawiki/htdocs/includes/exception/MWExceptionHandler.php(130): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#14 /opt/bitnami/apps/mediawiki/htdocs/includes/MediaWiki.php(550): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)

#15 /opt/bitnami/apps/mediawiki/htdocs/index.php(43): MediaWiki->run()

#16 {main}

Any thoughts?

Ciencia Al Poder (talkcontribs)

Ok, it now finds the tables correctly, but some columns are missing. You now need to run update.php to upgrade your database schema to your current MediaWiki version

Michelle la (talkcontribs)

Whoop!

I can the update.php and it lives!

Copied my images directory over and they are all in place...

I cannot put into word how very grateful I am for all your help. You've saved me hours and hours of work. And brought back from the brink a project and work, I was beginning to feel was going to be lost for ever. At a stroke you've restored my faith in "community" projects and support!

Before I go off and enjoy a well-earn cocktail. I was expect to have problem editing the pages and log on problems. The previous org rigged the wiki to a SSO or SAML style authentication system. I was surprised to find I could just hit "edit" and start making changes. Is there a setting that accounts for this access?

Best Wishes

Michelle...

ps. thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you! thank you!

Ciencia Al Poder (talkcontribs)