Due to the new database structure of vBulletin 5 along with Channels and Nodes, the upgrade is actually doing a lot of importing from old tables into new tables. Since sites usually delete content, forums and so forth, there are usually gaps in the IDs of these items. During an Import these gaps are eliminated due to how MySQL and auto-numbering work.
Announcement
Collapse
No announcement yet.
Thread ID's changed, links to your site no longer work?
Collapse
X
-
Thread ID's changed, links to your site no longer work?
According to Wayne Luke:
Why are my forums, threads, blogs, social groups, etc... renumbered? Or why does everything have new IDS?
Due to the new database structure of vBulletin 5 along with Channels and Nodes, the upgrade is actually doing a lot of importing from old tables into new tables. Since sites usually delete content, forums and so forth, there are usually gaps in the IDs of these items. During an Import these gaps are eliminated due to how MySQL and auto-numbering work.Tags: None
-
Moving this here, as its feedback about the beta.
As far as I know this is correct. I know we're doing things to preserve redirects, I'm not sure how much of that is working at this time though.
-
If redirects are not perfect, there is zero chance of established forums to upgrade. I'm not losing all my links in google and backlinks. This sounds really scary.
Comment
-
Originally posted by Zachery View PostAs far as I know this is correct. I know we're doing things to preserve redirects, I'm not sure how much of that is working at this time though.
So I'm assuming internally posted thread links would also be affected? For example I post a link in this post to another thread on this forum.
Comment
-
Right now they are doing 302 (temporary redirects). I am sure the bug will be fixed and they will implement 301 redirects in later builds.Owner: Oracle Forums - General Discussion Forums.
Comment
-
Originally posted by Hemanth View PostIMO, they shouldn't use redirects at all. i.e. thread IDs and postids should be kept the same for upgrades.
Comment
-
Originally posted by Zachery View PostIts bad practice to force ids to be preserved when an import is done, which is really what a vB5 upgrade is.
It's a stupid move, one done by someone who had either little migration experience or perhaps someone very short on time. "IF" the ids were preserved, someone could have coded an addon to rewrite urls to the old showthread.php etc method. Now you have entirely closed the possibility.Owner: Oracle Forums - General Discussion Forums.
Comment
-
In impex, our design goals were never to force ids into the system, it was seen as bad practice, I suspect its the same thing here. I'm just talking from experience with working with developers as to why its bad. I'm sorry I don't have more information.
Comment
-
Originally posted by Zachery View PostIts bad practice to force ids to be preserved when an import is done, which is really what a vB5 upgrade is.Sphinx Search for vBulletin 4: https://marketplace.digitalpoint.com...tin-4.870/item
Someone send me a message on Twitter when this site is usable again. https://twitter.com/digitalpoint
Comment
-
Originally posted by digitalpoint View PostErrrr... for the most part I agree with things you say, but this is absolutely not correct.
If you can give me information as to why it shouldn't happen this way and we should preserve ids in some way, I can make an improvement request. I can't promise it will happen though.
Comment
-
All I know is in my test upgrade of my 4.2.0 form to VB5 I could still access all threads using their old URLs. If I couldn't I would have complained about it when I tried. I'm sure I've hard deleted threads and posts from my forum too so it's not like there were no skipped numbers.
Comment
-
Originally posted by Zachery View PostI am parroting things I've been told in the past, based on semi-reliable developer conversations.
If you can give me information as to why it shouldn't happen this way and we should preserve ids in some way, I can make an improvement request. I can't promise it will happen though.
This database map adds unnecessary DB queries (you have to look up the mapping before you can redirect).
Future upgrades/scalability... let's say vB6 does an upgrade by "importing" again... and again remapping keys... you need a table to store the oldest mapping as well as the new mapping, doubling the size of the mapping database and adding even more queries (first looking up the old map and then looking up the new map based on the first mapping lookup).
I'd certainly be interested to hear the benefits of remapping primary keys and why retaining primary keys is considered "bad practice".Sphinx Search for vBulletin 4: https://marketplace.digitalpoint.com...tin-4.870/item
Someone send me a message on Twitter when this site is usable again. https://twitter.com/digitalpoint
Comment
-
Okay,
So a quick run down, is that in order to transition the system into the new db schema the new key ids don't really match their old counter parts.
We had things like postid, threadid, blogid, groupid, socialgroupmesageid, pmid, forumid, etc. these can't be carried over 1:1 into the new schema because of the schema.
We keep these old ids mapped properly. So if someone comes in via showthread.php?t=X or p=Y or forumdispay.php?f=Z they get redirected to the proper item in the new system.
Am I making more sense now?
Comment
-
Originally posted by Zachery View PostWe keep these old ids mapped properly. So if someone comes in via showthread.php?t=X or p=Y or forumdispay.php?f=Z they get redirected to the proper item in the new system.
Am I making more sense now?
Comment
Related Topics
Collapse
-
by fenderbobI've seen this feature on other forums so I'm just wondering if there is anyway to do this with vBulletin 5.
If I was to post a link to one of my recent support questions, it would look like...-
Channel: Support Issues & Questions
Sun 8th May '16, 9:31pm -
-
by bulldog1205I'm changing from another forum software to vbulletin. My current forum uses /showthread.php?tid=X where X is the thread ID number. I was hoping that impex would also transfer over thread urls, but apparently...
-
Channel: vBulletin 5 Installs & Upgrades
Mon 15th Apr '13, 7:41pm -
-
by m-d-luffyWhat indexing links do not work and do not know why they appear
It only appears after the upgrade.
https://sa-ar.anime-toons.tv/?s=&f=25
https://sa-ar.anime-toons.tv/online
...-
Channel: Support Issues & Questions
Wed 12th Sep '18, 12:03am -
Comment