After upgrade, need to disable 'parsing URL's?

[Trinity]

Hi, gang.

I have a question. After an upgrade, is there any way I can go into the database and automatically make every archive post NOT parse URL's? I've noticed that even though I created the appropriate bBcode before I upgraded my 2.x installation to 3, it's not displaying properly because phpBB 3 is parsing all the URL's in every post.

Any chance I could have every post in my forum not parsed URL-wise?

Please help.

[D-Shadow]

[Trinity]

Thank you. Is there any way to run a query that can update all my posts to be able to not have this in them? Just curious.

[igorw]

Hello, D-shadows query should do just that

[Trinity]

[igorw]

Well the query provided by D-Shadow would set the option for all posts currently in the database (your upgraded ones). For future posts it needs to be done in the posting screen, just tick that checkbox.

[Trinity]

[igorw]

Oh now i get it, you need a separate one for phpbb_posts. I didn't read it properly and thought it was posts in the first place. Sorry for the confusion!

[Trinity]

Hm, so do I have to do something else?

[D-Shadow]

[Trinity]

[igorw]

I think that's because the bbcode uids were removed durin conversion. Perhaps it'd be possible to buid a script that ran through all posts and readded them. If i recall correctly, it was in this format:
[bbcode:123456]Content[/bbcode]
123456 would be the bbcode uid, that is also a db field for the posts table afaik.

[Trinity]

Ick, what a drag.

[D-Shadow]

[Trinity]

Thanks for the post. I still think it's interesting to think about, because I guarantee that other people are facing the same problem if they had BBcode additions in their BB (which a lot of BB's had). If anyone has a script or idea they could share, please post it! I'm at a loss here.