Mediawiki Upgrade Database Error
Contents |
topic 113.193.104.33 (talkcontribs) Hi, I am trying to upgrade wiki 1.18 to 1.22. I uploaded wiki-22 files, copied Localsettings.php to the folder, ran mw-config/index.php
Error: 1054 Unknown Column 'page_links_updated' In 'field List' (localhost)
from web browser, then got this error: "A database query error has mediawiki a database query error has occurred. this may indicate a bug in the software. occurred. This may indicate a bug in the software." How should I fix this error? Your help is mediawiki database error search much appreciated. My current version: MediaWiki 1.18.0 PHP 5.3.24 (cgi-fcgi) MySQL 5.0.96-log Thanks, Vikas Reply 15:27, 20 December 2013 2 years ago Permalink Hide 88.130.102.228 (talkcontribs) Hi Vikas, at the
Upgrading Mediawiki
end of your LocalSettings.php file add $wgShowSQLErrors = 1; and run the update script again. What error message do you get? Reply 16:01, 20 December 2013 2 years ago Permalink Hide 113.193.104.33 (talkcontribs) Thanks for reply. This says: A database query error has occurred. This may indicate a bug in the software. Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len,page_content_model FROM `jainwikipage` WHERE page_namespace =
Mediawiki Unknown Column 'page_links_updated' In 'field List'
'0' AND page_title = 'Mw-config/index.php' LIMIT 1 Function: WikiPage::pageData Error: 1054 Unknown column 'page_content_model' in 'field list' (jainwikiuser.db.7394013.hostedresource.com) Reply 16:47, 20 December 2013 2 years ago Permalink Hide 88.130.102.228 (talkcontribs) The interesting part in that message is: Function: WikiPage::pageData Error: 1054 Unknown column 'page_content_model' in 'field list' (jainwikiuser.db.7394013.hostedresource.com) The updater obviously expects the column "page_content_model" to be in your database, but it is not. As afirst step, I would take a backup of the database and just try the update again. If that does not help, have a look at this thread, where the same problem has been discussed. Basically some hack to add and remove the column at the start of the update... This is actually not the same problem, sorry. Reply Edited by 88.130.123.192 12:31, 21 December 2013 2 years ago Permalink Hide Bawolff (talkcontribs) The database query indicates you are not running the web configurations script, but actually going to the page "Mw-config/index.php" on your wiki. Possibly you have rewrite rules set up that prevent you from accessing mw-config/index.php properly. If possible try running u
Deutsch• Zazaki• Ελληνικά• English• español• فارسی• français• हिन्दी• magyar• Bahasa Indonesia• italiano• 日本語• 한국어• Nederlands• polski• português do Brasil• русский• sicilianu• سنڌي• Türkçe• 中文 Download a package Stable versionMediaWiki 1.27 (1.27.1) mediawiki-1.27.1.tar.gz Git branch: REL1_27 mediawiki search a database query error has occurred Legacy versionsMediaWiki 1.26 (1.26.4) mediawiki-1.26.4.tar.gz Git branch: REL1_26 Alpha versionMediaWiki 1.28 MediaWiki
Mediawiki Database Update
nightly build Read more News Download from GitDownload from Git Upgrading to 1.27.1 Contents 1 Basic overview 1.1 mediawiki installation File transfer 1.2 Preliminary 2 Check requirements 3 Read the release notes 4 Back up existing files and the database 5 Unpack the new files 5.1 Using a tarball package https://www.mediawiki.org/wiki/Topic:Rlqs29fxd74rxtpo 5.1.1 FTP or graphical 5.1.2 Command line 5.2 Other files 5.3 Using Git 5.4 Using patch 5.5 Files remaining that may cause errors 6 Upgrade extensions 7 Adapt your LocalSettings.php 7.1 Skin registration 7.2 Extension registration 7.3 Other variables 8 Run the update script 8.1 Command line 8.1.1 What to do in case of "ALTER command denied to user" error https://www.mediawiki.org/wiki/Manual:Upgrading (or similar) 8.1.2 What to do in case of "unexpected T_STRING" error 8.1.3 What to do in case of 'register_argc_argv is set to false' error 8.2 Web browser 9 Test the update 10 Frequently asked questions 10.1 How hard is it to upgrade? 10.2 How do I upgrade from a really old version? In one step, or in several steps? 10.3 Should I back up first? 10.4 Can I keep my LocalSettings.php? 10.5 Can my wiki stay online while it is upgrading? 10.6 Why upgrade? 11 See also Basic overview[edit] File transfer[edit] Choose a method for transferring files: wget Secure copy with SCP or WinSCP SSH File Transfer Protocol (SFTP) Using a FTP client. The hosting company might provide a file manager interface via the web browser; check with your provider. Some other method. There is a list of these at w:List of file transfer protocols Preliminary[edit] Read the UPGRADE text file included in MediaWiki. Check the requirements Read the release notes Back up existing files and the database Unpack the new files Upgrade extensions Run the up
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About http://stackoverflow.com/questions/30555070/mediawiki-database-error-after-update Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the https://www.semantic-mediawiki.org/wiki/Help:Installation Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Mediawiki database error after update up database error vote 1 down vote favorite I hope for some help on the problem I have trying to update my Wiki from 1.21 to 1.25. I,m don't have experience doing this but I followed the manual in Mediawiki doing this. Create a new folder and put in the new fileset. Add the Images folder with content, moved the Localsettings.php from old to new. And renamed the folder unknown column 'page_links_updated' to the right sitename. As result i get this: a database query error has occurred. this may indicate a bug in the software. I'm a beginner and hope for some help, I read some things about using command-line scripts but don't know how to do that, maybe I forgot something in this actions. I must get this update online soon because my hosting provider is going to use only PHP5.4 in 2 weeks what makes my current wiki stop working. Thanks in advance. php mediawiki share|improve this question edited Jun 1 '15 at 21:58 EternalHour 3,14041537 asked May 31 '15 at 7:47 Fred MrNoname 61 Have you run the schema update script ? –Sulthan Allaudeen May 31 '15 at 8:36 No, i cannot run SSH at the hosting server. Beside that I have no experience with scripts. What is best way to do this? (database is about 52 mb) –Fred MrNoname Jun 1 '15 at 9:24 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Updating the database is a required step anytime you upgrade your MediaWiki version. If you cannot run SSH on the server,
Information Installation type: "N/A" is not in the list of possible values (new, upgrade, update) for this property. Installation method: N/A Table of Contents Contents 1 General notes 1.1 Environment 1.2 Settings 2 Requirements 3 Installation 4 Tests 5 Troubleshooting The recommended way for installing Semantic MediaWiki is by using Composer, but if you cannot use Composer for installation and upgrading, you have the option to install the file release as described on this help page. Note: The instructions on this page to install and update Semantic MediaWiki do not apply to the Semantic Bundle which also uses Semantic MediaWiki. See the help page on the Semantic Bundle for how to do this. There is also a help page on how to install on a Windows-based server. Please always check the exact requirements and follow the instructions carefully. Make sure you understand the legal disclaimer in the file [1] before proceeding. To upgrade a wiki running an older version of SMW, be sure to read the relevant section before starting the upgrade. Note: If you are using MediaWiki1.23 and higher and/or PHP5.4 and higher you are strongly encouraged to install or to update to Semantic MediaWiki 2.0 or higher. Semantic MediaWiki1.9 and lower is discouraged for productive use with these versions. General notes Semantic MediaWiki has dependencies that will be made available during the installation. Individual extensions to Semantic MediaWiki, e.g. Semantic Result Formats may have different requirements. Individual extensions to Semantic MediaWiki may not be compatible with the "~2.4" release (yet). Please see those extensions' documentation pages, or contact the respective developers, for further information. ConfirmEdit 1 extension(s) are known to cause limitations in the functioning of Semantic MediaWiki Environment It is expected that the PHP mbstring extension is enabled (provides PHP mb_*() multibyte functions such as mb_strpos in the php_mbstring.dll). This is standard but not enabled by default on some distributions of PHP. When using