Duplicate Records In MySQL Database For Each Page In SP Page Builder Pro
BAE Productions
I'm not sure of the exact timing when this occurred ... it was after the brute force attack we all experienced, and I believe after the recent SSP update, version 6.6.2.
Each of the Pages has been duplicated so there are two identical pages with the same Asset ID. Perhaps rather obvious, but trying to remove one of the duplicate pages as Administrator working within the SSP Component doesn't work. Example: selecting one of the duplicates and trashing it will trash both duplicate pages.
Looking at my datebase, in the sppagebuilder table, I am unable to remove one of the duplicates because the ID and Asset_ID are the same... therefore it does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
I wanted to give you the opportunity to suggest the best way to fix this matter. I assume I'll have to run a SQL query since the basics in phpMyAdmin cannot address it.
I'm not sure if anyone else using SP PageBuilder Pro has experienced or is experiencing this. If you've already provided details about the issue, please point me to that thread and/or fix.
Thank You
Toufiq
Accepted AnswerHi there,
Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. Watch the video first.
https://drive.google.com/file/d/1nxDCGjvYchgbsEyrZ1JmhbduuEcQFmmE/view
Best regards,
Toufiqur Rahman (Team Lead, Support)
BAE Productions
Accepted AnswerDownloaded com_sppbscan-1.0.5.zip
Tried to install and received this Error Message: Component Install: Field 'extension_id' doesn't have a default value
BAE Productions
Accepted AnswerNo, it doesn't resolve the issue because I can't install the component.
When I attempt to install SP PageBuilder Scan, I get the error I posted in my previous response.
I've tried several versions of the component, but the error is the same:
Component Install: Field 'extensionid' doesn't have a default value
I've watch the movie as well, in case you are going to ask that.
BAE Productions
Accepted AnswerIf you would, please follow-up with me on how to resolve this matter.
Has anyone else run into the install error for com_sppbscan? Please advise me on how to workaround the issue; I'd like to install and get these duplicate database records cleaned up.
Toufiq
Accepted AnswerCould you please provide your site's login credentials? Before sharing them, please make sure you're using a staging site rather than your live website, as I'd like to investigate the issue in a safe environment. If you don't already have a staging site, please create one and let me know once it's ready. Then, share the staging site's login details so I can take a closer look.
BAE Productions
Accepted AnswerI've created the staging site as you've requested; credentials are hidden below.
FYI ... the corruption from the attack has created duplicates of everything within the database. If you would like me to send you a sql dump file, just let me know. You'll see that all of the Joomla content articles, sppagebuilder pages, etc., has been duplicated. Since the sql tables no longer have unique id in the ID column, records cannot be deleted as normal in phpMyAdmin.
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
I was able to run ALTER TABLE commands, adding a new column with auto_increment which then allowed me to remove the duplicate record rows. The duplication corruption runs so deep that I was unable to remove duplicates without creating new issues (e.g., no longer being able to view pages in backend of SPPageBuilder while logged in as administrator).
The staging site I've provided has the original Joomla 6 files and database from after the critical security vulnerability attack in SP Page Builder (v6.1.1).
I appreciate your time and efforts with this situation.
Toufiq
Accepted AnswerPlease make sure that your extension_id exists this settings.
BAE Productions
Accepted AnswerThe extension_id exists ... however there is a length/value setting of 11, so it's int(11) ... it's not blank as in your example. Also, the checkboxes for Adjust Privileges and A_I are not checked... infact I am unable to check the box to turn on Adjust Privileges (it's grayed out).
Are you needing me to change the extension_id settings to be identical to your example?
BAE Productions
Accepted AnswerI see that the admin login is now broken. Guess what's why you now need access to the database. I can't give you access to the root of my server. I can send you a dump of the SQL database if you want, or I can create another clone of the original database to put the sandbox site back in working order.
Let me know.