Database update required - Forum | JoomShaper
Solved SP Page Builder

Database update required

Asked by Bartosz Rapp 5 years ago Last activity 5 years ago

After installint fresh copy of Joomla 3.9.23 an SP Page Builder 3.7.8 I get following info: Database update required SP Page Builder has been updated. To keep things running smoothly, we need to update your database. We strongly recommend you to take a backup in case anything goes wrong.

After clicking update button all seems to go well. I clear all the caches according to the guide. After goin to the maitenence page I gat again the information about database update requirement.

Although there is no error message (only success message) the tables in database are not created.
I alredy disabled strict mode in mysql for dates: NO_ZERO_IN_DATE and NO_ZERO_DATE are removed.

Accepted answer

Marked as the solution

11 more replies

Oldest first Newest first Most helpful
Toufiq Senior Staff
5 years ago

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Will you please provide me the Joomla administrator access check the issue? I will check & get back to you soon.

-Thanks

Bartosz Rapp Asked this
5 years ago

Yes. It has been provided in a private message.

Also in database the tables are created.
| yo6my_spmedia
| yo6my_sppagebuilder
| yo6my_sppagebuilder_addons
| yo6my_sppagebuilder_integrations
| yo6my_sppagebuilder_languages
| yo6my_sppagebuilder_sections

It seems SP Page builder cannot alrer them.

Toufiq Senior Staff
5 years ago

Please roll back your PHP version 7.4 to 7.3 and provide me the database access

Bartosz Rapp Asked this
5 years ago

It is not that simple. Other systems are dependent on PHP 7.4 and database contains other data that are semi-sensitive. I am former IT guy so if you want me to alter the tables by hand I can do it. Just post me the SQL script.

Toufiq Senior Staff
5 years ago
  1. Delete the page builder tables from your database
  2. Uninstall your page builder
  3. Re-install the page builder after applying the above instructions
Bartosz Rapp Asked this
5 years ago

By above instructions you mean rollback to PHP 7.3?

Toufiq Senior Staff
5 years ago

Please follow the instructions first. Ignore the version changing of PHP.

  1. Delete the page builder tables from your database
  2. Uninstall your page builder
  3. Re-install the page builder after applying the above instructions
Bartosz Rapp Asked this
5 years ago

OK. I tried it. Installation succesful. The problem is the same.

PS. Tables has been recreated suuccesfully.

Toufiq Senior Staff
5 years ago

Roll backup your PHP version 7.4 to 7.3 and give me the database access

Bartosz Rapp Asked this
5 years ago

I will test it with PHP 7.3 on virtual machine and I will come back to you with updated info.
Thanks!

Log in to reply.