hi i built a website using helix ultimate and page builder pro on my laptop when i tried to transfer it to a online server the database crashes and gives the following error
SQL query:
--
-- Database: joomla_db1
--
-- Table structure for table q23fx_sppagebuilder_collections
CREATE TABLE q23fx_sppagebuilder_collections
(
id
bigint(20) UNSIGNED NOT NULL,
asset_id
bigint(20) UNSIGNED NOT NULL DEFAULT 0,
title
varchar(255) NOT NULL DEFAULT '',
alias
varchar(255) NOT NULL DEFAULT '',
published
tinyint(4) NOT NULL DEFAULT 1,
access
int(10) UNSIGNED NOT NULL DEFAULT 0,
ordering
int(11) NOT NULL DEFAULT 0,
language
char(7) NOT NULL DEFAULT '*',
created
datetime NOT NULL,
created_by
bigint(20) DEFAULT NULL,
modified
datetime NOT NULL DEFAULT current_timestamp(),
modified_by
bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
MySQL said: Documentation
1067 - Invalid default value for 'modified'
This is what is in the tabe
127.0.0.1/joomla_db1/q23fx_sppagebuilder_collections/ http://localhost/phpmyadmin/index.php?route=/sql&pos=0&db=joomla_db1&table=q23fx_sppagebuilder_collections
Showing rows 0 - 1 (2 total, Query took 0.0103 seconds.)
SELECT * FROM q23fx_sppagebuilder_collections
id asset_id title alias published access ordering language created created_by modified modified_by
1 165 team members team-members 1 1 1 2025-03-16 18:06:35 578 2025-03-16 18:06:35 NULL
2 169 Events events 1 1 2 2025-03-16 18:13:52 578 2025-03-16 18:13:52 NULL
many thanks
mick