MyBB Community Forums

Full Version: Code color="" size=""
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
after merging vb to mybb I encounter this error in posts.

[color="red"]testing![/color]

it should be,

testing!

how to solve this? is there any sql query to be run?
Try running this query:

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'color="red"', 'color=red') WHERE `message` LIKE '%color="red"%';

Be sure to make a database backup just in case anything goes wrong.
I can't understand what you saying
(2011-07-28, 04:07 PM)faviouz Wrote: [ -> ]Try running this query:

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'color="red"', 'color=red') WHERE `message` LIKE '%color="red"%';

Be sure to make a database backup just in case anything goes wrong.

thanks!

how about the other color? and also the size"7" code?
What other color? And what size 7? Could you please demonstrate like you did in your first post?
the error [size="7"]testing![/size]

the right one testing!





color such as ="purple" ="pink", ="blue" etc.
For the size, this should work:

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'size="7"', 'size=xx-large') WHERE `message` LIKE '%size="7"%'; 

And regarding the other colors, just take a look at the first query and replace every instance of red with each color that you want to fix. For example, to fix the purple color you'd do:

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'color="purple"', 'color=purple') WHERE `message` LIKE '%color="purple"%';

Edit: not seen faviouz's response Smile
__________________________________________

for the other colors , please make new queries by taking above query given by faviouz as example !

AND for the size use below query

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'size="7"', 'size=large') WHERE `message` LIKE '%size="7%"'; 
thank you faviouz & ranjani! Smile

I hope that MyBB merge script will include the conversion of color,size,font code of vBulletin.