Your Help - Question | JoomShaper
SP Page Builder 6 is Here! Learn More →

Your Help

MB

mick Barraclough

SP Page Builder 4 weeks ago

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

0
1 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 weeks ago #204929

Hi there,

Thank you for reaching out. Please make an Akeeba backup using Akeeba backup Joomla extension. Then follow the screencast video.

https://drive.google.com/file/d/16fMwHR2ZAa3yctnP5rn7zm6YlwB7ijQj/view

Note: Before creating backup click on the configuration settings & set ZIP format instead of JPA.

Best regards,

Toufiqur Rahman (Team Lead, Support)

0