Cms pages datagrid not diplay any rows when Change locale

[ghena]

Changing env
APP_LOCALE=it
then clear cache configuration

then added a new translations for specific page: php artisan optimize:clear

The datagrid not diplay any rows

this is my db for cms_page_translations

this is the results of datagrid query

Please could you check ?
Regards.
g.

[Sanjaybhattwebkul]

Hi there,
I guess you don't add the pages for the IT locale, please take a reference from Here. and the issue will be resolved.

[ghena]

I did a small video.

https://drive.google.com/file/d/1ZjT9fLxSK1AWOjuAiwMhPL0QT6Rb3Zfv/view

The problem is not solved.
.g

[ghena]

I investigate further and:

Request URL: http://127.0.0.1:8000/admin/cms?v=1&page=1
Request Method: GET
Status Code: 500 Internal Server Error
Remote Address: 127.0.0.1:8000
Referrer Policy: no-referrer-when-downgrade
Missing required parameter for [Route: shop.cms.page] [URI: page/{slug}] [Missing parameter: slug].

editing \packages\Webkul\Admin\src\DataGrids\CMSPageDataGrid.php

public function prepareActions()
{

    // $this->addAction([ 
    //     'title'  => trans('admin::app.datagrid.view'),
    //     'method' => 'GET',
    //     'route'  => 'shop.cms.page',
    //     'index'  => 'url_key',
    //     'target' => '_blank',
    //     'icon'   => 'icon eye-icon',
    // ]);

it works.
the problem seem that translation url-key not exists.
if not exists action url generator goes on error.

But is possible that a user not fill all data with a new locale.
So when change the locale it goes on error.

Please fix.

[HermesZum]

It's not an optimal solution, because all translated pages appear in the list, but at least they appear when you use a local language in the Admin other than EN.

Try this:

packages/Webkul/Admin/src/DataGrids/CMSPageDataGrid.php

public function prepareQueryBuilder()
    {
        $queryBuilder = DB::table('cms_pages')
            ->select('cms_pages.id', 'cms_page_translations.page_title', 'cms_page_translations.url_key')
            ->leftJoin('cms_page_translations', function($leftJoin) {
                $leftJoin->on('cms_pages.id', '=', 'cms_page_translations.cms_page_id')
                         ->where('cms_page_translations.cms_page_id', app()->getLocale());
            });

        $this->addFilter('id', 'cms_pages.id');

        $this->setQueryBuilder($queryBuilder);
    }

remove the line:

->where('cms_page_translations.cms_page_id', app()->getLocale())

Will be like this:

public function prepareQueryBuilder()
    {
        $queryBuilder = DB::table('cms_pages')
            ->select('cms_pages.id', 'cms_page_translations.page_title', 'cms_page_translations.url_key')
            ->leftJoin('cms_page_translations', function($leftJoin) {
                $leftJoin->on('cms_pages.id', '=', 'cms_page_translations.cms_page_id');
            });

        $this->addFilter('id', 'cms_pages.id');

        $this->setQueryBuilder($queryBuilder);
    }

[devansh-webkul]

This is a bug and I have added a PR for that. With that PR now you can able to filter the locale from the data grid itself.