"Database Update Required" & "Missing Tables" Messages - Question | JoomShaper
Back to the questions

"Database Update Required" & "Missing Tables" Messages

RS

Ravi Shanmugam

SP Page Builder 3 years ago

Hi, I'm seeing the message "Database update required" on the SP Page Builder Pro page. Then I see "Missing Tables" and it lists 6 tables. ** 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. Missing Tables

Table #sppagebuilder does not exist.
Table #sppagebuilder_integrations does not exist.
Table #spmedia does not exist.
Table #sppagebuilder_languages does not exist.
Table #sppagebuilder_sections does not exist.
Table #sppagebuilder_addons does not exist.
    **

I clicked "Updated SP Pager Builder Database" and got the message "Fixed Missing Tables".

__sppagebuilder table successfully!

Created #sppagebuilder_integrations table successfully! Created #spmedia table successfully! Created #sppagebuilder_languages table successfully! Created #sppagebuilder_sections table successfully! Created #__sppagebuilder_addons

But if go back to Maintenance link on the link, I got the "Missing Tables" message again. What can I do to fix this issue?

0
6 Answers
Order by
Oldest Newest Votes
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #8635

Hello Ravi Shanmugam

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.

maintenannce.zip

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

0
MS
Martin Seidl
Accepted Answer
1 year ago #94920

I replaced both files but stille update mesage comes see also https://www.loom.com/share/dbab970e9c9f490ea48c00a8726f6559

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #98947

Hello Martin Seidl

Please create a new post regarding this. We will help you.

Best regards

0
MS
Martin Seidl
Accepted Answer
1 year ago #99863

you know what I really hate??? That I told u joomhsper team to take care of the fact that I dont get email notification any more, just by accident I saw your message Ofi!!!!

see here: https://www.joomshaper.com/forum/question/17846

I am so frustrated with Joomshaper!!!!!!!

0
MS
Martin Seidl
Accepted Answer
1 year ago #99865

I replaced both files with the result that even more tables need to be fixed:

https://www.loom.com/share/e40449305d8744edb2f11a8e484de682

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #99903

Hello Martin Seidl

Sorry for the experience. This solution was applicable to older versions of SP Page Builder. Please update to the latest SP Page Builder 3.8.9 and check the issue. If you still face the issue, then please create a new post. We will discuss there. You can easily find your posts in this link: https://www.joomshaper.com/forum/my-questions

I will talk to the management about your notification related issue.

Best regards

0