Critical Bug: Url Redirects do Not Work - Question | JoomShaper

Critical Bug: Url Redirects do Not Work

M

Martin

SP Page Builder 1 month ago

After updating to SP Page Builder 6.6.2, some of our redirects do not work anymore. Instead of redirecting, it gives and error: "You don't have permission to access this. Please contact a website administrator if this is incorrect."

This is not a permission error as all the items have access Public and they were working before the update.

Our redirects are simple Joomla articles, but it seems that the SP Page Builder router is doing something that it shouldn't.

This is the call stack:

0 A key is required Call Stack

Function Location

1 () JROOT/libraries/vendor/joomla/database/src/DatabaseQuery.php:1910 2 Joomla\Database\DatabaseQuery->bind() JROOT/libraries/vendor/joomla/database/src/DatabaseQuery.php:2008 3 Joomla\Database\DatabaseQuery->bindArray() JROOT/libraries/vendor/joomla/database/src/DatabaseQuery.php:1796 4 Joomla\Database\DatabaseQuery->whereIn() JROOT/components/comsppagebuilder/router.php:356 5 SppagebuilderRouterBase::getSlugsByCollectionItemIds() JROOT/components/comsppagebuilder/router.php:114 6 SppagebuilderRouterBase::buildRoute() JROOT/components/comsppagebuilder/router.php:590*

Please check this as soon as possible!

Thanks, Martin

0
27 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226171

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. To better address the issue, could you kindly provide Joomla administrator access? This will enable me to thoroughly investigate the matter and provide you with a prompt resolution.

Note: Also, Share an screencast video about the full scenario.

Best regards,

Toufiqur Rahman (Team Lead, Support)

0
M
Martin
Accepted Answer
1 month ago #226172

Hi,

I have added the sample test site credentials in the hidden content.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226174

Please share an screencast video. Thanks

0
M
Martin
Accepted Answer
1 month ago #226177

Link to the screencast added in hidden content.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226178

Please check the screenshot.

0
M
Martin
Accepted Answer
1 month ago #226180

Thanks, but that is why we are using the Joomla built-in redirects, so the old not working url will redirect to the new working URL.

It has always worked for hundreds of our sites and thousands of links and that is the way the Joomla redirects are used. And this particular redirect was working perfectly fine on this site before updating to the latest SP Page Builder.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226183

Will you please check now. Thanks

0
M
Martin
Accepted Answer
1 month ago #226184

Cleared Joomla cache and run in incognito window. Now with the https://domain.com/alias-to-be-redirected I get:

0 A key is required

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226185

Can you tell me which version was previously Page Builder?

0
M
Martin
Accepted Answer
1 month ago #226188

It was 6.2.2 before.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226190

Current version is 6.2.2

I have checked 6.2.1 version and same issue.

0
M
Martin
Accepted Answer
1 month ago #226191

Stange, I cannot explain that as when we discovered the issue, I especially checked my localhost copy on 6.2.2 and it was working. Then I updated to latest version to check if it is the SP Page Builder issue and after update the localhost site immedeatly had the same issue.

Anyway, this fix is really critical to us.

0
M
Martin
Accepted Answer
1 month ago #226192

It seems that the Collections are stealing the article urls. When I do this is components/com_sppagebuilder/router.php, it starts working again:

private static function getArticleIdBySlug($slug){
    return null; // PATCH: don't treat Joomla articles as SPPB dynamic items.

    /*$db = Factory::getDbo();
    $query = $db->getQuery(true)
        ->select('id')
        ->from('#__content')
        ->where('state = 1')
        ->where('alias = ' . $db->quote($slug));
    $db->setQuery($query);
    $articleId = $db->loadResult();

    if ($articleId) {
        return $articleId;
    }

    $query = $db->getQuery(true)
        ->select('id, title')
        ->from('#__content')
        ->where('state = 1');
    $db->setQuery($query);
    $articles = $db->loadObjectList();

    foreach ($articles as $article) {
        if (OutputFilter::stringURLSafe($article->title ?? '') === $slug) {
            return $article->id;
        }
    }

    return null;*/
}
0
M
Martin
Accepted Answer
1 month ago #226397

Please see my urgent request in hidden content (post #226190)!

0
M
Martin
Accepted Answer
1 month ago #226531

PLEASE SEE MY URGENT REQUEST IN HIDDEN CONTENT (POST #226190)!

IT IS NOT RELATED TO FIXING ANYTHING IN THE COMPONENT. IT JUST NEEDS 5 SECOND AND TWO CLICKS IN THIS THREAD.

THANK YOU!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226537

Please, Share forum post URL.

0
M
Martin
Accepted Answer
1 month ago #226540

It is the current post, url is https://www.joomshaper.com/forum/question/45205

Post #226190

Thanks!

0
M
Martin
Accepted Answer
1 month ago #226579

My request above is very clear, please do these 2 clicks that are critical for me due to data breach !!!!!!!!!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226584

Developer team checking your issue. Please allow me time.

0
M
Martin
Accepted Answer
1 month ago #226587

I'm not talking about solving the bug, I need you to remove certain info!!! I have added this for the third time in the hidden content.

Can you see it? Can you understand what it says? You just need to remove one link! I'm really getting desperate.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226598

I have removed the screenshot publicly.

0
M
Martin
Accepted Answer
1 month ago #226599

Thank you!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 month ago #226600

You are always welcome :)

0
M
Martin
Accepted Answer
2 weeks ago #229720

Friendy bump!

This is a serious and widespread issue. For now I have to patch all the sites manually after each SP Page Builder update which is a huge work when you have several dozens of sites.

Thanks!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 weeks ago #229776

Did you check the latest version? Please let me know.

0
M
Martin
Accepted Answer
2 weeks ago #229894

Indeed, in the fresh version of 6.7.0 it seems to be working fine again!

Thank you!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 weeks ago #229932

You are most welcome! We appreciate your feedback and are delighted to hear that you're satisfied with our service.

To officially close this forum post, mark it as accepted. If you have any more questions or need further assistance in the future, please don't hesitate to reach out to us.

As for writing a review about our product and support quality, we would greatly appreciate it! Your feedback helps us improve and serves as a valuable reference for others. Please take a moment to share your thoughts about your experience with our product and the support you received. Your input is valuable to us and the community. Thank you in advance for your time and support.

Joomla Extension Directory

JED.png

TrustPilot

Trust-Pilot.png

We're here to assist you with any further questions or requests you may have. Once again, thank you for choosing our product and for being a part of our community.

Best regards,

Toufiqur Rahman

Team Lead, Tech Support (JoomShaper)

0