Issue With The SP PageBuilder - Can't Create New Pages Or Edit Newly Duplicated ...
Georgi Georgiev
Hi JoomShaper,
I'm creating a website based on one of yout templates and I have several issues with the PageBuilder Pro.
Template - Shaper_qubic SP PageBuilder Pro version - Version 4.0.11
1. Issue with creating New Pages: When I want to create a new Page in the SP Page Builder, pops up error message in the right bottom corner. Field 'ordering' doesn't have a default value! I tried everything that I found in the Forum, but nothing helps.
2. Issue with changing content of duplicated page;
When I have duplicated existing page and try to change the name or the content in it and try to Save it. One message appear and the changes not applied, even I can't change the name of the duplicated page. This is the error - Incorrect integer value: '' for column ruhomesewebsite.uou93sppagebuilder.published at row 1.
Link to the screenshots - https://drive.google.com/drive/folders/1HwmCZ7W9tl9ATh8pyEjkfajVsh7lAgKU?usp=sharing
Rashida Rahman
Accepted AnswerHi there!
Thanks for your query.
- Please go to the phpMyAdmin, load up your site's database and then open the schema for the xxxxx_sppagebuilder. (here xxxxx is your database table prefix )
In the table you'll see, it should mention a line for this column ( ordering).
Just set default value for colomn ordering and save.
Clearing your Joomla and browser cache is always important.
- Which PHP version you are using there?
Please let me know if this solves the issue for you.
Best Regards
Georgi Georgiev
Accepted AnswerHi Rashida,
thank you for the reply! I already have been checked the steps you suggested. I saw them in outher posts here in the forum.
First I want to share with you that I have two tables in database with the sppagebuilder prefix in them you can check it here - https://prnt.sc/nqUp7uGPvhyg
- I did the steps from your reply and the issue still persist.
- PHP version I use is 8.0 with the settings you required in the documentation about the pagebuilder. My Joomla is version 4.3.1 and I use Shaper_qubic template with SP Pagebuilder version - 4.0.11.
Would you suggest another way around or how to fix the issue, because I can't move on with the development.
Thank you in advance!
Best, Georgi!
Rashida Rahman
Accepted AnswerAre you looking into the correct database of the respective site, please?
There should not be two tables as per my knowledge. I can see prefixes are different though.
In this case please take a full site backup and uninstall SP Page Builder completely(every instances of SP Page Builder) and then fresh download from our website and reinstall.
It should help!
Best Regards
Georgi Georgiev
Accepted AnswerHi Rashida,
I also have a problem with the Menus links linked to SP Pagebuilder Pages! When I go to front-end and click on the main menu item, for example "About Us" the URL link is www.domain/market/#undefined. Do you know what could be the problem?
Best, Georgi!
Rashida Rahman
Accepted AnswerHi,
Please check this:
Best Regards