| HideElements | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
| Note |
|---|
These scripts and tools are provided to help you manage your Kopano system. They are provided as a free service for Kopano users, without warranty of any kind. Please be aware that usage is at your own risk! |
...
- Shut down any running instance of Kopano Server (e.g. service kopano-server stop)
- Access your mysql console (mysql -p) and switch to the kopano database (use kopano;)
- Execute the following queries:
TRUNCATE tproperties;
INSERT IGNORE INTO tproperties (folderid,hierarchyid,tag,type,val_ulong,val_string,val_binary,val_double,val_longint,val_hi,val_lo) SELECT h.id, p.hierarchyid, p.tag, p.type, p.val_ulong, LEFT(p.val_string,255), LEFT(p.val_binary,255), p.val_double, p.val_longint, p.val_hi, p.val_lo FROM properties AS p JOIN hierarchy AS tmp ON p.hierarchyid = tmp.id AND p.tag NOT IN (0x1013,0x1009) JOIN hierarchy AS h ON tmp.parent = h.id AND h.type = 3; - Start Kopano Server again (e.g. service kopano-server start)
...
| Info |
|---|
Please note that this operation will take some time, depending on the database size. We recommend to do this operation outside normal operation hours. |
Related articles
| Content by Label | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page properties | ||
|---|---|---|
| ||
| Related issues |