Import Database Error 1067 - Invalid Default Value For 'created'
gragraphic
I completed the site locally, when transferring the database to the server via phpmyadmin I get this error when importing:
-- phpMyAdmin SQL Dump -- version 5.0.2! -- Versione del server: 10.4.13-MariaDB -- Versione PHP: 7.4.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";
/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /;
--
-- Database: impresaedilegoi
com_sppagebuilder_pro_v5.2.5
--
-- Struttura della tabella jos_sppagebuilder_assets
gragraphic
Accepted AnswerI tried to install the component from the live site but I get Warning JInstaller com_sppagebuilder_pro_v5.2.5: :Install: Error SQL Table 'impresaedileliogoi.jos_sppagebuilder' doesn't exist. In the end, to solve it online I had to put the old version com_sppagebuilder_pro_v3.8.10
