All product page are ok when using the English shop. For example: https://jukebox.skyberatedev.nl/index.php/seeburg-200-reclamebord.html?___store=default&___from_store=default_nl_migrated
When chaninging the laguage to Dutch the product image won’t load and the tab do not work correct. : https://jukebox.skyberatedev.nl/index.php/seeburg-200-reclamebord.html?___store=default_nl_migrated&___from_store=default
What is going wrong. It happens with a lot of the products but not with all.
7 answers
Hi There,
I tried a few times but could not connect your site. I run across this issue: https://www.dropbox.com/s/szh96doz2z0dslm/2018-06-08_08-11-54.png?dl=0
Please help to check your server again. Once I can access your site, I will check and get back to you.
Best Regards,
Ziven.
It is on-line again now.
Hi There,
I can access your site now. I tried to debug further using your old credentials provided via this ticket, however it seems you have deactivated them.
Please help to provide me again both Admin and SSH credentials.
PS. I am sorry for not checking and requesting the credentials earlier.
Best Regards,
Ziven.
Hi There,
I am sorry for replying this late as our team has just been back from weekend.
We have found the root of issue: http://i.prntscr.com/ueUARNwHQX_VgbHKdD51Ew.png
It relates to the Magento core issue with special chars in the value of Product’s name.
I have edited the product name from ‘Seeburg “200” reclamebord’ => Seeburg 200 reclamebord
(http://i.prntscr.com/FwbAdcFQRFGa8vGyqgopeA.png)
And the issue you mentioned was solved.
Please check again at your end.
Best Regards,
Ziven.
Thanks.
I see that is th eproblem.
Do you know an sql query to replace or remove them all in Magento 1 or 2. I have many products with ” or other special character in the product description.
Hi there,
Do you know an sql query to replace or remove them all in Magento 1 or 2.
You could use below SQL to mass update for all product’s names in the table catalog_product_entity_varchar in M2’s database:
UPDATE `catalog_product_entity_varchar` SET `value` = REPLACE(`value`, '"', '') WHERE `attribute_id` IN (SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = 'name' AND `entity_type_id` = 4);
Regards,
Mall.
