It looks very well now except that there are missing topics. It seems that the newer ones are the ones that are missing? They show up in the latest post part on the right hand side, but when I go into the section, they're not there??? Anyone know how to fix that
I've also been messing around, and it seems that when I create a new topic, it points to the one that would be in it's place...so to me that would say that the topics are there, just no link pointing to them on the forum listing.
please help me :)
Have you tried 'Find and repair any errors' in Admin mode | Forum Maintenance?
If that doesn't help:
1) Was your phpBB2 forum in use when you did the conversion and if so were the missing topics created when the conversion was part way through?
2) Is there anything unusual about the topics that are missing?
I did that now, and it seems to have fixed when I click on the last reply,but if I go into, say my general forum, there's stilla bunch missing.
1.The forums were not being used at the time of conversion either.
2.the only thing unusual about the topics that are missing I guess would be that if I create a new topic it has the title I choose for it, but it links to the old topic I created.
thanks for the help though :)
Are the missing posts/topics...
- All posts after a specific date/time
- Limited to one board (or a small number of all your boards)
- Randomly spread across many boards
- All posts by one user (or a small number of users)
Also roughly how many posts/topics are missing?
it seems that all the posts after october 20th 2004 are gone.
it's spread accross all boards, and by different users. (I guess it's a good thing my boards are very popular :P )
Interesting. Would you be willing to convert a few more times, I assume?
I suspect this may be caused by some error in the conversion process for the posts table... if one failed in a batch, the whole batch would probably fail.
Can you try the attached?
-[Unknown]
I did it, I got this message:
QuoteConverting groups... successful.
Converting members...
Warning: copy(/home/ph4rt/public_html/hellfire/phpBB2/images/avatars/8384523424101d85d15fba.jpg): failed to open stream: No such file or directory in /home/ph4rt/public_html/hellfire/smf/phpbb2_to_smf.php on line 509
successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... Duplicate entry '126' for key 1
and it never went to the next step (like the smilies, or the attachments).
I checked it out...and in my admin section it says that there's 66 posts and 9 topics, but I click into the board and it shows it's empty???
I did a check in the forum repair part and got this:
QuoteThe following errors are fouling up your forum (blank if none):
Message 654 has a non-existent topic ID: 127
Message 655 has a non-existent topic ID: 127
Message 656 has a non-existent topic ID: 127
Message 657 has a non-existent topic ID: 127
Message 658 has a non-existent topic ID: 127
Message 659 has a non-existent topic ID: 127
Message 660 has a non-existent topic ID: 127
Message 668 has a non-existent topic ID: 127
Message 670 has a non-existent topic ID: 127
Message 671 has a non-existent topic ID: 127
Message 673 has a non-existent topic ID: 127
Message 676 has a non-existent topic ID: 127
Message 679 has a non-existent topic ID: 127
Message 681 has a non-existent topic ID: 127
Message 682 has a non-existent topic ID: 127
Message 710 has a non-existent topic ID: 127
Message 712 has a non-existent topic ID: 127
Message 714 has a non-existent topic ID: 127
Message 730 has a non-existent topic ID: 127
Message 732 has a non-existent topic ID: 127
Message 733 has a non-existent topic ID: 127
Message 736 has a non-existent topic ID: 127
Message 737 has a non-existent topic ID: 127
Message 739 has a non-existent topic ID: 127
Message 841 has a non-existent topic ID: 127
Message 678 has a non-existent topic ID: 128
Message 684 has a non-existent topic ID: 128
Message 842 has a non-existent topic ID: 128
Message 685 has a non-existent topic ID: 129
Message 686 has a non-existent topic ID: 129
Message 690 has a non-existent topic ID: 130
Message 691 has a non-existent topic ID: 130
Message 692 has a non-existent topic ID: 130
Message 693 has a non-existent topic ID: 130
Message 694 has a non-existent topic ID: 130
Message 695 has a non-existent topic ID: 130
Message 718 has a non-existent topic ID: 130
Message 719 has a non-existent topic ID: 130
Message 721 has a non-existent topic ID: 130
Message 722 has a non-existent topic ID: 130
Message 723 has a non-existent topic ID: 130
Message 724 has a non-existent topic ID: 130
Message 700 has a non-existent topic ID: 131
Message 702 has a non-existent topic ID: 132
Message 703 has a non-existent topic ID: 132
Message 704 has a non-existent topic ID: 132
Message 705 has a non-existent topic ID: 132
Message 706 has a non-existent topic ID: 132
Message 707 has a non-existent topic ID: 132
Message 708 has a non-existent topic ID: 133
Message 709 has a non-existent topic ID: 133
Message 711 has a non-existent topic ID: 133
Message 713 has a non-existent topic ID: 133
Message 715 has a non-existent topic ID: 133
Message 716 has a non-existent topic ID: 133
Message 717 has a non-existent topic ID: 133
Message 720 has a non-existent topic ID: 133
Message 728 has a non-existent topic ID: 134
Message 729 has a non-existent topic ID: 134
Message 731 has a non-existent topic ID: 135
Message 740 has a non-existent topic ID: 136
Message 741 has a non-existent topic ID: 136
Message 742 has a non-existent topic ID: 136
Message 744 has a non-existent topic ID: 136
Message 743 has a non-existent topic ID: 137
Message 745 has a non-existent topic ID: 138
Message 746 has a non-existent topic ID: 139
Message 747 has a non-existent topic ID: 140
Message 748 has a non-existent topic ID: 141
Message 749 has a non-existent topic ID: 141
Message 750 has a non-existent topic ID: 141
Message 751 has a non-existent topic ID: 141
Message 752 has a non-existent topic ID: 141
Message 753 has a non-existent topic ID: 142
Message 754 has a non-existent topic ID: 142
Message 755 has a non-existent topic ID: 142
Message 756 has a non-existent topic ID: 142
Message 757 has a non-existent topic ID: 142
Message 758 has a non-existent topic ID: 142
Message 759 has a non-existent topic ID: 143
Message 760 has a non-existent topic ID: 143
Message 761 has a non-existent topic ID: 143
Message 762 has a non-existent topic ID: 143
Message 764 has a non-existent topic ID: 143
Message 765 has a non-existent topic ID: 143
Message 767 has a non-existent topic ID: 144
Message 768 has a non-existent topic ID: 144
Message 770 has a non-existent topic ID: 144
Message 771 has a non-existent topic ID: 144
Message 775 has a non-existent topic ID: 144
Message 776 has a non-existent topic ID: 144
Message 777 has a non-existent topic ID: 144
Message 778 has a non-existent topic ID: 144
Message 779 has a non-existent topic ID: 144
Message 780 has a non-existent topic ID: 144
Message 781 has a non-existent topic ID: 144
Message 782 has a non-existent topic ID: 144
Message 783 has a non-existent topic ID: 144
Message 784 has a non-existent topic ID: 144
Message 786 has a non-existent topic ID: 144
Message 787 has a non-existent topic ID: 144
Message 788 has a non-existent topic ID: 144
Message 796 has a non-existent topic ID: 144
Message 797 has a non-existent topic ID: 144
Message 798 has a non-existent topic ID: 144
Message 799 has a non-existent topic ID: 144
Message 800 has a non-existent topic ID: 144
Message 801 has a non-existent topic ID: 144
Message 802 has a non-existent topic ID: 144
Message 803 has a non-existent topic ID: 144
Message 804 has a non-existent topic ID: 144
Message 805 has a non-existent topic ID: 144
Message 806 has a non-existent topic ID: 144
Message 807 has a non-existent topic ID: 144
Message 808 has a non-existent topic ID: 144
Message 809 has a non-existent topic ID: 144
Message 810 has a non-existent topic ID: 144
Message 811 has a non-existent topic ID: 144
Message 812 has a non-existent topic ID: 144
Message 813 has a non-existent topic ID: 144
Message 816 has a non-existent topic ID: 144
Message 817 has a non-existent topic ID: 144
Message 818 has a non-existent topic ID: 144
Message 819 has a non-existent topic ID: 144
Message 824 has a non-existent topic ID: 144
Message 828 has a non-existent topic ID: 144
Message 829 has a non-existent topic ID: 144
Message 790 has a non-existent topic ID: 145
Message 791 has a non-existent topic ID: 145
Message 793 has a non-existent topic ID: 145
Message 814 has a non-existent topic ID: 146
Message 815 has a non-existent topic ID: 146
Message 820 has a non-existent topic ID: 147
Message 821 has a non-existent topic ID: 147
Message 822 has a non-existent topic ID: 148
Message 823 has a non-existent topic ID: 148
Message 825 has a non-existent topic ID: 148
Message 826 has a non-existent topic ID: 148
Message 827 has a non-existent topic ID: 148
Message 830 has a non-existent topic ID: 149
Message 831 has a non-existent topic ID: 150
Message 832 has a non-existent topic ID: 150
Message 833 has a non-existent topic ID: 151
Message 834 has a non-existent topic ID: 151
Message 835 has a non-existent topic ID: 151
Message 836 has a non-existent topic ID: 151
Message 837 has a non-existent topic ID: 152
Message 838 has a non-existent topic ID: 152
Message 839 has a non-existent topic ID: 152
Message 840 has a non-existent topic ID: 152
I clicked yes and checked...the boards are still messed up.
Sorry for the long post, i just wanted to give you all the info.
thanks for your help too :)
Quote from: evilsmiley on January 10, 2005, 12:19:30 PM
QuoteConverting topics... Duplicate entry '126' for key 1
Interesting. It's trying to convert 126 twice... this means a problem in your phpBB database. Do you know how to use phpMyAdmin? What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
-[Unknown]
yeah, I know a little bit about it, what all do I need to do with it?
Alright, first, we need to look at the phpBB tables to see if there's anything wrong with the topics table:
SELECT *
FROM phpbb_topics
WHERE topic_id = 126;
Do you get more than one topic?
Second question: was your forum in use while you did the conversion? This could cause problems, if it was.
-[Unknown]
I checked it out, I only have 1 topic_id under phpbb_topics , it doesn't say anything about 126 though.
I did a SQL query and it came back this:
QuoteSQL-query:
`topic_id` SELECT *
FROM `phpbb_topics`
WHERE 1
LIMIT 0 , 30
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'topic_id`SELECT * FROM `phpbb_topics` WHERE 1 LIMIT 0, 30' at l
furthermore, when I go into phpMyAdmin and click on my forum database, then click on phpbb_topics I get a table that shows me the following:
Quotetopic_id mediumint(8) UNSIGNED No auto_increment
then allows me to change ,delete, primary, index, or unique.
then there's other listings below it, like forum_id, topic_title and so on.
and to answer your other question, NO it was not in use (there were no users on the boards at the time).
**EDIT**
I did some more looking around and exported the phpbb_topics table and looked at it, what I found was this line:
QuoteINSERT INTO `phpbb_topics` VALUES (126, 8, 'FAF-FAS', 12, 1097634410, 36, 5, 0, 1, 0, 643, 666, 0, 1);
that is the only line with 126 in it too. don't know if that helps but I thought I'd give it to you just in case :)
In that case, I can only assume that someone posted something on your forum at the same time you were converting.
Can you try again, possibly during a slow time?
-[Unknown]
nope still no go. And no one has posted since yesterday :) (I have a really small forum)
I actually had the same thing happening to me last night. I converted from phpbb2 to SMF and it all looked fine, until I checked the postcount. It was reduced from over 18000 posts to a little over 8800 posts. On the main page it said 9 topics were created in a certain category, and then when I clicked on that category, no posts were there, no topics either.
It also didn't mention "last posted by". I'm not sure if I did anything wrong, but I do know no one was posting on my phpbb2 forum. It doesn't really matter, and I took it all off again, but i thought I'd mention that on here though.
Darn, why haven't people reported these things before?
Could either of you send me a database dump, or even better yet give me access to your test covnersion installation so I can test it and try to tweak the converter on site?
Thanks,
-[Unknown]