Hi, I got my webhost to restore my database for me but apparently, my website http://dummipedia.org/Free_Simplified_Online_Encyclopedia turns out the following database error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LocalFile::loadFromDB". MySQL returned error "1054: Unknown column 'img_sha1' in 'field list' (localhost)".
Do you think I should consult Bugzilla?
PM Poon
Hello,
you must run the "update.php" in the "maintenance" directory.
See http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Gruß Jan Luca
-----Ursprüngliche Nachricht----- Von: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] Im Auftrag von Ekompute .info Gesendet: Samstag, 14. März 2009 11:20 An: MediaWiki announcements and site admin list Betreff: [Mediawiki-l] Problem with upgrading form Mediawiki 1.10 to 1.14
Hi, I got my webhost to restore my database for me but apparently, my website http://dummipedia.org/Free_Simplified_Online_Encyclopedia turns out the following database error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LocalFile::loadFromDB". MySQL returned error "1054: Unknown column 'img_sha1' in 'field list' (localhost)".
Do you think I should consult Bugzilla?
PM Poon _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Jan Luca, can I run "update.php" from my computer? According to my webhost, I can do that.
PM Poon
On Sat, Mar 14, 2009 at 9:35 PM, Jan Luca jan@jans-seite.de wrote:
Hello,
you must run the "update.php" in the "maintenance" directory.
See http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Gruß Jan Luca
-----Ursprüngliche Nachricht----- Von: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] Im Auftrag von Ekompute .info Gesendet: Samstag, 14. März 2009 11:20 An: MediaWiki announcements and site admin list Betreff: [Mediawiki-l] Problem with upgrading form Mediawiki 1.10 to 1.14
Hi, I got my webhost to restore my database for me but apparently, my website http://dummipedia.org/Free_Simplified_Online_Encyclopedia turns out the following database error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LocalFile::loadFromDB". MySQL returned error "1054: Unknown column 'img_sha1' in 'field list' (localhost)".
Do you think I should consult Bugzilla?
PM Poon _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
Hi Jan Luca, can I run "update.php" from my computer? According to my webhost, I can do that.
PM Poon
Run from your computer, making the changes on the remote computer of your webhost? Theoretically, it can be done. You'd need to have in your computer the php cli installed, the same mediawiki files version as is in your host, *direct access to the webserver's mysql db*, the adminsettings pointing there and perhaps a copy of your localsettings. I don't think that's what your webserver is suggesting you to do though. The mysql servers are usually only reachable from the inside network.
Hi, thank you very much for your response. Sounds like from the frying pan into the fire, LOL. Anyway, I think I will just use the good old method, ie. transfer the files one by one. May take me months, but I think I will just do that.
PM Poon
On Wed, Mar 18, 2009 at 9:36 AM, Platonides Platonides@gmail.com wrote:
Ekompute .info wrote:
Hi Jan Luca, can I run "update.php" from my computer? According to my webhost, I can do that.
PM Poon
Run from your computer, making the changes on the remote computer of your webhost? Theoretically, it can be done. You'd need to have in your computer the php cli installed, the same mediawiki files version as is in your host, *direct access to the webserver's mysql db*, the adminsettings pointing there and perhaps a copy of your localsettings. I don't think that's what your webserver is suggesting you to do though. The mysql servers are usually only reachable from the inside network.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
Hi, thank you very much for your response. Sounds like from the frying pan into the fire, LOL. Anyway, I think I will just use the good old method, ie. transfer the files one by one. May take me months, but I think I will just do that.
If your hosting service tells you you can run the script, they probably have a utility to allow you to do so. You're not the only one who runs Mediawiki software on a hosted service. Contact your hosting service and find out how they support running scripts.
You can also try products like PHP Shell (http://phpshell.sourceforge.net/).
Mike
Ekompute .info wrote:
Hi, thank you very much for your response. Sounds like from the frying pan into the fire, LOL. Anyway, I think I will just use the good old method, ie. transfer the files one by one. May take me months, but I think I will just do that.
PM Poon
Transfer the files?? The changes update.php make apply to the database, not to mediawiki code.
Hi Platonides, how do it use update.php with phpAdmin, or is it MySQL?
PM Poon
On Thu, Mar 19, 2009 at 8:44 AM, Platonides Platonides@gmail.com wrote:
Ekompute .info wrote:
Hi, thank you very much for your response. Sounds like from the frying
pan
into the fire, LOL. Anyway, I think I will just use the good old method,
ie.
transfer the files one by one. May take me months, but I think I will
just
do that.
PM Poon
Transfer the files?? The changes update.php make apply to the database, not to mediawiki code.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
Hi Platonides, how do it use update.php with phpAdmin, or is it MySQL?
This has been answered in messages to you before. Here's a summary of the steps you need to take:
http://www.mwusers.com/wiki/index.php?title=Running_maintenance_scripts
Mike
Hi Mike, thank you very much for your response. I may have overlooked it after I didn't quite understand what it means. Now, it is getting clearer. The oversight is deeply regretted. I will try to ask my webhost to read it and then run AdminSettings.php for me after I set it up.
PM Poon
On Sun, Mar 22, 2009 at 1:48 AM, Michael Daly michael.daly@kayakwiki.orgwrote:
Ekompute .info wrote:
Hi Platonides, how do it use update.php with phpAdmin, or is it MySQL?
This has been answered in messages to you before. Here's a summary of the steps you need to take:
http://www.mwusers.com/wiki/index.php?title=Running_maintenance_scripts
Mike
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
Hi Mike, thank you very much for your response. I may have overlooked it after I didn't quite understand what it means. Now, it is getting clearer. The oversight is deeply regretted. I will try to ask my webhost to read it and then run AdminSettings.php for me after I set it up.
Don't run AdminSettings.php. Read the instructions again. You run the script you need. You use AdminSettings.php to provide the info that the script needs. This applies to all scripts, including update.php.
Mike
Hi Mike, thank you once again for the advice.
PM Poon
On Sun, Mar 22, 2009 at 6:19 AM, Michael Daly michael.daly@kayakwiki.orgwrote:
Ekompute .info wrote:
Hi Mike, thank you very much for your response. I may have overlooked it after I didn't quite understand what it means. Now, it is getting
clearer.
The oversight is deeply regretted. I will try to ask my webhost to read
it
and then run AdminSettings.php for me after I set it up.
Don't run AdminSettings.php. Read the instructions again. You run the script you need. You use AdminSettings.php to provide the info that the script needs. This applies to all scripts, including update.php.
Mike
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Platonides, Mike Daly, Jan Luca, Evelyn Yoder, Tim Starling, and the many, many others who have attempted to help me solve the problem of upgrading Mediawiki to Version 1.14.
My, am I glad that the mystery is suddenly solved. I think Mike Daly did mention it before but I didn't realize that I need to type in again the table prefix which I thought would create another prefix on top of the existing one. I was toying with the Mediawiki installer again this morning and presto! The website went up after I typed in the prefix, "kom".
Thank you very very much for all your kind assistance and moral support. My, am I glad that I would have no problems upgrading in the future. This phobia has been with me for far too long!
PM Poon
On Sat, Mar 14, 2009 at 6:19 PM, Ekompute .info ekompute@gmail.com wrote:
Hi, I got my webhost to restore my database for me but apparently, my website http://dummipedia.org/Free_Simplified_Online_Encyclopedia turns out the following database error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)from within function "LocalFile::loadFromDB". MySQL returned error "1054: Unknown column 'img_sha1' in 'field list' (localhost)".
Do you think I should consult Bugzilla?
PM Poon
mediawiki-l@lists.wikimedia.org