SPPB - JSON Garbage - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

SPPB - JSON Garbage

A

Alvaro

SP Page Builder 3 years ago

Searching for a domain name, I searched the database to see what pages it was on, then to verify if the domain was just a name or a url, I searched the JSON of the text column of the PREFIX_sppagebuilder table. And I was amazed when I found more than 12 results when in the live editor and in the public page it shows only 1 time. Then when checking I saw that the domain name appeared included in the values of the fields of the COLUMNS as a value of the description field like this: "description":"Founder - DomainName". We all know that columns do not have fields to display texts. That text was entered in a Feature Box addon and did not have to be as a column value.

Further searching found tons of LOREM IPSUM text (also actual text) as text field values in the columns, like so: "text":"lorem ipsum.....". this field and its value belong to the Text Block addon.

In summary, the description, text or other possibly editor-type fields are being duplicated and they are being attributed as a field and value of a column.

This is present in pages that I have created with Joomla 4.1 and SPPB 3.8.3 and then updated to 8.3.4 and 3.8.5, the revision was with version 3.8.5, I don't know if the update caused this or it is the latest version because in version 3.8.3 that bug was not present. I have tried to edit but nothing is removed.

This is not seen in the live editor or in the public part, it is only in the JSON of the database storing garbage.

0
1 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #61824

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Please share an screencast video about the full scenario & let me know what exactly do you want.

-Thanks

0