J-BusinessDirectory - Timestamp database error

Support Forum

 
 

 

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. 

 

4 replies

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_reviews (
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

 
 
 

5 Item(s)

Show per page