FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » phpbb convert - not all messages are imported & the sorting is arbitrarily
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
icon9.gif  phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28374] Thu, 20 October 2005 15:05 Go to next message
flanders is currently offline  flanders   Germany
Messages: 16
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hello,

thanks for the better forum as phpbb! Smile
but now i have a big problem. my old forum (phpbb) has actuall 22018 messages. when i run the importscript (phpBB2.php), it will convert the all 22018.
Finished Importing Users
Importing Categories 4
Finished Importing Categories
Importing Forums 14
Finished Importing Forums
Importing Moderators
Finished Importing Moderators
Importing Topics 945
Finished Importing Topics
Importing Messages 22018


ok, thats cool, BUT Smile in phpmyadmin i have in the table "fud26_msg " only 19.358 messages! after i do the "Forum Consistency" i will see all things of my old forum:) nice! but there where also only 19.358 messages. Where is the differece?! i need all messages...

and, the sorting is arbitrarily. the actuall messages are not on the top. there are mixed.

i hope you understand my very bad english. Thank you very much!
Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28379 is a reply to message #28374] Thu, 20 October 2005 15:47 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
There are 2 reasons why the counts may not match:

1) Whe the forum selects messages it does it by performing an INNER JOIN between the messages, message_body and topics table. Which means if there are orphaned records there are less entries.

You can check for this by executing the same query with count(*) and seeing how many rows are being returned.

2) The forum id of the message does not correspond to a know value, you add an error printing message for that by editing conversion script, in particular the:
<?php
if (!isset($forum_map[(int)$obj->forum_id])) {
                        continue;
                }
?>

code block.

Not sure about the other error, you'd need to show me (you did run the consistency checker, right?).


FUDforum Core Developer
Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28384 is a reply to message #28379] Thu, 20 October 2005 16:53 Go to previous messageGo to next message
flanders is currently offline  flanders   Germany
Messages: 16
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Thu, 20 October 2005 15:47


1) Whe the forum selects messages it does it by performing an INNER JOIN between the messages, message_body and topics table. Which means if there are orphaned records there are less entries.

You can check for this by executing the same query with count(*) and seeing how many rows are being returned.


ok i have do this. hier my modified query for control:
SELECT count( * )
FROM xxx.phpbb_posts p
INNER JOIN xxx.phpbb_posts_text pt ON p.post_id = pt.post_id
INNER JOIN xxx.phpbb_topics t ON t.topic_id = p.topic_id


the result is the same! 22020! ...





Ilia wrote on Thu, 20 October 2005 15:47


2) The forum id of the message does not correspond to a know value, you add an error printing message for that by editing conversion script, in particular the:
<?php
if (!isset($forum_map[(int)$obj->forum_id])) {
                        continue;
                }
?>

code block.

Not sure about the other error, you'd need to show me (you did run the consistency checker, right?).


ok, i hope i understand this right. i have modify the phpBB.php:
		if (!isset($forum_map[(int)$obj->forum_id])) {
			continue;
			echo "ERROR:PRINT";
		}


the "ERROR:PRINT" not comes! thats good, or? Confused





Ilia wrote on Thu, 20 October 2005 15:47


(you did run the consistency checker, right?).


yes. now i post you the result of the consistency check
Quote:


Disabling the forum for the duration of maintenance run
Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
Checking messages against users & threads
Checking threads against forums
Checking message approvals
Done: Checking message approvals
Checking threads against messages
OK
Checking thread last & first post ids
Done: Checking thread last & first post ids
Checking forum & topic relations
Done: Checking forum & topic relations
Validating Forum Order
Done: Validating Forum Order
Checking for presence of forum lock tables
Done: Checking for presence of forum lock tables
Checking thread_exchange
Checking read table against users & threads
Checking file attachments against messages
OK
Rebuild attachment cache for regular messages
Done: Rebuild attachment cache for regular messages
Rebuild attachment cache for private messages
Done: Rebuild attachment cache for private messages
Checking message reports
Checking polls against messages
Checking messages against polls
Checking polls options against polls
Checking polls votes
Rebuilding poll cache
Done: Rebuilding poll cache
Validating poll activation
Done: Validating poll activation
Checking smilies against disk files
OK
Checking disk files against smilies
OK
Rebuild Smiley Cache
Checking topic notification
Checking forum notification
Checking topic votes against topics
Rebuild topic rating cache
Done: Rebuild topic rating cache
Rebuilding user ranks, message counts & last post ids
Done: Rebuilding user levels, message counts & last post ids
Checking buddy list entries
Checking ignore list entries
Rebuilding buddy list cache
Done: Rebuilding buddy list cache
Rebuilding ignore list cache
Done: Rebuilding ignore list cache
Rebuilding ip filter cache
Done: Rebuilding ip filter cache
Rebuilding login filter cache
Done: Rebuilding login filter cache
Rebuilding email filter cache
Done: Rebuilding email filter cache
Rebuilding extension filter cache
Done: Rebuilding extension filter cache
Rebuilding custom tags for users
Done Rebuilding custom tags for users
Validating group resources
Done: Validating group resources
Validating group validity
Done: Validating group validity
Validating group members
Done: Validating group members
Validating group/forum relations
Done: Validating group/forum relations
Validating group/forum names
Done: Validating group/forum names (fixed: 3 relations)
Validating group/primary user relations
Done: Validating group/primary user relations
Rebuilding group leader cache
Done: Rebuilding group leader cache
Rebuilding group cache
Done: Rebuilding group cache
Validating User/Theme Relations
Done: Validating User/Theme Relations
Rebuilding Forum/Category order cache
Done: Rebuilding Forum/Category order cache
Remove absolete entries inside sessions table
Done: Removing absolete entries inside sessions table
Rebuilding Topic Views
Done: Rebuilding Topic Views
Unlocking database
Database unlocked
Cleaning forum's tmp directory
Done: Cleaning forum's tmp directory
Validate GLOBALS.php
Done: Validate GLOBALS.php
Re-enabling the forum.
DONE
It is recommended that you run SQL table optimizer after completing the consistency check. To do so click here, keep in mind that this process make take several minutes to perform.


now i have do the "SQL table optimizer after completing the consistency check." AND i have now more messages! 21463!

i am sure, that i missing some messages Confused


PS: now i understand the sorting... i dont like this sorting. you sort by creation of a thread... not form "last post". can i change the sorting? i don't find it in the adminarea

pps: thank you for the help!
Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28385 is a reply to message #28374] Thu, 20 October 2005 16:58 Go to previous messageGo to next message
flanders is currently offline  flanders   Germany
Messages: 16
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
SORTING: ok, when i create new posts then the sorting ist right. only the imported messages have a f*** sorting Evil or Very Mad
Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28387 is a reply to message #28385] Thu, 20 October 2005 17:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Consistency checker must run, otherwise various counts will be off, this is why the converter specifically directs you to run it...

Actually the messages ARE sorted by the date of last post, if that is not the case then I suspect there is a bug somewhere.

The sorting should've become fine AFTER the consistency checker had run.


FUDforum Core Developer

[Updated on: Thu, 20 October 2005 17:24]

Report message to a moderator

Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28388 is a reply to message #28387] Thu, 20 October 2005 17:49 Go to previous messageGo to next message
flanders is currently offline  flanders   Germany
Messages: 16
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
i had run the consistency checker! realy! the sorting do not care!

only new messages will be sorted. but the imported "old" messages are not sorted by "last post". only by "create date".
Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28389 is a reply to message #28388] Thu, 20 October 2005 18:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Can you give me access to the forum so I can see the problem?

FUDforum Core Developer
icon14.gif  Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28599 is a reply to message #28374] Tue, 01 November 2005 11:37 Go to previous message
flanders is currently offline  flanders   Germany
Messages: 16
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
IT WORKS! YEAH BABY! Smile

ok,

i have updated my phpbb 2.0.17 to 2.0.18 AND my FUD from 2.7.2 to 2.7.3 .

and now it imports all my messages and all things are wonderful!

ab big "thank you" to Ilia for the great help. Very Happy
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: phpbb2 conversion
Next Topic: vB 2.3.0
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 20 03:13:37 EDT 2017

Total time taken to generate the page: 0.00702 seconds