MAJ SP Page Builder problem "JInstaller: :Install: erreur SQL Duplicate column name 'catid" - Forum | JoomShaper
Staff replied SP Page Builder

MAJ SP Page Builder problem "JInstaller: :Install: erreur SQL Duplicate column name 'catid"

Asked by DigitM 11 months ago Last activity 11 months ago

Hello,
I am using Joomla 5.4.0, SP Page Builder 3.8.10 and PHP 8.4.
Every time I try to update the SP Page Builder component, I get the following message!
JInstaller: :Install: SQL error Duplicate column name “catid”.
Extension installation interrupted.
Component: installation error.
What can I do?
Thank you for your feedback.
Jack

1 reply

Ziaul Kabir Staff

Hello DigitM,

To resolve the issue, Please, follow these steps (Before doing this, Please, taking your database backup first.):

Navigated to cPanel -> phpMyAdmin.
Select the relevant database.
Executed the following SQL operation:

ALTER TABLE `yourDatabaseTablePrefix_sppagebuilder` DROP COLUMN `catid`

Here add your database table prefix in here yourDatabaseTablePrefix, You will found it in your Root Joomla folder -> configuration.php

After this sql operation, Please, Try to reinstall SP Page Builder Pro. Then clear your joomla cache.

Thank you.

Best regards,

Log in to reply.