I’ve successfully imported my vBulletin 5 forum into Discourse. While the overall import script works fine, I’m encountering errors when importing attachments. The attachments are stored in my database and include the following extensions: java, html, jpg, png, txt, rtf, zip, js, and xml. Upon debu…

You’ll need to add some debugging put statements to see what it’s happening.

I added debugging statement on upl_obj begin upl_obj = create_upload(post.user.id, filename, real_filename) if upl_obj&.persisted? html = html_for_upload(upl_obj, real_filename) if !post.raw[html] post.raw += "\n\n#{html}\n\n" post.s…

The only files that worked are ascii. My guess is an encoding error.

Is there an issue with files in database or import script encoding issue? @pfaffman

[image] See these files if others are encoded then why these extensions e.g jpg, png etc are not?

My guess, which could be wrong, is that a problem with newline encoding makes the data in the binary files wrong because a newline character is encoded as data. If the only files that work are ascii, it’s a good bet. So it’s not a Discourse issue, but a mysql issue.

[صورة] Jay Pfaffman: that a problem with newline encoding makes the data in the binary files wrong Almost - not newline encoding, but treated as text, and therefore corrupted. EF BF BD is the UTF-8 byte sequence for ‘REPLACEMENT CHARACTER’ (U+FFFD). This is indicative of a file being treated…

@RGJ Thanks for the help. I tried importing a new database with the correct images, and while it imported, not all attachments were fully imported. I’m encountering errors like this: [image] Any idea why this is happening? @RGJ @pfaffman

Posts are appearing like this, and there are many instances: [image]

I don’t think the importer can handle those. If I recall correctly, all [ATTACH] tags are removed from the posts since they are superfluous. That probably doesn’t work here because it does not expect JSON data in it. It would be matter of looking up the place where they are being removed and modify…

نقل قاعدة بيانات vBulletin 5 - أخطاء استيراد المرفقات حول امتداد المرفق

الدعم هجرة

pfaffman (Jay Pfaffman) 6 يوليو 2024، 6:34م 2

ستحتاج إلى إضافة بعض عبارات التصحيح لرؤية ما يحدث.

الموضوع		الردود	مرات العرض
vBulletin 5 import error (invalid character in website field) and a quick question about attachments Migration vbulletin5	3	832	17 أغسطس 2020
vBulletin import script is incompatible with vBulletin5 Feature	11	2833	16 يونيو 2016
Import scripts vbulletin5.rb Self-hosting	9	1318	20 أبريل 2020
Migrating vB5 to Discourse Support	3	2545	16 مايو 2015
Bulk file uploads (for migration) Self-hosting	2	1177	8 مايو 2015

نقل قاعدة بيانات vBulletin 5 - أخطاء استيراد المرفقات حول امتداد المرفق

الموضوعات ذات الصلة