nneonneo wrote:What posts are getting duplicated? If you visit the topics/posts in question, is there anything odd about them?
I don't know necessarily what you mean or consider odd? It's a normal topic...
Hopefully something here will give you some insight:
The members SQL. and categories SQL upload fine to my new forum database. When you try to upload the post SQL you get this error message which prevents it.
Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'.
Which is clearly a result of the posts for what ever reason being duplicated from the script. And I have double checked and made sure the setting you mentioned before were right.
Now if you load the new forum at this point. The members are all there. And the categories are all there. If you go into the categories you can see some topics. But here's something weird. One of the topics gets duplicated. Also the script failed to get the rest of the topics/posts past this point. It almost seems like it's getting stuck on one topic and repeating it over and over. It's a normal topic from what I can tell.
Now if you click into a topic there is nothing because the post SQL hasn't uploaded. If you go into the SQL files and delete the duplicate posts/topics, the file will upload and the posts and topics will display. But once again to clarify the script didn't completely rip the rest of the topics/posts. And trying to delete duplicates on a bigger forum strip isn't going to be easy or practical.
Now I watched in terminal with the script running and basically this is what I saw .
The topic id counts up and posts download at first.
So let's say this as a fake example (I know it's not exact to what's in terminal but I'm sure you'll get the picture):
T1: 2 post downloaded
T2: 3 post downloaded
T3: 8 posts.
Then when it reaches one of the topics Ids this happens
T15: 12 posts download
T16: 12 posts download
T17: 12 posts download
Etc. until the script reaches the end. So you can see for what ever reason it is just duplicating and getting stuck.
So hopefully this gives you or someone a better insight and can help. What ever info you need from me let me know. I would love to get over onto my own host.