Difference between revisions of "MediaWiki"

From Blue-IT.org Wiki

 
(Patches)
Line 10: Line 10:
 
#Mysql is only version 4.0.15
 
#Mysql is only version 4.0.15
 
#PHP is limited in memory
 
#PHP is limited in memory
 +
 +
You will get an error during installation.
  
 
Because of a bug in php you shoul do 2 things:
 
Because of a bug in php you shoul do 2 things:
Line 16: Line 18:
 
  memory_limit = 50M      ; Maximum amount of memory a script may consume (8MB)
 
  memory_limit = 50M      ; Maximum amount of memory a script may consume (8MB)
  
Second due to a bug in older mysql  versions you have to change two installation files of the media wiki.
+
Second due to a bug in older mysql  versions you have to change two installation files of the media wiki.  
  
 
At the end of the file ''maintenance/mysql5/tables.sql''
 
At the end of the file ''maintenance/mysql5/tables.sql''
 
Change
 
Change
  
PRIMARY KEY job_id (job_id),
 
 
  KEY (job_cmd, job_namespace, job_title)
 
  KEY (job_cmd, job_namespace, job_title)
 
  ) TYPE=InnoDB, DEFAULT CHARSET=utf8;
 
  ) TYPE=InnoDB, DEFAULT CHARSET=utf8;
Line 27: Line 28:
 
to  
 
to  
  
PRIMARY KEY job_id (job_id),
 
 
  KEY (job_cmd(255), job_namespace, job_title(255))
 
  KEY (job_cmd(255), job_namespace, job_title(255))
 
  ) TYPE=InnoDB, DEFAULT CHARSET=utf8;
 
  ) TYPE=InnoDB, DEFAULT CHARSET=utf8;
  
 
(!) '''The same''' (!) you have to do in file ''maintenance/archives/patch-job.sql''
 
(!) '''The same''' (!) you have to do in file ''maintenance/archives/patch-job.sql''

Revision as of 19:45, 1 June 2006

Concerns

  • Media Wiki 1.6.6
  • Mysql 4.0.15
  • SuSE 9.0 on vserver

Patches

There are some major problems concerning the installation of media wiki on SuSE 9.0 on a vserver:

  1. Mysql is only version 4.0.15
  2. PHP is limited in memory

You will get an error during installation.

Because of a bug in php you shoul do 2 things:

First edit /etc/php.ini an change the memory limit from 8 to 50MB:

memory_limit = 50M      ; Maximum amount of memory a script may consume (8MB)

Second due to a bug in older mysql versions you have to change two installation files of the media wiki.

At the end of the file maintenance/mysql5/tables.sql Change

KEY (job_cmd, job_namespace, job_title)
) TYPE=InnoDB, DEFAULT CHARSET=utf8;

to

KEY (job_cmd(255), job_namespace, job_title(255))
) TYPE=InnoDB, DEFAULT CHARSET=utf8;

(!) The same (!) you have to do in file maintenance/archives/patch-job.sql