Hi
I have accidentially changed ID number of K2 item (through the database table) to 10000000000000. Now all my new item gets the numbers after that. Is it possiblle to revert it? Changing the 10000000000000 and next to the previous ID (in database K2 item table) don't work. Still the 10000000000001 number is created.
Anybody can help? Where the last K2item ID is stored?
regards Tomek

Hi Tomek,

As far as I understand you would just need to edit any of the database tables that you changed.

It sounds like K2 auto-increments the id so you would need to go in and change the id manually. In Joomla 2.5 and Joomla 3 there is a relationship to the assets table as well so you may need to check a number of tables to fix this.

Hope that helps.

Anthony

Anthony Olsen wrote: Exactly!Anthony Olsen wrote: You are right. The point is that I cant identify the right tables in database but will try again.

Thank you very much Anthony for your precious time!
rgds Tomek

The k2 item can be found in #__k2_items

Change the id number back to what it should be and then you need to reset the autoindex

Go back to the main database overview of all the tables and click on sql in the top menu and use

Change the prefix to match your database and then change the value to be 1 higher than the id of the last article.

The assets table is a bit more difficult. You would need to search for the k2 item with your edited id value and set it back to what it should be.
Something like:

or you could try an extension like acl manager to try and fix the assets.

Best of luck.

Rob

Hi Rob
Wow, I managed it!
You are extremly nice and helpful. Thank you Rob and Anthony!
To be honest I had no hope that somebody will spare a time to help me - the problem was very specific ....
But JBteam rocks!!!!

regards Tomek

Great!

Glad you got it back to normal.

Rob