Guest biotox Posted March 11, 2009 Share Posted March 11, 2009 Okay, I already knew there was a problem with my cart when i had 198,000+ products when I should have only had about 400. Recreating the problem, import catalog (~200 items), delete products. Reason:had to do this many many times because you get a "?" when it doesnt like the format of a " or ' the "bullet" or the trademark or registered symbol. Tried to export the catalog, but it was a no-go. error on line 68, as well as out of memory (even after bumping it up to 128M on both export.php and db.php) Found out that Imported Products (Cat_Id 2) was the cause of all of these "Ghost" products. (this was also ver 3.2.4 of CC, but upgraded not too long ago) went into the admin side of the sql database and started deleting (from Imported Products), 100 at a time. now mind you, thats close to 200k products that do not exist. So spent a good 30 minutes doing that (as well as bumping it up to 1000, then finally 100.000). it finished loading up the 100k lines, clicked on delete, and i was timed out. =( figured there was an sql command to do this for me. there is (remember to back up your database before doing this. mine was 28M before): DELETE from [table name] where [field name] = 'whatever'; in my case it was: DELETE from 'CubeCart_inventory' where 'cat_id' = '2' and all that time spent deleting at 100 a time, made me feel pretty retarded when this finished in .8 seconds. after which, my .sql was 478K exporting went smoothly, rebuild was more responsive, and hey, i freed up about 28 of "garbage" from the database. Hope this helps someone else who has/had the same troubles as me. 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.