SQL command to fix BBCode.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 74
Joined: Mon Apr 28, 2003 7:49 pm

SQL command to fix BBCode.

Post by mkruer » Mon Sep 14, 2009 8:34 am

make a long story short, converted a minibb board to phpbb2 and then updated it to phpbb3 everything worked great. then i found out that the minibb was using html code instead of bbcode, so i went though and updated all the html into bbcode however i forgot that phpbb3 requires all bbcode to have a unique id. I totaly loosing my marbles when it comes to mysql.

below is a samle code, and i know its wrong, can someone post the correct code so i can run it though phpmysql and fix the database.

Code: Select all

update `phpbb_posts_text` set `post_text` = replace(`post_text`,'[/u]','[/u:'+phpbb_posts_text.bbcode_id+']');


User avatar
Support Team Member
Support Team Member
Posts: 51890
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: SQL command to fix BBCode.

Post by Brf » Mon Sep 14, 2009 11:17 am

Download the Support Toolkit: http://www.phpbb.com/support/stk/ and use it to reparse the bbcode.


Return to “[3.0.x] Support Forum”