Oh, that's unfortunate. But probably just not possible so we'll have to live with those broken jump to original post links.Best example would be Mike's forum which contains imported posts. The quotes don't break, but obviously the jump to post function doesn't work due to differences in formatting.
http://www.casualplayers.org/forums...ual-card-hall-of-fame-committee-member.15960/
In the thread above, instead of "train said" it's "train;286934 said".
Since Mike and Kier keep numb about quote conversion, I am assuming it'll be an issue. Could you please share your script with us if the train goes south?I'm going to run into this issue myself when I import, so if there isn't an official fix by that time, I'll write a simple php script that will scrub the database and replace where necessary.
I absolutely will. I've been doing data migration stuff at my day job as well, so it's still pretty fresh.Since Mike and Kier keep numb about quote conversion, I am assuming it'll be an issue. Could you please share your script with us if the train goes south?
I think that's absolutely worth it. I could give two craps as to how long an import takes as long as my data is imported and referenced properly.It's not possible to change the IDs when importing, as they're simply not guaranteed to be known. (I suppose we could try, as the average case would be known.) It's not a matter of just modifying the quote format, but looking up every post ID and replacing it. This would have to be done via a second pass script, that would take a significant amount of time on a large board.
CREATE TABLE `xf_posts_map` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`old_post_id` int(11) DEFAULT NULL,
`xf_post_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Eh? I think you have misunderstood me.and there's no reason you guys can't pull it off as well, especially considering the schema is extremely similar (according to Kier).
mysql_insert_id()
Of course they are notI was wondering if the id's of threads and posts would remain the same after a migration?
Of course they are not
Hi Floris,
Wouldn't it be better if the were?
We use essential cookies to make this site work, and optional cookies to enhance your experience.