SQL query processing error - Forum | JoomShaper
Staff replied SP Page Builder

SQL query processing error

Asked by marvays 2 years ago Last activity 2 years 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?

1 reply

Rashida Rahman Staff
2 years ago

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

Log in to reply.