Install Error - 3.7.4 To 3.8.3 - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!
Back to the questions

Install Error - 3.7.4 To 3.8.3

E

Eliot

SP Page Builder 3 years ago

Hi Guys

Joomla 3.9.22

When updating SP Page Builder Pro 3.7.4 to 3.8.3 I get the following error

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 `#sppagebuilderMODIFYasset_id` INT(11) NOT NULL DEFAULT '0'; Error Error installing component

Please advise how to fix. I assume I need to manually ALTER the #sppagebuilder table, but to what?

regards Eliot

0
3 Answers
Order by
Oldest Newest Votes
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #56666

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Keep a backup of your site first then uninstall your page builder and re-install page builder.

-Thanks

0
E
Eliot
Accepted Answer
3 years ago #56920

Hi Toufiq,

I just ran the following 

ALTER TABLE `#__sppagebuilder` 
          ADD COLUMN  `asset_id` int(11) NOT NULL DEFAULT 0
          AFTER `id`;

then re-installed and it works fine.

regards Eliot

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #57211

Provide me the database access & administrator access to check the issue. Thanks

0