Product Listing Sorter Drop-Down [Support Thread]

[Doomm]

I have recently uploaded this plugin on 3 of my 5 zencart based eshops.

All 3 of them are being constantly injected with trojan viruses since then. Not sure how it´s possible, but I didn´t make any other changes to the sites and as I said, those that have not been upgraded with this mod are clear. I´m using v1.1

[torvista]

All 3 of them are being constantly injected with trojan viruses since then.

How are these viruses being detected on your remote sites?

[Doomm]

They are detected by my antivirus (this is what you were asking, right?)

[torvista]

"my antivirus"

This is unclear.
I mean which antivirus software flags the trojan and where do you see the warning:
- when you access the sites through a browser (which browser)?
- some sort of notification from your hosting service?
- on your local development server?
Details....screenshots....etc.

[Doomm]

Trojans are detected by my antivirus (Eset), I see this when accessing sites through all browsers

multiple files are affected (index.html, various php files, etc, files that are not linked only to this plugin) and malicious code is inserted into it. I manually clean each and every file, so I´m very sure it´s there.

I don´t have crystal clear proof this is happening because of this plugin, but:
1.) I didn´t make any changes in last year except of this one
2.) Those sites that are nut upgraded with this plugin are still clear

So I assume, there has to be a link between these.

[torvista]

So I assume, there has to be a link between these.

Logical...but I can't see how...so more info needed..

So, ESET flags a trojan and then you examine the page on the hosting server and find a load of extra code in it which you clean out and ESET is then happy?
What version of Zen Carts are you using on these sites?

and a link to an infected site by private message please.

[Doomm]

I´m using both 1.38 and 1.50 versions, will PM you url of sites

[SoftCorpse]

Hello, thank you for this mod, however I cannot seem to get it going, I have installed all the files, but get the following error if I select one of the menu items in the dropdown except -Reset- which works fine:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_sort_order, pd.products_name limit 0, 15' at line 18
in:
[SELECT DISTINCT p.products_model, p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%speed%' OR p.products_model LIKE '%speed%' OR m.manufacturers_name LIKE '%speed%' OR (mtpd.metatags_keywords LIKE '%speed%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%speed%' AND mtpd.metatags_description !='')) )) order by m.manufacturers_name order by p.products_sort_order, pd.products_name limit 0, 15]

What and which file should I edit to change it to the correct syntax?

[torvista]

I assume you are using the current v2.0?

order by m.manufacturers_name order by p.products_sort_order, pd.products_name limit 0, 15]

The problem is there are two order clauses.

This is on the product listing?

What do you have defined here?
\includes\languages\english\extra_definitions\product_listing_sorter_en.php

define('PRODUCT_LISTING_SORTER_LIST', '
      Name (asc)d.products_name;
      Name (desc)d.products_name DESC;
      Model (asc).products_model;
      Model (desc).products_model DESC;
      Price (low to high).products_price_sorter;
      Price (high to low).products_price_sorter DESC;
      Manufacturer:m.manufacturers_name;
      Newest.products_date_added DESC;
      Most Popular: p.products_ordered DESC
      '); 

[SoftCorpse]

Yes, version 2.0, there is no file called product_listing_sorter_en.php only one named product_listing_sorter.php and it is the default one from the zipped package.

define('PRODUCT_LISTING_SORTER_LIST', '
Name (asc)d.products_name;
Name (desc)d.products_name DESC;
Model (asc).products_model;
Model (desc).products_model DESC;
Price (low to high).products_price_sorter;
Price (high to low).products_price_sorter DESC;
Manufacturer:m.manufacturers_name;
Newest.products_date_added DESC;
Most Popular: p.products_ordered DESC
');