Online demo Privacy policy GoBD notes Blog

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
current:upgrade [2017/10/29 09:46]
sj
current:upgrade [2019/04/29 21:47] (current)
sj
Line 248: Line 248:
 Nothing extra is required. Nothing extra is required.
  
-**from 1.3.0 to 1.3.2**+**from 1.3.0 to 1.3.5**
  
 The default mysql encoding has been changed from utf8 to utf8mb4. In mysql's terms 'utf8' is only a subset of the 4 byte range of the UTF-8 encoding. To provide full UTF-8 support mysql offers utf8mb4 encoding which is the default starting from 1.3.2.  The default mysql encoding has been changed from utf8 to utf8mb4. In mysql's terms 'utf8' is only a subset of the 4 byte range of the UTF-8 encoding. To provide full UTF-8 support mysql offers utf8mb4 encoding which is the default starting from 1.3.2. 
Line 266: Line 266:
 <code>sql_query_pre = SET NAMES utf8</code> <code>sql_query_pre = SET NAMES utf8</code>
  
-Additional notes: the piler install process creates piler.conf.default and sphinx.conf.default files.+Perform the following sql statements: 
 + 
 +<code> 
 +alter table sph_index change column `from` `from` tinyblob default null; 
 +alter table metadata change column `from` `from` varchar(255) not null; 
 +alter table metadata change column `fromdomain` `fromdomain` varchar(255) not null; 
 +alter table metadata change column `message_id` `message_id` varchar(255) not null; 
 +alter table attachment change column `name` `name` tinyblob default null; 
 +alter table sph_index change column `body` `body` mediumblob default null; 
 +alter table sph_index change column `subject` `subject` blob default null; 
 +</code> 
 + 
 +And add the following jobs to piler's crontab: 
 + 
 +<code> 
 +*/5 * * * * /usr/bin/find /var/piler/error -type f|wc -l > /var/piler/stat/error 
 +3 * * * * /usr/local/libexec/piler/watch_sphinx_main_index.sh 
 +</code> 
Google Analytics Alternative