Re: problem following 1.16 to 1.25 conversion

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Krishna Maheshwari
Thank you for your responses.

The way I upgraded (to date) from the original 1.16 version to 1.25 was to

1. Upgrade the server which was running an outdated version of Debian.  So,
I created a new server with the current stable distro of Debian and copied
the MySQL db to the new version of MySQL on the new server.  I copied the
mediawiki (v 1.16) to the new server as well.  This resulted in a few minor
issues due to incompatibilities w/ the updated PHP which I fixed.  This new
server is now running http://www.hindupedia.com

2. Created a backup image of the VM running http://www.hindupedia.com (on
Rackspace Cloud) and created a new server with that image (which is now
http://www.hindupedia.org)

I don't think that this is due to collisions as the updated MySQL and old
mediawiki running on a new version of PHP didn't have any problems (this is
hindupedia.com).

I also didn't export/import the database between hindupedia.com (running
updated OS/PHP but v1.16 of mediawiki) and hindupedia.org (running new
mediawiki).  So, don't think that this i the problem.

Since hindupedia.com is live and doesn't have any issues with the
multi-byte characters (and was where I migrated the data from the old mysql
to the new mysql), I think issue is happening due to something the
update.php script does (or doesn't do).

Any other ideas?

Thanks!

Krishna


--------------------------------------------------------------------------------
Krishna Maheshwari
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------

On Sat, Nov 14, 2015 at 7:00 AM, <[hidden email]>
wrote:

> Send MediaWiki-l mailing list submissions to
>         [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> or, via email, send a message with subject or body 'help' to
>         [hidden email]
>
> You can reach the person managing the list at
>         [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of MediaWiki-l digest..."
>
>
> Today's Topics:
>
>    1. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
>       of multi-byte article titles & articles (Ray Paseur)
>    2. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
>       of multi-byte article titles & articles (Bartosz Dziewoński)
>    3. [External_Data] Selection of language, country, cities,   etc
>       (Ed Hoo)
>    4. Email problem following 1.16 to 1.25 conversion (Cal Frye)
>    5. Re: Email problem following 1.16 to 1.25 conversion
>       (Thomas Mulhall)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 13 Nov 2015 14:25:15 +0000
> From: Ray Paseur <[hidden email]>
> To: "[hidden email]"
>         <[hidden email]>
> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
>         in corruption of multi-byte article titles & articles
> Message-ID:
>         <
> [hidden email]
> >
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> KKM: Sorry that I do not have a direct solution to the issue, but I have
> seen and researched similar issues in other sites.  This article should
> help explain what may be happening and offer some pointers.  The version
> level of PHP may be in play.
>
> http://iconoun.com/articles/collisions/
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 13 Nov 2015 16:21:19 +0100
> From: Bartosz Dziewoński <[hidden email]>
> To: MediaWiki announcements and site admin list
>         <[hidden email]>
> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
>         in corruption of multi-byte article titles & articles
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> I think something went wrong when you exported and imported the
> database. (I assume that's how you got the two sites up at the same
> time?) MediaWiki always stores all text in the UTF-8 encoding,
> and in the database, the encoding of the fields is marker as either
> "binary" or "utf8" (the former is recommended due to problems with older
> MySQL versions).
>
> My guess is that in the `page` table, the `page_title` field was marked
> as being in some different encoding. This does not normally cause
> problems (MediaWiki doesn't use any of MySQL encoding conversion
> functions), but when you exported it, MySQL tried to interpret the UTF-8
> bytes as whatever-encoding bytes and converted that to UTF-8. When you
> imported, the data was already damaged.
>
> If that's indeed the case (I'm just guessing), change the encoding of
> the field in the original table (do not convert or re-encode the data,
> it's correct, just marked wrong) and try to re-export and re-import that
> table.
>
> --
> Bartosz Dziewoński
>
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 13 Nov 2015 16:11:21 -0500
> From: Ed Hoo <[hidden email]>
> To: MediaWiki announcements and site admin list
>         <[hidden email]>
> Subject: [MediaWiki-l] [External_Data] Selection of language, country,
>         cities, etc
> Message-ID: <[hidden email]>
> Content-Type: text/plain;       charset=us-ascii
>
> Hi everyone,
>
> When using cargo and semantic forms, what is the best way to keep large
> lists of valid values.
> https://www.mediawiki.org/wiki/Extension:External_Data seems like a
> reasonable option.  Am I overlooking a simpler option for relatively large
> lists?
>
> As a separate question is there a way that allows for pick-lists to be
> organized in a hierarchical manner?  In the past, instead of using a
> dropdown listbox or combo box I used a popup menu with a submenu and that
> made selecting a value from a list with 100-200 choices very easy and very
> fast for the user.  Short of using 2 fields (one conditional on the other)
> what are the options in the wiki universe?!!
>
> PS.  Thanks for the tip on the data import extension!!
>
> Thanks again!
> -Ed
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 13 Nov 2015 17:14:12 -0500
> From: Cal Frye <[hidden email]>
> To: [hidden email]
> Subject: [MediaWiki-l] Email problem following 1.16 to 1.25 conversion
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> We did a migration and conversion from v.1.16 to 1.25.3 on a new server,
> using XAMPP as our base. Generally, it worked well, thanks for that!
>
> We have a lingering problem, however, in sending email, including
> confirmation messages, password resets, etc. No mail is sent, and the
> error, "Unknown error in PHP's mail() function." is returned.
>
> Google suggests two small changes in the UserMailer.php file, both
> having to do with the $headers variable. Neither fix works, however, in
> our case. I've scanned the archives of this list back to January, and
> didn't see anything there that seemed like this problem.
>
> Can anyone point me in the right direction? Many thanks!
>
> Cal Frye
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 13 Nov 2015 23:23:16 +0000
> From: Thomas Mulhall <[hidden email]>
> To: [hidden email]
> Subject: Re: [MediaWiki-l] Email problem following 1.16 to 1.25
>         conversion
> Message-ID:
>         <[hidden email]>
> Content-Type: text/plain; charset=utf-8
>
> Hi quick questions did you also update xampp since updating that may fix
> problem. Also what php version are you using. MediaWiki 1.25 supports php
> 5.3 or higher. And also in your local settings.php file you may need to
> either regenerate it so that it is much easier to update meaning you re
> generate the local settings file then copying it over to the
> localsettings.php file. Also removed when regenerating it by going to the
> sub folder w-config that localsettings.php should be temporary renamed so
> localsettings.php can be regenerated. Then rename file back and copy over
> from the new file to the old.
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
>
> ------------------------------
>
> End of MediaWiki-l Digest, Vol 146, Issue 14
> ********************************************
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Paladox
Maybe try running the updated in browser meaning going to sub mw-config go through the options then enter your upgrade key which can be found in your localsettings.php file. But question did you generate a new localsettings.php file since I think in 1.16 they had a adminsettings.php file or something similar I may be wrong. But try updating to see.
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by Krishna Maheshwari
I forgot to mention that this is only happening for article titles are not
article content which is multi-byte

Krishna

On Saturday, November 14, 2015, Krishna Maheshwari <
[hidden email]> wrote:

> Thank you for your responses.
>
> The way I upgraded (to date) from the original 1.16 version to 1.25 was to
>
> 1. Upgrade the server which was running an outdated version of Debian.
> So, I created a new server with the current stable distro of Debian and
> copied the MySQL db to the new version of MySQL on the new server.  I
> copied the mediawiki (v 1.16) to the new server as well.  This resulted in
> a few minor issues due to incompatibilities w/ the updated PHP which I
> fixed.  This new server is now running http://www.hindupedia.com
>
> 2. Created a backup image of the VM running http://www.hindupedia.com (on
> Rackspace Cloud) and created a new server with that image (which is now
> http://www.hindupedia.org)
>
> I don't think that this is due to collisions as the updated MySQL and old
> mediawiki running on a new version of PHP didn't have any problems (this is
> hindupedia.com).
>
> I also didn't export/import the database between hindupedia.com (running
> updated OS/PHP but v1.16 of mediawiki) and hindupedia.org (running new
> mediawiki).  So, don't think that this i the problem.
>
> Since hindupedia.com is live and doesn't have any issues with the
> multi-byte characters (and was where I migrated the data from the old mysql
> to the new mysql), I think issue is happening due to something the
> update.php script does (or doesn't do).
>
> Any other ideas?
>
> Thanks!
>
> Krishna
>
>
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>
> --------------------------------------------------------------------------------
>
> On Sat, Nov 14, 2015 at 7:00 AM, <[hidden email]
> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> wrote:
>
>> Send MediaWiki-l mailing list submissions to
>>         [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>> or, via email, send a message with subject or body 'help' to
>>         [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>>
>> You can reach the person managing the list at
>>         [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of MediaWiki-l digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
>>       of multi-byte article titles & articles (Ray Paseur)
>>    2. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
>>       of multi-byte article titles & articles (Bartosz Dziewoński)
>>    3. [External_Data] Selection of language, country, cities,   etc
>>       (Ed Hoo)
>>    4. Email problem following 1.16 to 1.25 conversion (Cal Frye)
>>    5. Re: Email problem following 1.16 to 1.25 conversion
>>       (Thomas Mulhall)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Fri, 13 Nov 2015 14:25:15 +0000
>> From: Ray Paseur <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> To: "[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>"
>>         <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
>>         in corruption of multi-byte article titles & articles
>> Message-ID:
>>         <
>> [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> >
>>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> KKM: Sorry that I do not have a direct solution to the issue, but I have
>> seen and researched similar issues in other sites.  This article should
>> help explain what may be happening and offer some pointers.  The version
>> level of PHP may be in play.
>>
>> http://iconoun.com/articles/collisions/
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Fri, 13 Nov 2015 16:21:19 +0100
>> From: Bartosz Dziewoński <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> To: MediaWiki announcements and site admin list
>>         <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
>>         in corruption of multi-byte article titles & articles
>> Message-ID: <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> Content-Type: text/plain; charset=utf-8; format=flowed
>>
>> I think something went wrong when you exported and imported the
>> database. (I assume that's how you got the two sites up at the same
>> time?) MediaWiki always stores all text in the UTF-8 encoding,
>> and in the database, the encoding of the fields is marker as either
>> "binary" or "utf8" (the former is recommended due to problems with older
>> MySQL versions).
>>
>> My guess is that in the `page` table, the `page_title` field was marked
>> as being in some different encoding. This does not normally cause
>> problems (MediaWiki doesn't use any of MySQL encoding conversion
>> functions), but when you exported it, MySQL tried to interpret the UTF-8
>> bytes as whatever-encoding bytes and converted that to UTF-8. When you
>> imported, the data was already damaged.
>>
>> If that's indeed the case (I'm just guessing), change the encoding of
>> the field in the original table (do not convert or re-encode the data,
>> it's correct, just marked wrong) and try to re-export and re-import that
>> table.
>>
>> --
>> Bartosz Dziewoński
>>
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Fri, 13 Nov 2015 16:11:21 -0500
>> From: Ed Hoo <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> To: MediaWiki announcements and site admin list
>>         <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> Subject: [MediaWiki-l] [External_Data] Selection of language, country,
>>         cities, etc
>> Message-ID: <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> >
>> Content-Type: text/plain;       charset=us-ascii
>>
>> Hi everyone,
>>
>> When using cargo and semantic forms, what is the best way to keep large
>> lists of valid values.
>> https://www.mediawiki.org/wiki/Extension:External_Data seems like a
>> reasonable option.  Am I overlooking a simpler option for relatively large
>> lists?
>>
>> As a separate question is there a way that allows for pick-lists to be
>> organized in a hierarchical manner?  In the past, instead of using a
>> dropdown listbox or combo box I used a popup menu with a submenu and that
>> made selecting a value from a list with 100-200 choices very easy and very
>> fast for the user.  Short of using 2 fields (one conditional on the other)
>> what are the options in the wiki universe?!!
>>
>> PS.  Thanks for the tip on the data import extension!!
>>
>> Thanks again!
>> -Ed
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Fri, 13 Nov 2015 17:14:12 -0500
>> From: Cal Frye <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> To: [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> Subject: [MediaWiki-l] Email problem following 1.16 to 1.25 conversion
>> Message-ID: <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> Hi,
>>
>> We did a migration and conversion from v.1.16 to 1.25.3 on a new server,
>> using XAMPP as our base. Generally, it worked well, thanks for that!
>>
>> We have a lingering problem, however, in sending email, including
>> confirmation messages, password resets, etc. No mail is sent, and the
>> error, "Unknown error in PHP's mail() function." is returned.
>>
>> Google suggests two small changes in the UserMailer.php file, both
>> having to do with the $headers variable. Neither fix works, however, in
>> our case. I've scanned the archives of this list back to January, and
>> didn't see anything there that seemed like this problem.
>>
>> Can anyone point me in the right direction? Many thanks!
>>
>> Cal Frye
>>
>>
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Fri, 13 Nov 2015 23:23:16 +0000
>> From: Thomas Mulhall <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
>> To: [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> Subject: Re: [MediaWiki-l] Email problem following 1.16 to 1.25
>>         conversion
>> Message-ID:
>>         <[hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> >
>> Content-Type: text/plain; charset=utf-8
>>
>> Hi quick questions did you also update xampp since updating that may fix
>> problem. Also what php version are you using. MediaWiki 1.25 supports php
>> 5.3 or higher. And also in your local settings.php file you may need to
>> either regenerate it so that it is much easier to update meaning you re
>> generate the local settings file then copying it over to the
>> localsettings.php file. Also removed when regenerating it by going to the
>> sub folder w-config that localsettings.php should be temporary renamed so
>> localsettings.php can be regenerated. Then rename file back and copy over
>> from the new file to the old.
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>> MediaWiki-l mailing list
>> [hidden email]
>> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>>
>>
>> ------------------------------
>>
>> End of MediaWiki-l Digest, Vol 146, Issue 14
>> ********************************************
>>
>
>

--
--------------------------------------------------------------------------------
Krishna Maheshwari
[hidden email]
[hidden email]
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

John Doe-27
do wiki links work and take you to the correct page?

On Sat, Nov 14, 2015 at 9:21 PM, kkm <[hidden email]> wrote:

> I forgot to mention that this is only happening for article titles are not
> article content which is multi-byte
>
> Krishna
>
> On Saturday, November 14, 2015, Krishna Maheshwari <
> [hidden email]> wrote:
>
> > Thank you for your responses.
> >
> > The way I upgraded (to date) from the original 1.16 version to 1.25 was
> to
> >
> > 1. Upgrade the server which was running an outdated version of Debian.
> > So, I created a new server with the current stable distro of Debian and
> > copied the MySQL db to the new version of MySQL on the new server.  I
> > copied the mediawiki (v 1.16) to the new server as well.  This resulted
> in
> > a few minor issues due to incompatibilities w/ the updated PHP which I
> > fixed.  This new server is now running http://www.hindupedia.com
> >
> > 2. Created a backup image of the VM running http://www.hindupedia.com
> (on
> > Rackspace Cloud) and created a new server with that image (which is now
> > http://www.hindupedia.org)
> >
> > I don't think that this is due to collisions as the updated MySQL and old
> > mediawiki running on a new version of PHP didn't have any problems (this
> is
> > hindupedia.com).
> >
> > I also didn't export/import the database between hindupedia.com (running
> > updated OS/PHP but v1.16 of mediawiki) and hindupedia.org (running new
> > mediawiki).  So, don't think that this i the problem.
> >
> > Since hindupedia.com is live and doesn't have any issues with the
> > multi-byte characters (and was where I migrated the data from the old
> mysql
> > to the new mysql), I think issue is happening due to something the
> > update.php script does (or doesn't do).
> >
> > Any other ideas?
> >
> > Thanks!
> >
> > Krishna
> >
> >
> >
> >
> --------------------------------------------------------------------------------
> > Krishna Maheshwari
> > Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
> >
> >
> --------------------------------------------------------------------------------
> >
> > On Sat, Nov 14, 2015 at 7:00 AM, <
> [hidden email]
> > <javascript:_e(%7B%7D,'cvml','[hidden email]
> ');>>
> > wrote:
> >
> >> Send MediaWiki-l mailing list submissions to
> >>         [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
> >>
> >> To subscribe or unsubscribe via the World Wide Web, visit
> >>         https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >> or, via email, send a message with subject or body 'help' to
> >>         [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]
> ');>
> >>
> >> You can reach the person managing the list at
> >>         [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
> >>
> >> When replying, please edit your Subject line so it is more specific
> >> than "Re: Contents of MediaWiki-l digest..."
> >>
> >>
> >> Today's Topics:
> >>
> >>    1. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
> >>       of multi-byte article titles & articles (Ray Paseur)
> >>    2. Re: Upgrading from v1.16.5 to 1.25.3 resulting in corruption
> >>       of multi-byte article titles & articles (Bartosz Dziewoński)
> >>    3. [External_Data] Selection of language, country, cities,   etc
> >>       (Ed Hoo)
> >>    4. Email problem following 1.16 to 1.25 conversion (Cal Frye)
> >>    5. Re: Email problem following 1.16 to 1.25 conversion
> >>       (Thomas Mulhall)
> >>
> >>
> >> ----------------------------------------------------------------------
> >>
> >> Message: 1
> >> Date: Fri, 13 Nov 2015 14:25:15 +0000
> >> From: Ray Paseur <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> To: "[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>"
> >>         <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
> >>         in corruption of multi-byte article titles & articles
> >> Message-ID:
> >>         <
> >>
> [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','
> [hidden email]
> ');>
> >> >
> >>
> >> Content-Type: text/plain; charset="iso-8859-1"
> >>
> >> KKM: Sorry that I do not have a direct solution to the issue, but I have
> >> seen and researched similar issues in other sites.  This article should
> >> help explain what may be happening and offer some pointers.  The version
> >> level of PHP may be in play.
> >>
> >> http://iconoun.com/articles/collisions/
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 2
> >> Date: Fri, 13 Nov 2015 16:21:19 +0100
> >> From: Bartosz Dziewoński <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> To: MediaWiki announcements and site admin list
> >>         <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> Subject: Re: [MediaWiki-l] Upgrading from v1.16.5 to 1.25.3 resulting
> >>         in corruption of multi-byte article titles & articles
> >> Message-ID: <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> Content-Type: text/plain; charset=utf-8; format=flowed
> >>
> >> I think something went wrong when you exported and imported the
> >> database. (I assume that's how you got the two sites up at the same
> >> time?) MediaWiki always stores all text in the UTF-8 encoding,
> >> and in the database, the encoding of the fields is marker as either
> >> "binary" or "utf8" (the former is recommended due to problems with older
> >> MySQL versions).
> >>
> >> My guess is that in the `page` table, the `page_title` field was marked
> >> as being in some different encoding. This does not normally cause
> >> problems (MediaWiki doesn't use any of MySQL encoding conversion
> >> functions), but when you exported it, MySQL tried to interpret the UTF-8
> >> bytes as whatever-encoding bytes and converted that to UTF-8. When you
> >> imported, the data was already damaged.
> >>
> >> If that's indeed the case (I'm just guessing), change the encoding of
> >> the field in the original table (do not convert or re-encode the data,
> >> it's correct, just marked wrong) and try to re-export and re-import that
> >> table.
> >>
> >> --
> >> Bartosz Dziewoński
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 3
> >> Date: Fri, 13 Nov 2015 16:11:21 -0500
> >> From: Ed Hoo <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> To: MediaWiki announcements and site admin list
> >>         <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> Subject: [MediaWiki-l] [External_Data] Selection of language, country,
> >>         cities, etc
> >> Message-ID: <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','
> [hidden email]');>
> >> >
> >> Content-Type: text/plain;       charset=us-ascii
> >>
> >> Hi everyone,
> >>
> >> When using cargo and semantic forms, what is the best way to keep large
> >> lists of valid values.
> >> https://www.mediawiki.org/wiki/Extension:External_Data seems like a
> >> reasonable option.  Am I overlooking a simpler option for relatively
> large
> >> lists?
> >>
> >> As a separate question is there a way that allows for pick-lists to be
> >> organized in a hierarchical manner?  In the past, instead of using a
> >> dropdown listbox or combo box I used a popup menu with a submenu and
> that
> >> made selecting a value from a list with 100-200 choices very easy and
> very
> >> fast for the user.  Short of using 2 fields (one conditional on the
> other)
> >> what are the options in the wiki universe?!!
> >>
> >> PS.  Thanks for the tip on the data import extension!!
> >>
> >> Thanks again!
> >> -Ed
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 4
> >> Date: Fri, 13 Nov 2015 17:14:12 -0500
> >> From: Cal Frye <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> To: [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
> >> Subject: [MediaWiki-l] Email problem following 1.16 to 1.25 conversion
> >> Message-ID: <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> Content-Type: text/plain; charset=ISO-8859-1
> >>
> >> Hi,
> >>
> >> We did a migration and conversion from v.1.16 to 1.25.3 on a new server,
> >> using XAMPP as our base. Generally, it worked well, thanks for that!
> >>
> >> We have a lingering problem, however, in sending email, including
> >> confirmation messages, password resets, etc. No mail is sent, and the
> >> error, "Unknown error in PHP's mail() function." is returned.
> >>
> >> Google suggests two small changes in the UserMailer.php file, both
> >> having to do with the $headers variable. Neither fix works, however, in
> >> our case. I've scanned the archives of this list back to January, and
> >> didn't see anything there that seemed like this problem.
> >>
> >> Can anyone point me in the right direction? Many thanks!
> >>
> >> Cal Frye
> >>
> >>
> >>
> >> ------------------------------
> >>
> >> Message: 5
> >> Date: Fri, 13 Nov 2015 23:23:16 +0000
> >> From: Thomas Mulhall <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>>
> >> To: [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
> >> Subject: Re: [MediaWiki-l] Email problem following 1.16 to 1.25
> >>         conversion
> >> Message-ID:
> >>         <[hidden email]
> >> <javascript:_e(%7B%7D,'cvml','
> [hidden email]');>
> >> >
> >> Content-Type: text/plain; charset=utf-8
> >>
> >> Hi quick questions did you also update xampp since updating that may fix
> >> problem. Also what php version are you using. MediaWiki 1.25 supports
> php
> >> 5.3 or higher. And also in your local settings.php file you may need to
> >> either regenerate it so that it is much easier to update meaning you re
> >> generate the local settings file then copying it over to the
> >> localsettings.php file. Also removed when regenerating it by going to
> the
> >> sub folder w-config that localsettings.php should be temporary renamed
> so
> >> localsettings.php can be regenerated. Then rename file back and copy
> over
> >> from the new file to the old.
> >>
> >> ------------------------------
> >>
> >> Subject: Digest Footer
> >>
> >> _______________________________________________
> >> MediaWiki-l mailing list
> >> [hidden email]
> >> <javascript:_e(%7B%7D,'cvml','[hidden email]');>
> >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >>
> >>
> >> ------------------------------
> >>
> >> End of MediaWiki-l Digest, Vol 146, Issue 14
> >> ********************************************
> >>
> >
> >
>
> --
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> [hidden email]
> [hidden email]
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>
> --------------------------------------------------------------------------------
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by Krishna Maheshwari
Thanks for your ideas.  I re-imaged the server to start the upgrade process
again.  Tried using mw-config from a browser (installing INTL, and all
other dependencies it suggested).

FYI, my 1.16 version used LocalSettings.php which I kept.  I didn't start
it from scratch with the upgraded install...There is also an
AdminSettings.php which contains the MySQL login/pw for use by the
maintenance scripts.

The wikilinks work but they also got corrupted along with the article title.

E.g.,
http://www.hindupedia.org/en/Category:Concise_Encyclopedia_of_Hinduism

Has a link to an article entitled "Adbhuta BrÄ hmaṇa" which works (links
to
http://www.hindupedia.org/en/Adbhuta_Br%C3%84%C2%81hma%C3%A1%C2%B9%E2%80%A1a
)

The first link in the article has proper multi-byte characters ("Adbhuta
Brāhmaṇa literally means wonderful or strange Brāhmaṇa.")

This title should be "Adbhuta Brāhmaṇa
<http://www.hindupedia.com/en/Adbhuta_Br%C4%81hma%E1%B9%87a>"

Best Regards,

Krishna

<NOTE :removing thread history because to much other stuff was embedded in
it due to the digest>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Paladox
Thanks for replying. Adminsettings.php was removed in i think mediawiki 1.17 and above. So please regenerate the localsettings.php because new settings were added. I would suggest doing another install of MediaWiki on a sub domain create the localsettings.php file for the website your doing and copying the bits that look odd but also keeping the extensions as they are.

Please see https://www.mediawiki.org/wiki/Manual:AdminSettings.php and try that first read the upgrading section.
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Marcin Cieslak-3
In reply to this post by Krishna Maheshwari
On 2015-11-14, Krishna Maheshwari <[hidden email]> wrote:
> Thank you for your responses.

> I created a new server with the current stable distro of Debian and copied
> the MySQL db to the new version of MySQL on the new server.

this is why I dislike Linux distribution model - upgrade sll or nothing.

what was the old MySQL version? the new one?

what exactly do you mean by "Copied mysql db"? just copied the files? using myisam
or innodb?

can you have a look at: 1) changed my.ini defaults after upgrade. 2) encoding
of the "page" table before and after the upgrade. 3) contents of "page" table before
and after upgrade?

As Bartosz suggested the raw data are probably correct just some metadata/encoding settings
changed.


Saper 2) encoding
of the "page" table before and after the upgrade. 3) contents of "page" table before
and after upgrade?

As Bartosz suggested the raw data are probably correct just some metadata/encoding settings
changed.


Saper


_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by Krishna Maheshwari
Continuing to dig into this...

Below are page table descriptions from mysql:
-----PAGE TABLE STATUS BEFORE UPGRADE-----
mysql> SHOW TABLE STATUS  WHERE  `NAME` LIKE  '%page%';
+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name              | Engine | Version | Row_format | Rows  |
Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time         | Update_time | Check_time |
Collation       | Checksum | Create_options | Comment |
+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| page              | InnoDB |      10 | Compact    | 12461 |
127 |     1589248 |               0 |      2162688 |  11534336 |
14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
| page_props        | InnoDB |      10 | Compact    |     0 |
0 |       16384 |               0 |            0 |  11534336 |
NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
| page_restrictions | InnoDB |      10 | Compact    |     2 |
8192 |       16384 |               0 |        65536 |  11534336
|              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
utf8_general_ci |     NULL |                |         |
| pagelinks         | InnoDB |      10 | Compact    | 28377 |
56 |     1589248 |               0 |      1589248 |  11534336 |
NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
mysql> SHOW COLUMNS FROM page;
+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        |
Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| page_id           | int(10) unsigned    | NO   | PRI | NULL           |
auto_increment |
| page_namespace    | int(11)             | NO   | MUL | NULL
|                |
| page_title        | varchar(255)        | NO   |     | NULL
|                |
| page_restrictions | tinyblob            | NO   |     | NULL
|                |
| page_counter      | bigint(20) unsigned | NO   |     | 0
|                |
| page_is_redirect  | tinyint(3) unsigned | NO   |     | 0
|                |
| page_is_new       | tinyint(3) unsigned | NO   |     | 0
|                |
| page_random       | double unsigned     | NO   | MUL | NULL
|                |
| page_touched      | binary(14)          | NO   |     |
|                |
| page_latest       | int(10) unsigned    | NO   |     | NULL
|                |
| page_len          | int(10) unsigned    | NO   | MUL | NULL
|                |
+-------------------+---------------------+------+-----+----------------+----------------+
mysql> select page_id,page_title from page where page_title like 'Adhik%';
+---------+----------------------------+
| page_id | page_title                 |
+---------+----------------------------+
|   11974 | Adhikamasa                 |
|   11975 | Adhikamasa,_adhimasa       |
|    7128 | AdhikamÄ sa                |
|    6658 | AdhikamÄ sa,_adhimÄ sa     |
|   11977 | Adhikara                   |
|   11978 | Adhikara_Nandi             |
|   11976 | Adhikarana                 |
|    6660 | Adhikaraṇa               |
|    6659 | AdhikÄ ra                  |
|    6661 | AdhikÄ ra_Nandi            |
|    7126 | AdhikamÄ sa,_adhimÄ sa     |
|    7117 | Adhikaraṇa               |
|    7125 | AdhikÄ ra                  |
|    7118 | AdhikÄ ra_Nandi            |
+---------+----------------------------+
-----PAGE TABLE STATUS AFTER UPGRADE-----

+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name              | Engine | Version | Row_format | Rows  |
Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time         | Update_time | Check_time |
Collation       | Checksum | Create_options | Comment |
+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| page              | InnoDB |      10 | Compact    | 11883 |
133 |     1589248 |               0 |      2162688 | 111149056 |
14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
| page_props        | InnoDB |      10 | Compact    |     0 |
0 |       16384 |               0 |            0 | 111149056 |
NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
| page_restrictions | InnoDB |      10 | Compact    |     2 |
8192 |       16384 |               0 |        65536 | 111149056
|              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
utf8_general_ci |     NULL |                |         |
| pagelinks         | InnoDB |      10 | Compact    | 28765 |
55 |     1589248 |               0 |      1589248 | 111149056 |
NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
|     NULL |                |         |
+-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
mysql> select page_id,page_title from page where page_title like 'Adhik%';
+---------+----------------------------+
| page_id | page_title                 |
+---------+----------------------------+
|   11974 | Adhikamasa                 |
|   11975 | Adhikamasa,_adhimasa       |
|    7128 | AdhikamÄ sa                |
|    6658 | AdhikamÄ sa,_adhimÄ sa     |
|   11977 | Adhikara                   |
|   11978 | Adhikara_Nandi             |
|   11976 | Adhikarana                 |
|    6660 | Adhikaraṇa               |
|    6659 | AdhikÄ ra                  |
|    6661 | AdhikÄ ra_Nandi            |
|    7126 | AdhikamÄ sa,_adhimÄ sa     |
|    7117 | Adhikaraṇa               |
|    7125 | AdhikÄ ra                  |
|    7118 | AdhikÄ ra_Nandi            |
+---------+----------------------------+


Not sure if this is correct, but I came across
http://product.hubspot.com/bid/7049/MySQL-and-Unicode-Three-Gotchas

which suggested that the page_title field could be improperly encoded (as
varchar 255 instead of utf8).

I tried to do

ALTER TABLE page MODIFY page_title VARCHAR(255) CHARACTER SET utf8;

But there are way too many conflicts/duplicates in the key page_name which
prevents me from doing it w/o dropping the index.  BTW, if I do it, I can't
recreate it with the "UNIQUE" property which it has right now due to the
duplicates.


https://www.mediawiki.org/wiki/Manual:MWDumper
Suggests that the character type should be set to Binary to prevent these
types of issues...but not sure what I need to do to get there from where I
am right now.

Any ideas?

Thanks,

Krishna
--------------------------------------------------------------------------------
Krishna Maheshwari
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Paladox
Hi what does your LocalSettings.php file look like please copy.

Note please comment out passwords and other personal data including upgrade key and security key and other data you think you doing want others seeing.
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by kkm
Below is my LocalSettings.php w/ sensitive info (e.g., logins/pw) blanked
out.

Best Regards,

Krishna

<?php

# This file was automatically generated by the MediaWiki installer.
# If you make manual changes, please keep track in case you need to
# recreate them later.
#
# See includes/DefaultSettings.php for all configurable settings
# and their default values, but don't forget to make changes in _this_
# file, not there.
#
# Further documentation for configuration settings may be found at:
# http://www.mediawiki.org/wiki/Manual:Configuration_settings

# If you customize your file layout, set $IP to the directory that contains
# the other MediaWiki files. It will be used as a base to locate files.
if( defined( 'MW_INSTALL_PATH' ) ) {
    $IP = MW_INSTALL_PATH;
} else {
    $IP = dirname( __FILE__ );
}

$path = array( $IP, "$IP/includes", "$IP/languages" );
set_include_path( implode( PATH_SEPARATOR, $path ) . PATH_SEPARATOR .
get_include_path() );

require_once( "$IP/includes/DefaultSettings.php" );
require_once( "{$IP}/extensions/NewUserNotif/NewUserNotif.php" );

#add extension to add <ref> tags
require_once( $IP.'/extensions/Cite/Cite.php' );


# If PHP's memory limit is very low, some operations may fail.
# ini_set( 'memory_limit', '20M' );
# make sure php can find mail api
ini_set ('include_path', get_include_path() . PATH_SEPARATOR .
'/usr/share/php/');

if ( $wgCommandLineMode ) {
    if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER
) ) {
        die( "This script must be run from the command line\n" );
    }
}
## Uncomment this to disable output compression
# $wgDisableOutputCompression = true;
#$wgDisableOutputCompression = false;

$wgSitename         = "Hindupedia, the Hindu Encyclopedia";

## The URL base path to the directory containing the wiki;
## defaults for all runtime URL paths are based off of this.
## For more information on customizing the URLs please see:
## http://www.mediawiki.org/wiki/Manual:Short_URL
$wgScriptPath       = "/eng"; #virtual path (right part of the first
rewrite rule)
$wgScriptExtension  = ".php";
$wgArticlePath = "/en/$1"; #virtual path (left part of first rewrite rule)
$wgUsePathInfo = true;


$wgEnableWriteAPI = true;
$wgEnableEmail      = true;
$wgEnableUserEmail  = true; # UPO

$wgEmergencyContact = "[hidden email]";
$wgPasswordSender = "[hidden email]";

## For a detailed description of the following switches see
## http://www.mediawiki.org/wiki/Extension:Email_notification
## and http://www.mediawiki.org/wiki/Extension:Email_notification
## There are many more options for fine tuning available see
## /includes/DefaultSettings.php
## UPO means: this is also a user preference option
$wgEnotifUserTalk = true; # UPO
$wgEnotifWatchlist = true; # UPO
$wgEmailAuthentication = true;

$wgDBtype           = "mysql";

$wgDBname           = "HindupediaMySQL";
$wgDBserver         = "localhost";
$wgDBuser           = ""; ##blanked out
$wgDBpassword       = ""; ##blanked out

# MySQL specific settings
$wgDBprefix         = "";

# MySQL table options to use during installation or update
$wgDBTableOptions   = "TYPE=InnoDB";

# Experimental charset support for MySQL 4.1/5.0.
$wgDBmysql5 = false;

# Postgres specific settings
$wgDBport           = "5432";
$wgDBmwschema       = "mediawiki";
$wgDBts2schema      = "public";

## Shared memory settings
$wgMainCacheType = CACHE_ACCEL; /* default: CACHE_NONE */
#$wgMemCachedServers = array();

## To enable image uploads, make sure the 'images' directory
## is writable, then set this to true:
$wgEnableUploads = true;
$wgUseImageMagick = true;
$wgImageMagickConvertCommand = "/usr/bin/convert";

## If you use ImageMagick (or any other shell command) on a
## Linux server, this will need to be set to the name of an
## available UTF-8 locale
$wgShellLocale = "en_US.UTF-8";

$wgUploadPath = "$wgScriptPath/images";
$wgUploadDirectory = "$IP/images";

#make links case in-sensitive
#$wgCapitalLinks = false;

$wgMimeDetectorCommand = "file -bi";

#mime type detection for pptx is incorrect...hence, disable mime type
checking for uploading it
#$wgVerifyMimeType = false;

srand(time());
$random = (rand()%4);
if ($random == 1)
{
    $wgLogo = "$wgScriptPath/images/hindupediabanner400x73.gif";
}
else if ($random == 2)
{
    $wgLogo = "$wgScriptPath/images/hindupediabanner2_400x73.gif";
}
else if ($random == 3)
{
    $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-1.gif";
}
else
{
    $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-2.gif";
}

## If you want to use image uploads under safe mode,
## create the directories images/archive, images/thumb and
## images/temp, and make them all writable. Then uncomment
## this, if it's not already uncommented:
# $wgHashedUploadDirectory = false;

## If you have the appropriate support software installed
## you can enable inline LaTeX equations:
$wgUseTeX           = false;

$wgLocalInterwiki   = $wgSitename;

$wgLanguageCode = "en";

$wgSecretKey = ""; ##blanked out

## Default skin: you can change the default skin. Use the internal symbolic
## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook':
#wfLoadSkin( 'CologneBlue' );
#wfLoadSkin( 'Modern' );
#wfLoadSkin( 'MonoBook' );
#wfLoadSkin( 'Vector' );
$wgDefaultSkin = 'monobook';
#$wgDefaultSkin = "gumax";

## For attaching licensing metadata to pages, and displaying an
## appropriate copyright notice / icon. GNU Free Documentation
## License and Creative Commons licenses are supported so far.
$wgEnableCreativeCommonsRdf = true;
$wgRightsPage = ""; # Set to the title of a wiki page that describes your
license/copyright
$wgRightsUrl = "http://www.gnu.org/copyleft/fdl.html";
$wgRightsText = "GNU Free Documentation License 1.2";
$wgRightsIcon = "${wgScriptPath}/skins/common/images/gnu-fdl.png";
# $wgRightsCode = "gfdl"; # Not yet used

$wgDiff = "/usr/bin/diff";
$wgDiff3 = "/usr/bin/diff3";

# When you make changes to this configuration file, this will make
# sure that cached pages are cleared.
$wgCacheEpoch = max( $wgCacheEpoch, gmdate( 'YmdHis', @filemtime( __FILE__
) ) );

# user/group permissions
$wgGroupPermissions['*']['edit'] = false;
$wgGroupPermissions['user']['edit'] = true;
# $wgGroupPermissions['confirmed']['edit'] = true;

#disable anonymous talk
$wgDisableAnonTalk = true;


#enable support for SVG image file type
$wgFileExtensions[] = 'svg';
$wgAllowTitlesInSVG = true;
#$wgSVGConverter = '/usr/share/ImageMagick';
$wgSVGConverters = array(
    'ImageMagick' => '$path/convert -background white -thumbnail
$widthx$height\! $input PNG:$output',
    'sodipodi' => '$path/sodipodi -z -w $width -f $input -e $output',
    'inkscape' => '$path/inkscape -z -w $width -f $input -e $output',
    'batik' => 'java -Djava.awt.headless=true -jar
$path/batik-rasterizer.jar -w $width -d $output $input',
    'rsvg' => '/usr/bin/rsvg -w$width -h$height $input $output',
    'imgserv' => '$path/imgserv-wrapper -i svg -o png -w$width $input
$output',
);
$wgSVGConverter = 'rsvg' ;

#enable support for MS PowerPoint
$wgFileExtensions[] = 'pptx';
$wgFileExtensions[] = 'ppt';

#enable support for AAC audio files
$wgFileExtensions[] = 'm4a';

#### Google Analytics
##Migration edit
require_once( "$IP/extensions/googleAnalytics/googleAnalytics.php" );
# Replace xxxxxxx-x with YOUR GoogleAnalytics UA number
$wgGoogleAnalyticsAccount = ""; ##blanked out

$wgGoogleAnalyticsIgnoreSysops = true;
$wgGoogleAnalyticsIgnoreBots = true;

# misc mediawiki settings
$wgEnableMWSuggest = true;
$wgShowIPinHeader = false;

# Set address bar icon
$wgFavicon = "/favicon.ico";


################### ConfirmAccount
#confirm user extension settings
###KKM update incompatible###
#include_once('extensions/ConfirmAccount/SpecialConfirmAccount.php');
$wgMakeUserPageFromBio = true;
$wgUseRealNamesOnly = true;
$wgAccountRequestMinWords = 50;
$wgAccountRequestExtraInfo = true;
$wgAllowAccountRequestFiles = true;
$wgConfirmAccountSaveInfo = true;
$wgConfirmAccountContact = "[hidden email]";

#StubManager Extension
require_once( "{$IP}/extensions/StubManager/StubManager.php" );

#Header Footer extension
require_once( "{$IP}/extensions/HeaderFooter/HeaderFooter.php" );

#Random Pages Extension
$namespace=true; #restrict extension to global namespace
###KKM update incompatible###
#require_once( "{$IP}/extensions/RandomPages/RandomPages.php" );

#Category Tree Extension
$wgUseAjax = true;
##Migration edit
#require_once( "{$IP}/extensions/CategoryTree/CategoryTree.php" );

#Description plugin - adds metadata from intro paragraph of each article to
help with search engine indexing
require_once("$IP/extensions/Description/Description.php");

#Add poem function for sanskrit text
require_once($IP.'/extensions/Poem/Poem.php');

#Add AutoLink
###KKM update incompatible###
#require_once("$IP/extensions/Autolink/Autolink.php");

#Add Social Bookmarking link
require_once("$IP/extensions/Bookmark/bookmark.php");

#Add Google Search
require_once("extensions/GoogleSiteSearch/GoogleSiteSearch.php");

#Add collist
require_once("extensions/collist/collist.php");

#add imagemap
#require_once("$IP/extensions/ImageMap/ImageMap.php");

#add dynamic page list
#KKM update fail
#require_once("$IP/extensions/DynamicPageList/DynamicPageList2.php");

#add parser functiosn (required for most templates)
##migration edit
require_once("$IP/extensions/ParserFunctions/ParserFunctions.php");

#add article to category
#require_once("$IP/extensions/articletocategory/articletocategory.php");

#add page black list extension
require_once("$IP/extensions/blacklist/blacklist.php");
$wgWhitelist['user']['read']  = $wgBlacklist['*']['read'] =
array("Special:RecentChanges", "Special:Listusers", "Special:Ipblocklist",
"Special:Log", "Special:Allmessages", "User talk:Krishna Maheshwari");

#add embed video extension (enable adding videos from popular sites like
google video, you tube, etc
#KKM update fail###
#require_once("$IP/extensions/EmbedVideo/EmbedVideo.php");


#if ($wgUser->isLoggedIn())
#{
    #CharInsert -- allow clickable extra characters & tags for edit boxes
    require_once("$IP/extensions/CharInsert/CharInsert.php");
#}

#rss feeds
#works but doesn't transclude source
#require_once("$IP/extensions/rss/rss.php");

#rss feeds - removed to see if it improves performance
#require_once("$IP/extensions/feedimport/feedimport.php");

#works but provides links to source instead of transcluding it
#require_once("$IP/extensions/simplefeed/SimpleFeed.php");

#Add Minify--which strips extra stuff from css & js files to make them
smaller
require_once("$IP/extensions/Minify/Minify.php");

#use ETags to facilitate caching at intermediary layers & the browser
$wgUseETag=true; /* default: false */
#server to send pages in to the browser in a compressed format
#$wgUseGzip=true; /* default: false */

#cache sidebar ...
#$wgSidebarCacheExpiry = 86400s; /*default*/
$wgEnableSidebarCache = true; /* default: false */
#enable client side caching
$wgCachePages = true; /* default: true */

#ParserCache
$wgEnableParserCache = true; /* default:false*/
$wgMainCacheType = CACHE_ANYTHING; /* default: CACHE_ANYTHING */

# Enable the basic file cache for static pages for non-logged-in visitors
$wgUseFileCache = true; /* default: false */
$wgFileCacheDirectory = "$IP/cache";

#default is 1, changing to a higher number will be a little bit
# nicer to the database
$wgHitcounterUpdateFreq = 100;

$wgExtraNamespaces[100] = "Quotes";
$wgExtraNamespaces[101] = "Quotes_talk";
$wgExtraNamespaces[102] = "Internal";
$wgExtraNamespaces[103] = "Internal_talk";
$wgExtraNamespaces[104] = "SupportUs";
$wgExtraNamespaces[105] = "SupportUs_talk";


#CSO_SiteAd - allow javascript inside protected wiki pages (ie
reciprocalURL)
#require_once("$IP/extensions/CSO_SiteAd/CSO_SiteAd.php");

####################### System Administration Extensions
#######################
##################### Enable only when needed, then disable
####################
#User Merge & Delete Extension
#KKM update fail###
#require_once( "$IP/extensions/UserMerge/UserMerge.php" );
$wgGroupPermissions['bureaucrat']['usermerge'] = true;

#optional - default is array( 'sysop' )
#$wgUserMergeProtectedGroups = array( 'groupname' );

#Usage Statistics
#KKM update fail###
#require_once( "{$IP}/extensions/UsageStatistics/SpecialUserStats.php" );
$wgUserStatsGoogleCharts = 1;

#SpecialLastUserLoginEx
#KKM update fail###
#require_once( "$IP/extensions/UserStats/SpecialLastUserLogin.php" );
$wgGroupPermissions['sysop']['lastlogin'] = true;


################################################################################
####################### Sending Email #######################
################################################################################
$wgSMTP = array(
        'host' => 'ssl://smtp.gmail.com',
        'IDHost' => 'hindupedia.com',
        'port' => 465,
        'username' => '', ##blanked out
        'password' => '', ##blanked out
        'auth' => true
     );

#$wgReadOnly = 'This wiki is currently being upgraded to a newer software
version.';
#require_once( "$IP/extensions/JsonConfig/JsonConfig.php" );
require_once( "$IP/extensions/PayPal.php" );
require_once( "$IP/extensions/MiniDonation/MiniDonation.php" );
require_once( "$IP/extensions/IAST/IAST.php" );
$wgShowExceptionDetails = true;
$wgShowSQLErrors = true;
$wgDebugDumpSql  = true;
$wgShowDBErrorBacktrace = true;
#Shows PHP errors
#error_reporting( -1 );
#ini_set( 'display_errors', 1 );

$wgReadOnly = 'This wiki is currently being upgraded to a newer software
version.';
$wgUpgradeKey = ''; ##blanked out


--------------------------------------------------------------------------------
Krishna Maheshwari
[hidden email]
[hidden email]
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------

On Mon, Nov 16, 2015 at 10:48 PM, kkm <[hidden email]> wrote:

> Continuing to dig into this...
>
> Below are page table descriptions from mysql:
> -----PAGE TABLE STATUS BEFORE UPGRADE-----
> mysql> SHOW TABLE STATUS  WHERE  `NAME` LIKE  '%page%';
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> | Name              | Engine | Version | Row_format | Rows  |
> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
> Auto_increment | Create_time         | Update_time | Check_time |
> Collation       | Checksum | Create_options | Comment |
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> | page              | InnoDB |      10 | Compact    | 12461 |
> 127 |     1589248 |               0 |      2162688 |  11534336 |
> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
> | page_props        | InnoDB |      10 | Compact    |     0 |
> 0 |       16384 |               0 |            0 |  11534336 |
> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
> | page_restrictions | InnoDB |      10 | Compact    |     2 |
> 8192 |       16384 |               0 |        65536 |  11534336
> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
> utf8_general_ci |     NULL |                |         |
> | pagelinks         | InnoDB |      10 | Compact    | 28377 |
> 56 |     1589248 |               0 |      1589248 |  11534336 |
> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> mysql> SHOW COLUMNS FROM page;
>
> +-------------------+---------------------+------+-----+----------------+----------------+
> | Field             | Type                | Null | Key | Default        |
> Extra          |
>
> +-------------------+---------------------+------+-----+----------------+----------------+
> | page_id           | int(10) unsigned    | NO   | PRI | NULL           |
> auto_increment |
> | page_namespace    | int(11)             | NO   | MUL | NULL
> |                |
> | page_title        | varchar(255)        | NO   |     | NULL
> |                |
> | page_restrictions | tinyblob            | NO   |     | NULL
> |                |
> | page_counter      | bigint(20) unsigned | NO   |     | 0
> |                |
> | page_is_redirect  | tinyint(3) unsigned | NO   |     | 0
> |                |
> | page_is_new       | tinyint(3) unsigned | NO   |     | 0
> |                |
> | page_random       | double unsigned     | NO   | MUL | NULL
> |                |
> | page_touched      | binary(14)          | NO   |     |
> |                |
> | page_latest       | int(10) unsigned    | NO   |     | NULL
> |                |
> | page_len          | int(10) unsigned    | NO   | MUL | NULL
> |                |
>
> +-------------------+---------------------+------+-----+----------------+----------------+
> mysql> select page_id,page_title from page where page_title like 'Adhik%';
> +---------+----------------------------+
> | page_id | page_title                 |
> +---------+----------------------------+
> |   11974 | Adhikamasa                 |
> |   11975 | Adhikamasa,_adhimasa       |
> |    7128 | AdhikamÄ sa                |
> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
> |   11977 | Adhikara                   |
> |   11978 | Adhikara_Nandi             |
> |   11976 | Adhikarana                 |
> |    6660 | Adhikaraṇa               |
> |    6659 | AdhikÄ ra                  |
> |    6661 | AdhikÄ ra_Nandi            |
> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
> |    7117 | Adhikaraṇa               |
> |    7125 | AdhikÄ ra                  |
> |    7118 | AdhikÄ ra_Nandi            |
> +---------+----------------------------+
> -----PAGE TABLE STATUS AFTER UPGRADE-----
>
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> | Name              | Engine | Version | Row_format | Rows  |
> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
> Auto_increment | Create_time         | Update_time | Check_time |
> Collation       | Checksum | Create_options | Comment |
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> | page              | InnoDB |      10 | Compact    | 11883 |
> 133 |     1589248 |               0 |      2162688 | 111149056 |
> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
> | page_props        | InnoDB |      10 | Compact    |     0 |
> 0 |       16384 |               0 |            0 | 111149056 |
> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
> | page_restrictions | InnoDB |      10 | Compact    |     2 |
> 8192 |       16384 |               0 |        65536 | 111149056
> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
> utf8_general_ci |     NULL |                |         |
> | pagelinks         | InnoDB |      10 | Compact    | 28765 |
> 55 |     1589248 |               0 |      1589248 | 111149056 |
> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
> |     NULL |                |         |
>
> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
> mysql> select page_id,page_title from page where page_title like 'Adhik%';
> +---------+----------------------------+
> | page_id | page_title                 |
> +---------+----------------------------+
> |   11974 | Adhikamasa                 |
> |   11975 | Adhikamasa,_adhimasa       |
> |    7128 | AdhikamÄ sa                |
> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
> |   11977 | Adhikara                   |
> |   11978 | Adhikara_Nandi             |
> |   11976 | Adhikarana                 |
> |    6660 | Adhikaraṇa               |
> |    6659 | AdhikÄ ra                  |
> |    6661 | AdhikÄ ra_Nandi            |
> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
> |    7117 | Adhikaraṇa               |
> |    7125 | AdhikÄ ra                  |
> |    7118 | AdhikÄ ra_Nandi            |
> +---------+----------------------------+
>
>
> Not sure if this is correct, but I came across
> http://product.hubspot.com/bid/7049/MySQL-and-Unicode-Three-Gotchas
>
> which suggested that the page_title field could be improperly encoded (as
> varchar 255 instead of utf8).
>
> I tried to do
>
> ALTER TABLE page MODIFY page_title VARCHAR(255) CHARACTER SET utf8;
>
> But there are way too many conflicts/duplicates in the key page_name which
> prevents me from doing it w/o dropping the index.  BTW, if I do it, I can't
> recreate it with the "UNIQUE" property which it has right now due to the
> duplicates.
>
>
> https://www.mediawiki.org/wiki/Manual:MWDumper
> Suggests that the character type should be set to Binary to prevent these
> types of issues...but not sure what I need to do to get there from where I
> am right now.
>
> Any ideas?
>
> Thanks,
>
> Krishna
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>
> --------------------------------------------------------------------------------
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Marcin Cieslak-3
In reply to this post by kkm
On 2015-11-17, kkm <[hidden email]> wrote:

> Continuing to dig into this...
>
> +---------+----------------------------+
>| page_id | page_title                 |
> +---------+----------------------------+
>|   11974 | Adhikamasa                 |
>|   11975 | Adhikamasa,_adhimasa       |
>|    7128 | AdhikamÄ sa                |
>|    6658 | AdhikamÄ sa,_adhimÄ sa     |
>|   11977 | Adhikara                   |
>|   11978 | Adhikara_Nandi             |
>|   11976 | Adhikarana                 |
>|    6660 | Adhikaraṇa               |
>|    6659 | AdhikÄ ra                  |
>|    6661 | AdhikÄ ra_Nandi            |
>|    7126 | AdhikamÄ sa,_adhimÄ sa     |
>|    7117 | Adhikaraṇa               |
>|    7125 | AdhikÄ ra                  |
>|    7118 | AdhikÄ ra_Nandi            |
> +---------+----------------------------+

Can you also show your client settings by giving "\s" to MySQL client?

> Not sure if this is correct, but I came across
> http://product.hubspot.com/bid/7049/MySQL-and-Unicode-Three-Gotchas
>
> which suggested that the page_title field could be improperly encoded (as
> varchar 255 instead of utf8).
>
> I tried to do
>
> ALTER TABLE page MODIFY page_title VARCHAR(255) CHARACTER SET utf8;

Don't. Probably your data got "double-encoded" as utf-8.
They were binary utf-8 and the upgrade tool (or whatever) decided
to re-encode them.

*IF* this is the case, I would mysqldump a whole database under
the UTF-8 client settings and then change character
set designations to "binary" and import it as binary into
the binary tables. Might work.

This problem was pretty often seen when upgrading from MySQL 3 to 4

Saper


_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by kkm
Hi,

My mysql settings as shown with the \s flag.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash                       TRUE
auto-vertical-output              FALSE
character-sets-dir                (No default value)
column-type-info                  FALSE
comments                          FALSE
compress                          FALSE
debug-check                       FALSE
debug-info                        FALSE
database                          (No default value)
default-character-set             auto
delimiter                         ;
enable-cleartext-plugin           FALSE
vertical                          FALSE
force                             FALSE
named-commands                    FALSE
ignore-spaces                     FALSE
init-command                      (No default value)
local-infile                      FALSE
no-beep                           FALSE
host                              (No default value)
html                              FALSE
xml                               FALSE
line-numbers                      TRUE
unbuffered                        FALSE
column-names                      TRUE
sigint-ignore                     FALSE
port                              3306
prompt                            mysql>
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
socket                            /var/run/mysqld/mysqld.sock
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
user                              root
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect-timeout                   0
max-allowed-packet                16777216
net-buffer-length                 16384
select-limit                      1000
max-join-size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE
plugin-dir                        (No default value)
default-auth                      (No default value)

My original mysql version (prior to the physical server migration) was:

*>SHOW VARIABLES LIKE "%version%";*

+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.44           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.44-0+deb8u1  |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+

However, the current version of mysql is
+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.46           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.46-0+deb8u1  |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+

This version is currently hosting v.1.16.5 of Hindupedia.  The upgraded
mediawiki would remain on this version of mysql.

An alternate approach would be to dump the mediawiki contents (using the
dumpBackup.php maintenance script and to import them using
importDump.php).  However, I haven't found a way to backup & restore the
images in such a way that the image links within the wiki still work (just
importing them by using importImages.php imported the images but didn't
restore the links to the images in the articles).

Krishna


--------------------------------------------------------------------------------
Krishna Maheshwari
[hidden email]
[hidden email]
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------

On Wed, Nov 18, 2015 at 12:08 AM, kkm <[hidden email]> wrote:

> Below is my LocalSettings.php w/ sensitive info (e.g., logins/pw) blanked
> out.
>
> Best Regards,
>
> Krishna
>
> <?php
>
> # This file was automatically generated by the MediaWiki installer.
> # If you make manual changes, please keep track in case you need to
> # recreate them later.
> #
> # See includes/DefaultSettings.php for all configurable settings
> # and their default values, but don't forget to make changes in _this_
> # file, not there.
> #
> # Further documentation for configuration settings may be found at:
> # http://www.mediawiki.org/wiki/Manual:Configuration_settings
>
> # If you customize your file layout, set $IP to the directory that contains
> # the other MediaWiki files. It will be used as a base to locate files.
> if( defined( 'MW_INSTALL_PATH' ) ) {
>     $IP = MW_INSTALL_PATH;
> } else {
>     $IP = dirname( __FILE__ );
> }
>
> $path = array( $IP, "$IP/includes", "$IP/languages" );
> set_include_path( implode( PATH_SEPARATOR, $path ) . PATH_SEPARATOR .
> get_include_path() );
>
> require_once( "$IP/includes/DefaultSettings.php" );
> require_once( "{$IP}/extensions/NewUserNotif/NewUserNotif.php" );
>
> #add extension to add <ref> tags
> require_once( $IP.'/extensions/Cite/Cite.php' );
>
>
> # If PHP's memory limit is very low, some operations may fail.
> # ini_set( 'memory_limit', '20M' );
> # make sure php can find mail api
> ini_set ('include_path', get_include_path() . PATH_SEPARATOR .
> '/usr/share/php/');
>
> if ( $wgCommandLineMode ) {
>     if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER
> ) ) {
>         die( "This script must be run from the command line\n" );
>     }
> }
> ## Uncomment this to disable output compression
> # $wgDisableOutputCompression = true;
> #$wgDisableOutputCompression = false;
>
> $wgSitename         = "Hindupedia, the Hindu Encyclopedia";
>
> ## The URL base path to the directory containing the wiki;
> ## defaults for all runtime URL paths are based off of this.
> ## For more information on customizing the URLs please see:
> ## http://www.mediawiki.org/wiki/Manual:Short_URL
> $wgScriptPath       = "/eng"; #virtual path (right part of the first
> rewrite rule)
> $wgScriptExtension  = ".php";
> $wgArticlePath = "/en/$1"; #virtual path (left part of first rewrite rule)
> $wgUsePathInfo = true;
>
>
> $wgEnableWriteAPI = true;
> $wgEnableEmail      = true;
> $wgEnableUserEmail  = true; # UPO
>
> $wgEmergencyContact = "[hidden email]";
> $wgPasswordSender = "[hidden email]";
>
> ## For a detailed description of the following switches see
> ## http://www.mediawiki.org/wiki/Extension:Email_notification
> ## and http://www.mediawiki.org/wiki/Extension:Email_notification
> ## There are many more options for fine tuning available see
> ## /includes/DefaultSettings.php
> ## UPO means: this is also a user preference option
> $wgEnotifUserTalk = true; # UPO
> $wgEnotifWatchlist = true; # UPO
> $wgEmailAuthentication = true;
>
> $wgDBtype           = "mysql";
>
> $wgDBname           = "HindupediaMySQL";
> $wgDBserver         = "localhost";
> $wgDBuser           = ""; ##blanked out
> $wgDBpassword       = ""; ##blanked out
>
> # MySQL specific settings
> $wgDBprefix         = "";
>
> # MySQL table options to use during installation or update
> $wgDBTableOptions   = "TYPE=InnoDB";
>
> # Experimental charset support for MySQL 4.1/5.0.
> $wgDBmysql5 = false;
>
> # Postgres specific settings
> $wgDBport           = "5432";
> $wgDBmwschema       = "mediawiki";
> $wgDBts2schema      = "public";
>
> ## Shared memory settings
> $wgMainCacheType = CACHE_ACCEL; /* default: CACHE_NONE */
> #$wgMemCachedServers = array();
>
> ## To enable image uploads, make sure the 'images' directory
> ## is writable, then set this to true:
> $wgEnableUploads = true;
> $wgUseImageMagick = true;
> $wgImageMagickConvertCommand = "/usr/bin/convert";
>
> ## If you use ImageMagick (or any other shell command) on a
> ## Linux server, this will need to be set to the name of an
> ## available UTF-8 locale
> $wgShellLocale = "en_US.UTF-8";
>
> $wgUploadPath = "$wgScriptPath/images";
> $wgUploadDirectory = "$IP/images";
>
> #make links case in-sensitive
> #$wgCapitalLinks = false;
>
> $wgMimeDetectorCommand = "file -bi";
>
> #mime type detection for pptx is incorrect...hence, disable mime type
> checking for uploading it
> #$wgVerifyMimeType = false;
>
> srand(time());
> $random = (rand()%4);
> if ($random == 1)
> {
>     $wgLogo = "$wgScriptPath/images/hindupediabanner400x73.gif";
> }
> else if ($random == 2)
> {
>     $wgLogo = "$wgScriptPath/images/hindupediabanner2_400x73.gif";
> }
> else if ($random == 3)
> {
>     $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-1.gif";
> }
> else
> {
>     $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-2.gif";
> }
>
> ## If you want to use image uploads under safe mode,
> ## create the directories images/archive, images/thumb and
> ## images/temp, and make them all writable. Then uncomment
> ## this, if it's not already uncommented:
> # $wgHashedUploadDirectory = false;
>
> ## If you have the appropriate support software installed
> ## you can enable inline LaTeX equations:
> $wgUseTeX           = false;
>
> $wgLocalInterwiki   = $wgSitename;
>
> $wgLanguageCode = "en";
>
> $wgSecretKey = ""; ##blanked out
>
> ## Default skin: you can change the default skin. Use the internal symbolic
> ## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook':
> #wfLoadSkin( 'CologneBlue' );
> #wfLoadSkin( 'Modern' );
> #wfLoadSkin( 'MonoBook' );
> #wfLoadSkin( 'Vector' );
> $wgDefaultSkin = 'monobook';
> #$wgDefaultSkin = "gumax";
>
> ## For attaching licensing metadata to pages, and displaying an
> ## appropriate copyright notice / icon. GNU Free Documentation
> ## License and Creative Commons licenses are supported so far.
> $wgEnableCreativeCommonsRdf = true;
> $wgRightsPage = ""; # Set to the title of a wiki page that describes your
> license/copyright
> $wgRightsUrl = "http://www.gnu.org/copyleft/fdl.html";
> $wgRightsText = "GNU Free Documentation License 1.2";
> $wgRightsIcon = "${wgScriptPath}/skins/common/images/gnu-fdl.png";
> # $wgRightsCode = "gfdl"; # Not yet used
>
> $wgDiff = "/usr/bin/diff";
> $wgDiff3 = "/usr/bin/diff3";
>
> # When you make changes to this configuration file, this will make
> # sure that cached pages are cleared.
> $wgCacheEpoch = max( $wgCacheEpoch, gmdate( 'YmdHis', @filemtime( __FILE__
> ) ) );
>
> # user/group permissions
> $wgGroupPermissions['*']['edit'] = false;
> $wgGroupPermissions['user']['edit'] = true;
> # $wgGroupPermissions['confirmed']['edit'] = true;
>
> #disable anonymous talk
> $wgDisableAnonTalk = true;
>
>
> #enable support for SVG image file type
> $wgFileExtensions[] = 'svg';
> $wgAllowTitlesInSVG = true;
> #$wgSVGConverter = '/usr/share/ImageMagick';
> $wgSVGConverters = array(
>     'ImageMagick' => '$path/convert -background white -thumbnail
> $widthx$height\! $input PNG:$output',
>     'sodipodi' => '$path/sodipodi -z -w $width -f $input -e $output',
>     'inkscape' => '$path/inkscape -z -w $width -f $input -e $output',
>     'batik' => 'java -Djava.awt.headless=true -jar
> $path/batik-rasterizer.jar -w $width -d $output $input',
>     'rsvg' => '/usr/bin/rsvg -w$width -h$height $input $output',
>     'imgserv' => '$path/imgserv-wrapper -i svg -o png -w$width $input
> $output',
> );
> $wgSVGConverter = 'rsvg' ;
>
> #enable support for MS PowerPoint
> $wgFileExtensions[] = 'pptx';
> $wgFileExtensions[] = 'ppt';
>
> #enable support for AAC audio files
> $wgFileExtensions[] = 'm4a';
>
> #### Google Analytics
> ##Migration edit
> require_once( "$IP/extensions/googleAnalytics/googleAnalytics.php" );
> # Replace xxxxxxx-x with YOUR GoogleAnalytics UA number
> $wgGoogleAnalyticsAccount = ""; ##blanked out
>
> $wgGoogleAnalyticsIgnoreSysops = true;
> $wgGoogleAnalyticsIgnoreBots = true;
>
> # misc mediawiki settings
> $wgEnableMWSuggest = true;
> $wgShowIPinHeader = false;
>
> # Set address bar icon
> $wgFavicon = "/favicon.ico";
>
>
> ################### ConfirmAccount
> #confirm user extension settings
> ###KKM update incompatible###
> #include_once('extensions/ConfirmAccount/SpecialConfirmAccount.php');
> $wgMakeUserPageFromBio = true;
> $wgUseRealNamesOnly = true;
> $wgAccountRequestMinWords = 50;
> $wgAccountRequestExtraInfo = true;
> $wgAllowAccountRequestFiles = true;
> $wgConfirmAccountSaveInfo = true;
> $wgConfirmAccountContact = "[hidden email]";
>
> #StubManager Extension
> require_once( "{$IP}/extensions/StubManager/StubManager.php" );
>
> #Header Footer extension
> require_once( "{$IP}/extensions/HeaderFooter/HeaderFooter.php" );
>
> #Random Pages Extension
> $namespace=true; #restrict extension to global namespace
> ###KKM update incompatible###
> #require_once( "{$IP}/extensions/RandomPages/RandomPages.php" );
>
> #Category Tree Extension
> $wgUseAjax = true;
> ##Migration edit
> #require_once( "{$IP}/extensions/CategoryTree/CategoryTree.php" );
>
> #Description plugin - adds metadata from intro paragraph of each article
> to help with search engine indexing
> require_once("$IP/extensions/Description/Description.php");
>
> #Add poem function for sanskrit text
> require_once($IP.'/extensions/Poem/Poem.php');
>
> #Add AutoLink
> ###KKM update incompatible###
> #require_once("$IP/extensions/Autolink/Autolink.php");
>
> #Add Social Bookmarking link
> require_once("$IP/extensions/Bookmark/bookmark.php");
>
> #Add Google Search
> require_once("extensions/GoogleSiteSearch/GoogleSiteSearch.php");
>
> #Add collist
> require_once("extensions/collist/collist.php");
>
> #add imagemap
> #require_once("$IP/extensions/ImageMap/ImageMap.php");
>
> #add dynamic page list
> #KKM update fail
> #require_once("$IP/extensions/DynamicPageList/DynamicPageList2.php");
>
> #add parser functiosn (required for most templates)
> ##migration edit
> require_once("$IP/extensions/ParserFunctions/ParserFunctions.php");
>
> #add article to category
> #require_once("$IP/extensions/articletocategory/articletocategory.php");
>
> #add page black list extension
> require_once("$IP/extensions/blacklist/blacklist.php");
> $wgWhitelist['user']['read']  = $wgBlacklist['*']['read'] =
> array("Special:RecentChanges", "Special:Listusers", "Special:Ipblocklist",
> "Special:Log", "Special:Allmessages", "User talk:Krishna Maheshwari");
>
> #add embed video extension (enable adding videos from popular sites like
> google video, you tube, etc
> #KKM update fail###
> #require_once("$IP/extensions/EmbedVideo/EmbedVideo.php");
>
>
> #if ($wgUser->isLoggedIn())
> #{
>     #CharInsert -- allow clickable extra characters & tags for edit boxes
>     require_once("$IP/extensions/CharInsert/CharInsert.php");
> #}
>
> #rss feeds
> #works but doesn't transclude source
> #require_once("$IP/extensions/rss/rss.php");
>
> #rss feeds - removed to see if it improves performance
> #require_once("$IP/extensions/feedimport/feedimport.php");
>
> #works but provides links to source instead of transcluding it
> #require_once("$IP/extensions/simplefeed/SimpleFeed.php");
>
> #Add Minify--which strips extra stuff from css & js files to make them
> smaller
> require_once("$IP/extensions/Minify/Minify.php");
>
> #use ETags to facilitate caching at intermediary layers & the browser
> $wgUseETag=true; /* default: false */
> #server to send pages in to the browser in a compressed format
> #$wgUseGzip=true; /* default: false */
>
> #cache sidebar ...
> #$wgSidebarCacheExpiry = 86400s; /*default*/
> $wgEnableSidebarCache = true; /* default: false */
> #enable client side caching
> $wgCachePages = true; /* default: true */
>
> #ParserCache
> $wgEnableParserCache = true; /* default:false*/
> $wgMainCacheType = CACHE_ANYTHING; /* default: CACHE_ANYTHING */
>
> # Enable the basic file cache for static pages for non-logged-in visitors
> $wgUseFileCache = true; /* default: false */
> $wgFileCacheDirectory = "$IP/cache";
>
> #default is 1, changing to a higher number will be a little bit
> # nicer to the database
> $wgHitcounterUpdateFreq = 100;
>
> $wgExtraNamespaces[100] = "Quotes";
> $wgExtraNamespaces[101] = "Quotes_talk";
> $wgExtraNamespaces[102] = "Internal";
> $wgExtraNamespaces[103] = "Internal_talk";
> $wgExtraNamespaces[104] = "SupportUs";
> $wgExtraNamespaces[105] = "SupportUs_talk";
>
>
> #CSO_SiteAd - allow javascript inside protected wiki pages (ie
> reciprocalURL)
> #require_once("$IP/extensions/CSO_SiteAd/CSO_SiteAd.php");
>
> ####################### System Administration Extensions
> #######################
> ##################### Enable only when needed, then disable
> ####################
> #User Merge & Delete Extension
> #KKM update fail###
> #require_once( "$IP/extensions/UserMerge/UserMerge.php" );
> $wgGroupPermissions['bureaucrat']['usermerge'] = true;
>
> #optional - default is array( 'sysop' )
> #$wgUserMergeProtectedGroups = array( 'groupname' );
>
> #Usage Statistics
> #KKM update fail###
> #require_once( "{$IP}/extensions/UsageStatistics/SpecialUserStats.php" );
> $wgUserStatsGoogleCharts = 1;
>
> #SpecialLastUserLoginEx
> #KKM update fail###
> #require_once( "$IP/extensions/UserStats/SpecialLastUserLogin.php" );
> $wgGroupPermissions['sysop']['lastlogin'] = true;
>
>
>
> ################################################################################
> ####################### Sending Email #######################
>
> ################################################################################
> $wgSMTP = array(
>         'host' => 'ssl://smtp.gmail.com',
>         'IDHost' => 'hindupedia.com',
>         'port' => 465,
>         'username' => '', ##blanked out
>         'password' => '', ##blanked out
>         'auth' => true
>      );
>
> #$wgReadOnly = 'This wiki is currently being upgraded to a newer software
> version.';
> #require_once( "$IP/extensions/JsonConfig/JsonConfig.php" );
> require_once( "$IP/extensions/PayPal.php" );
> require_once( "$IP/extensions/MiniDonation/MiniDonation.php" );
> require_once( "$IP/extensions/IAST/IAST.php" );
> $wgShowExceptionDetails = true;
> $wgShowSQLErrors = true;
> $wgDebugDumpSql  = true;
> $wgShowDBErrorBacktrace = true;
> #Shows PHP errors
> #error_reporting( -1 );
> #ini_set( 'display_errors', 1 );
>
> $wgReadOnly = 'This wiki is currently being upgraded to a newer software
> version.';
> $wgUpgradeKey = ''; ##blanked out
>
>
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> [hidden email]
> [hidden email]
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>
> --------------------------------------------------------------------------------
>
> On Mon, Nov 16, 2015 at 10:48 PM, kkm <[hidden email]> wrote:
>
>> Continuing to dig into this...
>>
>> Below are page table descriptions from mysql:
>> -----PAGE TABLE STATUS BEFORE UPGRADE-----
>> mysql> SHOW TABLE STATUS  WHERE  `NAME` LIKE  '%page%';
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | Name              | Engine | Version | Row_format | Rows  |
>> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
>> Auto_increment | Create_time         | Update_time | Check_time |
>> Collation       | Checksum | Create_options | Comment |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | page              | InnoDB |      10 | Compact    | 12461 |
>> 127 |     1589248 |               0 |      2162688 |  11534336 |
>> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_props        | InnoDB |      10 | Compact    |     0
>> |              0 |       16384 |               0 |            0 |  11534336
>> |           NULL | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | page_restrictions | InnoDB |      10 | Compact    |     2 |
>> 8192 |       16384 |               0 |        65536 |  11534336
>> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | pagelinks         | InnoDB |      10 | Compact    | 28377 |
>> 56 |     1589248 |               0 |      1589248 |  11534336 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> mysql> SHOW COLUMNS FROM page;
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> | Field             | Type                | Null | Key | Default        |
>> Extra          |
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> | page_id           | int(10) unsigned    | NO   | PRI | NULL           |
>> auto_increment |
>> | page_namespace    | int(11)             | NO   | MUL | NULL
>> |                |
>> | page_title        | varchar(255)        | NO   |     | NULL
>> |                |
>> | page_restrictions | tinyblob            | NO   |     | NULL
>> |                |
>> | page_counter      | bigint(20) unsigned | NO   |     | 0
>> |                |
>> | page_is_redirect  | tinyint(3) unsigned | NO   |     | 0
>> |                |
>> | page_is_new       | tinyint(3) unsigned | NO   |     | 0
>> |                |
>> | page_random       | double unsigned     | NO   | MUL | NULL
>> |                |
>> | page_touched      | binary(14)          | NO   |     |
>> |                |
>> | page_latest       | int(10) unsigned    | NO   |     | NULL
>> |                |
>> | page_len          | int(10) unsigned    | NO   | MUL | NULL
>> |                |
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> mysql> select page_id,page_title from page where page_title like 'Adhik%';
>> +---------+----------------------------+
>> | page_id | page_title                 |
>> +---------+----------------------------+
>> |   11974 | Adhikamasa                 |
>> |   11975 | Adhikamasa,_adhimasa       |
>> |    7128 | AdhikamÄ sa                |
>> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
>> |   11977 | Adhikara                   |
>> |   11978 | Adhikara_Nandi             |
>> |   11976 | Adhikarana                 |
>> |    6660 | Adhikaraṇa               |
>> |    6659 | AdhikÄ ra                  |
>> |    6661 | AdhikÄ ra_Nandi            |
>> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
>> |    7117 | Adhikaraṇa               |
>> |    7125 | AdhikÄ ra                  |
>> |    7118 | AdhikÄ ra_Nandi            |
>> +---------+----------------------------+
>> -----PAGE TABLE STATUS AFTER UPGRADE-----
>>
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | Name              | Engine | Version | Row_format | Rows  |
>> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
>> Auto_increment | Create_time         | Update_time | Check_time |
>> Collation       | Checksum | Create_options | Comment |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | page              | InnoDB |      10 | Compact    | 11883 |
>> 133 |     1589248 |               0 |      2162688 | 111149056 |
>> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_props        | InnoDB |      10 | Compact    |     0
>> |              0 |       16384 |               0 |            0 | 111149056
>> |           NULL | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | page_restrictions | InnoDB |      10 | Compact    |     2 |
>> 8192 |       16384 |               0 |        65536 | 111149056
>> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | pagelinks         | InnoDB |      10 | Compact    | 28765 |
>> 55 |     1589248 |               0 |      1589248 | 111149056 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> mysql> select page_id,page_title from page where page_title like 'Adhik%';
>> +---------+----------------------------+
>> | page_id | page_title                 |
>> +---------+----------------------------+
>> |   11974 | Adhikamasa                 |
>> |   11975 | Adhikamasa,_adhimasa       |
>> |    7128 | AdhikamÄ sa                |
>> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
>> |   11977 | Adhikara                   |
>> |   11978 | Adhikara_Nandi             |
>> |   11976 | Adhikarana                 |
>> |    6660 | Adhikaraṇa               |
>> |    6659 | AdhikÄ ra                  |
>> |    6661 | AdhikÄ ra_Nandi            |
>> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
>> |    7117 | Adhikaraṇa               |
>> |    7125 | AdhikÄ ra                  |
>> |    7118 | AdhikÄ ra_Nandi            |
>> +---------+----------------------------+
>>
>>
>> Not sure if this is correct, but I came across
>> http://product.hubspot.com/bid/7049/MySQL-and-Unicode-Three-Gotchas
>>
>> which suggested that the page_title field could be improperly encoded (as
>> varchar 255 instead of utf8).
>>
>> I tried to do
>>
>> ALTER TABLE page MODIFY page_title VARCHAR(255) CHARACTER SET utf8;
>>
>> But there are way too many conflicts/duplicates in the key page_name
>> which prevents me from doing it w/o dropping the index.  BTW, if I do it, I
>> can't recreate it with the "UNIQUE" property which it has right now due to
>> the duplicates.
>>
>>
>> https://www.mediawiki.org/wiki/Manual:MWDumper
>> Suggests that the character type should be set to Binary to prevent these
>> types of issues...but not sure what I need to do to get there from where I
>> am right now.
>>
>> Any ideas?
>>
>> Thanks,
>>
>> Krishna
>>
>> --------------------------------------------------------------------------------
>> Krishna Maheshwari
>> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>>
>> --------------------------------------------------------------------------------
>>
>
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

[MediaWiki-l] Fwd: problem following 1.16 to 1.25 conversion

kkm
My php settings didn't get through, so trying to resent.
--------------------------------------------------------------------------------
<[hidden email]>
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------

---------- Forwarded message ----------
From: kkm <[hidden email]>
Date: Wed, Nov 18, 2015 at 9:45 PM
Subject: Re: problem following 1.16 to 1.25 conversion
To: [hidden email]


Hi,

My mysql settings as shown with the \s flag.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash                       TRUE
auto-vertical-output              FALSE
character-sets-dir                (No default value)
column-type-info                  FALSE
comments                          FALSE
compress                          FALSE
debug-check                       FALSE
debug-info                        FALSE
database                          (No default value)
default-character-set             auto
delimiter                         ;
enable-cleartext-plugin           FALSE
vertical                          FALSE
force                             FALSE
named-commands                    FALSE
ignore-spaces                     FALSE
init-command                      (No default value)
local-infile                      FALSE
no-beep                           FALSE
host                              (No default value)
html                              FALSE
xml                               FALSE
line-numbers                      TRUE
unbuffered                        FALSE
column-names                      TRUE
sigint-ignore                     FALSE
port                              3306
prompt                            mysql>
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
socket                            /var/run/mysqld/mysqld.sock
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
user                              root
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect-timeout                   0
max-allowed-packet                16777216
net-buffer-length                 16384
select-limit                      1000
max-join-size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE
plugin-dir                        (No default value)
default-auth                      (No default value)

My original mysql version (prior to the physical server migration) was:

*>SHOW VARIABLES LIKE "%version%";*

+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.44           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.44-0+deb8u1  |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+

However, the current version of mysql is
+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| innodb_version          | 5.5.46           |
| protocol_version        | 10               |
| slave_type_conversions  |                  |
| version                 | 5.5.46-0+deb8u1  |
| version_comment         | (Debian)         |
| version_compile_machine | x86_64           |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+

This version is currently hosting v.1.16.5 of Hindupedia.  The upgraded
mediawiki would remain on this version of mysql.

An alternate approach would be to dump the mediawiki contents (using the
dumpBackup.php maintenance script and to import them using
importDump.php).  However, I haven't found a way to backup & restore the
images in such a way that the image links within the wiki still work (just
importing them by using importImages.php imported the images but didn't
restore the links to the images in the articles).

Krishna
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

Benjamin Lees
In reply to this post by kkm
You might want to fiddle with $wgDBTableOptions.[0]  The current
default is different from what you have.

[0] https://www.mediawiki.org/wiki/Manual:$wgDBTableOptions

On Wed, Nov 18, 2015 at 12:08 AM, kkm <[hidden email]> wrote:

> Below is my LocalSettings.php w/ sensitive info (e.g., logins/pw) blanked
> out.
>
> Best Regards,
>
> Krishna
>
> <?php
>
> # This file was automatically generated by the MediaWiki installer.
> # If you make manual changes, please keep track in case you need to
> # recreate them later.
> #
> # See includes/DefaultSettings.php for all configurable settings
> # and their default values, but don't forget to make changes in _this_
> # file, not there.
> #
> # Further documentation for configuration settings may be found at:
> # http://www.mediawiki.org/wiki/Manual:Configuration_settings
>
> # If you customize your file layout, set $IP to the directory that contains
> # the other MediaWiki files. It will be used as a base to locate files.
> if( defined( 'MW_INSTALL_PATH' ) ) {
>     $IP = MW_INSTALL_PATH;
> } else {
>     $IP = dirname( __FILE__ );
> }
>
> $path = array( $IP, "$IP/includes", "$IP/languages" );
> set_include_path( implode( PATH_SEPARATOR, $path ) . PATH_SEPARATOR .
> get_include_path() );
>
> require_once( "$IP/includes/DefaultSettings.php" );
> require_once( "{$IP}/extensions/NewUserNotif/NewUserNotif.php" );
>
> #add extension to add <ref> tags
> require_once( $IP.'/extensions/Cite/Cite.php' );
>
>
> # If PHP's memory limit is very low, some operations may fail.
> # ini_set( 'memory_limit', '20M' );
> # make sure php can find mail api
> ini_set ('include_path', get_include_path() . PATH_SEPARATOR .
> '/usr/share/php/');
>
> if ( $wgCommandLineMode ) {
>     if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER
> ) ) {
>         die( "This script must be run from the command line\n" );
>     }
> }
> ## Uncomment this to disable output compression
> # $wgDisableOutputCompression = true;
> #$wgDisableOutputCompression = false;
>
> $wgSitename         = "Hindupedia, the Hindu Encyclopedia";
>
> ## The URL base path to the directory containing the wiki;
> ## defaults for all runtime URL paths are based off of this.
> ## For more information on customizing the URLs please see:
> ## http://www.mediawiki.org/wiki/Manual:Short_URL
> $wgScriptPath       = "/eng"; #virtual path (right part of the first
> rewrite rule)
> $wgScriptExtension  = ".php";
> $wgArticlePath = "/en/$1"; #virtual path (left part of first rewrite rule)
> $wgUsePathInfo = true;
>
>
> $wgEnableWriteAPI = true;
> $wgEnableEmail      = true;
> $wgEnableUserEmail  = true; # UPO
>
> $wgEmergencyContact = "[hidden email]";
> $wgPasswordSender = "[hidden email]";
>
> ## For a detailed description of the following switches see
> ## http://www.mediawiki.org/wiki/Extension:Email_notification
> ## and http://www.mediawiki.org/wiki/Extension:Email_notification
> ## There are many more options for fine tuning available see
> ## /includes/DefaultSettings.php
> ## UPO means: this is also a user preference option
> $wgEnotifUserTalk = true; # UPO
> $wgEnotifWatchlist = true; # UPO
> $wgEmailAuthentication = true;
>
> $wgDBtype           = "mysql";
>
> $wgDBname           = "HindupediaMySQL";
> $wgDBserver         = "localhost";
> $wgDBuser           = ""; ##blanked out
> $wgDBpassword       = ""; ##blanked out
>
> # MySQL specific settings
> $wgDBprefix         = "";
>
> # MySQL table options to use during installation or update
> $wgDBTableOptions   = "TYPE=InnoDB";
>
> # Experimental charset support for MySQL 4.1/5.0.
> $wgDBmysql5 = false;
>
> # Postgres specific settings
> $wgDBport           = "5432";
> $wgDBmwschema       = "mediawiki";
> $wgDBts2schema      = "public";
>
> ## Shared memory settings
> $wgMainCacheType = CACHE_ACCEL; /* default: CACHE_NONE */
> #$wgMemCachedServers = array();
>
> ## To enable image uploads, make sure the 'images' directory
> ## is writable, then set this to true:
> $wgEnableUploads = true;
> $wgUseImageMagick = true;
> $wgImageMagickConvertCommand = "/usr/bin/convert";
>
> ## If you use ImageMagick (or any other shell command) on a
> ## Linux server, this will need to be set to the name of an
> ## available UTF-8 locale
> $wgShellLocale = "en_US.UTF-8";
>
> $wgUploadPath = "$wgScriptPath/images";
> $wgUploadDirectory = "$IP/images";
>
> #make links case in-sensitive
> #$wgCapitalLinks = false;
>
> $wgMimeDetectorCommand = "file -bi";
>
> #mime type detection for pptx is incorrect...hence, disable mime type
> checking for uploading it
> #$wgVerifyMimeType = false;
>
> srand(time());
> $random = (rand()%4);
> if ($random == 1)
> {
>     $wgLogo = "$wgScriptPath/images/hindupediabanner400x73.gif";
> }
> else if ($random == 2)
> {
>     $wgLogo = "$wgScriptPath/images/hindupediabanner2_400x73.gif";
> }
> else if ($random == 3)
> {
>     $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-1.gif";
> }
> else
> {
>     $wgLogo = "$wgScriptPath/images/hp_banner_shreyans-2.gif";
> }
>
> ## If you want to use image uploads under safe mode,
> ## create the directories images/archive, images/thumb and
> ## images/temp, and make them all writable. Then uncomment
> ## this, if it's not already uncommented:
> # $wgHashedUploadDirectory = false;
>
> ## If you have the appropriate support software installed
> ## you can enable inline LaTeX equations:
> $wgUseTeX           = false;
>
> $wgLocalInterwiki   = $wgSitename;
>
> $wgLanguageCode = "en";
>
> $wgSecretKey = ""; ##blanked out
>
> ## Default skin: you can change the default skin. Use the internal symbolic
> ## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook':
> #wfLoadSkin( 'CologneBlue' );
> #wfLoadSkin( 'Modern' );
> #wfLoadSkin( 'MonoBook' );
> #wfLoadSkin( 'Vector' );
> $wgDefaultSkin = 'monobook';
> #$wgDefaultSkin = "gumax";
>
> ## For attaching licensing metadata to pages, and displaying an
> ## appropriate copyright notice / icon. GNU Free Documentation
> ## License and Creative Commons licenses are supported so far.
> $wgEnableCreativeCommonsRdf = true;
> $wgRightsPage = ""; # Set to the title of a wiki page that describes your
> license/copyright
> $wgRightsUrl = "http://www.gnu.org/copyleft/fdl.html";
> $wgRightsText = "GNU Free Documentation License 1.2";
> $wgRightsIcon = "${wgScriptPath}/skins/common/images/gnu-fdl.png";
> # $wgRightsCode = "gfdl"; # Not yet used
>
> $wgDiff = "/usr/bin/diff";
> $wgDiff3 = "/usr/bin/diff3";
>
> # When you make changes to this configuration file, this will make
> # sure that cached pages are cleared.
> $wgCacheEpoch = max( $wgCacheEpoch, gmdate( 'YmdHis', @filemtime( __FILE__
> ) ) );
>
> # user/group permissions
> $wgGroupPermissions['*']['edit'] = false;
> $wgGroupPermissions['user']['edit'] = true;
> # $wgGroupPermissions['confirmed']['edit'] = true;
>
> #disable anonymous talk
> $wgDisableAnonTalk = true;
>
>
> #enable support for SVG image file type
> $wgFileExtensions[] = 'svg';
> $wgAllowTitlesInSVG = true;
> #$wgSVGConverter = '/usr/share/ImageMagick';
> $wgSVGConverters = array(
>     'ImageMagick' => '$path/convert -background white -thumbnail
> $widthx$height\! $input PNG:$output',
>     'sodipodi' => '$path/sodipodi -z -w $width -f $input -e $output',
>     'inkscape' => '$path/inkscape -z -w $width -f $input -e $output',
>     'batik' => 'java -Djava.awt.headless=true -jar
> $path/batik-rasterizer.jar -w $width -d $output $input',
>     'rsvg' => '/usr/bin/rsvg -w$width -h$height $input $output',
>     'imgserv' => '$path/imgserv-wrapper -i svg -o png -w$width $input
> $output',
> );
> $wgSVGConverter = 'rsvg' ;
>
> #enable support for MS PowerPoint
> $wgFileExtensions[] = 'pptx';
> $wgFileExtensions[] = 'ppt';
>
> #enable support for AAC audio files
> $wgFileExtensions[] = 'm4a';
>
> #### Google Analytics
> ##Migration edit
> require_once( "$IP/extensions/googleAnalytics/googleAnalytics.php" );
> # Replace xxxxxxx-x with YOUR GoogleAnalytics UA number
> $wgGoogleAnalyticsAccount = ""; ##blanked out
>
> $wgGoogleAnalyticsIgnoreSysops = true;
> $wgGoogleAnalyticsIgnoreBots = true;
>
> # misc mediawiki settings
> $wgEnableMWSuggest = true;
> $wgShowIPinHeader = false;
>
> # Set address bar icon
> $wgFavicon = "/favicon.ico";
>
>
> ################### ConfirmAccount
> #confirm user extension settings
> ###KKM update incompatible###
> #include_once('extensions/ConfirmAccount/SpecialConfirmAccount.php');
> $wgMakeUserPageFromBio = true;
> $wgUseRealNamesOnly = true;
> $wgAccountRequestMinWords = 50;
> $wgAccountRequestExtraInfo = true;
> $wgAllowAccountRequestFiles = true;
> $wgConfirmAccountSaveInfo = true;
> $wgConfirmAccountContact = "[hidden email]";
>
> #StubManager Extension
> require_once( "{$IP}/extensions/StubManager/StubManager.php" );
>
> #Header Footer extension
> require_once( "{$IP}/extensions/HeaderFooter/HeaderFooter.php" );
>
> #Random Pages Extension
> $namespace=true; #restrict extension to global namespace
> ###KKM update incompatible###
> #require_once( "{$IP}/extensions/RandomPages/RandomPages.php" );
>
> #Category Tree Extension
> $wgUseAjax = true;
> ##Migration edit
> #require_once( "{$IP}/extensions/CategoryTree/CategoryTree.php" );
>
> #Description plugin - adds metadata from intro paragraph of each article to
> help with search engine indexing
> require_once("$IP/extensions/Description/Description.php");
>
> #Add poem function for sanskrit text
> require_once($IP.'/extensions/Poem/Poem.php');
>
> #Add AutoLink
> ###KKM update incompatible###
> #require_once("$IP/extensions/Autolink/Autolink.php");
>
> #Add Social Bookmarking link
> require_once("$IP/extensions/Bookmark/bookmark.php");
>
> #Add Google Search
> require_once("extensions/GoogleSiteSearch/GoogleSiteSearch.php");
>
> #Add collist
> require_once("extensions/collist/collist.php");
>
> #add imagemap
> #require_once("$IP/extensions/ImageMap/ImageMap.php");
>
> #add dynamic page list
> #KKM update fail
> #require_once("$IP/extensions/DynamicPageList/DynamicPageList2.php");
>
> #add parser functiosn (required for most templates)
> ##migration edit
> require_once("$IP/extensions/ParserFunctions/ParserFunctions.php");
>
> #add article to category
> #require_once("$IP/extensions/articletocategory/articletocategory.php");
>
> #add page black list extension
> require_once("$IP/extensions/blacklist/blacklist.php");
> $wgWhitelist['user']['read']  = $wgBlacklist['*']['read'] =
> array("Special:RecentChanges", "Special:Listusers", "Special:Ipblocklist",
> "Special:Log", "Special:Allmessages", "User talk:Krishna Maheshwari");
>
> #add embed video extension (enable adding videos from popular sites like
> google video, you tube, etc
> #KKM update fail###
> #require_once("$IP/extensions/EmbedVideo/EmbedVideo.php");
>
>
> #if ($wgUser->isLoggedIn())
> #{
>     #CharInsert -- allow clickable extra characters & tags for edit boxes
>     require_once("$IP/extensions/CharInsert/CharInsert.php");
> #}
>
> #rss feeds
> #works but doesn't transclude source
> #require_once("$IP/extensions/rss/rss.php");
>
> #rss feeds - removed to see if it improves performance
> #require_once("$IP/extensions/feedimport/feedimport.php");
>
> #works but provides links to source instead of transcluding it
> #require_once("$IP/extensions/simplefeed/SimpleFeed.php");
>
> #Add Minify--which strips extra stuff from css & js files to make them
> smaller
> require_once("$IP/extensions/Minify/Minify.php");
>
> #use ETags to facilitate caching at intermediary layers & the browser
> $wgUseETag=true; /* default: false */
> #server to send pages in to the browser in a compressed format
> #$wgUseGzip=true; /* default: false */
>
> #cache sidebar ...
> #$wgSidebarCacheExpiry = 86400s; /*default*/
> $wgEnableSidebarCache = true; /* default: false */
> #enable client side caching
> $wgCachePages = true; /* default: true */
>
> #ParserCache
> $wgEnableParserCache = true; /* default:false*/
> $wgMainCacheType = CACHE_ANYTHING; /* default: CACHE_ANYTHING */
>
> # Enable the basic file cache for static pages for non-logged-in visitors
> $wgUseFileCache = true; /* default: false */
> $wgFileCacheDirectory = "$IP/cache";
>
> #default is 1, changing to a higher number will be a little bit
> # nicer to the database
> $wgHitcounterUpdateFreq = 100;
>
> $wgExtraNamespaces[100] = "Quotes";
> $wgExtraNamespaces[101] = "Quotes_talk";
> $wgExtraNamespaces[102] = "Internal";
> $wgExtraNamespaces[103] = "Internal_talk";
> $wgExtraNamespaces[104] = "SupportUs";
> $wgExtraNamespaces[105] = "SupportUs_talk";
>
>
> #CSO_SiteAd - allow javascript inside protected wiki pages (ie
> reciprocalURL)
> #require_once("$IP/extensions/CSO_SiteAd/CSO_SiteAd.php");
>
> ####################### System Administration Extensions
> #######################
> ##################### Enable only when needed, then disable
> ####################
> #User Merge & Delete Extension
> #KKM update fail###
> #require_once( "$IP/extensions/UserMerge/UserMerge.php" );
> $wgGroupPermissions['bureaucrat']['usermerge'] = true;
>
> #optional - default is array( 'sysop' )
> #$wgUserMergeProtectedGroups = array( 'groupname' );
>
> #Usage Statistics
> #KKM update fail###
> #require_once( "{$IP}/extensions/UsageStatistics/SpecialUserStats.php" );
> $wgUserStatsGoogleCharts = 1;
>
> #SpecialLastUserLoginEx
> #KKM update fail###
> #require_once( "$IP/extensions/UserStats/SpecialLastUserLogin.php" );
> $wgGroupPermissions['sysop']['lastlogin'] = true;
>
>
> ################################################################################
> ####################### Sending Email #######################
> ################################################################################
> $wgSMTP = array(
>         'host' => 'ssl://smtp.gmail.com',
>         'IDHost' => 'hindupedia.com',
>         'port' => 465,
>         'username' => '', ##blanked out
>         'password' => '', ##blanked out
>         'auth' => true
>      );
>
> #$wgReadOnly = 'This wiki is currently being upgraded to a newer software
> version.';
> #require_once( "$IP/extensions/JsonConfig/JsonConfig.php" );
> require_once( "$IP/extensions/PayPal.php" );
> require_once( "$IP/extensions/MiniDonation/MiniDonation.php" );
> require_once( "$IP/extensions/IAST/IAST.php" );
> $wgShowExceptionDetails = true;
> $wgShowSQLErrors = true;
> $wgDebugDumpSql  = true;
> $wgShowDBErrorBacktrace = true;
> #Shows PHP errors
> #error_reporting( -1 );
> #ini_set( 'display_errors', 1 );
>
> $wgReadOnly = 'This wiki is currently being upgraded to a newer software
> version.';
> $wgUpgradeKey = ''; ##blanked out
>
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> [hidden email]
> [hidden email]
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
> --------------------------------------------------------------------------------
>
> On Mon, Nov 16, 2015 at 10:48 PM, kkm <[hidden email]> wrote:
>
>> Continuing to dig into this...
>>
>> Below are page table descriptions from mysql:
>> -----PAGE TABLE STATUS BEFORE UPGRADE-----
>> mysql> SHOW TABLE STATUS  WHERE  `NAME` LIKE  '%page%';
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | Name              | Engine | Version | Row_format | Rows  |
>> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
>> Auto_increment | Create_time         | Update_time | Check_time |
>> Collation       | Checksum | Create_options | Comment |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | page              | InnoDB |      10 | Compact    | 12461 |
>> 127 |     1589248 |               0 |      2162688 |  11534336 |
>> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_props        | InnoDB |      10 | Compact    |     0 |
>> 0 |       16384 |               0 |            0 |  11534336 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_restrictions | InnoDB |      10 | Compact    |     2 |
>> 8192 |       16384 |               0 |        65536 |  11534336
>> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | pagelinks         | InnoDB |      10 | Compact    | 28377 |
>> 56 |     1589248 |               0 |      1589248 |  11534336 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> mysql> SHOW COLUMNS FROM page;
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> | Field             | Type                | Null | Key | Default        |
>> Extra          |
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> | page_id           | int(10) unsigned    | NO   | PRI | NULL           |
>> auto_increment |
>> | page_namespace    | int(11)             | NO   | MUL | NULL
>> |                |
>> | page_title        | varchar(255)        | NO   |     | NULL
>> |                |
>> | page_restrictions | tinyblob            | NO   |     | NULL
>> |                |
>> | page_counter      | bigint(20) unsigned | NO   |     | 0
>> |                |
>> | page_is_redirect  | tinyint(3) unsigned | NO   |     | 0
>> |                |
>> | page_is_new       | tinyint(3) unsigned | NO   |     | 0
>> |                |
>> | page_random       | double unsigned     | NO   | MUL | NULL
>> |                |
>> | page_touched      | binary(14)          | NO   |     |
>> |                |
>> | page_latest       | int(10) unsigned    | NO   |     | NULL
>> |                |
>> | page_len          | int(10) unsigned    | NO   | MUL | NULL
>> |                |
>>
>> +-------------------+---------------------+------+-----+----------------+----------------+
>> mysql> select page_id,page_title from page where page_title like 'Adhik%';
>> +---------+----------------------------+
>> | page_id | page_title                 |
>> +---------+----------------------------+
>> |   11974 | Adhikamasa                 |
>> |   11975 | Adhikamasa,_adhimasa       |
>> |    7128 | AdhikamÄ sa                |
>> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
>> |   11977 | Adhikara                   |
>> |   11978 | Adhikara_Nandi             |
>> |   11976 | Adhikarana                 |
>> |    6660 | Adhikaraṇa               |
>> |    6659 | AdhikÄ ra                  |
>> |    6661 | AdhikÄ ra_Nandi            |
>> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
>> |    7117 | Adhikaraṇa               |
>> |    7125 | AdhikÄ ra                  |
>> |    7118 | AdhikÄ ra_Nandi            |
>> +---------+----------------------------+
>> -----PAGE TABLE STATUS AFTER UPGRADE-----
>>
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | Name              | Engine | Version | Row_format | Rows  |
>> Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
>> Auto_increment | Create_time         | Update_time | Check_time |
>> Collation       | Checksum | Create_options | Comment |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> | page              | InnoDB |      10 | Compact    | 11883 |
>> 133 |     1589248 |               0 |      2162688 | 111149056 |
>> 14232 | 2015-11-01 10:40:06 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_props        | InnoDB |      10 | Compact    |     0 |
>> 0 |       16384 |               0 |            0 | 111149056 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>> | page_restrictions | InnoDB |      10 | Compact    |     2 |
>> 8192 |       16384 |               0 |        65536 | 111149056
>> |              3 | 2015-11-01 10:40:07 | NULL        | NULL       |
>> utf8_general_ci |     NULL |                |         |
>> | pagelinks         | InnoDB |      10 | Compact    | 28765 |
>> 55 |     1589248 |               0 |      1589248 | 111149056 |
>> NULL | 2015-11-01 10:40:07 | NULL        | NULL       | utf8_general_ci
>> |     NULL |                |         |
>>
>> +-------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
>> mysql> select page_id,page_title from page where page_title like 'Adhik%';
>> +---------+----------------------------+
>> | page_id | page_title                 |
>> +---------+----------------------------+
>> |   11974 | Adhikamasa                 |
>> |   11975 | Adhikamasa,_adhimasa       |
>> |    7128 | AdhikamÄ sa                |
>> |    6658 | AdhikamÄ sa,_adhimÄ sa     |
>> |   11977 | Adhikara                   |
>> |   11978 | Adhikara_Nandi             |
>> |   11976 | Adhikarana                 |
>> |    6660 | Adhikaraṇa               |
>> |    6659 | AdhikÄ ra                  |
>> |    6661 | AdhikÄ ra_Nandi            |
>> |    7126 | AdhikamÄ sa,_adhimÄ sa     |
>> |    7117 | Adhikaraṇa               |
>> |    7125 | AdhikÄ ra                  |
>> |    7118 | AdhikÄ ra_Nandi            |
>> +---------+----------------------------+
>>
>>
>> Not sure if this is correct, but I came across
>> http://product.hubspot.com/bid/7049/MySQL-and-Unicode-Three-Gotchas
>>
>> which suggested that the page_title field could be improperly encoded (as
>> varchar 255 instead of utf8).
>>
>> I tried to do
>>
>> ALTER TABLE page MODIFY page_title VARCHAR(255) CHARACTER SET utf8;
>>
>> But there are way too many conflicts/duplicates in the key page_name which
>> prevents me from doing it w/o dropping the index.  BTW, if I do it, I can't
>> recreate it with the "UNIQUE" property which it has right now due to the
>> duplicates.
>>
>>
>> https://www.mediawiki.org/wiki/Manual:MWDumper
>> Suggests that the character type should be set to Binary to prevent these
>> types of issues...but not sure what I need to do to get there from where I
>> am right now.
>>
>> Any ideas?
>>
>> Thanks,
>>
>> Krishna
>>
>> --------------------------------------------------------------------------------
>> Krishna Maheshwari
>> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>>
>> --------------------------------------------------------------------------------
>>
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
kkm
Reply | Threaded
Open this post in threaded view
|

Re: problem following 1.16 to 1.25 conversion

kkm
In reply to this post by kkm
I tried playing with $wgDBTableOptions but it didn't help.

Is there a way to import images into mediawiki and preserve existing file
links to those images?  e.g., restore all content--both text & images.

Best Regards,

Krishna


--------------------------------------------------------------------------------
Krishna Maheshwari
[hidden email]
[hidden email]
Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
--------------------------------------------------------------------------------

On Fri, Nov 20, 2015 at 1:45 PM, kkm <[hidden email]> wrote:

> I downloaded MySQL Workbench and started looking at the tables using this
> tool instead of the CLI.
>
> It looks like the article titles in the page table themselves aren't
> stored properly...yet they are presented properly in mediawiki....anyone
> know what is going on?
>
> BTW, if I dump the mediawiki articles and than import the dump, the
> articles w/ titles that require UTF8 are added to the mediawiki w/ correct
> UTF8 characters in the db...
>
> Do I need to go back and manually delete all the articles w/ the messed up
> titles or is there a way to fix this?  Or better yet, is there a way to fix
> the tables since the correct encoding is available somewhere...
>
> Best Regards,
>
> Krishna
>
>
> --------------------------------------------------------------------------------
> Krishna Maheshwari
> [hidden email]
> [hidden email]
> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>
> --------------------------------------------------------------------------------
>
> On Thu, Nov 19, 2015 at 9:27 PM, kkm <[hidden email]> wrote:
>
>> My php settings didn't get through, so trying to resent.
>>
>> --------------------------------------------------------------------------------
>> <[hidden email]>
>> Hindupedia, the Hindu Encyclopedia  (www.hindupedia.com)
>>
>> --------------------------------------------------------------------------------
>>
>> ---------- Forwarded message ----------
>> From: kkm <[hidden email]>
>> Date: Wed, Nov 18, 2015 at 9:45 PM
>> Subject: Re: problem following 1.16 to 1.25 conversion
>> To: [hidden email]
>>
>>
>> Hi,
>>
>> My mysql settings as shown with the \s flag.
>>
>> Variables (--variable-name=value)
>> and boolean options {FALSE|TRUE}  Value (after reading options)
>> --------------------------------- ----------------------------------------
>> auto-rehash                       TRUE
>> auto-vertical-output              FALSE
>> character-sets-dir                (No default value)
>> column-type-info                  FALSE
>> comments                          FALSE
>> compress                          FALSE
>> debug-check                       FALSE
>> debug-info                        FALSE
>> database                          (No default value)
>> default-character-set             auto
>> delimiter                         ;
>> enable-cleartext-plugin           FALSE
>> vertical                          FALSE
>> force                             FALSE
>> named-commands                    FALSE
>> ignore-spaces                     FALSE
>> init-command                      (No default value)
>> local-infile                      FALSE
>> no-beep                           FALSE
>> host                              (No default value)
>> html                              FALSE
>> xml                               FALSE
>> line-numbers                      TRUE
>> unbuffered                        FALSE
>> column-names                      TRUE
>> sigint-ignore                     FALSE
>> port                              3306
>> prompt                            mysql>
>> quick                             FALSE
>> raw                               FALSE
>> reconnect                         TRUE
>> socket                            /var/run/mysqld/mysqld.sock
>> ssl                               FALSE
>> ssl-ca                            (No default value)
>> ssl-capath                        (No default value)
>> ssl-cert                          (No default value)
>> ssl-cipher                        (No default value)
>> ssl-key                           (No default value)
>> ssl-verify-server-cert            FALSE
>> table                             FALSE
>> user                              root
>> safe-updates                      FALSE
>> i-am-a-dummy                      FALSE
>> connect-timeout                   0
>> max-allowed-packet                16777216
>> net-buffer-length                 16384
>> select-limit                      1000
>> max-join-size                     1000000
>> secure-auth                       FALSE
>> show-warnings                     FALSE
>> plugin-dir                        (No default value)
>> default-auth                      (No default value)
>>
>> My original mysql version (prior to the physical server migration) was:
>>
>> *>SHOW VARIABLES LIKE "%version%";*
>>
>> +-------------------------+------------------+
>> | Variable_name           | Value            |
>> +-------------------------+------------------+
>> | innodb_version          | 5.5.44           |
>> | protocol_version        | 10               |
>> | slave_type_conversions  |                  |
>> | version                 | 5.5.44-0+deb8u1  |
>> | version_comment         | (Debian)         |
>> | version_compile_machine | x86_64           |
>> | version_compile_os      | debian-linux-gnu |
>> +-------------------------+------------------+
>>
>> However, the current version of mysql is
>> +-------------------------+------------------+
>> | Variable_name           | Value            |
>> +-------------------------+------------------+
>> | innodb_version          | 5.5.46           |
>> | protocol_version        | 10               |
>> | slave_type_conversions  |                  |
>> | version                 | 5.5.46-0+deb8u1  |
>> | version_comment         | (Debian)         |
>> | version_compile_machine | x86_64           |
>> | version_compile_os      | debian-linux-gnu |
>> +-------------------------+------------------+
>>
>> This version is currently hosting v.1.16.5 of Hindupedia.  The upgraded
>> mediawiki would remain on this version of mysql.
>>
>> An alternate approach would be to dump the mediawiki contents (using the
>> dumpBackup.php maintenance script and to import them using
>> importDump.php).  However, I haven't found a way to backup & restore the
>> images in such a way that the image links within the wiki still work (just
>> importing them by using importImages.php imported the images but didn't
>> restore the links to the images in the articles).
>>
>> Krishna
>>
>>
>>
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l