[Solved] Jan help, how to control the ID in J! backend?

[dax702]

All my entries were in some crazy order from the first time I imported them, so I exported them to CSV from PhpMyAdmin and re-ordered them the way I wanted. Everything imported correctly (note: if you have any double quotes "" in the CSV then it gives an error so I had to fix a few of those but then it worked) I then submitted a test entry to make sure everything was working. Well, the entry submitted fine but look at the screen shot I have attached - At the far right under the ID column, why is the ID for my entry 363 instead of 181 like I am expecting it to be?

EDIT: I just made the second guestbook and submitted a test entry and it has an ID of 364, this is so weird....

[Jan]

hi, the id is automatically created by sql, e.g. there were 362 entries (there could be deleted or edited) if the table is not removed, the counting of itemid is no reset ...

But what is the problem, try to add one message again and see if you get 364, then everything is allright

[dax702]

So are you saying that every piece of content related information in Joomla gets an ID number? And it just increments across various components? In other words:

Component A has items that number 1-22
Then component B has items 23-44 like that?

Which SQL table is it that stores this numbering process? I deleted everything from the phoca items table so it's not in there. It must be a core Joomla table that stores this info? There's not really a problem, I just did not like the big jump in numbers..

[Jan]

No...

If you have e.g. phocaguestbook table and there are e.g. 100 messages:

ID 1 - 100 and you e.g. delete last 50 messages... then you will see in your admin messages:

ID 1 - 50 ... if someone leave a message now, the id will be 101, so you will see:

ID 1 .... 48, 49, 50, 101 ...

The id is an unique value ...

Jan

[dax702]

Wow... ok, I will just live with it then

[Jan]