Error message - Forum | JoomShaper
Solved SP Page Builder

Error message

Asked by ian shuter 5 years ago Last activity 5 years ago

Hi, I was upgrading my version of Pro from 3.7.4 to 3.7.9 when I got the following message

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';

Error
Error installing component

HOWEVER my Joomla updates dashboard states that the installed Version is now 3.7.9.

I am using the latest version of Joomla 3.9
www.swfhs.org.uk

Accepted answer

Marked as the solution
Toufiq Senior Staff
5 years ago

I have made uninstalled the extension and made re-installation. That's it. Now it works. Please close the forum post. Thanks

10 more replies

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

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Will you please provide me the Joomla administrator access & database access via hidden content area? I will check & get back to you soon.

-Thanks

ian shuter Asked this
5 years ago

See details below

Toufiq Senior Staff
5 years ago

Database access

ian shuter Asked this
5 years ago

see below

Toufiq Senior Staff
5 years ago

Login code please

ian shuter Asked this
5 years ago

see below

Toufiq Senior Staff
5 years ago

Please check now and let me know. Thanks

ian shuter Asked this
5 years ago

Hi

"Message
Installation of the component was successful."

All seems well, was it an error on my site?

Ian

ian shuter Asked this
5 years ago

Thank you

Toufiq Senior Staff
5 years ago

You are most welcome & Thanks

Log in to reply.