[Skip to main content](#vessel-content) # Category name not populating in Product new/edit ## - **[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")** - [![helenbn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6015.jpg)](/forum/user/6015-helenbn "View helenbn's Profile") Topic Author - [ Offline](/forum/user/6015-helenbn) Less More - Posts: 33 - Thank you received: 0 - - - [](http://prettygooddesigns.com) - 14 years 2 weeks ago [\#71929](#71929) by [helenbn](/forum/user/6015-helenbn "View helenbn's Profile") *[Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#71929 "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")* was created by *[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")* 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 [ ![hika_category_name.png](/forum/attachment/6449) ](/forum/attachment/6449 "...egory_name.png") --- Pretty Good Designs \| [ prettygooddesigns.com](http://prettygooddesigns.com) \| Hey, that's pretty good! - [ ![hika_category_name.png](/forum/attachment/6449) ](/forum/attachment/6449 "...egory_name.png") [ ](/forum/attachment/6449?download=1 "...egory_name.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 weeks ago [\#71975](#71975) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#71975 "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 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")** - [![helenbn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6015.jpg)](/forum/user/6015-helenbn "View helenbn's Profile") Topic Author - [ Offline](/forum/user/6015-helenbn) Less More - Posts: 33 - Thank you received: 0 - - - [](http://prettygooddesigns.com) - 14 years 2 weeks ago [\#72071](#72071) by [helenbn](/forum/user/6015-helenbn "View helenbn's Profile") Replied by *[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72071 "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 --- Pretty Good Designs \| [ prettygooddesigns.com](http://prettygooddesigns.com) \| Hey, that's pretty good! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 weeks ago [\#72312](#72312) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72312 "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")* You can fix that issue like that: [ www.hikashop.com/en/forum/3-bug-report/7...n-breadcrumbphp.html](http://www.hikashop.com/en/forum/3-bug-report/70854-bug-in-hikashop-16-in-breadcrumbphp.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")** - [![helenbn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6015.jpg)](/forum/user/6015-helenbn "View helenbn's Profile") Topic Author - [ Offline](/forum/user/6015-helenbn) Less More - Posts: 33 - Thank you received: 0 - - - [](http://prettygooddesigns.com) - 14 years 2 weeks ago - 14 years 2 weeks ago [\#72319](#72319) by [helenbn](/forum/user/6015-helenbn "View helenbn's Profile") Replied by *[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72319 "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")* That does it. But one question. Can we have it not show the very beginning of the string? not show the words "product category/" [ ![hika_category_name_almost.png](/forum/attachment/6482) ](/forum/attachment/6482 "...ame_almost.png") --- Pretty Good Designs \| [ prettygooddesigns.com](http://prettygooddesigns.com) \| Hey, that's pretty good! - [ ![hika_category_name_almost.png](/forum/attachment/6482) ](/forum/attachment/6482 "...ame_almost.png") [ ](/forum/attachment/6482?download=1 "...ame_almost.png") Last edit: 14 years 2 weeks ago by [helenbn](/forum/user/6015-helenbn "View helenbn's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 weeks ago [\#72493](#72493) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72493 "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")* 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); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")** - [![helenbn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6015.jpg)](/forum/user/6015-helenbn "View helenbn's Profile") Topic Author - [ Offline](/forum/user/6015-helenbn) Less More - Posts: 33 - Thank you received: 0 - - - [](http://prettygooddesigns.com) - 14 years 2 weeks ago [\#72529](#72529) by [helenbn](/forum/user/6015-helenbn "View helenbn's Profile") Replied by *[helenbn](/forum/user/6015-helenbn "View helenbn's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72529 "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")* 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. --- Pretty Good Designs \| [ prettygooddesigns.com](http://prettygooddesigns.com) \| Hey, that's pretty good! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 weeks ago [\#72816](#72816) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Category name not populating in Product new/edit](/forum/3-bug-report/71929-category-name-not-populating-in-product-new-edit#72816 "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")* It's not possible that you don't have it. Please double check Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MTkyOS1jYXRlZ29yeS1uYW1lLW5vdC1wb3B1bGF0aW5nLWluLXByb2R1Y3QtbmV3LWVkaXQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.062 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)