Hello,
I have a quickstart package containing an SP Pagebuilder v3.8.10, which I want to upgrade to v5.1.3 Pro.
What's the neat or best way to do this?
I tried to update but got an error message JInstaller: :Install: Error SQL Duplicate column name 'catid'.
Even an update from v3.8.10 Free to v4.0.0 Free gives the same error message.
Please give your advice.
Joomla! : 4.4.0
Template: SJ Silk - Starter Template of Helix Ultimate Framework
PHP: 8.0.23
Hello there!
Thanks for your query.
Can you try the following? Please keep a backup of your database. Then try to delete the column name 'catid' and then check. You can also try this:
The following forum link may help you as well:
https://www.joomshaper.com/forum/question/13409
Best Regards
Hello Rashida,
Thank you for your comment. However, there is no column 'catid'. So I can't uninstall it either.
Uninstalling SP Pagebuilder Free v3.8.10 gives an error message:
Jinstaller: :Install: Can't find XML setup file
An error has occured
0 Call to a member function children() on null
Installation of SP Pagebuilder Free v4.0.0 (v3.8.10 can no longer be downloaded) gives a message:
*JInstaller: :Install: Error SQL Duplicate column name 'catid'
Extension installation stopped.
A File that you have an override for in your template has been updated and you should review those changes
Error installing component.
I also looked at the other forum link, but no luck there either.
So what now? Any other suggestions/solutions?
Hello Rasidah,
I searched the database for tables named 'catid'. These were not there.
But this column was included in the #_sppagebuilder table. I removed it.
After I installed SP Pagebuilder Free v4.0.0. I got the error message:
Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/administrator/components/com_sppagebuilder/builder
Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/administrator/components/com_sppagebuilder/layouts
JInstaller: :Install: Error SQL Duplicate column name 'ordering'
Extension installation stopped.
Error installing component
Then I removed 'catid' and 'ordering'. But then I got the following error messages:
JInstaller: :Install: Error SQL Duplicate column name 'hits'
JInstaller: :Install: Error SQL Duplicate column name 'extension'
JInstaller: :Install: Error SQL Duplicate column name 'extension_view'
JInstaller: :Install: Error SQL Duplicate column name 'view_id'
What can we still do now? I still can't update to v4.0.0 free or higher.
Hi,
It seems your template is not from us. Please make sure your template and other components are compatible with your PHP version.
Moreover, if you have database backup and full site backup also, kindly give me your admin access to check.
Best Regards
Hi Rashida,
You're right. The SJ Silk template is not from Joomshaper but is based on Helix Ultimate and purchased from smartaddons. Template version is 2.0.15.
Admin access is in the hidden content.
Hello Rashida, have you had the opportunity to look at my problem yet?
