SP Page Builder Front Editor Not Working - Question | JoomShaper

SP Page Builder Front Editor Not Working

Clockworx Solutions

Clockworx Solutions

SP Page Builder 4 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';

0
11 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 4 years ago #14613

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

0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #14618

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.
0
Toufiq
Toufiq
Accepted Answer
Senior Staff 4 years ago #14641

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

0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #15644

Hi,

I have done the suggestion and still not working..

Is there another thing i can do?

Thank you

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 4 years ago #15652

Give me cpanel access & Joomla super administrator access

0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #15930

Hi Toufiq,

Thank you for the support,

The access is in the hidden content.

Thank you,

C

0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #15985

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 4 years ago #16018
0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #16028

Hi,

I have configurated again.

Please kindly try again,

Thank you,

C

0
Clockworx Solutions
Clockworx Solutions
Accepted Answer
4 years ago #16153

Hi,

Please any updates?

Thank you

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 4 years ago #16173

Hi there, Thanks for the getting back. I try to login your backend and successflly it has been login. But, i need a backup of your site to check locally. Can you manage for me? I try to install akeeba backup. But, it's failed.

https://drive.google.com/file/d/1HwEmKAzw-uVWQHdASGHU31nJaJKBSR56/view

-Thanks

0