Maintenance - Missing Tabels - Site Not Working 502 - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!
Back to the questions

Maintenance - Missing Tabels - Site Not Working 502

R

Ronald

SP Page Builder 3 years ago

Hello,

I have SP Page Builder Pro Version 3.8.6 installed on Joomla! 3.9.21 PHP 7.4.9. I use the template decora - Default. (http://www.rubouwdesign.nl/) My site isn't working however since the recent SP Pagebuilder update I did.

Trying to get it fixed I stumbled across the maintenance page in SP Pagebuilder and saw it listed missing tables. It mentions the following:

*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 #sppagebuilderintegrations does not exist.
Table #spmedia does not exist.
Table #sppagebuilderlanguages does not exist.
Table #sppagebuildersections does not exist.
Table #sppagebuilderaddons does not exist.*

When I select 'update tables' It says it has updated them succesfully, but when browsing to a different page and back again to the maintenance page, the same tables need updating. I assume this is why my site isn't working at the moment. Could you help me fix the problem?

Thanks

0
5 Answers
Order by
Oldest Newest Votes
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #67949

Please check now. Thanks

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #67455

Hello

Apologies for the inconvenience. Could you kindly check out the solutions for a similar problem in the links below?

https://www.joomshaper.com/forum/question/7

https://www.joomshaper.com/forum/question/663

Hope this will help you.

0
R
Ronald
Accepted Answer
3 years ago #67481

Hello Ariba, Thanks for the quick reply.

I tried replaciung the two files in the zip. It doesn't solve the problem however.

I get a new error in the maintenance page. An update of the database is required. The following needs to be updated:

Table

__sppagebuilder

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned
Mismatch found on the field: asset_id, Expected: int, Found: int(11)
Mismatch found on the field: view_id, Expected: bigint, Found: bigint(20)
Mismatch found on the field: published, Expected: tinyint, Found: tinyint(4)
Mismatch found on the field: catid, Expected: int, Found: int(11)
Mismatch found on the field: access, Expected: int, Found: int(11)
Mismatch found on the field: ordering, Expected: int, Found: int(11)
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: modified_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: checked_out, Expected: int, Found: int(11)
Mismatch found on the field: hits, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_integrations

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned

Table

__spmedia

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: modified_by, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_languages

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned

Table

__sppagebuilder_sections

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_addons

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder

Mismatch found on the field: asset_id, Expected field is null: no, Found: yes
Mismatch found on the field: view_id, Expected field is null: no, Found: yes
Mismatch found on the field: published, Expected field is null: no, Found: yes
Mismatch found on the field: catid, Expected field is null: no, Found: yes
Mismatch found on the field: access, Expected field is null: no, Found: yes
Mismatch found on the field: ordering, Expected field is null: no, Found: yes
Mismatch found on the field: created_by, Expected field is null: no, Found: yes
Mismatch found on the field: modified_by, Expected field is null: no, Found: yes
Mismatch found on the field: checked_out, Expected field is null: no, Found: yes
Mismatch found on the field: hits, Expected field is null: no, Found: yes

Table

__spmedia

Mismatch found on the field: created_by, Expected field is null: no, Found: yes
Mismatch found on the field: modified_by, Expected field is null: no, Found: yes

Table

__sppagebuilder_sections

Mismatch found on the field: created_by, Expected field is null: no, Found: yes

Table

__sppagebuilder_addons

Mismatch found on the field: created_by, Expected field is null: no, Found: yes

Table

__sppagebuilder

Mismatch found on the field: asset_id, expected default value: 0, found: n/a
Mismatch found on the field: view_id, expected default value: 0, found: n/a
Mismatch found on the field: published, expected default value: 1, found: n/a
Mismatch found on the field: catid, expected default value: 0, found: n/a
Mismatch found on the field: access, expected default value: 0, found: n/a
Mismatch found on the field: ordering, expected default value: 0, found: n/a
Mismatch found on the field: created_by, expected default value: 0, found: n/a
Mismatch found on the field: modified_by, expected default value: 0, found: n/a
Mismatch found on the field: checked_out, expected default value: 0, found: n/a
Mismatch found on the field: hits, expected default value: 0, found: n/a

Table

__spmedia

Mismatch found on the field: created_by, expected default value: 0, found: n/a
Mismatch found on the field: modified_by, expected default value: 0, found: n/a

Table

__sppagebuilder_sections

Mismatch found on the field: created_by, expected default value: 0, found: n/a

Table

__sppagebuilder_addons

Mismatch found on the field: created_by, expected default value: 0, found: n/a

After updating the following succesful update is mentioned:

Table

__sppagebuilder

Fixed: Modified mismatching field: id, Changed from bigint(20) unsigned to bigint unsigned
Fixed: Modified mismatching field: asset_id, Changed from int(11) to int
Fixed: Modified mismatching field: view_id, Changed from bigint(20) to bigint
Fixed: Modified mismatching field: published, Changed from tinyint(4) to tinyint
Fixed: Modified mismatching field: catid, Changed from int(11) to int
Fixed: Modified mismatching field: access, Changed from int(11) to int
Fixed: Modified mismatching field: ordering, Changed from int(11) to int
Fixed: Modified mismatching field: created_by, Changed from bigint(20) to bigint
Fixed: Modified mismatching field: modified_by, Changed from bigint(20) to bigint
Fixed: Modified mismatching field: checked_out, Changed from int(11) to int
Fixed: Modified mismatching field: hits, Changed from bigint(20) to bigint

Table

__sppagebuilder_integrations

Fixed: Modified mismatching field: id, Changed from bigint(20) unsigned to bigint unsigned

Table

__spmedia

Fixed: Modified mismatching field: id, Changed from bigint(20) unsigned to bigint unsigned
Fixed: Modified mismatching field: created_by, Changed from bigint(20) to bigint
Fixed: Modified mismatching field: modified_by, Changed from bigint(20) to bigint

Table

__sppagebuilder_languages

Fixed: Modified mismatching field: id, Changed from int(10) unsigned to int unsigned

Table

__sppagebuilder_sections

Fixed: Modified mismatching field: id, Changed from int(10) unsigned to int unsigned
Fixed: Modified mismatching field: created_by, Changed from bigint(20) to bigint

Table

__sppagebuilder_addons

Fixed: Modified mismatching field: id, Changed from int(10) unsigned to int unsigned
Fixed: Modified mismatching field: created_by, Changed from bigint(20) to bigint

Table

__sppagebuilder

Fixed: Modified mismatching field: asset_id, Changed field is null from yes to no
Fixed: Modified mismatching field: view_id, Changed field is null from yes to no
Fixed: Modified mismatching field: published, Changed field is null from yes to no
Fixed: Modified mismatching field: catid, Changed field is null from yes to no
Fixed: Modified mismatching field: access, Changed field is null from yes to no
Fixed: Modified mismatching field: ordering, Changed field is null from yes to no
Fixed: Modified mismatching field: created_by, Changed field is null from yes to no
Fixed: Modified mismatching field: modified_by, Changed field is null from yes to no
Fixed: Modified mismatching field: checked_out, Changed field is null from yes to no
Fixed: Modified mismatching field: hits, Changed field is null from yes to no

Table

__spmedia

Fixed: Modified mismatching field: created_by, Changed field is null from yes to no
Fixed: Modified mismatching field: modified_by, Changed field is null from yes to no

Table

__sppagebuilder_sections

Fixed: Modified mismatching field: created_by, Changed field is null from yes to no

Table

__sppagebuilder_addons

Fixed: Modified mismatching field: created_by, Changed field is null from yes to no

Table

__sppagebuilder

Fixed: Modified mismatching field: asset_id, changed default value from n/a to 0
Fixed: Modified mismatching field: view_id, changed default value from n/a to 0
Fixed: Modified mismatching field: published, changed default value from n/a to 1
Fixed: Modified mismatching field: catid, changed default value from n/a to 0
Fixed: Modified mismatching field: access, changed default value from n/a to 0
Fixed: Modified mismatching field: ordering, changed default value from n/a to 0
Fixed: Modified mismatching field: created_by, changed default value from n/a to 0
Fixed: Modified mismatching field: modified_by, changed default value from n/a to 0
Fixed: Modified mismatching field: checked_out, changed default value from n/a to 0
Fixed: Modified mismatching field: hits, changed default value from n/a to 0

Table

__spmedia

Fixed: Modified mismatching field: created_by, changed default value from n/a to 0
Fixed: Modified mismatching field: modified_by, changed default value from n/a to 0

Table

__sppagebuilder_sections

Fixed: Modified mismatching field: created_by, changed default value from n/a to 0

Table

__sppagebuilder_addons

Fixed: Modified mismatching field: created_by, changed default value from n/a to 0

When I refresh the page I continue getting an error message that a database updat is needed:

Table

__sppagebuilder

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned
Mismatch found on the field: asset_id, Expected: int, Found: int(11)
Mismatch found on the field: view_id, Expected: bigint, Found: bigint(20)
Mismatch found on the field: published, Expected: tinyint, Found: tinyint(4)
Mismatch found on the field: catid, Expected: int, Found: int(11)
Mismatch found on the field: access, Expected: int, Found: int(11)
Mismatch found on the field: ordering, Expected: int, Found: int(11)
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: modified_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: checked_out, Expected: int, Found: int(11)
Mismatch found on the field: hits, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_integrations

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned

Table

__spmedia

Mismatch found on the field: id, Expected: bigint unsigned, Found: bigint(20) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)
Mismatch found on the field: modified_by, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_languages

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned

Table

__sppagebuilder_sections

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)

Table

__sppagebuilder_addons

Mismatch found on the field: id, Expected: int unsigned, Found: int(10) unsigned
Mismatch found on the field: created_by, Expected: bigint, Found: bigint(20)

Can you help me fix this?

Thanks,

Ronald Ubels

0
R
Ronald
Accepted Answer
3 years ago #67963

Thanks so much! Whatever you did, it worked! My site is up and running again!

Thanks alot!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #67986

You are most welcome. Will you please spend some to write a review about our product and support quality? 

https://extensions.joomla.org/extension/sp-page-builder/

0