Resolved - Can't find Cloned Product in Database

[Dirty Butter]

I'm pulling my hair out with this one. I've created 3 products lately using the cloned product process. I had created a template for all our estates products and cloned it to create them. I also added a new Category. They ALL show in the front end and in the sitemap. BUT I can't find them in the database! This is so weird! I've repaired the database, with no luck.

 

Is this a hosting issue, or did the cloned items end up somewhere else in the database besides _inventory?

[bsmither]

This may be what is causing the apparent problem of not finding them in the _inventory table: If records in the _inventory table are deleted, that creates a void that possibly can later be filled by an insertion. That being done, and if the database utility (phpMyAdmin) is not configured - or does not make the assumption - to default ORDER BY the primary index, then the inserted records that fill voids will not be in the list where you might expect.

 

Try forcing the utility to ORDER BY the _inventory table by 'product_id'. The index 'product_id' is never reused.

[Dirty Butter]

I tried a SORT by product_id, but that didn't show them. I'm sorry, but I don't know what I have to do to "Try forcing the utility to ORDER BY the _inventory table by 'product_id'. I've chatted with HostGator's online support, and of course they say the problem is with CC, not HG.

"

[bsmither]

"I can't find them in the database!"

 

I was under the impression you were using a utility included in your HostGator account Control Panel (phpMyAdmin, perhaps?). By whatever means that utility has to sort by a specific column is what I am describing.

[Dirty Butter]

OK, I did that, and even visually looked at all 127 products in the database - the newest 3 just don't show there. It's been a long time before those that I added a product.

I can't find the new category when I search for the Category in phpmyadmin, either, but it shows on the front end.

[bsmither]

I'm looking at the Plush Catalog shop, and in Latest Products, I see the form elements (View Source in the browser -shortened) to "add-to-basket" the two top-most items:

<input name="add[3256][quantity]" value="1" />"Carters Halloween Orange Pumpkin Tan Velour Bear with Cap"

<input name="add[3255][quantity]" value="1" />"Carters Just One You Pink Brown Spot Dog Crib Pull Brahms"

 

So, try to have the phpMyAdmin filter the product_id column to show only the record where product_id = 3256 (and then 3255).

 

And, again, I don't mean to insult - but are you looking at the right database?

[Dirty Butter]

This issue is in the dirtybutterestates.com store - one I don't do much with - sorry I should have said - and no insult, as this is probably some dumb thing I'm doing,

The Mikasa product id is 130, and the phpmyadmin stops at 129, which is the template I made.

[bsmither]

The projector appears to be product_id = 132.

[Dirty Butter]

This is the link to the Mikasa product from the Product Summary page:

dirtybutterestates.com/admin.php?_g=products&node=index&sort%5Bupdated%5D=DESC&action=edit&product_id=130

[bsmither]

"127 products in the database"
 

Highest product_id is 132, so there are five deletions/voids. product_ids 128-132 must have filled those voids. The question is, is phpMyAdmin showing them?

[Dirty Butter]

no, it's not - that's my problem. I've tried using phpmyadmin to search for Mikasa, and since the list is small, I've tried actually skimming through the whole list. I did the same thing with Haiti, STP, and Kodascope for the other latest products, and I can't find them, either.

 

I would not have realized there was a problem, but I created a new Google Product Category code on products.index,php for the camera equipment I'll be listing - it shows in my list within Admin, but started checking when it would not stick when I saved the Google Product Category for the movie projector. When I started looking for the problem I realized these newer listings weren't showing in phpmyadmin at all. I say it has to be a HG problem, but they say not.

[bsmither]

"no, it's not"

 

Ok, interesting.

 

I also see that the projector has a seo_path. Look in the CC_seo_urls table, find "vintage-kodascope-eight-model-40-movie-projector", and verify the item_id is 132.

[Dirty Butter]

No, it doesn't find it.

[bsmither]

"I can't find the new category when I search for the Category in phpmyadmin, either, but it shows on the front end."

 

Do the newest products and category show in CubeCart's admin screens?

 

Please verify the dbhost and dbname as given in the /includes/global.inc.php file for that store with where you log in to on phpMyAdmin.

[Dirty Butter]

Everything shows correctly from Admin, except for the newly created google_products_category not saving my click on the button. I'll go check the dbhost and dbname info and be back.

[Dirty Butter]

The problem DOES have something to do with what the current database info is and what is in includes. I changed hosts some time ago. Because I hadn't made any changes to this site in so long the issue had not shown up until now. I'll see if I can figure this out for myself, hopefully. Thank you for suggesting I check that!!!

[Dirty Butter]

They have TWO copies of my database there - the old one I'm used to, and another one that matches the includes. The support person should have caught my mistake, as I gave them the old name's database I thought was it when I talked to them. You're a life saver (and hair saver in this case lol). Thank you for bearing with me - see, there's no such thing as asking the obvious with a newbie - and no matter how hard I try I'll always be a newbie.