magicandmischief182 1 Posted March 11, 2009 Ok, before I posted I tried to answer my own question but it doesn't seem to be an easy fix. I tried to add a new product with attributes and the attributes won't show up now. Share this post Link to post Share on other sites
Jack_mcs 789 Posted March 11, 2009 (edited) This contribution doesn't change the admin at all so that problem can't be related to it. Jack Edited March 11, 2009 by Jack_mcs Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
magicandmischief182 1 Posted March 12, 2009 You are correct, I made an error on my end. Share this post Link to post Share on other sites
morehawes 0 Posted March 12, 2009 Hi Jack, thanks for the great contribution! The results returned are spot on. I am however running into some performance sluggishness on my store which has 4500 products (unsurprisingly!). We're talking around 15 seconds for the query to run when entered directly into phpMyAdmin. I'm on a dedicated server so power isn't really an issue – any ideas on how this could be improved, or would you recommend going back to the drawing board? Again big thanks! Joe MacMan strikes again! Always backup first before listening to me! Share this post Link to post Share on other sites
Jack_mcs 789 Posted March 12, 2009 You can disable the code that checks the files and others pages (like information manager, if you use that) but I think the main slowdown is coming from the code having to check the descriptions of all of those products. I don't think there is much that can be done about that. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
morehawes 0 Posted March 12, 2009 Thanks Jack - thats what I figured but just wanted to get your take on it. Cheers! Joe MacMan strikes again! Always backup first before listening to me! Share this post Link to post Share on other sites
magicandmischief182 1 Posted March 16, 2009 Since I've uploaded this add on I've gotten a few emails from customers that searched for items that were not found. How can I made it mandatory that they put their email address in the "email" box so that I can email them back letting them know if I have the product they searched for? Share this post Link to post Share on other sites
Jack_mcs 789 Posted March 16, 2009 It should already be that way. Are you using the latest version? Have you tested it? Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
magicandmischief182 1 Posted March 17, 2009 It should already be that way. Are you using the latest version? Have you tested it? Jack I did test it, and all I did was put the product search in the title, hit submit and it automatically emailed me. As far as I can tell I'm using the latest version. Share this post Link to post Share on other sites
Jack_mcs 789 Posted March 17, 2009 Try using the advanced_search_result.php and includes/modules/product_list.php files from the contribution to see if the problem goes away. If it does, you replace yours one at a time to isolate the problem. If not, it has something to do with your installation/server. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
Uniquelady 0 Posted April 8, 2009 Hi Jack I have a small problem. I run this contribution on my test server and I just ran it, it works quite well. But, and again but. I doesn't like that it is showing my card processing files under files I've found. So how do I turn this of? Best Regards Michelle Nielsen Uniquelady.dk Share this post Link to post Share on other sites
Jack_mcs 789 Posted April 8, 2009 By "card processing files" do you mean the checkout pages? If so, is the problem that they are showing up in the files section of the search results? What are you typing in for the search string? Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
Uniquelady 0 Posted April 11, 2009 By "card processing files" do you mean the checkout pages? If so, is the problem that they are showing up in the files section of the search results? What are you typing in for the search string? Jack Hi Jack If you type in something to search on www.uniquelady.michellecorydon.dk/catalog/avanced_search.php There in the bottom a list of files on the website is showing - sometimes if you search it will also come up with the checkout files. It would be lovely to get that function turned off. The link is for my test shop. Best Regards Michelle Nielsen Share this post Link to post Share on other sites
Jack_mcs 789 Posted April 11, 2009 In the includes/functions/site_search.php file, find this line $fileList = CheckFileContents($dir, $searchTerm, $fileList, $languageDir); and change it to //$fileList = CheckFileContents($dir, $searchTerm, $fileList, $languageDir); That should remove it. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
Uniquelady 0 Posted April 15, 2009 Hi Jack When Customers aren't finding anything, the contact form doesn't appear Why can that be? Best Regards Michelle www.uniquelady.dk Share this post Link to post Share on other sites
Jack_mcs 789 Posted April 15, 2009 If it displays "no product found," or something similar, then it means you missed a step in the installation procedure. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
vicster 0 Posted May 28, 2009 (edited) I have a strange question...I'm asking here because I have this contrib installed and I know Jack is very smart. :) I am in the midst of creating a Google Toolbar button that allows people to search my site for something they have already searched elsewhere on the web for. I have everything set up except the search part...I don't know how it should look (btw - it is contained in an xml file). Right now I have it as: <search charset="iso-8859-1"> http://www.mysite.com/catalog/advanced_search_result.php?search_in_description=1&inc_subcat=1&keywords={query}&pfrom=&pto=&categories_id=&x=0&y=0</search> The query part is then replaced (by Google) by the keywords entered in the original search. (All of the &'s were replaced with &'s as required when using XML) When I use this button, however, nothing is searched/returned - you are just taken to catalog/index.php. So I am wondering if I'm even putting the correct stuff there to do a search on my site. I know this post could be a long shot, but I have no idea how search works. TIA UPDATE: Never mind...it's an IE problem. It's working fine in Firefox. Edited May 28, 2009 by vicster Share this post Link to post Share on other sites
Jack_mcs 789 Posted May 28, 2009 I have a strange question...I'm asking here because I have this contrib installed and I know Jack is very smart. :) Ha Ha - another one fooled. :) I know this post could be a long shot, but I have no idea how search works. TIA I can't help you with this. You can try posting in the general forum though. But I'm pretty sure google will provide help with getting that to work and there is a google forum for such questions where you are more likely to find an answer. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
magicandmischief182 1 Posted June 25, 2009 Is it possible to make the site search not search in the files? If a customer searches on my website they get the following "Products meeting the search criteria" and "Files found meeting the search criteria". So is it possible just to search in the Products so that it doesn't slow down the search wait time. Thanks, Jeff Share this post Link to post Share on other sites
Jack_mcs 789 Posted June 26, 2009 Is it possible to make the site search not search in the files? If a customer searches on my website they get the following "Products meeting the search criteria" and "Files found meeting the search criteria". So is it possible just to search in the Products so that it doesn't slow down the search wait time. Thanks, Jeff Yes, but finding the answer is very dificult. Please closely follow these steps: - Click on the browsers scroll bar to the right - Scroll up about six posts - Read the post Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
mhsuffolk 31 Posted June 26, 2009 Hi Jack I have Info Pages Unlimited installed Will Site search Plus search these pages or is there a modification available The Extra Info pages are stored in the database Martin OsC 2.3.4.1 CE Frozen PHP 7.2 MySQL 10.1.36-MariaDB-cll-lve. Phoenix in development Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix 1.0.4.0) here. Share this post Link to post Share on other sites
Jack_mcs 789 Posted June 26, 2009 There is code in it to search the Information Pages, which are also in the database. That code can be edited to read in some other contribution. You would just need to copy and rename the function CheckInfomationPages in includes/functions/site_search.php and then add a line for the new function in the CheckAllPages function. The most dificult part would be in changing the code in the new function to read in the database information but that can be copied from wherever that contribution loads that information normally. Jack Support Links: Need Help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC version (the community-supported responsive version) here. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
mhsuffolk 31 Posted June 26, 2009 Thank you for your swift answer, I will have a go next week Martin OsC 2.3.4.1 CE Frozen PHP 7.2 MySQL 10.1.36-MariaDB-cll-lve. Phoenix in development Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix 1.0.4.0) here. Share this post Link to post Share on other sites
magicandmischief182 1 Posted June 29, 2009 Yes, but finding the answer is very dificult. Please closely follow these steps: - Click on the browsers scroll bar to the right - Scroll up about six posts - Read the post Jack Haha, thanks! Share this post Link to post Share on other sites
Clau123 0 Posted July 7, 2009 I had some trouble installing this contrib. The troubles I had were to let it work on mysql 5 and with product extra fields. I did de following, and at my site it's working: Instead of: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on p.products_id = pa.products_id left join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on pa.options_values_id = pov.products_options_values_id "; I used: $from_str = "from (((((" . TABLE_PRODUCTS . " p) left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef on p.products_id=p2pef.products_id) left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id) left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on p.products_id = pa.products_id) left join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on 'pa.options_values_id = pov.products_options_values_id' ,". TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c" ; Instead of: $where_str .= "(((pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%' )) or ( pov.products_options_values_name like '%" . tep_db_input($keyword) . "%' )"; I used: $where_str .= "((pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%') or ( pov.products_options_values_name like '%" . tep_db_input($keyword) . "%' ) or p2pef.products_extra_fields_value like '%" . tep_db_input($keyword) . "%'"; I don't know if the code is completely right, so if anyone has recommendations, I love to hear it Share this post Link to post Share on other sites