Questions About Manually Fix Broken SP Pages - Question | JoomShaper
Back to the questions

Questions About Manually Fix Broken SP Pages

KC

Kare Casals

SP Page Builder 10 months ago

Hi. As a result of the SP Page Builder update, our pages have broken, so we are now trying to fix these pages manually and I would have asked for a few clarifications so that we don't have to start looking into the code ourselves;

  1. As far as I remember, SP Page Builder stores all page data locally in the database?

  2. All elements are in folder /components/comsppagebuilder/addons? Do these change/update only during SP Page Builder updates?

  3. Is all the SP Page Builder page data in the _sppagebuilder table?

  4. Is there anything in the _sppagebuilder table about the page information that we should know about? (e.g. "id":"xxxxxxxxx" ?)

  5. It seems that in the _sppagebuilder table the "assetid" of some pages has been change / updated. I assume this is related to the add on elements..?

Thanks for you help and all the additional information that you can provide us :-)

0
1 Answers
Order by
Oldest Newest Votes
Ziaul Kabir
Ziaul Kabir
Accepted Answer
Support Agent 10 months ago #186532

Hi Kare,

Thanks for reaching out. Below are the clarifications regarding SP Page Builder’s data storage and structure:

  1. Database Storage: • Yes, SP Page Builder stores all page data locally in the _sppagebuilder table within the database.
  2. Addon Elements Location: • All SP Page Builder elements (addons) are stored in the folder: /components/com_sppagebuilder/addons/ • These files may be updated or modified during SP Page Builder updates, so any custom changes in this directory might be overwritten.
  3. Page Data in Database: • The _sppagebuilder table contains the page content, structure, and settings. • Most of the page-related information (like layout and elements) is stored in JSON format within this table.
  4. Important Fields in _sppagebuilder Table: • The "id" field represents the unique page identifier. • The "assetid" field might be updated when changes are made to add-ons or when SP Page Builder updates are applied.
  5. Asset ID Changes: • If some “assetid” values have changed, it could be due to add-on updates or modifications in the component structure. • You might want to compare backups or manually adjust IDs if needed.

If you are manually fixing pages, I’d recommend exporting a backup before making any direct database edits. Let me know if you need more details!

Best regards,

0