Category name not populating in Product new/edit

Hi,

I have imported from VM and all is good and ready to go and I just noticed that the Category Name field is not populated in the Product new/edit page even though the Category ID # is there and correct. I need help with this.

Thanks for such a great product!
Helen

Hi,

Please turn on the debug mode and the error reporting option of the joomla configuration and try again. That might display some errors.

Do these categories have a name in the categories listing ?

All categories have a name for each id#.

In debug, Hikashop > Products fails to load with the following error:


500 - An error has occurred.

JDatabaseMySQLi::query: 1038 - Out of sort memory; increase server sort buffer size SQL=SELECT DISTINCT b.* FROM #__hikashop_category AS a LEFT JOIN #__hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id=2 ORDER BY b.category_left

You can fix that issue like that:
www.hikashop.com/en/forum/3-bug-report/7...n-breadcrumbphp.html

That does it. But one question. Can we have it not show the very beginning of the string? not show the words "product category/"

You can edit the file "category" of the view "product" for your back end template via the menu Display->Views and add the line:
array_shift($parents);
after the line:
$parents = $class->getParents($row->category_id);

I do not have a file "category" in the view "product" in the back end. So I located administrator > components > com_hikashop > views > product > tmpl > category.php and inserted it after line 41 but that did not change anything.

It's not possible that you don't have it. Please double check