[Skip to main content](#vessel-content) # category\_left, category\_right, category\_depth ## - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 2 weeks ago [\#70460](#70460) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") *[category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70460 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* was created by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 2 weeks ago [\#70605](#70605) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70605 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* Hi, Yes, that's possible: [ www.hikashop.com/en/forum/2-general-talk...port-sql-script.html](http://www.hikashop.com/en/forum/2-general-talk-about-hikashop/8527-import-sql-script.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 2 weeks ago [\#70706](#70706) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70706 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* Hello, and how can I the script execute? In joomla? On the shell? What is a simple way? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 2 weeks ago - 14 years 2 weeks ago [\#70708](#70708) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70708 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* You can add it in a view file via the menu Display->Views, display the page of that view and that will run the code. PS: do not post the same message on several threads. Last edit: 14 years 2 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). The following user(s) said Thank You: [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 2 weeks ago [\#70710](#70710) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70710 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* I don't understand, what a view for wich page is Another way? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 2 weeks ago [\#70712](#70712) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70712 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* You can use sourcerer to add that code anywhere on your website: [ extensions.joomla.org/extensions/core-en...code-in-content/5051](http://extensions.joomla.org/extensions/core-enhancements/coding-a-scripts-integration/custom-code-in-content/5051) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 2 weeks ago [\#70891](#70891) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70891 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* I started code It does'nt work. No errors One Idea? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 2 weeks ago [\#70896](#70896) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#70896 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* I've no idea. That code works fine. We use it in HikaShop to recalculate the category tree when you change the parent category of categories. You might want to try to do that instead with a fake category. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 1 week ago [\#71362](#71362) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#71362 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* Does'nt work I set my code as first - Echo "Anfang"; and last - Echo "Ende"; I see "Anfang" as output but not "Ende" I set Echo $database; after $database =& JFactory::getDBO(); but I see nothing. I think "& JFactory::getDBO()" does'nt work With fake categorie does'nt work too Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 1 week ago [\#71365](#71365) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#71365 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* It's normal that there is nothing in $database... It's a database object. There is nothing to display in it. if you don't see the "ende" text, it means that there is an error in the code you have. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 1 week ago [\#71376](#71376) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#71376 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* <?php echo "Anfang"; $database =& JFactory::getDBO(); $categoryClass = hikashop::get('class.category'); $query = 'SELECT category_left,category_right,category_depth,category_id,category_parent_id FROM '.hikashop::table('category').' ORDER BY category_left ASC'; $database->setQuery($query); $categories = $database->loadObjectList(); $root = null; $categoryClass->categories = array(); foreach($categories as $cat){ $categoryClass->categories[$cat->category_parent_id][]=$cat; echo $cat->categoriy_parent_id; if(empty($cat->category_parent_id)){ $root = $cat; } } $categoryClass->rebuildTree($root,0,1); echo "Erfolg!"; I copied code from internet Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 1 week ago [\#71532](#71532) 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\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#71532 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* That sounds fine. Do you have the category_parent_id properly set for each of your categories ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 14 years 1 week ago [\#71547](#71547) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[Re: category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#71547 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* Yes That does'nt work with one single category, that I in Hikashop Menu set Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")** - [![cobinet_edv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Topic Author - [ Offline](/forum/user/9990-cobinet-edv) Less More - Posts: 107 - Thank you received: 0 - - 13 years 9 months ago [\#86909](#86909) by [cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile") Replied by *[cobinet\_edv](/forum/user/9990-cobinet-edv "View cobinet_edv's Profile")* on topic *[category\_left, category\_right, category\_depth](/forum/4-how-to/70460-category-left-category-right-category-depth#86909 "Hello, I set data in the table cn_hikashop_category self. It works. But I set no data for fileds category_left, category_right, category_depth So I have no tree for categories left up. I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled. Is it possible? Thanks")* Ok I have it It is not fine solution, but it works I have inserted the code in category/lising.php It works Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzcwNDYwLWNhdGVnb3J5LWxlZnQtY2F0ZWdvcnktcmlnaHQtY2F0ZWdvcnktZGVwdGg/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.109 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)