VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: VB74 on December 29, 2024, 17:29:30 PM

Title: VirtueMart reviews issue with HTML
Post by: VB74 on December 29, 2024, 17:29:30 PM
Hello everybody,

I have an issue with my VirtueMart reviews. Please, see the attached screenshot.

There is an issue with HTML.

Thanks in advance for the support.


VirtueMart 4.4.0 11095
Joomla 5.2.2
PHP 8.2.18

https://casa-bandera.com/fr/boutique-livres-cuisine-italienne/ebook-qs1
Title: Re: VirtueMart reviews issue with HTML
Post by: hazael on December 31, 2024, 10:32:53 AM
First, make sure that the data in the database is saved in the correct format (avoid double HTML encoding).
If the database uses the wrong encoding (e.g. latin1 instead of utf8mb4), character display errors may occur.

Check the table settings in the database: #__virtuemart_product_reviews and make sure the column responsible for comments has the utf8mb4 encoding
Title: Re: VirtueMart reviews issue with HTML
Post by: VB74 on December 31, 2024, 14:26:20 PM
Hi hazael,

Thanks for your reply.

I checked the database and the column "comment", the HTML encoding is: utf8mb4_unicode_ci   
Title: Re: VirtueMart reviews issue with HTML
Post by: hazael on January 09, 2025, 18:08:03 PM
Hello and how are you? do you still have this problem?
Title: Re: VirtueMart reviews issue with HTML
Post by: VB74 on January 09, 2025, 22:17:02 PM
Hi Hazael,

I'm fine thanks and you?

Yes, the problem is still there. I recently updated VirtueMart to the latest version (4.4.4) but it didn't solve it.