error installing quickstart package

More
10 months 3 days ago - 10 months 3 days ago #10910 by tigersloft
tigersloft created the topic: error installing quickstart package
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
Last Edit: 10 months 3 days ago by tigersloft. Reason: new info

Please Log in or Create an account to join the conversation.

More
10 months 15 hours ago #11754 by marcin
marcin replied the topic: error installing quickstart package
Hi,

It is hard to say anything without a closer look.
Please submit a ticket and provide us with the following details:
- Joomla credentials
- FTP server details
joomla-monster.com/my-account/submit-ticket

Regards,
Marcin

Please Log in or Create an account to join the conversation.

Time to create page: 0.224 seconds

INDICO S.C.

ul. Wałowa 10/3, 84-200 Wejherowo, registered in Centralna Ewidencja i Informacja o Działalnosci Gospodarczej
NIP/VATID: PL5882424318

Copyright © 2009-2019 Joomla-Monster.com All rights reserved.

Joomla-Monster.com and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.