Guest AndEverythingNice Posted May 3, 2011 Share Posted May 3, 2011 I have 1 product on my site that is showing an error. I believe I deleted the product a couple months back but for some reason it is showing up on my google crawl stats as a soft 404 error. Can someone please help me fix? My link MySQL Error Occured 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 QUERY = SELECT cat_name FROM shop_CubeCart_category WHERE cat_id = Quote Link to comment Share on other sites More sharing options...
convict Posted May 3, 2011 Share Posted May 3, 2011 This product has NO category ID defined - it belongs to NO category. You have to delete it from database outside of CubeCart. Quote Link to comment Share on other sites More sharing options...
Guest AndEverythingNice Posted May 4, 2011 Share Posted May 4, 2011 This product has NO category ID defined - it belongs to NO category. You have to delete it from database outside of CubeCart. Thank you for your help, I went into my database and tried to locate the item but it is not there to delete. I went to my shop_cubecart_inventory on my ccrt1 database. Am I looking in the wrong place? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 4, 2011 Share Posted May 4, 2011 Product ID 165: it really should be there in the _inventory table. Try sorting the table by Id and see what's there. Quote Link to comment Share on other sites More sharing options...
Guest AndEverythingNice Posted May 4, 2011 Share Posted May 4, 2011 Product ID 165: it really should be there in the _inventory table. Try sorting the table by Id and see what's there. Thank you for your help! I went back into the database, sorted by id and product 165 is not there. I have 163, 164 then jumps to 167. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 4, 2011 Share Posted May 4, 2011 Ok. If using the standard (non-sef) web address syntax, I get the same error: http://and-everything-nice.biz/shop/?act=viewProd&productId=165 Bad http://and-everything-nice.biz/shop/?act=viewProd&productId=164 Good http://and-everything-nice.biz/shop/?act=viewProd&productId=167 Good That tells me the SEO mod is not malfunctioning. But because this is a custom skin, maybe some editing of viewProd.inc.php has also occurred? Generally, CC is supposed to determine first if the product Id exists in the database, then if it does, build the sef url (which is where I think the crash is coming from), and build the category breadcrumb. I think there may be a flaw in the SEO mod program or it was not installed correctly in this file. To conclude, Google is still remembering this product. You will need to tell Google, somehow, to discard this from search results of your store. If Google is actively finding this link, you need to somehow determine on what page the link is located. 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.