Hello,
some days ago I did a cleam installation of Roundcube, as offered I downloaded version 1.1.0. Installation went well, Roundcube is working as intended.
Yesterday I installed calendar-plugin, an run:
mysql -u root -p roundcubemail < /var/lib/roundcube/plugins/calendar/drivers/database/SQL/mysql.initial.sql
After typing the password I get:
ERROR 1064 (42000) at line 26: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0',
created
datetime NOT NULL DEFAULT '1000-01-' at line 7
Is there a problem with the SQL-code, or is this a problem with MariaDB?
Thaanks a lot!
Cheers, Torsten
On Tue, Mar 17, 2015 at 9:43 AM, T. Ermlich Pelegrine@gmx.net wrote:
Hello,
some days ago I did a cleam installation of Roundcube, as offered I downloaded version 1.1.0. Installation went well, Roundcube is working as intended.
Yesterday I installed calendar-plugin, an run: mysql -u root -p roundcubemail < /var/lib/roundcube/plugins/calendar/drivers/database/SQL/mysql.initial.sql After typing the password I get: ERROR 1064 (42000) at line 26: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0',
created
datetime NOT NULL DEFAULT '1000-01-' at line 7
Ooopsie, that's an error in the SQL schema. Fixed in https://gitlab.com/kolab-roundcube-plugins/calendar/commit/125420074d136bb23...
~Thomas
Thanks! :)
Now that works ... but it gives additional errors: ERROR 1005 (HY000) at line 26: Can't create table 'roundcubemail.events' (errno: 121) Do you have have an idea?
Plus I found some typos: It should be "Kategorie", not "Katgorie: plugins/calendar/localization/de_DE.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_DE.inc:$labels['remove_category'] = 'Katgorie entfernen'; plugins/calendar/localization/de_CH.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_CH.inc:$labels['remove_category'] = 'Katgorie entfernen'; plugins/calendar_kolab/localization/de_CH.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar_kolab/localization/de_CH.inc:$labels['remove_category'] = 'Katgorie entfernen';
Cheers, Torsten
Gesendet: Dienstag, 17. März 2015 um 09:58 Uhr Von: "Thomas Bruederli" thomas@roundcube.net An: "Roundcube Users mailing list" users@lists.roundcube.net Betreff: Re: [RCU] Problem running the calendar sql-command
On Tue, Mar 17, 2015 at 9:43 AM, T. Ermlich Pelegrine@gmx.net wrote:
Hello,
some days ago I did a cleam installation of Roundcube, as offered I downloaded version 1.1.0. Installation went well, Roundcube is working as intended.
Yesterday I installed calendar-plugin, an run: mysql -u root -p roundcubemail < /var/lib/roundcube/plugins/calendar/drivers/database/SQL/mysql.initial.sql After typing the password I get: ERROR 1064 (42000) at line 26: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0',
created
datetime NOT NULL DEFAULT '1000-01-' at line 7Ooopsie, that's an error in the SQL schema. Fixed in https://gitlab.com/kolab-roundcube-plugins/calendar/commit/125420074d136bb23...
~Thomas _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Everything runs fine now! I simply reinstalled the Roundcube database.
Cheers, Torsten
T. Ermlich Pelegrine@gmx.net schrieb am 17.03.2015 10:31:
Thanks! :)
Now that works ... but it gives additional errors: ERROR 1005 (HY000) at line 26: Can't create table 'roundcubemail.events' (errno: 121) Do you have have an idea?
Plus I found some typos: It should be "Kategorie", not "Katgorie: plugins/calendar/localization/de_DE.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_DE.inc:$labels['remove_category'] = 'Katgorie entfernen'; plugins/calendar/localization/de_CH.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_CH.inc:$labels['remove_category'] = 'Katgorie entfernen'; plugins/calendar_kolab/localization/de_CH.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar_kolab/localization/de_CH.inc:$labels['remove_category'] = 'Katgorie entfernen';
Cheers, Torsten
[...]
On Tue, Mar 17, 2015 at 10:31 AM, T. Ermlich Pelegrine@gmx.net wrote:
Plus I found some typos: It should be "Kategorie", not "Katgorie: plugins/calendar/localization/de_DE.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_DE.inc:$labels['remove_category'] = 'Katgorie entfernen'; plugins/calendar/localization/de_CH.inc:$labels['add_category'] = 'Katgorie hinzufügen'; plugins/calendar/localization/de_CH.inc:$labels['remove_category'] = 'Katgorie entfernen';
Fixed in https://www.transifex.com/projects/p/kolab/resource/calendar/ Will be added to a future release of the plugin.
~Thomas