Prestashop: “You do not have permission to edit this.” after update from 1.6.1.24 to 1.7.6.3

Created on 1 Feb 2020  ·  42Comments  ·  Source: PrestaShop/PrestaShop

Describe the bug
Hi, with our ISP we updated from 1.6.1.24 to 1.7.6.3 in a sub folder so the site is not operative but it's quite to ready.
The data seems right.
I have a problem with permission.
When a try to install theme or modules we get this message:
“You do not have permission to edit this.”
I download all site and db to test it in local server, the same thing happens.
Thanks for any replies

To Reproduce
Steps to reproduce the behavior:

The ISP used classic update with the native module
I have the log.txt

Screenshots
“You do not have permission to edit this.”
the image show the warning in italian language.
Schermata 2020-02-01 alle 12 30 50

Additional information
PrestaShop version: 1.7.6.3
PHP version: 7.1

1.7.6.3 Autoupgrade Bug No change required Theme & logo
Source
picture ballashop

All 42 comments

Hi @ballashop,

I did not manage to reproduce the issue with PS1.7.6.3 after an upgrade from PS1.6.1.24 using the 1-click upgrade v4.10.1.
I attached a screen record
https://drive.google.com/file/d/1-hmJQiHk9fff9BR_CDkGAxltFyZJcz66/view
What is the exact version did you use during the upgrade?
Are you using an employee with a super admin profile?

Thanks!

khouloudbelguith picture khouloudbelguith on 3 Feb 2020

Hi @khouloudbelguith
thanks a lot to reply me.
Can I send you the log.txt via email?
The ISP started from 1.6.1.24 to 1.7.6.3 by 1-click upgrade (it is likely that the version used is v4.10.1).
About a user yes, I'm using a super admin one.
Thanks a lot for your support.

ballashop picture ballashop on 3 Feb 2020

@ballashop,

Can you please provide us the log of your upgrade? It can be found in the log.txt file, available in <admin folder>/autoupgrade/tmp/log.txt.
We need also to retrieve the PHP error log and the debug mode report in order to find out what's wrong.
Don't you know how to get this information? Please read the following article:
http://build.prestashop.com/howtos/misc/how-to-create-bug-report/
This is a public space.
You can provide me the module by email.
My address mail: khouloud.[email protected]
Let's be safe!

Thanks!

khouloudbelguith picture khouloudbelguith on 3 Feb 2020

dear @khouloudbelguith ,
I sent you a email with logs.
I'm waiting your kind response.
Thanks for your support.

ballashop picture ballashop on 3 Feb 2020

@ballashop, thanks!
You have some warnings during the upgrade.

  1. >[WARNING] SQL 1.7.5.0
    1071 in ALTER TABLE ps_customer
    CHANGE company company VARCHAR(255),
    CHANGE email email VARCHAR(255) NOT NULL,
    CHANGE passwd passwd VARCHAR(255) NOT NULL: Specified key was too long; max key length is 1000 bytes

  1. [WARNING] SQL 1.7.5.0
    1071 in ALTER TABLE ps_employee
    CHANGE firstname firstname VARCHAR(255) NOT NULL,
    CHANGE email email VARCHAR(255) NOT NULL,
    CHANGE passwd passwd VARCHAR(255) NOT NULL,
    CHANGE lastname lastname VARCHAR(255) NOT NULL: Specified key was too long; max key length is 1000 bytes

  • [WARNING] SQL 1.7.6.2
    1054 in INSERT INTO ps_info_lang SELECT
    entity.id_info, 1, entity.id_lang, entity.text
    FROM ps_info_lang entity
    LEFT JOIN ps_info_lang entity2 ON entity2.id_shop = 1 AND entity.id_info = entity2.id_info
    WHERE entity2.id_shop IS NULL: Unknown column 'entity2.id_shop' in 'where clause'

  • [WARNING] SQL 1.7.0.0
    1062 in INSERT INTO ps_hook (name, title, description, position) VALUES
    ('actionValidateCustomerAddressForm', 'Customer address form validation', 'This hook is called when a customer submit its address form', '1'),
    ('displayAfterCarrier', 'After carriers list', 'This hook is displayed after the carrier list in Front Office', '1'),
    ('displayCarrierExtraContent', 'Display additional content for a carrier (e.g pickup points)', 'This hook calls only the module related to the carrier, in order to add options when needed.', '1'),
    ('validateCustomerFormFields', 'Customer registration form validation', 'This hook is called to a module when it has sent additional fields with additionalCustomerFormFields', '1'),
    ('displayProductExtraContent', 'Display extra content on the product page', 'This hook expects ProductExtraContent instances, which will be properly displayed by the template on the product page.', '1'),
    ('displayNavFullWidth', 'Navigation', 'This hook displays full width navigation menu at the top of your pages', '1'),
    ('displayAfterBodyOpeningTag', 'Very top of pages', 'Use this hook for advertisement or modals you want to load first.', '1'),
    ('displayBeforeBodyClosingTag', 'Very bottom of pages', 'Use this hook for your modals or any content you want to load at the very end.', '1'): Duplicate entry 'displayAfterBodyOpeningTag' for key 'hook_name'

    • Thanks to check those tables.
    You can find the full schema for 1.7.6.3 here:
    https://github.com/PrestaShop/PrestaShop/blob/1.7.6.3/install-dev/data/db_structure.sql

    Thanks!

    khouloudbelguith picture khouloudbelguith on 3 Feb 2020

    Hi @khouloudbelguith,
    thanks a lot,
    Can I ask you the kindness to indicate which of these warnings concerns the administrator's permissions?
    So I can send this message to the ISP to fix it.
    Thanks a lot.

    ballashop picture ballashop on 3 Feb 2020

    Dear @khouloudbelguith
    I'm in contact with our ISP to fix the problem.
    As I have useful information, I will write here.
    Thanks a lot.

    ballashop picture ballashop on 3 Feb 2020

    @ballashop, Thanks!
    Waiting for your feedback.

    khouloudbelguith picture khouloudbelguith on 3 Feb 2020

    Desar @khouloudbelguith
    the ISP fixed the problem, they wrote:

    "_the problem was generated by an update bug of version 1.6 to 1.7 in the access a authentication tables_"

    Unfortunately I don't have more specific information, I'm sorry.
    Thanks a lot.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, To fix this issue you need to replace the ps_access table in DB with the one from clean PS1.7 installation.
    You can, for example, install PrestaShop separately, copy & paste the table ps_access to your shop.
    Or you can follow this solution in this comment to solve your issue https://github.com/PrestaShop/PrestaShop/issues/9513#issuecomment-415011961
    Before any modification, you can make a backup of your old database.
    Thanks to check & feedback

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    Dear @khouloudbelguith
    really thanks for the message that really useful.
    I've found another error about renew, the ISP wrote: the error it depend on a bug of Prestashop after update from 1.6 to 1.7.
    Can I post here or I have to open another issue?
    Thanks for you support.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, yes, you can post it here.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    Ok @khouloudbelguith

    when I click to the renew (dashboard)

    renw

    I get this message from debug:

    renew-error

    Thanks for your support.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, could you please try to re-install the productcomments module with removing the folder, clear cache, check & feedback.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    Hi @khouloudbelguith
    Ok, I'll try now, thanks.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, thanks!
    Waiting for your feedback.

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    Hi, @khouloudbelguith
    I didn't find this module :( into the module folder.
    Maybe I'm wrong path.
    I'm waiting your kind response.
    Thanks.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, in your BO => Modules => Module manager page => if you search for the productcomment, you can't find it?
    https://github.com/PrestaShop/productcomments
    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    no unfortunately!
    how can it be?
    I looked for a clean install of 1.7.6.3 and there is no such module either.
    Thanks

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, yes!
    This module is not automatically installed.
    But the link "Product Reviews" in the dashboard is related to this module.
    https://drive.google.com/file/d/1kzmuibruja4rhD1xorExUCMFhhSrMTSI/view
    If the module is not installed, this link is not displayed.
    image

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    Hi @khouloudbelguith
    is it possible that from 1.6.1.24 to 1.7.6.3 (update by native PS module) the dashboard show the box also without the module?
    for some reason he brought the data back but not the module.
    I have the renew link in dashboard:

    Schermata 2020-02-04 alle 12 25 31

    That link points to a module that doesn't exist, why the error appear, maybe!
    The ISP rename module 1.6 folder,

    module-rename

    Can I take the module folder, the link you wrote before:
    https://github.com/PrestaShop/productcomments
    and copy it to the server, within module folder?
    Thanks for your support.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, the productcomments module is compatible with PS1.7.6.0 or more: https://github.com/PrestaShop/productcomments/blob/master/productcomments.php#L60
    It is not compatible with PS1.6.1.24
    image

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    ok, of course :)
    the clean site is version 1.7.6.3, i can test first on that.
    Obviously I intended to operate on 1.7
    I'll let you know.
    Thanks a lot.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, thanks!
    Waiting for your feedback.

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    hi @khouloudbelguith
    I tried to install the module I downloaded from:
    https://github.com/PrestaShop/productcomments

    Schermata 2020-02-04 alle 16 00 15

    but it didn't work:

    Schermata 2020-02-04 alle 15 59 40

    Do you have any other suggestions on how to proceed?
    Thanks for your support.

    ballashop picture ballashop on 4 Feb 2020

    @khouloudbelguith
    i tried do install by module catalog in local clean PS installation, I found it and I installed but I've got this error:

    error comment module

    I'm waiting your kind response.
    Thanks.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, I tried with fresh install PS1.7.6.3 & it is OK.
    module_productcomments.webm.zip
    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    I have done exactly the same steps! with a different result.
    Now I will do this:
    I delete the productcomments folder
    I clean the cache
    I close and restart MAMP
    I will go through the same steps again
    Then I report you.
    Thanks a lot for your support.

    ballashop picture ballashop on 4 Feb 2020
    👍1

    @ballashop, waiting for your feedback.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    ok, in local site I installed with success, now I'm going to do the same steps with online site (into a sub folder) not the operative one of course :), it's still to 1.6.1.24 version
    I'll let you know.
    Thanks for your support.

    ballashop picture ballashop on 4 Feb 2020
    👍1

    @ballashop, waiting for your feedback.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    amazing, online I can't find this module, I don't understand why!!!
    I tried with:
    comment, commenti (italian language), renew, recensioni.
    I also synced to the marketplace but no term can find this module, I find it incredible.
    can I copy the folder from the local server to the remote server?
    Thanks for your support.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, you can search with the tech name of this module.
    Try with this productcomments.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    I tried but it didn't work!
    Schermata 2020-02-04 alle 16 54 16
    Schermata 2020-02-04 alle 16 54 30
    Schermata 2020-02-04 alle 16 54 39
    Schermata 2020-02-04 alle 16 54 47
    any other suggestions?
    Thanks a lot.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, what is the exact version of this shop?

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    1.7.6.3
    Thanks

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, check that the module is not installed.
    Search it in the Module manager page.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    it is not installed online:

    Schermata 2020-02-04 alle 17 03 57

    and this is the local site:

    Schermata 2020-02-04 alle 17 04 51

    can I copy and paste the productcomments from local to online folder?
    Thanks a lot for your support.

    ballashop picture ballashop on 4 Feb 2020

    @ballashop, try to compress the productcomments module & upload it in the second shop.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    ok, I compress the productcomments folder then I uploaded by BO the zip file:

    Schermata 2020-02-04 alle 17 10 41

    now I have it into the online site.

    modulo caricato

    The reviews are not displayed at the moment but this I think is a problem of the theme we used.
    I'm setting up the theme we bought into the PS marketplace and I'll contact the developer to fix that.
    The site is in debug mode and we don't have any error message!
    Thanks a lot @khouloudbelguith for your valuable contribution.

    ballashop picture ballashop on 4 Feb 2020
    🎉1

    @ballashop, I will close the issue.
    Feel free to open a new one when needed.

    Thanks!

    khouloudbelguith picture khouloudbelguith on 4 Feb 2020

    @khouloudbelguith
    TOP! thanks a lot.

    ballashop picture ballashop on 4 Feb 2020
    👍1
    Was this page helpful?
    0 / 5 - 0 ratings

    Related issues

    web service product update failing with "Property Product->price is not valid"
    esistgut picture esistgut  ·  3Comments
    SQL Manager allows saving wrong query
    zuk3975 picture zuk3975  ·  3Comments
    Prestashop 1.7 : Site only accessible in debug mode
    wikao2 picture wikao2  ·  3Comments
    The Symfony debug bar hides the action buttons on the product page
    rGaillard picture rGaillard  ·  3Comments
    core.js obfuscated
    vincent-dp picture vincent-dp  ·  3Comments