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

Celebrate JoomShaper's Sweet 16 with Flat 35% OFF!

Critical Bug: Url Redirects do Not Work

M

Martin

SP Page Builder 6 days 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
23 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 6 days 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
5 days ago #226172

Hi,

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 5 days ago #226174

Please share an screencast video. Thanks

0
M
Martin
Accepted Answer
5 days ago #226177

Link to the screencast added in hidden content.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 5 days ago #226178

Please check the screenshot.

0
M
Martin
Accepted Answer
5 days 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 5 days ago #226183

Will you please check now. Thanks

0
M
Martin
Accepted Answer
5 days 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 5 days ago #226185

Can you tell me which version was previously Page Builder?

0
M
Martin
Accepted Answer
5 days ago #226188

It was 6.2.2 before.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 5 days ago #226190

Current version is 6.2.2

I have checked 6.2.1 version and same issue.

0
M
Martin
Accepted Answer
5 days 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
5 days 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
2 days ago #226397

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

0
M
Martin
Accepted Answer
1 day 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 day ago #226537

Please, Share forum post URL.

0
M
Martin
Accepted Answer
1 day 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 day 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 23 hours ago #226584

Developer team checking your issue. Please allow me time.

0
M
Martin
Accepted Answer
23 hours 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 22 hours ago #226598

I have removed the screenshot publicly.

0
M
Martin
Accepted Answer
22 hours ago #226599

Thank you!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 22 hours ago #226600

You are always welcome :)

0