Hi all,
I'm preparing a wiki site with several languages (all v1.11). All single wikis work fine individually, installations are ok, no error reports (see http://www.iustitia.com/wiki/environment_ok.png). All wikis use the same db with different table prefixes (es_, en_, de_, etc.). But there is one single step that drives me crazy. As the site is being hosted on a shared hosting, I ONLY have access to MySQL via phpMyAdmin.
These tutorials (http://www.mediawiki.org/wiki/Manual:Wiki_family, http://www.mediawiki.org/wiki/Help_talk:Interwiki_linking, http://www.mediawiki.org/wiki/Help:Interwiki_linking, http://www.steverumberg.com/wiki/index.php/WikiHelp) indicate that I must insert a new row by clicking on "interwiki", then on "Browse", then on "Insert", filling in these 2 "Values":
- iw_prefix = the language prefix. Example: "es" for spanish, "de" for german, etc. - iw_url = the URL to the sister project. Example: http://www.iustitia.com/wiki/es/index.php/$1
But there resides my problem! I CANNOT indicate any URL at "iw_url", because its "Type" is set to "BLOB" and not to "varchar(32)" as it supposed to be (?). See http://www.iustitia.com/wiki/mysql_iw_url_blob.png
Other users had the same problem (see http://www.mediawiki.org/wiki/Help_talk:Interwiki_linking#Database_Blob) but the link they were provided with is not solving this issue (http://meta.wikimedia.org/wiki/Help:Guide_for_system_administrators_for_sett...).
So, my questions are:
1) How can I indicate the URL using phpMyAdmin (please remember that I do not have telnet access to the server)? 2) Do I have to indicate something in the column "Function" (by default its empty)?
Operating system: Linux Kernel: 2.6.9-55.0.2.ELsmp Apache: 1.3.37 (Unix) PERL: 5.8.8 PHP: 5.2.1 MySQL: 4.1.22-standard
Any help would be greatly appreciated.
Thanks in advance! Zelula
Zelula X wrote:
But there resides my problem! I CANNOT indicate any URL at "iw_url", because its "Type" is set to "BLOB" and not to "varchar(32)" as it supposed to be (?). See http://www.iustitia.com/wiki/mysql_iw_url_blob.png
Well, it allows you to upload it as a file. So you could create a file only with the url (no line breaks) and upload for that field. You could manually prepare a SQL dump with all the URLs and import that via phpmyadmin.
Thx Platonides, but I'm not a SQL guru :-/.
1) Can the file be a normal *.txt file? Example: created with thye Windows notepad?
2) Could you give me a link on how to create a SQL dump manually?
Thanks in advance! Zelula
On Nov 17, 2007 5:00 PM, Platonides Platonides@gmail.com wrote:
Zelula X wrote:
But there resides my problem! I CANNOT indicate any URL at "iw_url", because its "Type" is set to "BLOB" and not to "varchar(32)" as it supposed to be (?). See http://www.iustitia.com/wiki/mysql_iw_url_blob.png
Well, it allows you to upload it as a file. So you could create a file only with the url (no line breaks) and upload for that field. You could manually prepare a SQL dump with all the URLs and import that via phpmyadmin.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Zelula X wrote:
- Can the file be a normal *.txt file? Example: created with thye
Windows notepad?
Sure thing.
- Could you give me a link on how to create a SQL dump manually
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
MinuteElectron.
mediawiki-l@lists.wikimedia.org