Solved SP Page Builder

Joomla 4 and SPPB 5.3.4. Database not actually

Asked by laasigberg 2 years ago Last activity 2 years ago

On the advice of a JoomShaper colleague, I updated to Joomla 4. SPPB 5.3.4 is installed and now Joomla's backend says that the database is not up to date. SPPB 5.3.4 does not match CMS version 3.8.10! How can I update the database so that I have access to all functions in the backend again?

The database is not up to date!
Warning: The database is not up to date!
The database schema version (5.3.4) does not match the CMS version (3.8.10).
The database update version (5.3.4) does not match the CMS version (SP Page Builder).
The table "'jos336_sppagebuilder'" has the wrong type or attributes for the column "'created_on'" with type "datetime". (From file: "2.0-2016-11-04.sql".)
The table "'jos336_sppagebuilder'" has the wrong type or attributes for the column "'modified'" with type "datetime". (From file: "2.0-2016-11-04.sql".)
The table "'jos336_spmedia'" has the wrong type or attributes for the column "'created_on'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_spmedia'" has the wrong type or attributes for the column "'modified_on'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_sppagebuilder'" has the wrong type or attributes for the column "'created_on'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_sppagebuilder'" has the wrong type or attributes for the column "'modified'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_sppagebuilder'" has the wrong type or attributes for the column "'checked_out_time'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_sppagebuilder_sections'" has the wrong type or attributes for the column "'created'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_sppagebuilder_addons'" has the wrong type or attributes for the column "'created'" of type "datetime". (From file: "3.7.10.sql".)
The table "'jos336_spmedia'" has the wrong type or attributes for the column "'created_on'" of type "datetime". (From file: '3.7.14.sql'.)
The table 'jos336_spmedia' has the wrong type or attributes for the column 'modified_on' with type 'datetime'. (From file: '3.7.14.sql'.)
The table 'jos336_sppagebuilder' has the wrong type or attributes for the column 'created_on' with type 'datetime'. (From file: '3.7.14.sql'.) and more....

Accepted answer

Marked as the solution

Ofi Khan Staff

2 years ago

I have installed the latest version on your site. The issue is fixed. Please check it now.

9 more replies

Ofi Khan Staff

2 years ago

Hello laasigberg

Apology for the inconvenience. Please share your administrator access here to check the issue. Use the Hidden Content box to share the credentials. Make sure that you have a full site backup with you before sharing.

Best regards

laasigberg Asked this

2 years ago

Ofi Khan Staff

2 years ago

Yes, joomla backend access

laasigberg Asked this

2 years ago · edited

here

Ofi Khan Staff

2 years ago

Thanks. I have checked System -> Database Maintenance. It looks good now. Please check and let me know if you have further issues.

laasigberg Asked this

2 years ago

Under Components are more Issues

404 View nicht gefunden [Name, Typ, Präfix]: editor, html, sppagebuilderView and more, left under Components >>> SPPB

laasigberg Asked this

2 years ago

Now are under system and Database fourther Problems

laasigberg Asked this

2 years ago

It works,nice!

Thanks

Ofi Khan Staff

2 years ago

You are welcome 😊

Please accept the answer that helped you. It will be then easier to find the solution for the other users with the same issue. There is a button to accept answer after each comment.

I have a humble request too. It would be very kind of you if you can manage some moment to give us feedback on

This will inspire us to improve.