JodliDev / calendar

GNU Affero General Public License v3.0
16 stars 12 forks source link

MySQL database update problem #28

Closed IgorA100 closed 1 year ago

IgorA100 commented 2 years ago

MariaDB Server version: 10.1.37 my.cnf:

...
innodb_large_prefix=true
innodb_file_format=Barracuda
...

# bin/initdb.sh --dir=plugins/calendar/drivers/caldav/SQL Creating database schema... ERROR: [1709] Index column size too large. The maximum column size is 767 bytes. (SQL Query: CREATE TABLE IF NOT EXISTScaldav_calendars( calendar_idint(11) UNSIGNED NOT NULL AUTO_INCREMENT, user_idint(10) UNSIGNED NOT NULL DEFAULT '0', source_idint(10) UNSIGNED DEFAULT NULL, namevarchar(255) CHARACTER SET utf8mb4 NOT NULL, colorvarchar(8) NOT NULL, showalarmstinyint(1) NOT NULL DEFAULT '1', caldav_tagvarchar(255) DEFAULT NULL, caldav_urlvarchar(1024) NOT NULL, caldav_last_changetimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, is_icaltinyint(1) NOT NULL DEFAULT '0', ical_uservarchar(255) DEFAULT NULL, ical_passvarchar(1024) DEFAULT NULL, PRIMARY KEY(calendar_id), INDEXcaldav_user_name_idx(user_id,name), CONSTRAINTfk_caldav_calendars_user_idFOREIGN KEY (user_id) REFERENCESusers(user_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINTfk_caldav_calendars_sourcesFOREIGN KEY (source_id) REFERENCEScaldav_sources(source_id) ON DELETE CASCADE ON UPDATE CASCADE ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */) [FAILED] ERROR: [1709] Index column size too large. The maximum column size is 767 bytes.

JodliDev commented 1 year ago

Sorry for never replying. It looks to me that this is an issue with your database. I assume that this issue has been resolved. If not please let me know :)