Auto Increment in the table hikashop_category

  • Posts: 634
  • Thank you received: 16
7 years 11 months ago #258215

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.27
-- Browser(s) name and version -- : any

I want to modify the auto increment with this sequence after delete all custom categories in a built custom component:

$query = "ALTER TABLE #__hikashop_category AUTO_INCREMENT = 14";

But it seems it doesn't work properly.

It's the sentence fine?

Or I can't alter the auto increment in this table?

Thanks in advance.

-- Víctor

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 11 months ago #258218

Hi,

This looks fine to me. If that doesn't work, you have a category with an id higher than that or you've removed the auto increment from the table.

The following user(s) said Thank You: PeterChain

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

Time to create page: 0.052 seconds
Powered by Kunena Forum