Hi I see following error when I tried to install Lotus in my website
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 27 SQL=CREATE TABLE IF NOT EXISTS `#__lotus_notifications` ( `id` INT(10) UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL, `created_by` INT(10) UNSIGNED NOT NULL, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `published` TINYINT(3) NOT NULL DEFAULT '0', `checked_out` INT(10) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `access` INT(10) UNSIGNED NOT NULL DEFAULT '1', `language` CHAR(7) NOT NULL DEFAULT '*', `to` VARCHAR(1024) NOT NULL, `registration_ids` TEXT NOT NULL, `condition` VARCHAR(1024) NOT NULL, `collapse_key` VARCHAR(256) NOT NULL, `priority` VARCHAR(10) NOT NULL, `content_available` TINYINT(1) NOT NULL, `time_to_live` INT(10) NOT NULL, `restricted_package_name` VARCHAR(255) NOT NULL, `dry_run` TINYINT(1) NOT NULL DEFAULT '0', `data` TEXT NOT NULL, `notification` TEXT NOT NULL, PRIMARY KEY (`id`), INDEX `idx_lotus_notifications_access` (`access`), INDEX `idx_lotus_notifications_checkout` (`checked_out`), INDEX `idx_lotus_notifications_published` (`published`), INDEX `idx_lotus_notifications_language` (`language`) ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Package Install: There was an error installing an extension: com_lotus.zip