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
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
I replaced these files already before, following the instructions of question 7.
Unfortunately the result is the same even if I replace the files again.
Please share your administrator and database access here to check this issue. Use the Hidden Content box to share the credentials.
Unfortunately 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.
Did you find a solution for database fields with a size in the field type, like my example above?
It will be fixed in the next update.
