Prestashop: Prestashop 1.7.6 Related Product and Images Thumbnails

[Dupflo]

Hello, after update 1.7.6 I am unable to add related product to the product.

When I am trying to select thumbnail for product variante, I also have an issue that does not allow me to see the images.

I have the following error in my console.

GET https://url.domain/administrationfolder/themes/new-theme/public/index.php?controller=AdminPerformance&token=a37fb1e3cce99e983e72d3640f8c50c5 net::ERR_ABORTED 404 (Not Found)

Server : Apache/2.4.25 (Debian)

PHP : 7.0.33-0+deb9u3

Thank you by advance

[khouloudbelguith]

Hi @Dupflo,

I did not manage to reproduce the issue with PS1.7.6.1.
https://drive.google.com/file/d/1gIehWK6_6CcUyHBrnSxxpdEfsoFOQSYB/view
Could you please provide us with more info? We need more details to understand how we can reproduce your issue:

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

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!

[Dupflo]

I just fixed the error of the images because the update just remove small_default ! So my issue is only issue number 1

server setup and configuration : Apache/2.4.25 (Debian), PHP 7.0.33-0
PrestaShop version (source) : 1.7.6
debug mode report : Even on debug mod I don't have access to report the website is working fine

[khouloudbelguith]

@Dupflo, there is error in the console?
You need to enable debug mode in your store and debug request which is sent for product action in your browser, using DevTools, so:

1. enable debug mode
2. go to the product page
3. open up developer tools
4. go to Network tab
5. add a related product
6. wait for an error, you should see red request information in Network tab
7. click on it, you should see the error message in "Response" or "Preview" tab

Thanks!

[Dupflo]

Thank you! Here is what I got

I got Failed to Load Response Data for both "Response" and "Preview" tab

I have no related product that is proposed.. even related product previously added to a product are displayed in Front Office but not on the Back Office

[khouloudbelguith]

@Dupflo, you have an error 404.
There is no error displayed in the Preview Tab when you click on the "the error message"?

Thanks!

[Dupflo]

@Dupflo, you have an error 404.
There is no error displayed in the Preview Tab when you click on the "the error message"?

Thanks!

No error, I got something like my request is find in the database since I can find this code with the debug mod based on my "XL" research

[{"id":"8","name":"Ultra Nuit (XL) (ref: UN_U)","ref":"UN_U","image":"https:\/\/hannahpad.fr\/477-home_default\/serviette-hygienique-ultra-nuit-xl.jpg"},{"id":"9","name":"Super Ultra Nuit (XXL) (ref: SUN_U)","ref":"SUN_U","image":"https:\/\/hannahpad.fr\/515-home_default\/protection-hygienique-super-ultra-nuit-xxl.jpg"},{"id":"13","name":"Coffret Ultra Nuit (XL) (ref: UN_C)","ref":"UN_C","image":"https:\/\/hannahpad.fr\/600-home_default\/coffret-ultra-nuit-xl.jpg"},{"id":"15","name":"Coffret - Super Ultra Nuit (XXL) (ref: SUN_C)","ref":"SUN_C","image":"https:\/\/hannahpad.fr\/637-home_default\/coffret-super-ultra-nuit-xxl.jpg"},{"id":"62","name":"Ultra Nuit (XL) - Revendeurs (ref: UN_R)","ref":"UN_R","image":"https:\/\/hannahpad.fr\/890-home_default\/serviette-hygienique-ultra-nuit-xl.jpg"},{"id":"63","name":"Super Ultra Nuit (XXL) - Revendeurs (ref: SUN_R)","ref":"SUN_R","image":"https:\/\/hannahpad.fr\/910-home_default\/protection-hygienique-super-ultra-nuit-xxl.jpg"}]

This is the code generate by the request but it does not display

I can give you an access if you want, this is the very first time I have no clear idea of an error..

[Dupflo]

Do you think this issue can come from my PHP version ?

[khouloudbelguith]

@Dupflo,

Could you please follow this link: https://github.com/PrestaShop/php-ps-info
phppsinfo file provides an equivalent to the phpinfo() function that reports PrestaShop Requirements information about the PHP/MySQL/Apache environment and offers suggestions for improvement.

1. Upload the file to the server. You should upload your file to the exact directory you want to test. Typically, this will be your httpdocs (/var/www/vhosts/example.com/httpdocs/) directory, although you can upload it to any subdirectory on your server as well. Use FTP to upload the file.
2. Visit the page in your browser. If you uploaded it to your html directory, you should now visit http://www.example.com/phppsinfo.php, replacing example.com with your own domain name.
3. Now you can view all of the information about PHP for your server for that particular directory.
   

Thanks to check and feedback.

[Dupflo]

Thank you I will test and let you know

[khouloudbelguith]

@Dupflo, thanks!
Waiting for your feedback.

[Dupflo]

@khouloudbelguith here is what I got

[khouloudbelguith]

@Dupflo, did you installed any custom module before this issue occurs?

Thanks!

[Dupflo]

@khouloudbelguith this is my customer website and there is a ndk_custom_module.
This bug appeared since 1.7.6 update

[khouloudbelguith]

@Dupflo, during the upgrades, are there any errors occurred?
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
Thanks!

[Dupflo]

@khouloudbelguith Here is the log
log.txt

[khouloudbelguith]

[2019-09-13 01:12:16] 01:12:16 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign". Message: "An exception occurred while executing 'CREATE UNIQUE INDEX admin_filter_search_id_idx ON ps_admin_filter (employee, shop, controller, action, filter_id)':
[2019-09-13 01:12:16] In AbstractMySQLDriver.php line 115:
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] An exception occurred while executing 'CREATE UNIQUE INDEX admin_filter_sea
[2019-09-13 01:12:16] rch_id_idx ON ps_admin_filter (employee, shop, controller, action, filter_i
[2019-09-13 01:12:16] d)':
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] oo long; max key length is 1000 bytes
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] In PDOConnection.php line 106:
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] oo long; max key length is 1000 bytes
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] In PDOConnection.php line 104:
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] oo long; max key length is 1000 bytes
[2019-09-13 01:12:16]
[2019-09-13 01:12:16] prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]
[2019-09-13 01:12:16] Error during database upgrade. You may need to restore your database.
[2019-09-13 01:12:16] Error upgrading Doctrine schema

You have issues during the upgrade.
You have an issue with table ps_admin_filter
Thanks to check the structure of this Table

Thanks!

[Dupflo]

It seems looking good

[khouloudbelguith]

@Dupflo, but you have all these errors related to this table.

[2019-09-13 01:12:16] Error during database upgrade. You may need to restore your database.
[2019-09-13 01:12:16] Error upgrading Doctrine schema

The upgrade is not well working is your case.

Thanks!

[Dupflo]

I finaly found the issue came for ajax_products_list.php

line 26 : @trigger_error('Using '.__FILE__.' to make an ajax call is deprecated since 1.7.6.0 and will be removed in the nex major version. Use a controller instead.', E_USER_DEPRECATED);

I found on google a version to (credits from https://www.sunnytoo.com/forums/topic/megamenu-product-block#post-52015)

Thank you Prestashop... no it works

ajax_products_list-2.zip

[khouloudbelguith]

@Dupflo, Thanks for your feedback.
Since it is fixed.
I close the issue, feel free to open a new one when needed.

Thanks!