Difference between revisions of "Upgrade a wiki"
m |
(Illegal mix of collations error) |
||
| Line 14: | Line 14: | ||
For information on how to do this, see [[Run a wiki maintenance script]] | For information on how to do this, see [[Run a wiki maintenance script]] | ||
| + | |||
| + | == Illegal mix of collations error == | ||
| + | If the wiki has [[MW:DPL|DPL]] running on it you may have an error similar such as: | ||
| + | :'''Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat' ''' | ||
| + | |||
| + | This problem can be solved by looping through all the tables and setting their character set to ''utf8'' using the [[change the character-set of a wiki database]] procedure. but first you're best to get rid of the database view that DPL uses with '''drop prefix_dpl_clview''', then change the character sets as shown in the procedure, and then put the DPL view back as shown below (from [[DPL:Manual - Source and Installation]]): | ||
| + | {{code|<mysql> | ||
| + | CREATE VIEW prefix_dpl_clview AS | ||
| + | SELECT IFNULL(cl_from, page_id) AS cl_from, IFNULL(cl_to, '') AS cl_to, cl_sortkey | ||
| + | FROM `prefix_page` LEFT OUTER JOIN `prefix_categorylinks` ON page_id=cl_from; | ||
| + | </mysql>}} | ||
| + | |||
== See also == | == See also == | ||
Revision as of 04:07, 28 January 2009
|
Upgrade a wiki Organic Design procedure |
Shell in and change to the wiki's directory in /var/www/wikis.
Put the site down for maintenance by adding $wgSiteDown = true; to it's LocalSettings.php file.
Update wiki symlink to point to the new code-base.
Upgrading a wiki to a more recent version involves running the update.php maintenance script. Make sure that you have created an AdminSettings.php first.
For information on how to do this, see Run a wiki maintenance script
Illegal mix of collations error
If the wiki has DPL running on it you may have an error similar such as:
- Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat'
This problem can be solved by looping through all the tables and setting their character set to utf8 using the change the character-set of a wiki database procedure. but first you're best to get rid of the database view that DPL uses with drop prefix_dpl_clview, then change the character sets as shown in the procedure, and then put the DPL view back as shown below (from DPL:Manual - Source and Installation):
