Rob Emmet Posted February 20, 2011 Share Posted February 20, 2011 I have a store with 28,852 products. None of the products after SKU 27,405 show up in the search results when I search for them using the osCommerce search function. Coincidentally, the Froogle export from Easy Populate and the Googlebase export from a separate add-on do not export records after that SKU either. The products following the SKU in question are visible on the website, just not searchable or exportable. I've checked the data in MySQL, repaired the product and product description table and deleted several products immediately preceeding and following the SKU that is the stop point to eliminate the possibility of corrupt data. Any thoughts? Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 20, 2011 Share Posted February 20, 2011 Small Integer has a max value of 32767, so it is not that. Type Storage Minimum Value Maximum Value (Bytes) (Signed/Unsigned) Signed/Unsigned) TINYINT 1 -128 127 0 255 SMALLINT 2 -32768 32767 0 65535 MEDIUMINT 3 -8388608 8388607 0 16777215 INT 4 -2147483648 2147483647 0 4294967295 BIGINT 8 -9223372036854775808 9223372036854775807 0 18446744073709551615 Any chance of a site url. G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Rob Emmet Posted February 21, 2011 Author Share Posted February 21, 2011 Thanks for checking. www.p2marine.com. http://www.p2marine.com/sailing-gear/edson-marine/edson-classic-pedestal.shtml As an example all products from the manufacturer "Edson" appear in my HTML pages. Edson also appears as a manufacturere in advanceed search, but no Edson products are found by search. Link to comment Share on other sites More sharing options...
Rob Emmet Posted February 21, 2011 Author Share Posted February 21, 2011 Very strange. I just added the products I deleted yesterday to the end of the table (Same products_model, new product_id) and those products are searchable, but the others are not. There is now a range of non-searchable products. It does not just stop at one product. I suppose a work-around could be to delete and re-add the products in the specified range, but I'd really like to know what's happening. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.