Author Topic: error fresh install kolab calendar  (Read 5707 times)

Offline fferraro87

  • Newbie
  • *
  • Posts: 3
error fresh install kolab calendar
« on: January 16, 2020, 06:31:34 AM »
Hi,

i'm trying to install kolab calendar plugin so i've added requirements package on composer :

Code: [Select]
    "require": {
        "php": ">=5.4.0",
        "pear/pear-core-minimal": "~1.10.1",
        "pear/auth_sasl": "~1.1.0",
        "pear/net_idna2": "~0.2.0",
        "pear/mail_mime": "~1.10.0",
        "pear/net_smtp": "~1.8.1",
        "pear/crypt_gpg": "~1.6.3",
        "pear/net_sieve": "~1.4.3",
        "roundcube/plugin-installer": "~0.1.6",
        "masterminds/html5": "~2.5.0",
        "endroid/qr-code": "~1.6.5",
        "kolab/net_ldap3": "~1.1.1",
        "kolab/libcalendaring": ">=3.4.0",
        "kolab/libkolab": ">=3.4.0",
        "kolab/calendar": ">=3.5.2"
    },

but i've that error during installation :
Code: [Select]
ERROR: Error in DDL schema /var/www/html/plugins/calendar/drivers/database/SQL/mysql.initial.sql: [1005] Can't create table 'webmail.levmail_calendars' (errno: 150)
it seems that mysql.initial.sql has some errors on foreign key.
So how can i fix?
Thanks

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363
Re: error fresh install kolab calendar
« Reply #1 on: January 16, 2020, 10:20:59 AM »
Looks like database prefix and plugin installer bug: https://github.com/roundcube/plugin-installer/issues/19

Offline fferraro87

  • Newbie
  • *
  • Posts: 3
Re: error fresh install kolab calendar
« Reply #2 on: January 16, 2020, 10:34:46 AM »
Looks like database prefix and plugin installer bug: https://github.com/roundcube/plugin-installer/issues/19

So what i need to do? i've added prefix like this :
Code: [Select]
CREATE TABLE IF NOT EXISTS `webmail_calendars` (
  `calendar_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `color` varchar(8) NOT NULL,
  `showalarms` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY(`calendar_id`),
  INDEX `user_name_idx` (`user_id`, `name`),
  CONSTRAINT `fk_calendars_user_id` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
but it doesn't work