Difference between revisions of "Upgrade a wiki"
m (→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: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 the [[DPL:DPL:Manual - Source and Installation|DPL manual]]): |
{{code|<mysql> | {{code|<mysql> | ||
CREATE VIEW prefix_dpl_clview AS | CREATE VIEW prefix_dpl_clview AS | ||
Revision as of 04:08, 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 the DPL manual):
