Install error - 3.7.4 to 3.8.3 - Forum | JoomShaper
Staff replied SP Page Builder

Install error - 3.7.4 to 3.8.3

Asked by Eliot 4 years ago Last activity 4 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

3 replies

Oldest first Newest first Most helpful
Toufiq Senior Staff
4 years ago

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

Eliot Asked this
4 years ago

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

Toufiq Senior Staff
4 years ago

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

Log in to reply.