AbleCommerce Shopping Cart Software

Hello,
I'm having "weird" database probems on our GoDaddy hosted site. So I'm not sure if I really have a problem, or if I'm just not understanding something.

My breadcrumbs are blank on my category pages. They only show the "home" link.

Let us assume that my hiearchy is "root->MainCat1->Subcat1"

How does the control build a path?

In the CategoryBreadcrumb.ascx.cs file I see a call to CatalogDataSource.GetPath(...).

Which table(s) does it read to construct the path?

Thanks,
-tomas

OK. I found my problem.
We're using GoDaddy to host our staging server and are required to use the MS Database Publishing Wizard to upload our DB from dev to Staging.

When my ac_ParentsCategory table was uploaded, it exploded from 68 rows to 680 rows. My guess is that the publishing wizard did not drop/create/populate the ac_CategoryParents table properly.

I ended up having to write a script to clean and repopulate the ac_CategoryParents table.

This solved the breadcrumb problem.

But I have other DB errors popping up. I wonder how many of these are due to bad imports!

-tomas

dadkind wrote:Hello,
I'm having "weird" database probems on our GoDaddy hosted site. So I'm not sure if I really have a problem, or if I'm just not understanding something.

My breadcrumbs are blank on my category pages. They only show the "home" link.

Let us assume that my hiearchy is "root->MainCat1->Subcat1"

How does the control build a path?

In the CategoryBreadcrumb.ascx.cs file I see a call to CatalogDataSource.GetPath(...).

Which table(s) does it read to construct the path?

Thanks,
-tomas