traylor23

Thank you, both, for the help. I really appreciate it!

Added the 3 lines to classes/catalogue.class.php, resaved all my categories, cleared cache, and it did not resolve the problem that I am having. The good news is that I do have a direct fix in just restoring 6.4.7, and it completely fixes the issue for me. Thanks for the timely response. Hoping that I can figure this out. I'm going to stop messing with it, for now, and see what other info can be gleaned from what I've shared. Ok...so, I just disabled the "Hide out of stock products," and it reverted back to working properly. So, this is the issue. It doesn't answer the database error that has popped up, which is still there, but it is a temporary fix for the links being broken. I usually delete all out of stock items promptly, so it's not too big of an issue, but would be nice to work properly.

Hello All, I have replicated this issue twice. The first time, I thought it was something I did, but now that I've gone through the upgrade process again, I can confirm that it was the upgrade process that broke something. Here is what is happening. When I click on my main categories, some of them are either broken links, or link to other categories. Even though the URLs are correct in Admin, and in the address bar, what is being returned is either a page not found, or a different page altogether. This is not throwing any errors in the error log, that I can see, but there is a database error, and it is as follows: ballcard_ccrt01.CubeCart_extension_info 10 InnoDB utf8_unicode_ci 32 kB - CubeCart_extension_info.seller_id has a key type KEY but expecting key. What could have caused this? How can it be fixed (short of reverting to 6.4.7)? Thank you all in advance. Matt Ballcardz.com (the problem can be experienced by clicking the first four links in Shop by Category, but is not exclusive to those links.

I’ll let you know how it goes on my end. So, yes, instead of empty, it was posting 0, making it impossible to add to cart. As you stated, I can manually type a 1 in that field, if I choose, but it’s just another step that interferes with a routine. I appreciate your help, as we all do!

Having an issue with this also, where the minimum_quantity column is not being autofilled at 1, but rather, is taking the 0 for being left blank. This is for all new items added to the store as of the last update. I have since gone back and edited phpmyadmin for those columns to behave correctly, but I'd rather it be automatic, rather than something I have to manually do!

Got it all fixed, including the highlighted database errors. Thanks to this forum, or I'd have to switch carts. Special thanks to @bsmither, @Dirty Butter and @havenswift-hosting. You folks are most helpful, and we're highly grateful for you!

Thank G-d!

Yep. Already thought of this. The backup for my hosting happened on 11/12, and there have been hundreds of categories and products added/removed since then, and no backup within cubecart. Oh well. Tedious lesson learned. I really appreciate your help, as always. After I get these cats reassigned, I will need to revisit this, as I'm having the same KEY/PRIMARY database errors that led me to this thread.

That is correct. What happened is, that I was trying to fix an error that was listed here, went to the Structured column under Cubecart_category, and hit DROP. It was a mistake. I didn't catch it before it was gone. And, now, it appears I'm going to have to manually reassign all of these categories. If there's another way, that'd be awesome! Reggie Jackson should be under the following Category Tree: All Baseball Cards --> Last Names - J --> Jackson, Reggie

Ballcardz.com

I have no clue what I'm doing. When I drop in the code into the SQL section of Cubecart, it tells me that 1 line was affected, but it makes no changes that I can see to the database table. This thing has literally unassociated every category from it's parent category. This happened under the structure tab in phpMyAdmin

I accidentally dropped the index CubeCart_category.cat_parent_id Of course I didn't back the db up before. Please help :-<

Hey There...for some reason, Cubecart's site won't let me message you. Is there a way to add a background image to the skin, and is there any way to have the products in list view by default? Thanks, Matt

I'm getting this same error, but it's saying from thumbs.db instead of the index.htm. Before I deleted the index.htm, it was giving me both errors.

That mod looks like it would do exactly what I want it to do. I'm still playing with Brian's edits in a cloned store. Not having any trouble, just haven't had time to mess with it. If that doesn't appear to be a solution, this might. Thanks for sharing! This worked perfectly, by the way. Thanks!

Great stuff, bsandall! Haven't tested it yet, but I'm sure it'll be fine. Still having a problem with my pictures auto-assigning to products after I did the 6.1.3 upgrade, but I'm sure that's something I didn't do right.

All cool stuff, and I really appreciate the help. Trying to implement Brian's Custom Search edits, but I have run into an annoyance, at least on the admin side of things, that's different since upgrading to v6.1.3. Basically, any category that I created, and used a custom seo url for, is now showing up in my add a product pages, where you would select a category, differently than they ever have before, making finding the categories difficult. Well, I was able to track this back to the database and see that all of these new cats were assigned a custom tag of 1, and when I made all of them 0 again, everything was back to normal. Every time I add a new category, I have to go clear this 1 designation for it to look correct and be in the right order. I have included a couple of pictures to demonstrate what I'm talking about. Does anyone know of a way I can stop the new categories from gaining this 1 designation? Also, if I forgo using the Custom URL and then update it later, the update causes the 1 to be designated. Thanks!

I would love for it to be both. What I'm saying is that ideally, I'd love for it to also be clickable, where all items for that team would aggregate, but that seems like some extreme coding.

Since I don't foresee this being a clickable, aggregate linking mechanism, I could just add the 2nd/3rd team to the same field, i.e. Chicago Cubs - Atlanta Braves

Ahh...good point. I'll edit there as well. I actually don't use UPC codes because baseball cards aren't sold individually at the retail store level. Of course I would, Brian! Just let me know!

It worked fine as far as that side of things. Here is a screenshot after I changed the definitions.xml to reflect the new term.

That's awesome! Thanks for testing it before I had the chance to! Maybe @bsmither can chime in for some ideas for that?

Yes....Does the "It works in my mind" reason become a sound theory? Kurouto and 6.1.12

Let's say, for arguments sake, that I just wanted to duplicate the Product Code field and then change the name of that; is that possible? Practical?