articles integration problem while testing my site for Joomla 4 - Forum | JoomShaper
Solved SP Page Builder

articles integration problem while testing my site for Joomla 4

Asked by Tracey Field 3 years ago Last activity 3 years ago

Hi, I wonder if anyone has a similar experience and any advice.

I'm currently testing my Joomla 3 site to move to Joomla 4 (yes I know its late but I was hoping for a software update for a plugin I love)

I am testing my site having used MM4 to create a staging so I can see what is working, what isn't.

On my Joomla 3 site I primarily use the pagebuilder articles integration. So articles integration is active and on every article I have enabled page builder as the editor.

On my test joomla 4 site I activated articles integration and my website pages look as they should on the front end. However, when I go to an article there is no option to enable page builder as the editor, making the pages uneditable.

I know the answer is often cache so I cleared the cache on my hosting, cleared the cache on the site and cleared my browser cache. Still no option for the page builder editor.

I'm open to any ideas, oh, and Im an annoying non techy user. Thank you!

Accepted answer

Marked as the solution
Toufiq Senior Staff
3 years ago

Please check now & let me know. If you confirm it works fine. Then I will move it on your server. Thanks

9 more replies

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

Hi there,

I appreciate you reaching out. I sincerely apologize for this oversight. Will you please provide me the Joomla administrator access to check the issue? I will check & get back to you soon. 

-Thanks

Tracey Field Asked this
3 years ago

Brilliant thank you! This is a testing site using MigrateMe4 staging so isn't live at the moment.

The details are in the hidden section.

Thank You!!!!

Tracey Field Asked this
3 years ago · edited

Just checking I need to do this on the joomla 4 staging site?

It looks incredibly complicated with lots of elements I didn't really understand and it went very fast (Im not an IT person)

Do I need to do all of what is in the video or just part of it?

I will watch again very closely stage by stage to try and do it but want to make sure I do it in the right place!
Thank you, Im so grateful for your help!
Tracey

Toufiq Senior Staff
3 years ago

It's not complicated. It's like the Joomla quickstart pack installation process. You can try it on your local host or staging site first. Thanks

Tracey Field Asked this
3 years ago

Ok, I'm sorry, I'm stuck

I have to open up phpmyadmin via my website hosting, when I click on the databases tab I don't have an option to create a new database for the backup file?

And I don't understand how you got to local host/test to then click on the next bit?

And I guess it seems complicated to me because I didn't use a quickstart process, mainly because my hosting allowed me to add Joomla with a click of a button, but also because I started from scratch so I didn't use quickstart. It means I'm not familiar with phpmyadmin or moving around files. Its why I had to purchase a component to help me create my staging site as I didn't know how to do it myself.

Sorry, Tracey

Toufiq Senior Staff
3 years ago

Another process is Donwload a backup of your site. Then uninstall page builder and make re-install.

Toufiq Senior Staff
3 years ago

Before uninstall page builder you should comment these line of code. Cause, There is no way to keep a backup module if you uninstall the page builder.

administrator/components/com_sppagebuilder/installer.script.php

foreach ($modules as $module)
        {
            $name = (string)$module->attributes()->module;
            $client = (string)$module->attributes()->client;

            $db = Factory::getDBO();
            $query = $db->getQuery(true);
            $query->select($db->qn('extension_id'));
            $query->from($db->qn('#__extensions'));
            $query->where($db->qn('type') . ' = ' . $db->q('module'));
            $query->andWhere($db->qn('element') . ' = ' . $db->q($name));
            $db->setQuery($query);
            $extensions = $db->loadColumn();

            if (count((array) $extensions))
            {
                foreach ($extensions as $id)
                {
                    $installer = new Installer;
                    $result = $installer->uninstall('module', $id);
                }
                $status->modules[] = array('name' => $name, 'client' => $client, 'result' => $result);
            }
        }

-Thanks

Tracey Field Asked this
3 years ago

Ok, I'm going to go this route as my hosting does a really simple back up and restore through them.

To make sure I've got it correct, do I add this code before or after I do the back up?

I'm guessing before otherwise I loose it when I uninstall?

I understand it is before I uninstall page builder.

I've found the installer script file in the file manager on my hosting do I add the code at the end or somewhere else?

Thanks Tracey

Tracey Field Asked this
3 years ago

I've downloaded and saved the original installer script file in case I get it all wrong and need to upload the original back.

I'm in the file manager in my hosting site. Where in the file should I add the code? Do I just add it at the end?

Once I've done that I run a back up.

Then uninstall page builder

Then set up my staging site

Then reinstall page builder

Is that correct?
Tracey

Toufiq Senior Staff
3 years ago

Can you give me hosting access?

Tracey Field Asked this
3 years ago

Yes, details in hidden content.

I've just created a fresh back up on my hosting, logged out my users and unpublished the login menu to avoid anyone else logging in.

Let me know if you need anything else.

Tracey

Toufiq Senior Staff
3 years ago

Give me Authentication code. Check your email.

Tracey Field Asked this
3 years ago

below

Tracey Field Asked this
3 years ago · edited

yes, thank you, pagebuilder is working great on there!

What do I need to do next?

Do I continue with working off the staging site you have built? (assuming it was my site that was the problem)

Or, if it was a bug in pagebuilder do I wait for the fix?

Toufiq Senior Staff
3 years ago

There is no issue on Page Builder. If you confirm that it works fine then you should move it main site. Thanks

Tracey Field Asked this
3 years ago

Thank you, I didn't dare touch anything or login anywhere until I knew you were no longer there!

I also wasn't clear whether it was for me to carry on with or if there was something else you needed to do.

I appreciate your help! Have a great weekend
Tracey

Toufiq Senior Staff
3 years ago

Should i do anything now?

Tracey Field Asked this
3 years ago

Sorry, I now have to learn what to do to move from a staging site to make it live (this was why I was using migrateme4 as I don't know how to do this)

The staging site you set up had some additional errors with repeatable modules that also needs to be resolved before I move over.

I haven't got time to do anything further before I have to go to work unfortunately so everything is on pause. (making me panic as my members can't access the site)

It would be good to know what the problem was as I feel I may have to replicate it if I can't resolve the staging to live quickly tonight.

I do really appreciate your help and time

Toufiq Senior Staff
3 years ago

It would be good to know what the problem was as I feel I may have to replicate it if I can't resolve the staging to live quickly tonight.

What i have done exactly. I just uninstalled Page Builder and made re-install page builder.

Tracey Field Asked this
3 years ago

Ok, sorry, I know it is frustrating trying to help people who don't understand.

Toufiq Senior Staff
3 years ago

Sorry!

Tracey Field Asked this
3 years ago · edited

Hi, I've had more time to look around the staging site you created (thank you again).

However all the modules that I created using page builder on my joomla 3 site have been lost in the staging process.

Page builder integration is working fine in articles but wherever there was a module position, the position is still there, but is no longer linked to a module. When you go to content, site modules and search by type, there are no modules that I created using page builder.

I would be grateful for your thoughts.

Thanks
Tracey

and a thought just after I logged off, is there a way of somehow downloading my page builder modules from my joomla 3 site and then uploading them to my joomla 4 staging site?

Toufiq Senior Staff
3 years ago

If you use Page Builder module then download the json file using export option then import on your new site. Thanks

Tracey Field Asked this
3 years ago

Ok thank you the export/import works - and then needs to rebuild every article and pages module links within the website.

So just checking you don't have any other suggestions and my only options are to decide which is less labour intensive to rebuild?

On my staging site I lose SP page builder article integration but I do get to keep my modules and links

Or on your staging site I can keep article integration and then import/export each module over and rebuild all the links

Am I correct in thinking we've run out of any other options?

Toufiq Senior Staff
3 years ago

There is no alternative way except export and import process.

Tracey Field Asked this
3 years ago

ok, that means a partial rebuild of the website to import over 200 modules and then go to every page of the website to reconnect the links to modules.

Its very strange, im sure there must be a simpler answer as to why pagebuilder article integration isnt working properly on my site in the migration.

Thanks for trying to help anyway

Tracey Field Asked this
3 years ago · edited

But when you did that it didn't work!

I asked the question to clarify if I added that code at the end of the file to make sure I got it correct.
You then created a staging site for me instead of telling me what to do.

Your staging site corrected the article integration problem, but it didn't keep the modules, it lost them all.

And so that is why I am right back at the beginning where we started with my orginal question.

As no one else is having problems migrating with the software, I can only conclude it is a conflict with something else that is causing the problem.

When researching elsewhere for a solution regarding article integrations not working on migration someone suggested the following: "sometimes something in an .htaccess file messes with things running in a sub folder in the test migration area. But hopefully the developers would have noticed anything not loading."

Does that sound like a possibility?

Toufiq Senior Staff
3 years ago

I have found another issue on your database table. There are double page builder similar type of database on your database table. I need to forward your issue to our developer team. Thanks

Tracey Field Asked this
3 years ago · edited

If you had a look today that's because I started to try out another pagebuilder yesterday as if I have to do a rebuild I will need to consider all options. I'd rather stick with yours obviously (I know it and have lots built with it ) so I can uninstall the new pagebuilder as I've only been familiarising myself with it at the moment.

I think I did use a different pagebuilder originally before finding yours so while that would have been uninstalled some time ago I know uninstalls don't always clean up everything?

Let me know if you need be to delete anything that you think might be causing a conflict. I've been through everything once again to check for compatibility. There is one piece of software that I had disabled as it isn't joomla 4 ready (the reason I had delayed doing this). I've found I can't uninstall it as I get an error message: 0 Undefined constant "JPATH" with a link to public_html/libraries/src/Installer/Adapter/ModuleAdapter.php:214... I wonder if this is what is causing the conflict. I've messaged the software support but responses have been very patchy but will hope for a response. If you know a way of forcing the uninstall let me know.

I deleted the staging site you created - partly because it didn't have any of my modules, but also because my website is an active membership site so new members are being added each day meaning it was no longer up to date.

I'm unable to do anything further until the weekend due to other commitments for the rest of the week so I've reset all the security features and deleted all staging sites (yours and mine) and will start the process again with a fresh start at the weekend.

Thanks Tracey

Toufiq Senior Staff
3 years ago

Solved your issue on my end. I will share with you on my server. Thanks

Tracey Field Asked this
3 years ago

Hi sorry for the delay in responding, I was unable to work on the site last week due to other commitments. Im pleased to say that I started from scratch again yesterday with a new staging site. A couple of things had updates during the week, and I also needed to do a database fix to correct some articles that hadn't migrated properly. And page builder migrated over including article integration. The main thing that was different was that I didn't need to activate the integration, it happened automatically this time.

Something still isn't quite right, as the save on anything new is very glitchy and I have to save after every individual action, new coloumn, new add on etc and I sometimes have to repeat an action 3 or 4 times to get it to 'stick'.

However, all my information has migrated across without the need for a rebuild and so I've gone live with Joomla 4. This means we can close the ticket.

Thanks
Tracey

Toufiq Senior Staff
3 years ago

You are most welcome & Let me know if you need further any help. :)

Log in to reply.