Database Update Required - ERROR - Question | JoomShaper

Database Update Required - ERROR

R

redclara

SP Page Builder 3 years ago

We have the following problem when trying to update the SP Page Builder database:

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.

Table

__sppagebuilder

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

Table

__sppagebuilder_integrations

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

Table

__spmedia

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

Table

__sppagebuilder_languages

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

Table

__sppagebuilder_sections

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

Table

__sppagebuilder_addons

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

Table

__sppagebuilder

Mismatch found on the field: catid, expected default value: 0, found: n/a
Mismatch found on the field: ordering, expected default value: 0, found: n/a
0
2 Answers
R
redclara
Accepted Answer
3 years ago #767

We have PHP version: 7.3.4 The crash occurs with SP Page Builder 3.7.8. With the version SP Page Builder 3.7.4 it works correctly.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 3 years ago #869

Hello redclara

In this case, 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