VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: ttanidis on September 12, 2022, 11:49:30 AM

Title: VirtueMart order search not work with Greek characters
Post by: ttanidis on September 12, 2022, 11:49:30 AM
Hello,


Website ver.:
Joomla: 3.10.11
Virtuemart: 4.0.6 10690
PHP: 7.4.30


I have a problem in VirtueMart > Orders. When I try to find an order by name with Greek characters, the search result is "No records found". When I try to find an order by name with English characters the search shows the order.



Does anyone know how to help me?
Thank you very much.
Title: Re: VirtueMart order search not work with Greek characters
Post by: GJC Web Design on September 12, 2022, 22:07:14 PM
see  https://forum.virtuemart.net/index.php?topic=148837.msg531181#msg531181
Title: Re: VirtueMart order search not work with Greek characters
Post by: ttanidis on September 14, 2022, 11:56:44 AM
Thanks for your reply. In the link you suggested there is no relevant solution.
Title: Re: VirtueMart order search not work with Greek characters
Post by: GJC Web Design on September 14, 2022, 19:17:25 PM
From Max....

QuoteThe search is imho the last problem.

What a foo. Long time ago, I wrote it so, that vm encoded the strings to html entities. I removed that 1-2 years ago, because some people had trouble with imports.

now joomla changed the db handler (and it looks like for j3 also) that any query gets encoded. So they adapted my "stubborn" way for which I got so much negative response. But yes it is just a lot more secure.

should be in the latest test release  https://dev.virtuemart.net/projects/virtuemart/files
Title: Re: VirtueMart order search not work with Greek characters
Post by: Milbo on November 03, 2022, 00:23:41 AM
Please try https://dev.virtuemart.net/attachments/1339/com_virtuemart.4.0.7.10731_package_or_extract.zip

you can see it as really hardened RC, it runs for example on extensions.virtuemart.net
Title: Re: VirtueMart order search not work with Greek characters
Post by: Milbo on November 03, 2022, 00:25:01 AM
Quote from: GJC Web Design on September 14, 2022, 19:17:25 PM
From Max....

QuoteThe search is imho the last problem.

What a foo. Long time ago, I wrote it so, that vm encoded the strings to html entities. I removed that 1-2 years ago, because some people had trouble with imports.

now joomla changed the db handler (and it looks like for j3 also) that any query gets encoded. So they adapted my "stubborn" way for which I got so much negative response. But yes it is just a lot more secure.

should be in the latest test release  https://dev.virtuemart.net/projects/virtuemart/files

oha, I need to fix this entry. It was actually the adjustment to php8 and it was my fault.