Problems viewing some forum posts. Please help....

We think it's definately something to do with the message rather than any subsequent comments, but when doing a before and after comparison, the record dosn't seem to have changed.

Any ideas on what we could try to identify the problem?

The SadGeezers Guide to Cult Sci Fi
http://www.sadgeezer.com
SadCAST - The Sci Fi Video Podcast
http://sadgeezer.libsyn.com/

This is the code that was used to import the data from a pnphpbb BS to the Drupal Forums.

As I said above - EVERYTHING has worked very well except for a few missing posts (which are in the database (on Drupal) but missing from the diplayed forum message listings).

Any help with what could have gone wrong would be much appreciated.

# start pnPhpBB stuff
# Written by Feodor (feodor [at] mundo.ru)
#
# Modified for drupal 4.5.2 and phpbb 2.0.11-2.0.13
# by Alexander Mikhailian 
# modified for postnuke pnphpbb conversion by Keizo

# screwed up for drupal 5 by me (actually my wife NewKate)

# Drupal variables for node counts
#
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);

SELECT @forum_title:='Forums';
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';

#
# Create a vocabulary (called "Forum")
#
DELETE FROM vocabulary WHERE module='forum';
INSERT INTO vocabulary (vid,name,description,help,relations,hierarchy,multiple,required,module,weight)
  SELECT @vocabulary_vid+1,@forum_title,'','','0','1','0','1','forum','0';

#
# Set up the vocabulary "Forum" as the forum vocabulary
#
DELETE FROM variable WHERE name = 'forum_nav_vocabulary';
INSERT INTO variable (name, value) VALUES ('forum_nav_vocabulary', CONCAT('i:',@vocabulary_vid+1,';'));

#
# The default comment order in phpbb2 is "oldest first"
#
DELETE FROM variable WHERE name = 'comment_default_order';
INSERT INTO variable (name, value) VALUES ('comment_default_order', 's:1:\"2\";');

#
# Import categories from nuke_phpbb_categories as terms
#
INSERT INTO term_data (tid,vid,name,weight)
  SELECT @term_data_tid+cat_id,@vocabulary_vid+1,cat_title,cat_order
  FROM phpbb_categories;
  
#
# Import terms from nuke_phpbb_forums
#  
INSERT INTO term_data (tid,vid,name,description,weight)
  SELECT @term_data_tid+@phpbb_cat+forum_id,@vocabulary_vid+1, forum_name,forum_desc,forum_order
  FROM phpbb_forums;

ALTER TABLE term_data ORDER BY tid;

#
# Import forum hierarchy 
# Drupal allows topics to be created at this level while phpbb2 does not. If you want to disallow topics below
# categories, mark them as containers in the forum configuration dialog
#


# BROKE HERE!!!!???

#this block to rem later
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);


INSERT INTO term_hierarchy (tid,parent)
  SELECT @term_data_tid+cat_id,'0'
  FROM phpbb_categories;

INSERT INTO term_hierarchy (tid,parent)
  SELECT @term_data_tid+@phpbb_cat+forum_id, @term_data_tid+cat_id
  FROM phpbb_forums;
  
ALTER TABLE term_hierarchy ORDER BY tid;

#
# Create temporary tables for sorting topics and comments.
#

DROP TABLE IF EXISTS temp_posts;
CREATE TABLE temp_posts (
   post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   poster_id mediumint(8) DEFAULT '0' NOT NULL,
   post_time int(11) DEFAULT '0' NOT NULL,
   post_edit_time int(11),
   post_subject blob,
   post_text text,
   PRIMARY KEY (post_id),
   KEY forum_id (forum_id),
   KEY topic_id (topic_id),
   KEY poster_id (poster_id),
   KEY post_time (post_time)
);
DROP TABLE IF EXISTS temp_node;
CREATE TABLE temp_node (
   post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   PRIMARY KEY (post_id),
   KEY topic_id (topic_id)
);
   
#
# Copy into temporary table topics without comments
#
INSERT INTO temp_node (post_id,topic_id)
  SELECT MIN(post_id), topic_id
  FROM phpbb_posts
  GROUP BY topic_id;
INSERT INTO temp_posts (post_id, topic_id,forum_id,poster_id, post_time,post_edit_time,post_subject,post_text)
  SELECT c.post_id, c.topic_id, a.forum_id, IF(a.poster_id='-1','0',a.poster_id), a.post_time, a.post_edit_time, 
  REPLACE(b.post_subject, CONCAT(':',b.bbcode_uid),''), REPLACE(b.post_text, CONCAT(':',b.bbcode_uid),'')
  FROM phpbb_posts AS a, phpbb_posts_text AS b, temp_node AS c
  WHERE c.post_id=a.post_id AND c.post_id=b.post_id;

#
# Insert nid and tid from temp_posts into term_node
#
#this block to rem later
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);

INSERT INTO term_node (nid,tid)
  SELECT @node_nid+topic_id,@term_data_tid+@phpbb_cat+forum_id
  FROM temp_posts;

ALTER TABLE term_node ORDER BY nid;

#
# Insert forum topics from temp_posts into node
#

#this block to rem later
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);

#INSERT INTO node (nid,type,title,uid,created,comment,body,changed)
  #SELECT @node_nid+topic_id,'forum',post_subject,poster_id,post_time,'2',post_text,
  #IF(post_edit_time<>'NULL',post_edit_time,post_time)
  #FROM temp_posts;


SET @default_story_format = 3; 
INSERT INTO node_revisions (nid, title, uid, timestamp, body, format)
 SELECT @node_nid+topic_id,post_subject,poster_id,post_time,post_text,
 @default_story_format
  FROM temp_posts;


INSERT INTO node (nid, type, title, uid, created, comment, changed, vid)
SELECT @node_nid+topic_id,
'forum',
post_subject,
poster_id,
post_time,
'2',
IF(post_edit_time<>'NULL',post_edit_time,post_time),
node_revisions.vid
FROM temp_posts
Inner Join node_revisions on @node_nid+topic_id=node_revisions.nid;


ALTER TABLE node ORDER BY nid;

#
# Insert nid into forum 
#


#this block to rem later
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);

DELETE FROM forum;
INSERT INTO forum (nid,vid,tid)
  SELECT @node_nid+topic_id, vid, @term_data_tid+@phpbb_cat+forum_id
  FROM temp_posts
Inner Join node_revisions on @node_nid+topic_id=node_revisions.nid;
#
# Insert comments into comments for topics from temp_posts
#
INSERT INTO comments (nid,uid,subject,comment,hostname,timestamp,users)
  SELECT @node_nid+a.topic_id,
  CASE WHEN a.poster_id='-1' THEN '0' ELSE a.poster_id END,
  REPLACE(c.post_subject, CONCAT(':',c.bbcode_uid),''),
  REPLACE(c.post_text, CONCAT(':',c.bbcode_uid),''),
  CONCAT_WS('.',CONV(SUBSTRING(a.poster_ip,1,2),16,10),
    CONV(SUBSTRING(a.poster_ip,3,2),16,10),
    CONV(SUBSTRING(a.poster_ip,5,2),16,10),
    CONV(SUBSTRING(a.poster_ip,7,2),16,10)),
  a.post_time,'a:1:{i:0;i:0;}'
  FROM phpbb_posts AS a LEFT JOIN temp_posts AS b ON a.post_id=b.post_id,phpbb_posts_text AS c
  WHERE b.post_id IS NULL AND a.post_id=c.post_id;
ALTER TABLE comments ORDER BY cid;

UPDATE comments,node
  SET comments.subject=IF(comments.subject='',
    CONCAT('Re:',node.title),comments.subject)
  WHERE comments.nid=node.nid;
  
#
# Update thread in comments
#
#this block to rem later
SELECT @phpbb_terms:=MAX(forum_id) FROM phpbb_forums;
SELECT @phpbb_cat:=MAX(cat_id) FROM phpbb_categories;
SELECT @term_data_tid:=id FROM sequences WHERE name = 'term_data_tid';
  SELECT IF( @term_data_tid>0,  @term_data_tid, @term_data_tid:=0);
SELECT @comments_cid:=id FROM sequences WHERE name = 'comments_cid';
  SELECT IF( @comments_cid>0,  @comments_cid, @comments_cid:=0);
SELECT @vocabulary_vid:=id FROM sequences WHERE name = 'vocabulary_vid';
  SELECT IF( @vocabulary_vid>0,  @vocabulary_vid, @vocabulary_vid:=0);
SELECT @node_nid:=id FROM sequences WHERE name = 'node_nid';
  SELECT IF( @node_nid>0,  @node_nid, @node_nid:=0);
DROP TABLE IF EXISTS comments_tmp;
CREATE TABLE comments_tmp (
   cid int(10) NOT NULL default '0',
    nid int(10) NOT NULL default '0',
    thread int(10) NOT NULL  auto_increment,
    PRIMARY KEY  (nid,thread)
    );
    
INSERT INTO comments_tmp (cid,nid)
  SELECT cid,nid
  FROM comments
  WHERE cid>@comments_cid;

UPDATE comments,comments_tmp 
  SET comments.thread=CONCAT(CONCAT(REPEAT(9,
    LEFT(comments_tmp.thread,LENGTH(comments_tmp.thread)-1)),
    RIGHT(comments_tmp.thread,1)),'/') 
  WHERE comments.cid=comments_tmp.cid;

#
# Update history
#
#INSERT INTO history (uid, nid, timestamp)
#  SELECT a.uid, b.nid, a.timestamp
#  FROM users AS a, node AS b
#  WHERE a.uid>0 AND b.nid>@node_nid;

#
# update topic statistics 
#

INSERT INTO node_comment_statistics 
  (nid,last_comment_timestamp,last_comment_name,last_comment_uid,comment_count)
  SELECT @node_nid+pt.topic_id, pp.post_time, ppt.post_subject, IF(pp.poster_id=-1,0,pp.poster_id), 
    pt.topic_replies
  FROM node dn, phpbb_topics pt, phpbb_posts pp, phpbb_posts_text ppt
  WHERE dn.nid = @node_nid+pt.topic_id 
    AND pt.topic_last_post_id = pp.post_id 
    AND pp.post_id = ppt.post_id;

#put something into node_counter for read counts (totalcount is the read count, daycount seems to be the #same thing?)
            INSERT INTO node_counter (nid,totalcount,daycount,timestamp)
            SELECT @node_nid+topic_id,
            topic_views,
            topic_views,
            unix_timestamp(topic_time)
            FROM phpbb_topics;

#update for user 2
update node set uid=1 where uid=2;
update node_revisions set uid=1 where uid=2;
update comments set uid=1 where uid=2;


#
# Delete all temp tables
#
DROP TABLE IF EXISTS temp_posts;
DROP TABLE IF EXISTS comments_tmp;
DROP TABLE IF EXISTS temp_node;

#
# Update Drupal variables 
#
SELECT @term_data_tid:=MAX(tid) FROM term_data;
SELECT @comments_cid:=MAX(cid) FROM comments;
SELECT @node_nid:=MAX(nid) FROM node;
SELECT @users_uid:=MAX(uid) FROM users;
SELECT @vocabulary_vid:=MAX(vid) FROM vocabulary;

DELETE FROM sequences WHERE name="term_data_tid";
DELETE FROM sequences WHERE name="comments_cid";
DELETE FROM sequences WHERE name="node_nid";
DELETE FROM sequences WHERE name="users_uid";
DELETE FROM sequences WHERE name="vocabulary_vid";

INSERT INTO sequences (name,id) SELECT "term_data_tid", @term_data_tid;
INSERT INTO sequences (name,id) SELECT "comments_cid",@comments_cid;
INSERT INTO sequences (name,id) SELECT "node_nid",@node_nid;
INSERT INTO sequences (name,id) SELECT "users_uid",@users_uid;  
INSERT INTO sequences (name,id) SELECT "vocabulary_vid",@vocabulary_vid;

--------------------------------------------------------

The SadGeezers Guide to Cult Sci Fi
http://www.sadgeezer.com
SadCAST - The Sci Fi Video Podcast
http://sadgeezer.libsyn.com/