SP Page builder front editor not working - Forum | JoomShaper
Staff replied SP Page Builder

SP Page builder front editor not working

Asked by Clockworx Solutions 5 years ago Last activity 5 years ago

Hi,
Im having this problem with the frontend editor from the SP Page builder, that when i tried to access the editor, it only displays a white square.

My SP Page builder is Version: 3.7.3
I have tried to update it but it give the following error:
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';

11 replies

Toufiq Senior Staff

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Will you please provide me the Joomla administrator access & FTP access to check the issue? I will check & get back to you soon.

-Thanks

Clockworx Solutions Asked this

Hi,

I cannot give you admin access, but i can tell you the path and actions i have took

Those are:
It show the "bug" when i try to access Joomla dashboard> SP Page builder> Pages > Services> Frontend Editor> Edit page

Further information:

    • Joomla version:

** Dev- pegasus: Joomla! 3.9.26

** Pegasus-consultancy: Joomla! 3.9.19

  • Browser we tried to access the SP Page Builder:

** Google Chrome

** Safari

** Mozilla

  • Version of the SP page builder on both websites (WE have a dev and Production that both has the same problem):

** Version: 3.7.3

** Current plugin version: 3.7.9

I have tried to update the plugin by installing the new version, and it does not work and appears the following message:
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';

  • I have cleaned the cache as well for the plug in and also for the other extensions.
Toufiq Senior Staff

You can keep an backup of your site and uninstall your page builder and make an re-install your page builder. Thanks

Clockworx Solutions Asked this

Hi,

I have done the suggestion and still not working..

Is there another thing i can do?

Thank you

Toufiq Senior Staff

Give me cpanel access & Joomla super administrator access

Clockworx Solutions Asked this

Hi Toufiq,

Thank you for the support,

The access is in the hidden content.

Thank you,

C

Clockworx Solutions Asked this

Hi Toufiq,

Do you have any updates on this issue?

Our project is depending on this tool and we need to move forward with this.

Looking forward to hearing from you,

Thank you,

C

Clockworx Solutions Asked this

Hi,

I have configurated again.

Please kindly try again,

Thank you,

C

Clockworx Solutions Asked this

Hi,

Please any updates?

Thank you

Log in to reply.