Unable to open CMS in Backend in Prestashop 1.7.6.1

accessorybee01 · July 1, 2020

Hi,

Please Help or tell me where to go and ask help

Actually I recently noticed that I am not able to find a way to edit CMS pages in backend. As Pages option under Design menu was not there!! and upon searching alot on Google and in forums and asking for help nothing helped out. But then somewhere I found about the Schema Structure of Database.

So, I checked the database and found the rows defining tabs were missing in two table, one for controller routing and other one for showing Text on particular tab in Dashboard menu. So, I added the values there by trying different values and finally the PAGES option is start showing up in backed and routing to the correct controller, as the errors stops after trying different values. But whenever I click on that option without any error now Dashboard opens up. and in Url the bar of browser the following URL address is being routed

https://www.accessorybee.com/store/xxxxxxxxx/index.php/improve/design/cms-pages/index.php?controller=AdminDashboard&token=XXXXXXX292573fb4e36bXXXXXXXXXXXX

Also after clicking Pages button the progress bar of browser waits for 4 to 5 seconds like something is being calculating and looks like its kinda failed so Dashboard is being shown up.

Please help out as access to CMS pages is totally blocked and I am unable to edit or add any CMS Page.

Will be thankful for any help.

SectioPrima · July 12, 2020

I have the exact same problem. Opened a thread a while before and also got no answer from anybody. Can't find a solution anywhere in google also..
Pls if someone knows a fix share it here..

accessorybee01 · July 18, 2020

On 7/12/2020 at 10:07 PM, SectioPrima said:

I have the exact same problem. Opened a thread a while before and also got no answer from anybody. Can't find a solution anywhere in google also..
Pls if someone knows a fix share it here..

Looks like I am not the only one who is pulling his hair due to frustration. Actually what I think is that I should have chosen Magento instead of Prestashop. This is real pin in a.. if it screws up!!! and mostly it does.

PrestaServicePro · July 18, 2020

Hello, Please follow my step. Maybe it can be useful for you.

1) Enter DB of the shop.

2) Find the table ps_cms_category. Enter it.

3) First take backup for this table. Then change id_parent to 0 for all records.

4) Then again try to navigate CMS pages.

Also enable HTML option in BO (under General tab).

Let me know about the result.

If this way will be useless restore the modified table, and share image of problem here.

Edited July 18, 2020 by PrestaServicePro (see edit history)

accessorybee01 · July 18, 2020

52 minutes ago, PrestaServicePro said:

Hello, Please follow my step. Maybe it can be useful for you.

1) Enter DB of the shop.

2) Find the table ps_cms_category. Enter it.

3) First take backup for this table. Then change id_parent to 0 for all records.

4) Then again try to navigate CMS pages.

Also enable HTML option in BO (under General tab).

Let me know about the result.

If this way will be useless restore the modified table, and share image of problem here.

Hi,

I checked the DB and found only one entry in the ps_cms_category and in id_parent the value entered is already 0 !

What should I do as HTML option is also enabled.

accessorybee01 · July 18, 2020

Hi,

I checked the DB and found only one entry in the ps_cms_category and in id_parent the value entered is already 0 !

What should I do as HTML option is also enabled.

PrestaServicePro · July 18, 2020

ENter the BO, find preferences > general tab, click it. On the page you will SSL options and HTML option. Please, share your current problem's img.

accessorybee01 · July 18, 2020

In Url the bar of browser the following URL address is being routed

https://www.accessorybee.com/store/xxxxxxxxx/index.php/improve/design/cms-pages/index.php?controller=AdminDashboard&token=XXXXXXX292573fb4e36bXXXXXXXXXXXX

Also after clicking Pages button the progress bar of browser waits for 4 to 5 seconds like something is being calculating and looks like its kinda failed so Dashboard is being shown up.

Actually the pages option was not showing so I manually entered the values in two tables in Database to add a new tab as I found through searching in Google and forums that it can be added. But now I forgot which tables were those, otherwise will have sent you a screenshot of them also.

accessorybee01 · July 18, 2020

Hi,

I found those two tables in which I added entries and option under Design Menu starts appearing. Actually I manually added the entries which should be there. But I dont know If I had done anything wrong or incomplete.

I am attaching the screen shots for you to check

PrestaServicePro · July 20, 2020

Hello, okay, i understood you. Please, send me BO and MySql access via direct message, it seems you made a mistake on DB. Depending on your table values, i want to set correct IDs.

SectioPrima · July 28, 2020

This topic in github solved my problem:
https://github.com/PrestaShop/PrestaShop/issues/17833

I just replaced those two items. I got them from one of my old DB backups (I think any before PS 1.7.6 will do, because I think the problem occurred after PS version update), and it worked for me. CMS pages are accessible again!

saidani · August 26, 2020

in my case i resolved the bug by adding 4 lignes into table authorization_role and acces

into prefix_authorization_role add

ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE

ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE

ROLE_MOD_TAB_ADMINCMSCONTENT_READ

ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE

then into acces table

add id_authorization_role into acces - (id_profil=1 id_authorization_role)

accessorybee01 · September 5, 2020

On 8/26/2020 at 6:39 PM, saidani said:

in my case i resolved the bug by adding 4 lignes into table authorization_role and acces

into prefix_authorization_role add

ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE

ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE

ROLE_MOD_TAB_ADMINCMSCONTENT_READ

ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE

then into acces table

add id_authorization_role into acces - (id_profil=1 id_authorization_role)

Thankss Buddy its working now!!! You are genius it worked in one shot!! God Bless You Buddy

CarlosTeo · July 4, 2023

On 8/26/2020 at 2:09 PM, saidani said:

in my case i resolved the bug by adding 4 lignes into table authorization_role and acces

into prefix_authorization_role add

ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE

ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE

ROLE_MOD_TAB_ADMINCMSCONTENT_READ

ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE

then into acces table

add id_authorization_role into acces - (id_profil=1 id_authorization_role)

It seems to be a good solution for my case but I dont know how to do this,. can you explain better please.

PS 1.7 CMS MISSING in BOFIFCE

ps8modules · July 5, 2023

Just save this script in the root of the eshop and run it.
Add missing profiles for CMS pages to the database.

<?php

/* 'id_profile' => '1' = Admin profile */

include('./config/config.inc.php');
include('./init.php');

$db = Db::getInstance();

$existCmsCreate = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE\'');
$existCmsDelete = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE\'');
$existCmsRead = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_READ\'');
$existCmsUpdate = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE\'');

// ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE
if (!$existCmsCreate) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE<br>';
} else {
    $checkIfExistsInAccessCmsCreate = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsCreate);

    if (!$checkIfExistsInAccessCmsCreate)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsCreate
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE
if (!$existCmsDelete) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE<br>';
} else {
    $checkIfExistsInAccessCmsDelete = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsDelete);

    if (!$checkIfExistsInAccessCmsDelete)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsDelete
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_READ
if (!$existCmsRead) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_READ'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_READ<br>';
}  else {
    $checkIfExistsInAccessCmsRead = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsRead);

    if (!$checkIfExistsInAccessCmsRead)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsRead
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE
if (!$existCmsUpdate) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE<br>';
}  else {
    $checkIfExistsInAccessCmsUpdate = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsUpdate);

    if (!$checkIfExistsInAccessCmsUpdate)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsUpdate
            )
        );  
    }
}

Edited July 5, 2023 by ps8moduly.cz (see edit history)

CarlosTeo · July 5, 2023

11 hours ago, ps8moduly.cz said:

Just save this script in the root of the eshop and run it.
Add missing profiles for CMS pages to the database.

<?php

/* 'id_profile' => '1' = Admin profile */

include('./config/config.inc.php');
include('./init.php');

$db = Db::getInstance();

$existCmsCreate = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE\'');
$existCmsDelete = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE\'');
$existCmsRead = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_READ\'');
$existCmsUpdate = $db->getValue('SELECT id_authorization_role FROM '._DB_PREFIX_.'authorization_role WHERE slug = \'ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE\'');

// ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE
if (!$existCmsCreate) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_CREATE<br>';
} else {
    $checkIfExistsInAccessCmsCreate = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsCreate);

    if (!$checkIfExistsInAccessCmsCreate)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsCreate
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE
if (!$existCmsDelete) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_DELETE<br>';
} else {
    $checkIfExistsInAccessCmsDelete = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsDelete);

    if (!$checkIfExistsInAccessCmsDelete)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsDelete
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_READ
if (!$existCmsRead) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_READ'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_READ<br>';
}  else {
    $checkIfExistsInAccessCmsRead = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsRead);

    if (!$checkIfExistsInAccessCmsRead)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsRead
            )
        );    
    }
}

// ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE
if (!$existCmsUpdate) {
    $db->insert('authorization_role',
        array(
            'slug' => 'ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE'
        )
    );
    $insertedId = $db->Insert_ID();
    $db->insert('access',
        array(
            'id_profile' => '1',
            'id_authorization_role' => $insertedId
        )
    );

    echo 'added ROLE_MOD_TAB_ADMINCMSCONTENT_UPDATE<br>';
}  else {
    $checkIfExistsInAccessCmsUpdate = $db->getValue('SELECT id_profile FROM '._DB_PREFIX_.'access WHERE id_authorization_role = '.$existCmsUpdate);

    if (!$checkIfExistsInAccessCmsUpdate)  {
        $db->insert('access',
            array(
                'id_profile' => '1',
                'id_authorization_role' => $existCmsUpdate
            )
        );  
    }
}

Hi ps8moduly.cz

I´m sorry but my skills in code are limited.

You suggest to put this code in root but what file of presta?

Thank you very much for helping me.

ps8modules · July 5, 2023

Hi.

Open a text editor, paste the entire code into it and save it as, for example, repairCMS.php.
Upload the file repairCMS.php to FTP to the main folder where you have Prestashop installed.
Then enter a link to the file in the URL of your eshop, something like https://mysite.com/repairCMS.php

Then you can check in the database if there are records.

Edited July 5, 2023 by ps8moduly.cz (see edit history)

CarlosTeo · July 5, 2023

Hi.

Thanks again for your help.

I think I do it all right but don´t see changes.

I clean cache, clean cookie, anonimus page and other safari browser.

Still white page!

As I sayd the CMS is there except category.

Could be a language problem?

ps8modules · July 5, 2023

SQL query:

SELECT * FROM ps0k_authorization_role WHERE slug LIKE '%ROLE_MOD_TAB_ADMINCMS%';

CarlosTeo · July 5, 2023

THIS ????

ps8modules · July 5, 2023

Are you serious ?
Can't you see that you have two SELECTs?
You have to clear the content and then copy what I gave you.

I think your knowledge is not enough for that and you can hurt yourself even more.
Please hire someone. I don't know how to advise you anymore.

Edited July 5, 2023 by ps8moduly.cz (see edit history)

CarlosTeo · July 5, 2023

Ok ps8moduly.cz.

Sorry my lack of knowledge and don´t be rude.

If I find a professional to do this sure I do!

Thanks anyway for your help

(I change it and still same white)

ps8modules · July 5, 2023

Hi.

I assumed that if you were able to import data from another version of Prestashop, you would be able to do this as well.

I contacted you but no response.

lukask10 · May 28

I have this same problem. Would anyone like to help me and visit my store?

dave97 · June 20

yo cuando intento acceder en el backoffice en diseño>paginas me da este error:

Unable to open CMS in Backend in Prestashop 1.7.6.1

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in