Post by marc@63400 » Wed Apr 19, 2023 11:56 pm

hello, we had tags on our products and everything works nikel .... and for a few days now the tags that have a space no longer work ... I can't find anything and I don't know what to do except to take all the products.... but it's a crazy job... do you have an idea? or a solution? a problem updating my server? I am PHP 7.4.33 (cli) (built: Apr 9 2023 16:54:16) ( NTS ) it may be that but how to find ???

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by marc@63400 » Thu Apr 20, 2023 12:03 am

I am with version 3.0.3.6 :)

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by straightlight » Thu Apr 20, 2023 8:28 am

PHP under 8.2 is no longer supported by the PHP foundation. Better consider the possibility to upgrade your PHP version to a higher version rather than staying behind. Same goes with OC 4 once it will be ready.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by marc@63400 » Thu Apr 20, 2023 12:08 pm

I upgraded to 8.2.5 but still have the same issues.
I found an error in the logs I try to look in this direction.
the error is: "rewrite:error" -> AH10411: Rewritten query string contains control characters or spaces in the apache logs which could be solved with a rewrite of the .htacces but for the moment I'm blocked :) if you have a little time... I'm a taker

New member

Posts

Joined
Wed Jun 30, 2021 12:24 am

Post by by mona » Thu Apr 20, 2023 5:29 pm

Easiest way is to simply log the query which is being executed to see if there is anything wrong with it when selecting a tag.
in catalog/model/catalog/product.php, function getProducts(....) you add:

Code: Select all

if (!empty($data['filter_tag'])) $this->log->write('Products Query for tag:['.$data['filter_tag'].']:'.$sql);
before:

Code: Select all

$query = $this->db->query($sql);
Then you can check the where clause and even copy and paste that query to a query tool to see why it doesn't do what you expect.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am
Who is online

Users browsing this forum: No registered users and 12 guests