SQL Query Processing Error - Question | JoomShaper
Back to the questions

SQL Query Processing Error

marvays

marvays

SP Page Builder 1 year ago

I have joomla 3 and sppb 3. i am trying upgrade for sppb 5.3.2, but afer upgrade i see:

JInstaller: :Installation: SQL Error Duplicate column name 'is_favorite' Extension Update: SQL query processing error: DB function failed, error number 1060 Duplicate column name 'is_favorite' SQL = ALTER TABLE #__sppagebuilder_addonlist ADD is_favorite tinyint(1) NOT NULL DEFAULT '0' AFTER status;

Any idea pls?

0
1 Answers
Order by
Oldest Newest Votes
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #159125

Hello there!

Thanks for your query. Can you try the following?

  1. Database backup
  2. Uninstall all instances of SP Page Builder Pro
  3. Install it again
  4. Clear CMS and browser cache

You can check out the steps here:

https://web.archive.org/web/20230331121247/https://www.joomshaper.com/documentation/sp-page-builder/sp-page-builder-3/faq-problems-solutions#install-error-sql-duplicate-column-name

The following forum link may help you as well:

https://www.joomshaper.com/forum/question/13409

Best Regards

0