[Web-cyradm] Database Errors in 0.5.5

[Lukasz Marciniak]

Użytkownik Just Gags napisał:
> E_ALL did not being up any additional errors. However, but finding the
> mysql query and manually running it, I got the following message from
> mysql:
> 
> ERROR 1054 (42S22): Unknown column 'folders' in 'field list'
> 
> Is the database not populating correctly?


There was missing line in scripts/create_*.sql. Corrected today in svn
version number 830 (in trunk and release_0_5_5 branch).

Hot-fix:
MySql:
ALTER TABLE `domain` ADD `folders` varchar(255) NOT NULL DEFAULT '';
Pgsql:
ALTER TABLE domain ADD folders varchar(255);
ALTER TABLE domain SET DEFAULT '';
UPDATE domain SET folders = DEFAULT;
ALTER TABLE domain ALTER COLUMN folders SET NOT NULL;

Regards,
Lukasz