Can't install T4 PageBuilder on 3.9.2 PHP 7.2

dorsetjoomlart

Standard installer returns this.

Warning
JInstaller: :Install: Error SQL Invalid default value for 'ctime'
Extension Install: SQL error processing query: DB function failed with error number 1067
Invalid default value for 'ctime'
SQL =
CREATE TABLE #__t4_item (
id int(11) NOT NULL AUTO_INCREMENT,
asset_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
asset_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Joomla Item reference',
asset_id int(11) DEFAULT NULL,
tag_id int(11) DEFAULT NULL,
content mediumtext COLLATE utf8mb4_unicode_ci,
ctime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
rev int(11) DEFAULT NULL,
working_content mediumtext COLLATE utf8mb4_unicode_ci,
type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Package Install: There was an error installing an extension: plg_system_t4

navongol

The Same

Setting Value

PHP Built On Windows NT INTELLECTIVE-01 10.0 build 17134 (Windows 10) AMD64
Database Type mysql
Database Version 5.5.62
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.10
Web Server Microsoft-IIS/10.0
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.9.1 Stable [ Amani ] 27-November-2018 15:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:64.0) Gecko/20100101 Firefox/64.0

CREATE TABLE #__t4_item (
id int(11) NOT NULL AUTO_INCREMENT,
asset_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
asset_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Joomla Item reference',
asset_id int(11) DEFAULT NULL,
tag_id int(11) DEFAULT NULL,
content mediumtext COLLATE utf8mb4_unicode_ci,
ctime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
rev int(11) DEFAULT NULL,
working_content mediumtext COLLATE utf8mb4_unicode_ci,
type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Package Install: There was an error installing an extension: plg_system_t4
Error
Error installing package

felix1

Same for me on 3.9.2 and 7.2.10 and Purity III Template.

Warning

JInstaller: :Install: Error SQL Invalid default value for 'ctime'
Extension Install: SQL error processing query: DB function failed with error number 1067
Invalid default value for 'ctime'
SQL =

Error installing package

saguaros

felix1

Hi,

Our team just update the package, pls try to download again and install into your site: https://www.joomlart.com/member/downloads/joomlart/t4/t4-preview

felix1

Still error (see below)!

Template: Purity III 1.2.4
Joomla: 3.9.2
PHP: 7.2.10

Warning
JInstaller: :Install: Error SQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Extension Install: SQL error processing query: DB function failed with error number 1293
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
SQL =
CREATE TABLE #__t4_item (
id int(11) NOT NULL AUTO_INCREMENT,
asset_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
asset_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Joomla Item reference',
asset_id int(11) DEFAULT NULL,
tag_id int(11) DEFAULT NULL,
content mediumtext COLLATE utf8mb4_unicode_ci,
ctime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
rev int(11) DEFAULT NULL,
working_content mediumtext COLLATE utf8mb4_unicode_ci,
type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Package Install: There was an error installing an extension: plg_system_t4
×
Error
Error installing package

saguaros

felix1
Would you mind creating a new discussion and share the credentials of your site so we can try to install and see how it goes?

felix1

If I share my credentials, will they be visible for everybody in forum?

saguaros

felix1

When you create a new discussion, edit the Fields and add info there, only Moderators can see