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
Staff replied
SP Page Builder
MAJ SP Page Builder problem "JInstaller: :Install: erreur SQL Duplicate column name 'catid"
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.