Follow SMF on Twitter.
Started by waremock, August 13, 2008, 05:36:01 AM
Quote from: ReVoKe on August 13, 2008, 10:09:46 PMi don't think its possible with out one taking over the other
Quote from: waremock on August 31, 2008, 05:25:41 PMThat's what I had to do, I also had to do a temp table for the topics which contained the topic id and the new auto increment field. Once I had that I ran a query to change the topic id to the new auto increment and then change it in the messages table using the new topic id.I also had to purge a few of the log tables, once I did this I recounted the statistics and ran the find errors query.This worked great and I was able to merge the boards.If anyone would like to write some type of merge program I could give you the queries I used to do the merge.I did have a few of the post end up with the wrong topics but I was able to fix this by splitting the post.It was a lot of work but I did not loose any of the topics.
Quote from: waremock on November 15, 2008, 02:28:11 PMI can show you how in a few days, all the information is in my work computer.How many posts, topics and boards do you have in each forum?
set @counter = 0;UPDATE `smf_messages` SET `id_msg` = (@counter := @counter + 1)
set @counter = 0;UPDATE `smf_topics_temp` SET `id_topic_new` = (@counter := @counter + 1)
set @counter = 0;UPDATE `smf_topics` SET `id_topic` = (@counter := @counter + 1)