Insert attachment all - issue relating to vBulletin import


Andy

Administrator
Staff member
If you have imported from vBulletin you might run into an issue where messages contain non-default ATTACH bbcodes. When you run the Insert attachment all add-on it will check for non-default ATTACH bbcodes and abort if it finds any.

To update these non-default ATTACH bbcodes, you will want to run two SQL queries, one to remove the ._xfImport code and another to change CONFIG to full.

Example of non-default ATTACH bbcode
[ATTACH=CONFIG]1234._xfImport[/ATTACH]

Example after the two SQL queries are run
[ATTACH=full]1234[/ATTACH]

SQL queries:

UPDATE xf_post SET message = REPLACE(message, '._xfImport', '')

UPDATE xf_post SET message = REPLACE(message, '[ATTACH=CONFIG', '[ATTACH=full')
 

Similar threads

Top