I'm trying to install the latest version of Jbusiness directory into a clean install of joomla 4. I get the following error:
JInstaller: :Install: Error SQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Intall aborted
However in the database it does look like it installed the tables.
Please advise.
I'd try to delete the old tables, if empty, and try again.
If it results in the same error, definitely open a ticket with CMS.
They may be backed up as I have not received a response to my tickets since the new release.
UPDATE I had put in a ticket to Cloudaccess as well in case it was something on their side: Here is there reply
Hello Susan,
I checked and it looks like the issue is with the component itself. It is creating a table that has two timestamp columns and causing an error. Since we are unable to troubleshoot the extension, we would advise contacting the developer of the extension so they can guide you in the right direction. If they give any instructions that need to be followed on our end then do let us know and we will gladly assist you with it.
For reference, you can provide them this:
CREATE TABLE #__jbusinessdirectory_company_
(id
int(11) NOT NULL AUTO_INCREMENT,name
varchar(100) DEFAULT NULL,subject
varchar(255) DEFAULT NULL,description
text DEFAULT NULL,userId
int(11) NOT NULL,email
varchar(55) DEFAULT NULL,likeCount
smallint(6) DEFAULT '0',dislikeCount
smallint(6) DEFAULT '0',loveCount
smallint(6) DEFAULT '0',state
tinyint(4) NOT NULL DEFAULT '1',itemId
int(11) NOT NULL,creationDate
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,aproved
tinyint(1) NOT NULL DEFAULT '0',ipAddress
varchar(45) DEFAULT NULL,abuseReported
tinyint(1) NOT NULL DEFAULT '0',rating
decimal(2,1) NOT NULL DEFAULT '0.0',approved
tinyint(1) NOT NULL DEFAULT '0',review_type
tinyint(1) NOT NULL DEFAULT '1',created
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
),
KEY idx_state
(state
),
KEY idx_userId
(userId
),
KEY idx_aproved
(aproved
),
KEY idx_approved
(approved
),
KEY idx_review_type
(review_type
),
KEY idx_item_id
(itemId
)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
It seems that you are using an older database server that does not allow 2 timestamps on the same table.
Please create a ticket on our store and provide us admin access to perform the installation for you.
this error is because you used an old database table, framed so you have to create a new one