XF 1.4 remove all sorts font in forum with regular expressions

[jamalfree]

hello
how can find and replace all sorts font in forum

example fonts

bla bla bla bla bla bla bla bla

bla bla bla bla bla bla bla

i want keep only content and remove bbcode font like this
bla bla bla bla bla bla bla

i see the topic https://xenforo.com/community/resources/post-content-find-replace.1549/ but i didnt know what shoud enter in fields because i have not experience regular expressions

 

[Paul B]

Try this.

Quick Find:

[font

Regular Expression:

#\[font=([^\]]+)\](.*)\[/font\]#siU

Replacement String:

\2

Take a backup first as I haven't tested it.

 

[jamalfree]

thanks brogan i will try later ; can you provide me Method for color its look close method to remove font!!

 

[Paul B]

Quick Find:

[color=

Regular Expression:

#\[color=[^\]]+\](.+)\[/color\]#siU

Replacement String:

\1

 

[jamalfree]

thanks brogan i will try later .....

 

[jamalfree]

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 99480 bytes) in /home/xxx/public_html/xxx/library/Zend/Db/Statement/Mysqli.php on line 294

 

[Paul B]

You are running into a memory limit.

How many posts do you have?

 

[jamalfree]

106,984

 

[jamalfree]

if i run addon and he clean my db and if he stopped and i get error and i run addon again to finish his job is correct way or not; perhaps i get problems in

 

[Paul B]

The recommended minimum for XF is 128M, which is actually the PHP default.

You should contact your host and ask them to increase it (or you can try doing it in php.ini - memory_limit).