Prestashop: Link widget - Blocks cannot be updated when memcached is enabled Prestashop 1.7

[ets-soft]

Describe the bug

I enabled caching with CacheMemcached, my memcached server has been correctly configured and working well. But since the caching is enabled, sometimes when I save products, disable/enable module... it doesn't take effect! There is no change on the FO when I update product information (sometimes), I disable a module and reload the BO the module keep enabled...
I have checked some core files of Prestashop, I think the problem is in doctrine, when an SQL is executed via doctrine it doesn't clear all related SQL cached queries!

Expected behavior

All related cached SQL queries must be cleared when an Insert, update, delete, etc. queries are executed

Steps to Reproduce

Edit by Khouloud

the cache issue is happening on another area such as module link list this: https://prnt.sc/rjjfs3
Can you follow:

1. enable your Memcached
2. Design > Link widget
3. Try to edit some link (title, URL...) then save

4. Go to the Front office and review the links. You will notice there are no changes in FO

Steps to reproduce the behavior:

1. Go to "Advanced parameters / Performance / Caching"
2. Set "Use cache" to "Yes"
3. Select caching system as "CacheMemcached"
4. Configure your memcached server
5. After you have successfully enabled memcached, try to disable a certain module via module list in BO then reload the BO you will see the module keep enabled! Try to update product information via BO and review the product on FO you will see product info is not updated (sometimes)

Additional information

• PrestaShop version: 1.7
• PHP version: 7.0

[khouloudbelguith]

Hi @ets-soft,

Thanks for your report.
I did not manage to reproduce the issue with PS1.7.6.4.
I attached a screen record
Untitled_ Mar 17, 2020 10_44 AM.webm.zip
Could you please provide us with more info? We need more details to understand how we can reproduce your issue:

• host
• server setup and configuration
• PrestaShop version (source)
• debug mode report
• PHP error logs
• apache error log
• javascript console log
• screenshots

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/

Thanks!

[ets-soft]

hi @khouloudbelguith
Thanks for checking, I just review the problem, seem it's ok when updating product info but the cache issue is happening on other area such as module link list this: https://prnt.sc/rjjfs3
Can you follow:

1. enable your memcached
2. Design > Link widget
3. Try to edit some link (title, URL...) then save
4. Go to Front office and review the links. You will notice there is no changes in FO

Thanks

[khouloudbelguith]

@ets-soft, thanks for these clarifications.
I manage to reproduce the issue with PS1.7.5.2 and PS1.7.6.4.
Untitled_ Mar 23 2020 2_17 PM.webm.zip

I’ll add this to the debug roadmap so that it’s fixed. If you have already fixed it on your end or if you think you can do it, please do send us a pull request!
Thanks!

[ets-soft]

hi @khouloudbelguith
I think the problem may not only happen in the link widget title, it's only 1 example case. Please tell the dev team to check the whole caching process deeply to make sure it works correctly everywhere.
Actually, I tried to look into the code of Prestashop but could not figure out how to fix the issue so I'm looking forward to a fix from Prestashop as this is really important feature and I really need it for my customers' website.

Thanks

[khouloudbelguith]

@ets-soft, thanks for these clarifications.

[LukasK13]

I can confirm this issue on PS 1.7.7.0