I have this small Question, when table "forums"
e.g, mybb_forums -> fid -> auto increment..
than why in some forum, fid is 121, 91, 1, 4 , 7 and 137 like this.
I am pretty sure Admin has not deleted so much of forum which lies in between these numbers...
as per auto increment -> it should has to be -> 1, 2, 3,.... etc.,
rectify me , if I am wrong.
Thanks
Well seeing as it's an auto increment value, either that have just gone through that many forums, or they've edited the auto increment value, which is pretty unlikely.
Well, what If I say they have not gone through that much forums, as i have wriitten above too, they have not deleted this much of forum.
and editing the auto increment value is unlikely as you told, i agree too.
Moreover, I have asked admin too, and he has done nothing as you said...
neither deleted so much of forum, nor edited the auto increment value..
Forums aren't sorted by fid, but by disporder, which is configureable in the Admin CP, so you can change the order forums appear in any time. As a result the order of fid and the fid itself will be more or less random, depending on when you create which forum and how many forums you deleted in between.
mybb.com forum order is: 1, 119, 124, 127, 129, 126, 81, 87, 121, 141, 142, 147, 148, 8, 73, 102, 72, 68, 65, 103, 104, 10, 105, 149, 132, 117, 21, 22, 24, 38, 146, 19, 7, 34, 137, 136, 12, 11, 133, 13, 106, 143, 74, 97, 138, 2, 3, 17, 91, 111, 95
and not 1, 2, 3, 7, 8, 10, 11, 12, 13, 17, 19, 21, 22, 24, 34, ...
The fid number is completely irrelevant, just ignore it.
I thought he meant that the admin hadn't made 137 forums for it to even get to that ID, not just the order they're in. But if it's just about the order then yeah, that's configurable.
(2011-03-09, 11:19 PM)frostschutz Wrote: [ -> ]Forums aren't sorted by fid, but by disporder, which is configureable in the Admin CP, so you can change the order forums appear in any time. As a result the order of fid and the fid itself will be more or less random, depending on when you create which forum and how many forums you deleted in between.
mybb.com forum order is: 1, 119, 124, 127, 129, 126, 81, 87, 121, 141, 142, 147, 148, 8, 73, 102, 72, 68, 65, 103, 104, 10, 105, 149, 132, 117, 21, 22, 24, 38, 146, 19, 7, 34, 137, 136, 12, 11, 133, 13, 106, 143, 74, 97, 138, 2, 3, 17, 91, 111, 95
and not 1, 2, 3, 7, 8, 10, 11, 12, 13, 17, 19, 21, 22, 24, 34, ...
The fid number is completely irrelevant, just ignore it.
I know this, but I am not talking about how forums is arranged or ordered, When you hover your mouse to forum, there is fid=131 and when you check how the table mybb_forums is created than you will find
'fid' smallint(5) unsigned not null auto_increment,
which means when forum is created in Admin CP it should have fid=1 , fid=2, fid=3, .... and should not create forum as fid=1, fid=12, fid=97, fid=129... etc., hope this was clear
(2011-03-09, 11:23 PM)MattRogowski Wrote: [ -> ]I thought he meant that the admin hadn't made 137 forums for it to even get to that ID, not just the order they're in. But if it's just about the order then yeah, that's configurable.
no its not about order, its about fid number that is alloted when it is created.
Thanks
Quote:which means when forum is created in Admin CP it should have fid=1 , fid=2, fid=3, .... and should not create forum as fid=1, fid=12, fid=97, fid=129... etc., hope this was clear
It doesn't do that. What makes you think it does?
(2011-03-09, 11:49 PM)labrocca Wrote: [ -> ]Quote:which means when forum is created in Admin CP it should have fid=1 , fid=2, fid=3, .... and should not create forum as fid=1, fid=12, fid=97, fid=129... etc., hope this was clear
It doesn't do that. What makes you think it does?
'fid' smallint(5) unsigned not null auto_increment,
as there is not any option to assign value in AdminCP.. for fid...
which means it should take value by default in chronological order ....if not assigned any..
rectify me If i am wrong...
Thanks
Quote:which means it should take value by default in chronological order ....if not assigned any.
And that is what it does. The action of create forum will auto increment the fid. Again..what makes you think it doesn't do that.
(2011-03-10, 12:31 AM)labrocca Wrote: [ -> ]Quote:which means it should take value by default in chronological order ....if not assigned any.
And that is what it does. The action of create forum will auto increment the fid. Again..what makes you think it doesn't do that.
I mean the same but in my localhost -> fid shown when hovering the mouse is fid=1, fid=113, fid=112 instead of fid=1, fid=2, fid=3
and i have just deleted 2-3 forum,
not only in my localhost.
Lets talk about your forum which is in your sig - "supportforums.net", when i was checking fid they are :-
fid=2, fid=3, fid=13, fid=23, fid=50, fid=47, fid=59, fid=75.... and more..
so have you really deleted the forum which lies in between missing numbers..
Thanks