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

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

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

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.