magicandmischief182 Posted March 11, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 11, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
magicandmischief182 Posted March 12, 2009 Share Posted March 12, 2009 You are correct, I made an error on my end. Quote Link to comment Share on other sites More sharing options...
morehawes Posted March 12, 2009 Share 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! Quote Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 12, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
morehawes Posted March 12, 2009 Share Posted March 12, 2009 Thanks Jack - thats what I figured but just wanted to get your take on it. Cheers! Quote Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
magicandmischief182 Posted March 16, 2009 Share 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? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 16, 2009 Author Share Posted March 16, 2009 It should already be that way. Are you using the latest version? Have you tested it? Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
magicandmischief182 Posted March 17, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 17, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Uniquelady Posted April 8, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted April 8, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Uniquelady Posted April 11, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted April 11, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Uniquelady Posted April 15, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted April 15, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
vicster Posted May 28, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 28, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
magicandmischief182 Posted June 25, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 26, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
mhsuffolk Posted June 26, 2009 Share 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 Quote Live shop Phoenix 1.0.8.4 on PHP 7.4 Working my way up the versions. Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 26, 2009 Author Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
mhsuffolk Posted June 26, 2009 Share Posted June 26, 2009 Thank you for your swift answer, I will have a go next week Martin Quote Live shop Phoenix 1.0.8.4 on PHP 7.4 Working my way up the versions. Link to comment Share on other sites More sharing options...
magicandmischief182 Posted June 29, 2009 Share 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! Quote Link to comment Share on other sites More sharing options...
Clau123 Posted July 7, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.