broken breadcrumb trail in Tell a Friend

[Guest]

I imported the database of my old store to the new one, and it caused a problem:

before the import, going to the Tell a Friend would make a breadcrumb trail like top >> catalog >> hardware >> keyboards >> whatever item

 

Now, on the other hand, I get something equivalent to

top >> catalog >> hardware >> >> whatever item

 

And yes, it shows 4 of the '>' things together.

 

Might this problem be caused by my product categories layout? not all products are in sub-sub categories. However, no matter where I take the product from, I get the same problem.

 

Help?

 

-Ethan

[Guest]

I found the problem, and I'd like your oppinion and help with a fix:

in application_top, on line ~492, there's a query for:

$model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

In no model is entered for a product, this is, of course, empty.

I'm considering replacing the query for one that will bring the product's name, but I have some doubts:

A product's name could be rather long, and may not look good in the breadcrumb. What do you think?

 

I'd need help re-writing the query so that it brings the name (from products_description), based on the currnet language.

 

what do you guys think on the matter?

 

-Ethan