RSS

LuxCal Forum

The place for questions, suggestions and news about the LuxCal Event Calendar

User:   Password:   Remember Me?   
LuxCal Forum / General / Support / Problem with installing the calendar
Posted:  19 Jun 2016 01:14
I'm getting this when installing the calendar


016.06.18 23:09:39 Script: /install440.php - SQL query error: SQLSTATE[42000]:
Syntax error or access violation: 1101 BLOB/TEXT column 'editor' can't have a default value
Query string:
CREATE TABLE IF NOT EXISTS `mycal_events` (
`ID` INTEGER PRIMARY KEY AUTO_INCREMENT,

`type` TINYINT NOT NULL DEFAULT 0,
`private` TINYINT NOT NULL DEFAULT 0,
`title` TEXT DEFAULT NULL,

`venue` TEXT DEFAULT NULL,
`text1` TEXT DEFAULT NULL,
`text2` TEXT DEFAULT NULL,
`text3` TEXT DEFAULT NULL,

`attach` TEXT DEFAULT NULL,
`catID` MEDIUMINT NOT NULL DEFAULT 1,
`userID` MEDIUMINT DEFAULT NULL,

`editor` TEXT NOT NULL DEFAULT '',
`approved` TINYINT NOT NULL DEFAULT 0,

`checked` TEXT DEFAULT NULL,
`notify` TINYINT NOT NULL DEFAULT -1,
`notMail` TEXT DEFAULT NULL,

`sDate` VARCHAR(10) DEFAULT NULL,
`eDate` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
`xDates` TEXT DEFAULT NULL,
`sTime` VARCHAR(5) DEFAULT NULL,
`eTime` VARCHAR(5) NOT NULL DEFAULT '99:00',
`rType` TINYINT NOT NULL DEFAULT 0,
`rInterval` TINYINT NOT NULL DEFAULT 0,
`rPeriod` TINYINT NOT NULL DEFAULT 0,
`rMonth` TINYINT NOT NULL DEFAULT 0,
`rUntil` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
`aDateTime` VARCHAR(16) NOT NULL DEFAULT '9999-00-00 00:00',
`mDateTime` VARCHAR(16) NOT NULL DEFAULT '9999-00-00 00:00',
`status` BOOLEAN NOT NULL DEFAULT 0)
Posted:  23 Jun 2016 08:17   Last Edited By: Roel B.
Hi there,

There is an incompatibility between the calendar and one of the MySQL versions, which will be solved in the next LuxCal-MySQL version.
You can either install the SQLite version, which has no problem, or send me your email address via the Contact Us page and I will send you a pre-copy of the next LuxCal version.
Roel