i receive the following error when installing either quickstart package for this template.
Error
Table 'forsalebycontractor.#__djc2_users' doesn't exist
Invalid default value for 'modified'
please advise.
*add - did a fresh joomla install and tried to install DJcatalog2 separately. received the error below.
Warning
JInstaller: :Install: Error SQL Invalid default value for 'modified'
Extension Install: SQL error processing query: DB function failed with error number 1067
Invalid default value for 'modified'
SQL =
CREATE TABLE IF NOT EXISTS `#__djc2_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`customer_group_id` int(11) NOT NULL,
`client_type` char(1) NOT NULL DEFAULT 'A',
`firstname` varchar(50) NOT NULL,
`lastname` varchar(50) NOT NULL,
`company` varchar(100) NOT NULL,
`position` varchar(100) DEFAULT NULL,
`address` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`postcode` varchar(20) NOT NULL,
`country_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL DEFAULT '0',
`vat_id` varchar(20) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`fax` varchar(20) DEFAULT NULL,
`www` varchar(255) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`gdpr_agreement` tinyint(4) NOT NULL DEFAULT '0',
`gdpr_policy` tinyint(4) NOT NULL DEFAULT '0',
`modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`tos` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_user_id` (`user_id`),
KEY `idx_customer_group_id` (`customer_group_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Package Install: There was an error installing an extension: com_djcatalog2.zip