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:

1. Export all pages one by one
2. Uninstall SP Page Builder
3. Install a new version

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