Major site crash after u/g of SPPB to version 5.5.2 - Forum | JoomShaper
Staff replied SP Page Builder

Major site crash after u/g of SPPB to version 5.5.2

Asked by Chris Elliott 1 year ago Last activity 1 year ago

Seen this several times now and each time you guys fix it and fail to tell me what you do to fix it so I'll try again.

Website running SPPBPro 3.8.10 reports I can upgrade to 5.5.2. In the past, the upgrade option has failed and left the site absolutely broken, so this time I manually installed 5.5.2 to again crash the site.

Control Panel error:

JInstaller: :Install: Error SQL Duplicate column name 'catid'
Extension installation stopped.
Error installing component

After failed update from 3.8.10 to 5.5.2 the front end reports:

Failed opening required '/home/[accountname]/public_html/components/com_sppagebuilder/builder/classes/base.php' (include_path='.:/opt/cpanel/ea-php82/root/usr/share/pear')

A point of note is that this doesn;t happen on all upgrades but 2 or 3 updates have recently killed the sites in question.

In hidden details I give a link to a broken, upgraded 5.5.2 site (in a subfolder off the manually restored 3.8.10 site which is fine now).

Please can you :

  1. Indentify on this broken site what is wrong?
  2. Fix it?
  3. Tell me how you fix it so I can fix it myself next time.?

Chris

4 replies

Toufiq Senior Staff

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. Please check now & let me know.

Best regards,

Toufiqur Rahman (Team Lead, Support)

Chris Elliott Asked this

Yes you fixed it.

Now, can you confirm what I was doing wrong and exactly what you had to do to fix it?

Chris

Toufiq Senior Staff

There were missing folders during installation (component/com_sppagebuilder/Builder and administrator/component/com_sppagebuilder/editor). First, I replaced them using Phoca Commander, then uninstalled Page Builder and reinstalled it.

Toufiq Senior Staff

If you're satisfied with our product and service, please close the forum post. You can also rate our product and support quality here.

https://www.trustpilot.com/review/www.joomshaper.com

https://extensions.joomla.org/extension/sp-page-builder/

Chris Elliott Asked this

I can see you installed Phoca Commander but failed to uninstall it - thats poor.

Secondly, you're making life difficult for me here - I guess I will have to figure out exactly what black magic tricks you performed...

I can see the /builder folder contains
v

and I see /editor contains

/traits
/helpers
/data

if this happens again (I guess it will) then I have copied backup of the above folders and their contents and can upload them if I have to.

Ultimately though, this is clearly a BUG and I presume will you be fixing this in 5.5.3 so that if the folders and their contents are not there, then the 5.5.3 update will add them in?

Toufiq Senior Staff

Did you try to rollback previous version when installation failed?

Chris Elliott Asked this

Yes - that failed too.

Toufiq Senior Staff

Okay. We will investigate it on our end if it occurred, and then we will fix it.

Log in to reply.