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

__________________________________________
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!
I hope that MyBB merge script will include the conversion of color,size,font code of vBulletin.