I am able to import everything in the PHPBB2Drupal settings except attachments, I cannot get a "green light" until I disable attachments. Can someone help please?

PHPBB 3.x
Drupal 6.x
PHPBB2Drupal 3.13(HEAD)

CommentFileSizeAuthor
#4 Untitled.jpg88.95 KBNeoID

Comments

naheemsays’s picture

The error text seems to not be shown (fixed in HEAD and should be in the next nightly.) - but to allow attachments you also need the comment_upload module.

A further note - I have not tested attachment upload since I have taken over this module and ported from drupal 5 to drupal 6 and then from phpbb2 to phpbb3, so there may be other problems. Given enough details, I am willing to help work through them.

eyelleye’s picture

Version: master » 6.x-2.0-beta2

Even with the comment_upload module enabled, on 6.x-2.0-beta2 there is still an issue with importing attachments:
user warning: Unknown column 'a.post_id' in 'on clause' query: SELECT * FROM phpbb_attachments a INNER JOIN phpbb_posts p ON a.post_id = p.post_id WHERE p.topic_id = 0 ORDER BY a.attach_id in /*drupalPath*/sites/all/modules/phpbb2drupal/phpbb2drupal.module on line 653.

It would appear that in phpbb3 that post_id for the phpbb_attachments table is now post_msg_id.

naheemsays’s picture

Can you have a look in your database and see what columns the phpbb_attachments table contains? does it have a column called post_id? If so, I have no idea what is wrong there.

While I do maintain this module, I have not looked deep into this module deeply for a good few months now and the phpbb3 support was added without me actually needing it, so there has not been as much testing.

If the post_id column does not exist, can you put the full list of columns that do exist here please?

NeoID’s picture

StatusFileSize
new88.95 KB

If your still interested, here's a screenshot of the columns. Looks like post_id has been changed to post_msg_id?

naheemsays’s picture

Status: Active » Fixed

This should be fixed in HEAD with this commit: http://drupal.org/cvs?commit=212642

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.