Search Feature on Admin for catalog Crashes Server!!

[HollyRidge]

oscdox 2.0RC2

Everytime I try to use the search feature at the top of the catalog products/categories section in the admin center it crashes server. The server specs is: Dual Xeon 2.4Ghz, 1 GB ram, RHEL 3, Cpanel, PHP 4.3.10, MySQL 4.0.25.

Basically what I have been trying to do is search using the model # to see where the product is at with "Top" selected in the "Go To:" drop down.

I have tested this on an oscommerce install as well and works fine.

I have also opened a bug report as #0000084 (http://bugtrack.oscmax.com/view.php?id=84)

[michael_s]

This only seems to affect linux based servers, not windows based.

Here is a fix:

http://bugtrack.oscmax.com/view.php?id=84

[HollyRidge]

Please see my PM, I cant see any of the notes with the fix.

[HollyRidge]

This has been fixed! :) Thank you for helping us fix this problem!

I went a little past the fix that was in the bug tracker and wanted to post for anyone that wanted it. This fixes so that the admin can still search by model & now even description as well!

It is a quick fix in admin/categories.php

This fix is for oscdox 2.0rc2 (may work in other versions although may not)

Change (around line 1183) from...

      $products_query = tep_db_query("select p.products_ship_price, p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' or p.products_model like '%" . tep_db_input($search) . "%' order by pd.products_name");

To...

      $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and (pd.products_name like '%" . tep_db_input($search) . "%'  or p.products_model like '%" . tep_db_input($search) . "%'  or pd.products_description like '%" . tep_db_input($search) . "%') order by pd.products_name");

And change (around line 1186) from...

      $products_query = tep_db_query("select p.products_ship_price, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");

To...

      $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");

I have tested this on our machine and is working great for us. :)