SP Pagebuilder PRO Repeating "Database Update Required"
OCRAM
Hello
SP Pagebuilder PRO repeats "Database update required" after updating the database: There is a problem with the types of the table ids, for example:
Table #__sppagebuilder Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned
SP Pagebuilder Pro: 3.7.9 Joomla: 3.9.24 Database: 10.3-MariaDB
Ofi Khan
Accepted AnswerHello OCRAM
Please take a full site backup before applying the fix. I am providing a patch for you. Inside the maintenance.zip there are two files.
Please replace the administrator/components/com_sppagebuilder/helpers/maintenance.php file with the maintenance.php file and replace the administrator/components/com_sppagebuilder/sql/install/mysql/install.mysql.utf8.sql file with the install.mysql.utf8.sql from the zip. Hopefully, it will solve the issue. For your reference: https://www.joomshaper.com/forum/question/7
Best regards
OCRAM
Accepted AnswerI replaced these files already before, following the instructions of question 7. Unfortunately the result is the same even if I replace the files again.
Ofi Khan
Accepted AnswerPlease share your administrator and database access here to check this issue. Use the Hidden Content box to share the credentials.
OCRAM
Accepted AnswerUnfortunately the owner does not allow it.
I think it has to do with the Maria-DB. It puts the size behind the type:
For Example: bigint(20) unsigned instead of bigint unsigned
That is why the update database reports a type mismatch. If I change the type to bigint unsigned it will be reconverted automatically to bigint(20) unsigned.
Hope this hint helps to find a solution.
OCRAM
Accepted AnswerDid you find a solution for database fields with a size in the field type, like my example above?