Error JInstaller: :Instalar: Error SQL Duplicate Column Name 'catid'
Carlos Arango
Hi, please i need help to solve an error when i try to installlate the sp page builder in my website, y currently update from joomla 3 to joomla 5 and now, when i try to upload the sp page builder again, the system says: JInstaller: :Instalar: Error SQL Duplicate column name 'catid'
Ziaul Kabir
Accepted AnswerHello,
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,