Joomla 4 And SPPB 5.3.4. Database Not Actually
laasigberg
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....
Ofi Khan
Accepted AnswerI have installed the latest version on your site. The issue is fixed. Please check it now.
Ofi Khan
Accepted AnswerHello 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
Ofi Khan
Accepted AnswerThanks. I have checked System -> Database Maintenance. It looks good now. Please check and let me know if you have further issues.
laasigberg
Accepted AnswerUnder Components are more Issues
404 View nicht gefunden [Name, Typ, Präfix]: editor, html, sppagebuilderView and more, left under Components >>> SPPB
Ofi Khan
Accepted AnswerYou 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.