MAJ SP Page Builder Problem "JInstaller: :Install: Erreur SQL Duplicate Column Name 'catid"
DigitM
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
Ziaul Kabir
Accepted AnswerHello 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,