Difference between revisions of "Upgrade a wiki"

From Organic Design wiki
(Illegal mix of collations error)
m (Illegal mix of collations error)
Line 19: Line 19:
 
:'''Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat' '''
 
:'''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]]):
+
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:DPL:Manual - Source and Installation]]):
 
{{code|<mysql>
 
{{code|<mysql>
 
CREATE VIEW prefix_dpl_clview AS  
 
CREATE VIEW prefix_dpl_clview AS  
Line 25: Line 25:
 
   FROM `prefix_page` LEFT OUTER JOIN `prefix_categorylinks` ON page_id=cl_from;
 
   FROM `prefix_page` LEFT OUTER JOIN `prefix_categorylinks` ON page_id=cl_from;
 
</mysql>}}
 
</mysql>}}
 
  
 
== See also ==
 
== See also ==

Revision as of 04:08, 28 January 2009

Procedure.svg 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:DPL:Manual - Source and Installation):

{{{1}}}

See also