Error installing Lotus

chinnam
chinnam
  • chinnam
  • 5 months ago
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
Access to viewing replies is restricted.
Showing 1 of 1 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai