maintenance - missing tabels - site not working 502 - Forum | JoomShaper
Solved SP Page Builder

maintenance - missing tabels - site not working 502

Asked by Ronald 4 years ago Last activity 4 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

Accepted answer

Marked as the solution
Toufiq Senior Staff
4 years ago

Please check now. Thanks

4 more replies

Oldest first Newest first Most helpful
Ronald Asked this
4 years ago

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

Ronald Asked this
4 years ago

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

Thanks alot!

Log in to reply.