Page 1 of 1
Reset Category Id count in for Catalog
Posted: 15 Jan 2017, 04:35
by alex110504
Is there a way to reset count of category ID's in catalog? I had initial catalog tree with the root category starting with 1. I deleted the tree in expert admin panel and started creating a new one, however the category id's shifted. The root now starts with 15. Deleted all categories again, ran "index/rebuild" and "admin/cache" jobs, created new list of categories, but this did not help.
Running symfony "aimeos/aimeos-core": "~2016.10"
symfony 3.1.8
Re: Reset Category Id count in for Catalog
Posted: 15 Jan 2017, 14:50
by aimeos
The old data is still in the cache. You have to execute on the command line:
The
admin/cache job controller removes only
expired cache entries.
Re: Reset Category Id count in for Catalog
Posted: 15 Jan 2017, 15:11
by alex110504
Deleted entire category tree through admin back end, used the suggested command, refreshed the admin back end in browser, added new root node, id is incremented again. Starts with 17 now. I guess I'll live with it. Thanks!
Re: Reset Category Id count in for Catalog
Posted: 15 Jan 2017, 15:21
by aimeos
That's the best way. Otherwise, you would have to reset the MySQL autoinrement value for the mshop_catalog table.