adding a new category; which tables are affected?

  • Posts: 6
  • Thank you received: 0
10 years 7 months ago #174297

I ran into this issue when adding a new category:

When i use the joomla admin panel to add a new category, the new cat is listed for me to see.

however, when I add categories thru MySQL, I cannot view the new cats using the admin panel.

When adding a cat thru the admin panel, are other tables affected? eg. a row is inserted into another table to support the new cat. If this is the case, what are those tables?

If this isnt the problem, how can i view the cats added thru MySQL?

Thanks in advance for your help.

Please Log in or Create an account to join the conversation.

  • Posts: 26230
  • Thank you received: 4035
  • MODERATOR
10 years 7 months ago #174308

Hi,

If you want to add a category directly in the database, you have to be careful to not break the b-tree.
HikaShop categories are like the Joomla categories, they are more than an id, there is a complete tree structure that should be followed.
You can read more about Joomla categories or the b-tree algorithm on joomla website or wikipedia.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum