Is it possible to reuse item numbers?

Omeka Classic Items and Collections
1

I did an import and ended up manually deleting all the items and now I have hundreds of unused numbers. Is it possible to reuse those as they don’t actually have an item attached to them?

Cheers
DC

2

Hi.

This thread, albeit for Omeka S, could give some hints: Reset Omeka S resource ID

3

I’m hoping there’s a way to do it without having to reset the database. I have a few thousand items that aren’t empty I don’t want to get rid of.

4

There is no safe way. It’s the nature of relational databases. Primary keys should not be reused.

At any rate, it’s purely cosmetic. Its ok and expected to have ID gaps.

5

If you still want to do something about it, you should first determine the highest ID used for a not-empty Item; then, you might use the following command in your database:

ALTER TABLE yourtablename AUTO_INCREMENT = newIDvalue

where newIDvalue is the value you’ve found before + 1

Remember that you might still have some gaps, though.

Hope this helps.

6

This topic was automatically closed 360 days after the last reply. New replies are no longer allowed.