If you are getting a "Error SQL Duplicate column name 'catid'" message after trying to update update from SP Page Builder v3.x or v4.x to v5.0.x in Joomla, here is how to fix your site and complete the update.
BTW, you might also be getting an error that looks like this:
"Failed opening required '/home/sitename/public_html/stageit/components/com_sppagebuilder/builder/classes/base.php' (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear')
00:00 - Introduction and Sponsored Message
00:35 - Attempting to Update to SP Page Builder 5
01:08 - Encountering the 'Duplicate column name' Error
01:42 - Uninstalling SP Page Builder
02:13 - Preparing to Edit the Database
03:20 - Disabling SP Page Builder in the Database
04:59 - Backing Up the Database
06:06 - Verifying the Fix in Joomla Backend
06:48 - Reinstalling SP Page Builder 3
07:22 - Successfully Updating to SP Page Builder 5
08:00 - Conclusion
Summary
The video demonstrates the steps to fix the "SQL Duplicate column name 'catid'" error that can occur when updating SP Page Builder to version 5 on a Joomla site. Here’s the step-by-step process outlined in the video:
Introduction: The presenter mentions the sponsor and introduces the problem with updating SP Page Builder.
Update Attempt: The presenter downloads SP Page Builder 5 and tries to install it over the existing version.
Error Encounter: The "SQL Duplicate column name 'catid'" error appears during installation.
Uninstall SP Page Builder: To fix the issue, SP Page Builder needs to be uninstalled, but the broken installation prevents it from being removed through the Joomla interface.
Access PHPMyAdmin: Use PHPMyAdmin to manage your Joomla database.
Disable Extensions: Locate the Joomla database and the extensions table. Disable all SP Page Builder extensions by changing the 'enabled' field from 1 to 0 for each entry related to SP Page Builder.
Backup Database: Export and save the database as a backup to ensure you can restore it if something goes wrong.
Verify Backend: Return to the Joomla backend and verify that you can now access the manage extensions page without errors.
Reinstall SP Page Builder 3: Download and install the latest version of SP Page Builder 3.
Update to SP Page Builder 5: After successfully installing version 3, proceed to install SP Page Builder 5. This time, the update should complete without issues.
The video concludes with a reminder to follow any additional instructions provided by JoomShaper and encourages viewers to subscribe for more Joomla-related content.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment