|
|
| Re: phpbb convert - not all messages are imported & the sorting is arbitrarily [message #28379 is a reply to message #28374] |
Thu, 20 October 2005 19:47   |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 20:53 |
flanders
Messages: 16
Registered: October 2005
Karma: 0
|
Junior Member |
|
|
| 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? 
| 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
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!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]