Can't Upgrade SP Page Builder - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!
Back to the questions

Can't Upgrade SP Page Builder

PB

Paul Blacknell

SP Page Builder 3 years ago

I'm trying to upgrade from 3.4.3. to 3.8.8 but it'a failing. It asks me to download and install manually which also fails.

It says

Warning
JInstaller: :Install: Error SQL Unknown column 'asset_id' in '#__sppagebuilder'
Extension Update: SQL error processing query: DB function failed with error number 1054
Unknown column 'asset_id' in '#__sppagebuilder'
SQL =
ALTER TABLE `#__sppagebuilder` MODIFY `asset_id` INT(11) NOT NULL DEFAULT '0';

I'm trying then to download 3.7.15 as maybe that works but I can't find it (or 3.5.x or 3.6.x)

0
Website
https://www.nomadsailing.co.uk
3 Answers
Order by
Oldest Newest Votes
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 years ago #87859

Hi there!

Sorry for the inconvenience.

The following process may help:

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

Best Regards

0
PB
Paul Blacknell
Accepted Answer
3 years ago #89279

This did not work at all. If you read my post above you can see that it complains of Unknown column 'asset_id' but you're suggestion is for a duplicate (already existing) column

I need you help please

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 years ago #92641

Hi,

Really sorry for the delayed response.

Both can be solved in the same way as you can see from the following conversation too:

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

If your issue still persist, would you please give me your admin access to check?

Best Regards

0