AbanteCart Community

eCommerce construction => Installation and Configuration => Fresh Installation => Topic started by: Massimo Moroni on November 20, 2020, 11:36:40 AM

Title: fresh installation error 1293
Post by: Massimo Moroni on November 20, 2020, 11:36:40 AM

Hi all,
making a fresh installation i get this error
Following error has occurred during installation:
parsererror:
SQL Error: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Error No: 1293

any clue to solve this?
thanks
max

Title: Re: fresh installation error 1293
Post by: abantecart on November 21, 2020, 06:21:25 PM

Hello Massimo

What type/version of database do you have? What AbanteCart version do you try to install?

Title: Re: fresh installation error 1293
Post by: Carlo Magno on November 25, 2020, 06:01:46 AM

Hi all, I have the same issue.
My configuration:

PHP Version 7.4.12
System: Linux 185-196-161-46
mysqlnd 7.4.12

Title: Re: fresh installation error 1293
Post by: abolabo on November 25, 2020, 06:18:40 AM

Quote from: Carlo Magno on November 25, 2020, 06:01:46 AM

Hi all, I have the same issue.
My configuration:

PHP Version 7.4.12
System: Linux 185-196-161-46
mysqlnd 7.4.12

mysqlnd it's just a driver for mysql.
You should to post mysql database server version.

Title: Re: fresh installation error 1293
Post by: Carlo Magno on November 25, 2020, 10:04:05 AM

5.5.68-MariaDB - MariaDB Server