Page Builder Database Upgrade does not go away - Forum | JoomShaper
Solved SP Page Builder

Page Builder Database Upgrade does not go away

Asked by TheBearded 5 years ago Last activity 3 years ago

Hello,

since the upgrade to SPPB 3.7.8 Pro I can find a message in my backend which tells me that it neesd to upgrade the SP Page Builder database.

Some of the error messages look rather severe, like
Table #__sppagebuilder does not exist.
Table #sppagebuilder_integrations does not exist.
(just to name a few).

If I then click on "Update SP Page Builder Database" button it tells me that all upgrades have been performed sucessfully. But the message stays, also after clearing Joomla cache and logging out and back in again.

I can do this over and over again, but nothing visibly happens and SPPB continues to tell me that the database needs to be upgraded.

Any ideas?

Thanks,
Ben

Accepted answer

Marked as the solution
Toufiq Senior Staff
5 years ago

Hi there,

Please follow the instruction. Download the zip file maintenannce.zip there are two files.

-Replace the administrator/components/com_sppagebuilder/helpers/maintenance.php file with the maintenance.php file from the zip.

-Replace the administrator/components/com_sppagebuilder/sql/install/mysql/install.mysql.utf8.sql file with the install.mysql.utf8.sql from the zip.

Note: The Page Builder has 5 datbase table and id filed will be auto increment. If the auto increment doesn't set, you need to set the auto increment in your id filed. 

#__sppagebuilder
#__sppagebuilder_addons
#__sppagebuilder_integrations
#__sppagebuilder_languages
#__sppagebuilder_sections

https://prnt.sc/wc5sil
https://prnt.sc/wc5t09
I hope this patch will solve your issue if this is only a MySQL v8 related issue.

-Thanks

51 more replies

Oldest first Newest first Most helpful
Kawshar Ahmed Senior Staff
5 years ago

Please share your PHP and Mysql version.

Thanks

TheBearded Asked this
5 years ago

PHP: 7.3.25
MySQL: 8.0.21-12

D56 WebDesign
5 years ago

Hello,

I have got the same problem.
php: 7.4.3
MySQL: 8.0.22

Tried all kinds of options but until now, no result.
Can you please help me with this problem?

Thankx in advance.

Kawshar Ahmed Senior Staff
5 years ago

Thanks for the information. We will try on our end and share a solution as soon as possible.

Thanks

Paul Frankowski Senior Staff
5 years ago

If I may....
So far we noticed that this problem appears only on MySQL v8, not olders.
It should be solved in the upcoming update SPPPB 3.7.9. Give us few days.

Martin Seidl
3 years ago

Hey Paul hope u r doing well.
The prob is still there even with SPPB 3.8.10 and Joomla 4.3.4 and php 8.2

Mehmet Serdar Uğur
5 years ago

My personal solution :
I've edit the file "/administrator/components/com_sppagebuilder/sql/install/mysql/install.mysql.utf8.sql"
for table definitions with my own Database Tables Prefix (xxxx):
#__sppagebuilder → 'xxxx_sppagebuilder'
you can see your database tables prefix on Global Configuration/Server tab.

TheBearded Asked this
5 years ago

Hi Toufiq,

thanks for the maintenance file, this seem to have worked. When I try to set the AUTO_INCREMENT value for the id field in table sppagebuilder, my phpMyAdmin will throw error message "ERROR 1067: Invalid default value for 'created_on'".

Any ideas?

Thanks,
Ben

TheBearded Asked this
5 years ago

My provider is not using cPanel. What exactly do you need: Joomla backend acess? MySQL database access (this will be going via PHPmyAdmin)? Somthing else?

Toufiq Senior Staff
5 years ago

Database access. Thanks

Log in to reply.