I have a site on J4.4.13 running SP Page Builder 3.8.9 and its asking for an update to 5.3.2 - when i try this it causes all sorts of issues, mostly showing
Failed opening required '/home/mydomain/public_html/components/com_sppagebuilder/builder/classes/base.php' (include_path='.:/opt/cpanel/ea-php82/root/usr/share/pear')
Would like to get it updated properly, what is the best way please?
HI Richard,
I will try my best, now I am doing your website backup.
I need FTP access, becuase Phoca Commander doen't work on your site.
added - thanks
I saw that "You do not have access to the Administrator section of this site." so I guess, you disabled my access.
Yes, site is broken, but I couldn't connect to database to fix tables.
BTW
I noticed that used by you template Flex has a problem with PHP 8, that's why you have error message:
Deprecated: Creation of dynamic property Joomla\CMS\Document\ErrorDocument::$helix3 is deprecated in /public_html/templates/flex/error.php on line 26
nope that wasnt me, i have the same message and the site is down, i might have to restore it from backup?
i have restore from baackup, i am struggling to share phpadmin or even cpanel.
i have tried updating sp pagebuilder to 5.3.2 after finding that one on here but the error is still there.
i tried AI to fix the issue and a few upgrades and restores from backup as each didnt work but they summed up which might help you as follows:
Current version: SP Page Builder 3.8.94 on Joomla 4.4.13
Attempted updates: Both 5.3.2 and 6.2.3 fail with same error
Exact error: Duplicate column name 'catid'
The catid column already exists in #__sppagebuilder table before update
When you drop it and run the update, it gets added back but then the installer tries to add it AGAIN
This suggests their SQL update script has a bug where it tries to ADD the column twice
Database info: You have phpMyAdmin access and can provide table structure exports if needed
Ask them specifically:
Is this a known bug in the 3.8.94 → 5.x/6.x migration?
Can they provide a patched installer or manual SQL instructions?
Or do they have a migration script that handles this properly?
This is clearly a bug on their end - the update script should check IF the column exists before trying to ADD it (standard SQL practice).
As i say this is an AI summing up sorry if its a bit abrupt!
How many pages do you have there ?
Maybe try that method:
Tomorrow, I will ask one team member to look , becuase I will be in travel.
Thanks that could be an option, there arent too many pages. i am taaking aanother baackup now and the server wil take another tonight so tomorrow will be a good time to have a look.
Remember to create a working access to us.
You can create subdomain, where we can "play" with update without risk.
yes all done details in hidden content. Full copy of the site and there is an upto date akeeba backup available for when it goes wrong!
thanks
Any suggestions please as to how to get this one updated?
thanks
Anything please?
Have you changed password to admin again?
I see "Warning! You do not have access to the Administrator section of this site."
"Not very funny" quote from Indiana Jones.
Without PHPMyAdmin is not possible to fix it, as I told you before
No i havent that is what happens when you try and update it and the i lose access as you have, i just dont know how to share phpadmin access to you, will figure it out.
In the hidden content is cpanel login thanks
