Hi, I finally managed to upgrade my database from Version 1.12 to 1.14. Everything seems to be okay except that the website doesn't show any articles. I know I have to transfer the images folder over. What else do I need to do? Do I need to transfer the docs folder too? My website is at http://teknologi-maklumat.com/teknologi/index.php/Main_Page
It really looks like a new installation!
PM Poon
Hi, it is really amazing! I managed to duplicate my "ekompute" wiki database, just in case the original gets corrupted. I named the new database "teknologi".
I then installed Mediawiki Version 1.14. When I set up the wiki by rerunning the installer, everything looks find. However, the pages are empty so I thought I could correct it by replace the new docs and images folders with the old one. (I replaced the images folder once in my previous attempt and the images appear. But now it suddenly doesn't).
Seems like everyone is having no problems with upgrading. I wonder why I am so damp!
PM Poon
On Sun, Mar 29, 2009 at 7:09 PM, Ekompute .info ekompute@gmail.com wrote:
Hi, I finally managed to upgrade my database from Version 1.12 to 1.14. Everything seems to be okay except that the website doesn't show any articles. I know I have to transfer the images folder over. What else do I need to do? Do I need to transfer the docs folder too? My website is at http://teknologi-maklumat.com/teknologi/index.php/Main_Page
It really looks like a new installation!
PM Poon
Le dimanche 29 mars 2009 à 23:27 +0800, Ekompute .info a écrit :
Hi, it is really amazing! I managed to duplicate my "ekompute" wiki database, just in case the original gets corrupted. I named the new database "teknologi".
I then installed Mediawiki Version 1.14. When I set up the wiki by rerunning the installer, everything looks find. However, the pages are empty so I thought I could correct it by replace the new docs and images folders with the old one. (I replaced the images folder once in my previous attempt and the images appear. But now it suddenly doesn't).
Seems like everyone is having no problems with upgrading. I wonder why I am so damp!
PM Poon
Hello,
no you are not alone I post a similar problem yesterday:
"database did not find the text of an existing page after upgrading from 1.11 to 1.14"
In my case it seems that the id of a page text is no more the same as its title id, so I only get the title and not the text, with an error message. Is it the same for you ?
Best Francois Colonna
Hi Francois Colonna, mine looks like a brand new website. I wonder whether it is because I changed the name of my database as I didn't want to corrupt the original one. This problem has been a longstanding one and it's like an axe on my neck. I like Mediawiki but till date, I have not been able to do even one upgrade, so my Dummipedia.org and Teknologi-maklumat.com websites are still using the 1.10 version. Now the Teknologi-maklumat.com site is down. Wonder whether it is my webhost trying to help me solve the problem. They are very helpful but they are not familiar with the software either.
PM Poon
On Mon, Mar 30, 2009 at 4:01 AM, Frames Project frames@lct.jussieu.frwrote:
Le dimanche 29 mars 2009 à 23:27 +0800, Ekompute .info a écrit :
Hi, it is really amazing! I managed to duplicate my "ekompute" wiki database, just in case the original gets corrupted. I named the new
database
"teknologi".
I then installed Mediawiki Version 1.14. When I set up the wiki by
rerunning
the installer, everything looks find. However, the pages are empty so I thought I could correct it by replace the new docs and images folders
with
the old one. (I replaced the images folder once in my previous attempt
and
the images appear. But now it suddenly doesn't).
Seems like everyone is having no problems with upgrading. I wonder why I
am
so damp!
PM Poon
Hello,
no you are not alone I post a similar problem yesterday:
"database did not find the text of an existing page after upgrading from 1.11 to 1.14"
In my case it seems that the id of a page text is no more the same as its title id, so I only get the title and not the text, with an error message. Is it the same for you ?
Best Francois Colonna
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
I wonder whether it is because I changed the name of my database as I didn't want to corrupt the original one.
I've upgraded my wiki many times and never had a problem. I also follow the instructions and don't try to do things that are not in the upgrade instructions.
You do things that are not in the instructions - like renaming the database or things that are incorrect, like not running the update script after a restore from a previous version etc.
If you want to make changes to the wiki, do that either entirely before or entirely after the upgrade, not _during_ the upgrade.
If you are afraid of corrupting the database - make a backup.
If you are going to make changes, make sure you understand the ramifications of the actions you take. If you change things (like the name of the database), you have to make the corresponding changes to the configuration (i.e. LocalSettings.php).
Don't blame MW for things you do on your own.
Mike
Hi Mike, sorry if I appear to be blaming MW. Actually I am not. I am just saying that I have not been able to upgrade successfully and I cannot run the update script in my shared hosting.
PM Poon
On Mon, Mar 30, 2009 at 5:49 AM, Michael Daly michael.daly@kayakwiki.orgwrote:
Ekompute .info wrote:
I wonder whether it is because I changed the name of my database as I didn't want to
corrupt
the original one.
I've upgraded my wiki many times and never had a problem. I also follow the instructions and don't try to do things that are not in the upgrade instructions.
You do things that are not in the instructions - like renaming the database or things that are incorrect, like not running the update script after a restore from a previous version etc.
If you want to make changes to the wiki, do that either entirely before or entirely after the upgrade, not _during_ the upgrade.
If you are afraid of corrupting the database - make a backup.
If you are going to make changes, make sure you understand the ramifications of the actions you take. If you change things (like the name of the database), you have to make the corresponding changes to the configuration (i.e. LocalSettings.php).
Don't blame MW for things you do on your own.
Mike
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Mike, sorry if I appear to be blaming MW. Actually I am not. I did acknowledge that everyone has no problems... it's only me that is unable to do it.
What I am just saying is that I have not been able to upgrade successfully and I cannot run the update script in my shared hosting. But what you said about changing the name of my database may be the cause of the problem. It is hard to understand the ramifications unless one is an expert. I did screw up my database once by trying to follow the instructions in Mediawiki.org after I transferred from another webhost. Fortunately, maiahost, my new webhost, helped me out by reinstalling it for me as I could not get the backup restored because of poor internet connection.
PM Poon
On Mon, Mar 30, 2009 at 5:49 AM, Michael Daly michael.daly@kayakwiki.orgwrote:
Ekompute .info wrote:
I wonder whether it is because I changed the name of my database as I didn't want to
corrupt
the original one.
I've upgraded my wiki many times and never had a problem. I also follow the instructions and don't try to do things that are not in the upgrade instructions.
You do things that are not in the instructions - like renaming the database or things that are incorrect, like not running the update script after a restore from a previous version etc.
If you want to make changes to the wiki, do that either entirely before or entirely after the upgrade, not _during_ the upgrade.
If you are afraid of corrupting the database - make a backup.
If you are going to make changes, make sure you understand the ramifications of the actions you take. If you change things (like the name of the database), you have to make the corresponding changes to the configuration (i.e. LocalSettings.php).
Don't blame MW for things you do on your own.
Mike
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Did you two run upgrade.php from the maintenance folder on your databases? And naming your database something new as long as your LocalSettings.php points to it shouldn't cause any problems.
Good luck! -Courtney
Hi Christensen, thank you very much for your reply. I did point to the new database in LocalSettings.php but it didn't work for me. Tried it three times.
Extreme phobia began about a year back when Siteground could not help me restore with two of their backups, even though they charge me for it, and I thought that one full year of hard work had gone down the drain. At that time, I thought I would not continue doing websites because if it were 10 years of effort, I would have jumped up through the window, LOL. Didn't touch my website for quite many weeks after that, even though Siteground somehow or rather manage to restore it eventually after I told them that I am giving up on websites.
Anyway, I will take a plunge and try Mike's proposal. No confidence in backups these days, I know the fear is illogical. Maybe arming myself with 3 different copies will reduce the risk.
PM Poon
I am using a shared server and I do not have access to running the upgrade.php.
On Mon, Mar 30, 2009 at 8:41 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Did you two run upgrade.php from the maintenance folder on your databases? And naming your database something new as long as your LocalSettings.php points to it shouldn't cause any problems.
Good luck! -Courtney
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi, I just tried to upgrade one of my smaller websites from 1.12 to 1.14. Now the site is down. The error message is:
*Warning*: require_once(/home/ekomrinf/public_html/mywiki/LocalSettings.php) [function.require-oncehttp://teknologi-maklumat.com/mywiki/function.require-once]: failed to open stream: Permission denied in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113*
*Fatal error*: require_once() [function.requirehttp://teknologi-maklumat.com/mywiki/function.require]: Failed opening required '/home/ekomrinf/public_html/mywiki/LocalSettings.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113
*Doesn't look very serious, though. How do I solve it?
PM Poon*
* On Tue, Mar 31, 2009 at 1:28 AM, Ekompute .info ekompute@gmail.com wrote:
Hi Christensen, thank you very much for your reply. I did point to the new database in LocalSettings.php but it didn't work for me. Tried it three times.
Extreme phobia began about a year back when Siteground could not help me restore with two of their backups, even though they charge me for it, and I thought that one full year of hard work had gone down the drain. At that time, I thought I would not continue doing websites because if it were 10 years of effort, I would have jumped up through the window, LOL. Didn't touch my website for quite many weeks after that, even though Siteground somehow or rather manage to restore it eventually after I told them that I am giving up on websites.
Anyway, I will take a plunge and try Mike's proposal. No confidence in backups these days, I know the fear is illogical. Maybe arming myself with 3 different copies will reduce the risk.
PM Poon
I am using a shared server and I do not have access to running the upgrade.php.
On Mon, Mar 30, 2009 at 8:41 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Did you two run upgrade.php from the maintenance folder on your databases? And naming your database something new as long as your LocalSettings.php points to it shouldn't cause any problems.
Good luck! -Courtney
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi, I looked at the solution from the internet and found an answer at MedaWiki Users http://www.mwusers.com/forums/showthread.php?p=30793. It says to change the permission for LocalSettings to 644. Does that means that everyone can read my LocalSettings.php?
Anyway, it works, but to my surprise, I couldn't see any of my files! It is exactly like what happened when I tried to upgrade Dummipedia.org. So it's back to square one again.
PM Poon
On Tue, Mar 31, 2009 at 2:51 AM, Ekompute .info ekompute@gmail.com wrote:
Hi, I just tried to upgrade one of my smaller websites from 1.12 to 1.14. Now the site is down. The error message is:
*Warning*: require_once(/home/ekomrinf/public_html/mywiki/LocalSettings.php) [ function.require-oncehttp://teknologi-maklumat.com/mywiki/function.require-once]: failed to open stream: Permission denied in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113*
*Fatal error*: require_once() [function.requirehttp://teknologi-maklumat.com/mywiki/function.require]: Failed opening required '/home/ekomrinf/public_html/mywiki/LocalSettings.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113
*Doesn't look very serious, though. How do I solve it?
PM Poon
On Tue, Mar 31, 2009 at 1:28 AM, Ekompute .info ekompute@gmail.comwrote:
Hi Christensen, thank you very much for your reply. I did point to the new database in LocalSettings.php but it didn't work for me. Tried it three times.
Extreme phobia began about a year back when Siteground could not help me restore with two of their backups, even though they charge me for it, and I thought that one full year of hard work had gone down the drain. At that time, I thought I would not continue doing websites because if it were 10 years of effort, I would have jumped up through the window, LOL. Didn't touch my website for quite many weeks after that, even though Siteground somehow or rather manage to restore it eventually after I told them that I am giving up on websites.
Anyway, I will take a plunge and try Mike's proposal. No confidence in backups these days, I know the fear is illogical. Maybe arming myself with 3 different copies will reduce the risk.
PM Poon
I am using a shared server and I do not have access to running the upgrade.php.
On Mon, Mar 30, 2009 at 8:41 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Did you two run upgrade.php from the maintenance folder on your databases? And naming your database something new as long as your LocalSettings.php points to it shouldn't cause any problems.
Good luck! -Courtney
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Since it mentions "Permission denied" my first thought is that maybe your server doesn't have permission to read the LocalSettings.php file?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Ekompute .info Sent: Monday, March 30, 2009 2:51 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Upgrading Mediawiki
Hi, I just tried to upgrade one of my smaller websites from 1.12 to 1.14. Now the site is down. The error message is:
*Warning*: require_once(/home/ekomrinf/public_html/mywiki/LocalSettings.php) [function.require-oncehttp://teknologi-maklumat.com/mywiki/function.require-once]: failed to open stream: Permission denied in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113*
*Fatal error*: require_once() [function.requirehttp://teknologi-maklumat.com/mywiki/function.require]: Failed opening required '/home/ekomrinf/public_html/mywiki/LocalSettings.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113
*Doesn't look very serious, though. How do I solve it?
PM Poon*
* On Tue, Mar 31, 2009 at 1:28 AM, Ekompute .info ekompute@gmail.com wrote:
Hi Christensen, thank you very much for your reply. I did point to the new database in LocalSettings.php but it didn't work for me. Tried it three times.
Extreme phobia began about a year back when Siteground could not help me restore with two of their backups, even though they charge me for it, and I thought that one full year of hard work had gone down the drain. At that time, I thought I would not continue doing websites because if it were 10 years of effort, I would have jumped up through the window, LOL. Didn't touch my website for quite many weeks after that, even though Siteground somehow or rather manage to restore it eventually after I told them that I am giving up on websites.
Anyway, I will take a plunge and try Mike's proposal. No confidence in backups these days, I know the fear is illogical. Maybe arming myself with 3 different copies will reduce the risk.
PM Poon
I am using a shared server and I do not have access to running the upgrade.php.
On Mon, Mar 30, 2009 at 8:41 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Did you two run upgrade.php from the maintenance folder on your databases? And naming your database something new as long as your LocalSettings.php points to it shouldn't cause any problems.
Good luck! -Courtney
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
Hi Christensen, thank you again for your response. When I changed permission for LocalSettings.php to 644, it works but all my articles have mysteriously disappeared. Maybe I ought to execute update.php, as has been mentioned many times previously, although I set up using the Mediawiki installer. I have asked my webhost to do it. Will have to wait and see after they have done it to see if I have screwed up again.
PM Poon
On Tue, Mar 31, 2009 at 4:06 AM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Since it mentions "Permission denied" my first thought is that maybe your server doesn't have permission to read the LocalSettings.php file?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto: mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Ekompute .info Sent: Monday, March 30, 2009 2:51 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Upgrading Mediawiki
Hi, I just tried to upgrade one of my smaller websites from 1.12 to 1.14. Now the site is down. The error message is:
*Warning*: require_once(/home/ekomrinf/public_html/mywiki/LocalSettings.php) [function.require-once< http://teknologi-maklumat.com/mywiki/function.require-once%3E]: failed to open stream: Permission denied in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113*
*Fatal error*: require_once() [function.requirehttp://teknologi-maklumat.com/mywiki/function.require]: Failed opening required '/home/ekomrinf/public_html/mywiki/LocalSettings.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in * /home/ekomrinf/public_html/mywiki/includes/WebStart.php* on line *113
*Doesn't look very serious, though. How do I solve it?
PM Poon*
On Tue, Mar 31, 2009 at 1:28 AM, Ekompute .info ekompute@gmail.com wrote:
Hi Christensen, thank you very much for your reply. I did point to the
new
database in LocalSettings.php but it didn't work for me. Tried it three times.
Extreme phobia began about a year back when Siteground could not help me restore with two of their backups, even though they charge me for it, and
I
thought that one full year of hard work had gone down the drain. At that time, I thought I would not continue doing websites because if it were 10 years of effort, I would have jumped up through the window, LOL. Didn't touch my website for quite many weeks after that, even though Siteground somehow or rather manage to restore it eventually after I told them that
I
am giving up on websites.
Anyway, I will take a plunge and try Mike's proposal. No confidence in backups these days, I know the fear is illogical. Maybe arming myself
with 3
different copies will reduce the risk.
PM Poon
I am using a shared server and I do not have access to running the upgrade.php.
On Mon, Mar 30, 2009 at 8:41 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
Did you two run upgrade.php from the maintenance folder on your
databases?
And naming your database something new as long as your
LocalSettings.php
points to it shouldn't cause any problems.
Good luck! -Courtney
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
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
Maybe I ought to execute update.php, as has been mentioned many times previously, although I set up using the Mediawiki installer.
As has been mentioned before - if you run the installer, the installer should have run the update.php script. I've never run the installer but I assume it should have shown you the database updates taking place or logged the information to some file. Did you see any evidence that the database tables were updated when you ran the installer?
If you upgrade *without* using the installer, then running the update script is one of the steps in the process. If you restore an *older* version of the database, you also have to run update to bring it up to the new version level.
I have asked my webhost to do it. Will have to wait and see after they have done it to see if I have screwed up again.
If the update script was already run, running it again will not have any effect as the script will check the state of the tables and do nothing.
Maybe you should install an older version of MW on your own computer and upgrade that to 1.14 so you can see what's happening without relying on something happening on a distant server. If you understand what is going on with upgrades on your machine you'll understand what needs to be done on the server.
Mike
Hi Mike, thank you for your response. Yes, I did see a long list of files been updated and at the end of it, it says successful installation. But I wonder why I cannot access the files. The number of tables in the database has been increased from 35 to 73 and I do see the details of each table. They are definitely not empty. However, I cannot view any of my articles on the browser.
Yes, maybe I ought to run it on my computer and see what's happening. I screwed up my databases so many times, trying to upgrade these last few months.
PM Poon
On Tue, Mar 31, 2009 at 6:23 AM, Michael Daly michael.daly@kayakwiki.orgwrote:
Ekompute .info wrote:
Maybe I ought to execute update.php, as has been mentioned many times previously, although I set up using the Mediawiki installer.
As has been mentioned before - if you run the installer, the installer should have run the update.php script. I've never run the installer but I assume it should have shown you the database updates taking place or logged the information to some file. Did you see any evidence that the database tables were updated when you ran the installer?
If you upgrade *without* using the installer, then running the update script is one of the steps in the process. If you restore an *older* version of the database, you also have to run update to bring it up to the new version level.
I have asked my webhost to do it. Will have to wait and see after they have done
it
to see if I have screwed up again.
If the update script was already run, running it again will not have any effect as the script will check the state of the tables and do nothing.
Maybe you should install an older version of MW on your own computer and upgrade that to 1.14 so you can see what's happening without relying on something happening on a distant server. If you understand what is going on with upgrades on your machine you'll understand what needs to be done on the server.
Mike
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
From Ekompute .info On Monday, March 30, 2009 5:59 PM
Hi Christensen, thank you again for your response. When I changed permission for LocalSettings.php to 644, it works but all my articles have mysteriously disappeared. Maybe I ought to execute update.php, as has been mentioned many times previously, although I set up using the Mediawiki installer. I have asked my webhost to do it. Will have to wait and see after they have done it to see if I have screwed up again.
PM Poon
Hi PM,
Do you have any access to your database other than through your wiki? Command line or PHPMyAdmin? If you do, can you check the database that your LocalSettings file is pointing to and can you see if there is any data in that database?
You are saying that the MediaWiki UI shows up, just that you don't seem to have any articles right?
Good luck, -Courtney
Hi Christensen, I do have access to the Cpanel which provides MySQL and phpAdmin access. The database after upgrading says 152,714 records and 38.8 MB.
I was just wondering. If the database was written with UTF8 backward compatibility, can I change it to binary during the Mediawiki installation? I did that and wonder whether this could be the cause.
PM Poon
On Tue, Mar 31, 2009 at 9:22 PM, Christensen, Courtney < ChristensenC@battelle.org> wrote:
From Ekompute .info On Monday, March 30, 2009 5:59 PM
Hi Christensen, thank you again for your response. When I changed
permission
for LocalSettings.php to 644, it works but all my articles have
mysteriously
disappeared. Maybe I ought to execute update.php, as has been mentioned
many
times previously, although I set up using the Mediawiki installer. I have asked my webhost to do it. Will have to wait and see after they have done
it
to see if I have screwed up again.
PM Poon
Hi PM,
Do you have any access to your database other than through your wiki? Command line or PHPMyAdmin? If you do, can you check the database that your LocalSettings file is pointing to and can you see if there is any data in that database?
You are saying that the MediaWiki UI shows up, just that you don't seem to have any articles right?
Good luck, -Courtney
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org