[sorry for the duplicate message, forgot to CC to the list] That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema."
--- On Tue, 8/26/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: "Sullivan, James (NIH/CIT) [C]" sullivan@mail.nih.gov Date: Tuesday, August 26, 2008, 7:19 AM
That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema." hmmm.
--- On Tue, 8/26/08, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
From: Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: ek79501@yahoo.com, "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Date: Tuesday, August 26, 2008, 6:44 AM
After upgrading the Mediawiki code did you run: maintenance/update.php and maintenance/refreshLinks.php ?
-Jim
-----Original Message----- From: Eric K [mailto:ek79501@yahoo.com] Sent: Monday, August 25, 2008 9:27 PM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations
Here's what I found. When Mediawiki upgrades, it doesnt seem to care to update the table schemes properly. Here's a sample of what I found: Old table row specs, for mw_image (this is after the upgrade has been applied from 1.9.3 to 1.13.0): img_size int(8) img_width int(5) img_height int(5) New table row specs for the same table, mw_image (for a brand new 1.13.0 installation): img_size int(10) img_width int(11) img_height int(11) The field sizes are different as you can see. New tables have bigger fields but the old ones still contain short fields after the upgrade is applied.This is just an example. The bug that I was getting (illegal mix of collations), was fixed due to the Collation fields being different in the cases for an upgraded MW and a new MW. I also noticed differences in all the other fields as well (Default, Type, Binary, Attributes) for tables rows. Sometimes the differences were significant. Here are some real examples: - length of data field doubled for example, int(5) to int (10) - the Type changed in an upgraded version from "varbinary(255)" to "blob", in a new installation Usually, Collate was empty for a brand new 1.13.0, while it was latin_bin or latin1_swedish_ci for an upgraded version. There must be important reasons why changes were made to the rows as versions progressed. So i guess this is something that should be fixed for upgrading? That means, when an upgrade is being applied, it should update all the row data for each table as well. Erik
--- On Sat, 8/23/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of collations To: mediawiki-l@lists.wikimedia.org Date: Saturday, August 23, 2008, 11:30 AM
Everything works on my wiki, except when I view the logs for a page, I get this error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "LinkCache::addLinkObj". MySQL returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)". Any ideas on how to fix this? I can go into myPhPAdmin and manipulate tables if needed. thanks Eric
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Assuming Alternative 2 works as advertised, check that permissions are set properly and that it ran completely. I've always used the commandline method so I'm not familiar with Alternative 2.
Also, consider that an extension that is working with the old schema needs to be upgraded.
And if you have commandline access, try running update.php from the commandline.
If that fails you may want to start from scratch and do the upgrade again from backups.
-Jim
-----Original Message----- From: Eric K [mailto:ek79501@yahoo.com] Sent: Tuesday, August 26, 2008 8:21 AM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error:Illegalmix of collations
[sorry for the duplicate message, forgot to CC to the list] That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema."
--- On Tue, 8/26/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: "Sullivan, James (NIH/CIT) [C]" sullivan@mail.nih.gov Date: Tuesday, August 26, 2008, 7:19 AM
That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema." hmmm.
--- On Tue, 8/26/08, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
From: Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: ek79501@yahoo.com, "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Date: Tuesday, August 26, 2008, 6:44 AM
After upgrading the Mediawiki code did you run: maintenance/update.php and maintenance/refreshLinks.php ?
-Jim
-----Original Message----- From: Eric K [mailto:ek79501@yahoo.com] Sent: Monday, August 25, 2008 9:27 PM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations
Here's what I found. When Mediawiki upgrades, it doesnt seem to care to update the table schemes properly. Here's a sample of what I found: Old table row specs, for mw_image (this is after the upgrade has been applied from 1.9.3 to 1.13.0): img_size int(8) img_width int(5) img_height int(5) New table row specs for the same table, mw_image (for a brand new 1.13.0 installation): img_size int(10) img_width int(11) img_height int(11) The field sizes are different as you can see. New tables have bigger fields but the old ones still contain short fields after the upgrade is applied.This is just an example. The bug that I was getting (illegal mix of collations), was fixed due to the Collation fields being different in the cases for an upgraded MW and a new MW. I also noticed differences in all the other fields as well (Default, Type, Binary, Attributes) for tables rows. Sometimes the differences were significant. Here are some real examples: - length of data field doubled for example, int(5) to int (10) - the Type changed in an upgraded version from "varbinary(255)" to "blob", in a new installation Usually, Collate was empty for a brand new 1.13.0, while it was latin_bin or latin1_swedish_ci for an upgraded version. There must be important reasons why changes were made to the rows as versions progressed. So i guess this is something that should be fixed for upgrading? That means, when an upgrade is being applied, it should update all the row data for each table as well. Erik
--- On Sat, 8/23/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of collations To: mediawiki-l@lists.wikimedia.org Date: Saturday, August 23, 2008, 11:30 AM
Everything works on my wiki, except when I view the logs for a page, I get this error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "LinkCache::addLinkObj". MySQL returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)". Any ideas on how to fix this? I can go into myPhPAdmin and manipulate tables if needed. thanks Eric
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Jim, thanks. There were some problems during installation but it did go through. Since I was able to change the table structures by hand, I assumed the script could have done the same but did not. In my next upgrade, I will take notes and compare the schemas and then get back here if I notice differences. thanks! Eric
--- On Tue, 8/26/08, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
From: Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error:Illegalmix of collations To: ek79501@yahoo.com, "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Date: Tuesday, August 26, 2008, 7:32 AM
Assuming Alternative 2 works as advertised, check that permissions are set properly and that it ran completely. I've always used the commandline method so I'm not familiar with Alternative 2.
Also, consider that an extension that is working with the old schema needs to be upgraded.
And if you have commandline access, try running update.php from the commandline.
If that fails you may want to start from scratch and do the upgrade again from backups.
-Jim
-----Original Message----- From: Eric K [mailto:ek79501@yahoo.com] Sent: Tuesday, August 26, 2008 8:21 AM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error:Illegalmix of collations
[sorry for the duplicate message, forgot to CC to the list] That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema."
--- On Tue, 8/26/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: "Sullivan, James (NIH/CIT) [C]" sullivan@mail.nih.gov Date: Tuesday, August 26, 2008, 7:19 AM
That might be it but, the directions dont ask me to run those scripts separately, as far as I can see? http://www.mediawiki.org/wiki/Manual:Upgrading_MediaWiki I followed the Alternative 2, which just asked me to re-run the installer. In that, it says: - "When the installation process starts, the script will detect existing MediaWiki tables, and upgrade their schema." hmmm.
--- On Tue, 8/26/08, Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov wrote:
From: Sullivan, James (NIH/CIT) [C] sullivan@mail.nih.gov Subject: RE: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations To: ek79501@yahoo.com, "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Date: Tuesday, August 26, 2008, 6:44 AM
After upgrading the Mediawiki code did you run: maintenance/update.php and maintenance/refreshLinks.php ?
-Jim
-----Original Message----- From: Eric K [mailto:ek79501@yahoo.com] Sent: Monday, August 25, 2008 9:27 PM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegalmix of collations
Here's what I found. When Mediawiki upgrades, it doesnt seem to care to update the table schemes properly. Here's a sample of what I found: Old table row specs, for mw_image (this is after the upgrade has been applied from 1.9.3 to 1.13.0): img_size int(8) img_width int(5) img_height int(5) New table row specs for the same table, mw_image (for a brand new 1.13.0 installation): img_size int(10) img_width int(11) img_height int(11) The field sizes are different as you can see. New tables have bigger fields but the old ones still contain short fields after the upgrade is applied.This is just an example. The bug that I was getting (illegal mix of collations), was fixed due to the Collation fields being different in the cases for an upgraded MW and a new MW. I also noticed differences in all the other fields as well (Default, Type, Binary, Attributes) for tables rows. Sometimes the differences were significant. Here are some real examples: - length of data field doubled for example, int(5) to int (10) - the Type changed in an upgraded version from "varbinary(255)" to "blob", in a new installation Usually, Collate was empty for a brand new 1.13.0, while it was latin_bin or latin1_swedish_ci for an upgraded version. There must be important reasons why changes were made to the rows as versions progressed. So i guess this is something that should be fixed for upgrading? That means, when an upgrade is being applied, it should update all the row data for each table as well. Erik
--- On Sat, 8/23/08, Eric K ek79501@yahoo.com wrote:
From: Eric K ek79501@yahoo.com Subject: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of collations To: mediawiki-l@lists.wikimedia.org Date: Saturday, August 23, 2008, 11:30 AM
Everything works on my wiki, except when I view the logs for a page, I get this error:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "LinkCache::addLinkObj". MySQL returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)". Any ideas on how to fix this? I can go into myPhPAdmin and manipulate tables if needed. thanks Eric
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org