I am attempting to upgrade Mediawiki 1.5.2 to 1.6.5 but am hitting some issues in the upgrade.php step. Below is the steps I followed:
1.) Backup EVERYTHING 2.) Copy new Mediwiki 1.6.5 on top of Mediawiki 1.5.2 (preserving LocalSettings.php, AdminSettings.php, images, and extensions. 3.) Ensure AdminSettings.php file is set correctly 4.) cd in maintenance directory 5.) run php update.php
It starts out okay, sees all my wiki tables, and then gives this error and dies: ERROR 1005 (HY000): Can't create table 'wiki_transcache' (errno: 13)
I set my AdminSettings.php to be the MySQL admin login. If I run the same SQL from mysql> prompt (not via the script) it also gives the same error. Not being very fluent in MySQL, this tells me that somehow both my MySQL admin account, and the account that Mediawiki logs in MySQL as lost CREATE privilleges on my databse. Can someone confirm? If so, how do I put them back? Thanks in advance!!
Greg Rodenhiser wrote:
It starts out okay, sees all my wiki tables, and then gives this error and dies: ERROR 1005 (HY000): Can't create table 'wiki_transcache' (errno: 13)
Possibly your MySQL data directory is borked. Check the file permissions, make sure the MySQL user has appropriate rights to create files in there.
-- brion vibber (brion @ pobox.com)
That was it!!! Thank you!!!!! On a side note, Mediawiki seems far more strict about html tags in the wiki pages. We used a lot of <dt> and <dd> but did not include </dt> and </dd> closing tags. On Mediawiki 1.5.2 this made no difference, it magically assumed the closing tags. Now we have to "repair" a lot of our lazy wiki pages. Is there a way to get back the older sloppy html behavior? Again, thank you for your help thus far..... And thanks in advance to anyone who knows about the html issue!!
On 5/5/06, Brion Vibber brion@pobox.com wrote:
Greg Rodenhiser wrote:
It starts out okay, sees all my wiki tables, and then gives this error
and
dies: ERROR 1005 (HY000): Can't create table 'wiki_transcache' (errno: 13)
Possibly your MySQL data directory is borked. Check the file permissions, make sure the MySQL user has appropriate rights to create files in there.
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Greg Rodenhiser wrote:
That was it!!! Thank you!!!!! On a side note, Mediawiki seems far more strict about html tags in the wiki pages. We used a lot of <dt> and <dd> but did not include </dt> and </dd> closing tags. On Mediawiki 1.5.2 this made no difference, it magically assumed the closing tags. Now we have to "repair" a lot of our lazy wiki pages. Is there a way to get back the older sloppy html behavior? Again, thank you for your help thus far..... And thanks in advance to anyone who knows about the html issue!!
This sounds like http://bugzilla.wikimedia.org/show_bug.cgi?id=5497
The simplest workaround would be to enable the HTML Tidy mode, which will use an external program for some HTML validity/normalization.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org