Jump to content
accessorybee01

Unable to open CMS in Backend in Prestashop 1.7.6.1

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Posted (edited)

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 by PrestaServicePro (see edit history)

Share this post


Link to post
Share on other sites
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.

Db cms_category table.png

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Click on Pages menu option.png

Share this post


Link to post
Share on other sites

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

psvb_tab table entry values.png

psvb_tab table.png

psvb_tab_lang table.png

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More