# Fix quotes after phpBB import

**URL:** <https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133>\
**Category:** Product Support\
**Created:** [January 27, 2018, 1:39am UTC](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133 "2018-01-27T01:39:46Z")\
**Posts on this page:** 1\
**Showing post:** 72

<div class="post-metadata">

**Author:** ![Tomasz136472](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tomasz136472/32/85114_2.png) [@Tomasz136472](https://meta.discourse.org/u/Tomasz136472)\
**Post date:** [February 23, 2018, 6:41pm UTC](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133/72 "2018-02-23T18:41:56Z")

</div>

Hi @omarfilip,

I have completed my import from IPB recently with help of @pfaffman

I found, however, using rake commands to slow for fixing quotes and stuff as my forum has 1.3 mln posts it does take time.

I prefer to do all of the stuff directly on the database and then to rebake.

For the quotes for instance I would do:

```plaintext
UPDATE posts SET raw = REPLACE(raw, '[quote=', ''||chr(10)||'[quote=') where raw like '%[quote=%';
UPDATE posts SET raw = REPLACE(raw, '[/quote]', '[/quote]'||chr(10)||'') where raw like '%[/quote]%'; 

```

and then rebake.

I would actually fix everything I can before I even start rebake as you can see you changes live by simple regenerating HTML or editing the posts.

Hope it helps!

---

_[View the full topic](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133)._