import database error 1067 - Invalid default value for 'created' - Forum | JoomShaper
Staff replied SP Page Builder

import database error 1067 - Invalid default value for 'created'

Asked by gragraphic 2 years ago Last activity 2 years ago

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

2 replies

Oldest first Newest first Most helpful
gragraphic Asked this
2 years ago · edited

I 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

Ofi Khan Staff
2 years ago

Hello gragraphic

Apology for the inconvenience. Please run this SQL Query on your database and then try to install again.

SET SQL_MODE='ALLOW_INVALID_DATES'

Best regards

Log in to reply.