Update SP Pagebuilder Free 3.8.10 To SP Pagebuilder Pro 5.1.3 Results In Error Duplicate Column Name 'catid' - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Update SP Pagebuilder Free 3.8.10 To SP Pagebuilder Pro 5.1.3 Results In Error Duplicate Column Name 'catid'

D56 WebDesign

D56 WebDesign

SP Page Builder 2 years ago

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

0
6 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 2 years ago #134584

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:

  1. Database backup
  2. Uninstall SP Page Builder Pro
  3. Install it again
  4. Clear CMS and browser cache

The following forum link may help you as well:

https://www.joomshaper.com/forum/question/13409

Best Regards

0
D56 WebDesign
D56 WebDesign
Accepted Answer
2 years ago #134630

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.

  • The installation crashes the entire site. Again, there is no 'catid' column.

I also looked at the other forum link, but no luck there either.

So what now? Any other suggestions/solutions?

0
D56 WebDesign
D56 WebDesign
Accepted Answer
2 years ago #134677

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.

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 2 years ago #134817

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

0
D56 WebDesign
D56 WebDesign
Accepted Answer
2 years ago #134837

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.

0
D56 WebDesign
D56 WebDesign
Accepted Answer
2 years ago #135634

Hello Rashida, have you had the opportunity to look at my problem yet?

0