This is a discussion on Search Feature on Admin for catalog Crashes Server!! within the osCMax v2 Features Discussion forums, part of the osCMax v2.0 Forums category; oscdox 2.0RC2 Everytime I try to use the search feature at the top of the catalog products/categories section in the ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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) |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| This only seems to affect linux based servers, not windows based. Here is a fix: http://bugtrack.oscmax.com/view.php?id=84
__________________ Michael Sasek osCMax Developer
|
|
#3
| |||
| |||
| Please see my PM, I cant see any of the notes with the fix. |
|
#4
| |||
| |||
| 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... Code: $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");
Code: $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... Code: $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");
Code: $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");
|
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| problem with admin panel search function | taol | osCMax v2 Features Discussion | 0 | 12-13-2006 03:15 PM |
| osCAdminID generated and not letting the admin search | sarath26 | osCMax v2 Features Discussion | 1 | 11-27-2006 09:53 AM |
| Little help locating feature in admin please | pede | osCMax v2 Features Discussion | 3 | 07-23-2006 02:58 PM |
| new server, now getting no modules in admin and errors. | red_fraggle | osCommerce 2.2 Installation Help | 4 | 01-19-2005 09:09 AM |
| english.php crashes when saved by the built in file editor | Trinity | osCMax v1.7 Discussion | 1 | 09-22-2004 01:06 AM |