Converted scraped TapaTalk BBS to phpBB 3.3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
TheHerb
Registered User
Posts: 1
Joined: Mon Feb 01, 2021 4:26 am

Converted scraped TapaTalk BBS to phpBB 3.3

Post by TheHerb »

Hey everyone,
Hoping someone can give me some pointers before I delver much further into trying solutions myself. Some backstory first:

- I ripped a tapa talk forum to a sqlite3 database.
- rebuilt the data into a phpbb compatible schema and injected the data directly into the respective forums/topics/posts tables in phpbb.

Now, everything *seems* to be working for the most parts. All of the posts and forums are there and everything by and large works except a couple things.

1) the imported posts are not indexed for searching (I've tried all the various index options to delete/create indexes) so searching for keywords yields no results.
2) the posts themselves don't seem to be "processed" as in style tags like and simply show up as the plain text.

Now if I "edit" and "save" the post it will fix both items above I describe but there are over 2k posts so that's not a scalable fix :)

I presume it has to do with either the bbcode_uid or the checksum field in the posts table as both those fields were not filled out when I inserted the data into the DB but that's just a guess as it appears to be the only difference I can see in the data. Would love to get a more expert opinion before I go trying to fiddle around further.

Thanks again for any help,
- Eric
User avatar
janus_zonstraal
Registered User
Posts: 6613
Joined: Sat Aug 30, 2014 1:30 pm

Re: Converted scraped TapaTalk BBS to phpBB 3.3

Post by janus_zonstraal »

Maybe you have to reparse the posts.
viewtopic.php?t=2446856
Sorry! My English is bat ;) !!!
dima55
Registered User
Posts: 2
Joined: Mon Nov 20, 2023 5:45 am

Re: Converted scraped TapaTalk BBS to phpBB 3.3

Post by dima55 »

Resurrecting this old topic. I'm doing a tapatalk import. Do you still have any notes about how you reconstructed the tables to make phpbb happy? Thanks.
User avatar
warmweer
Jr. Extension Validator
Posts: 11856
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Converted scraped TapaTalk BBS to phpBB 3.3

Post by warmweer »

dima55 wrote: Mon Nov 20, 2023 6:00 am Resurrecting this old topic. I'm doing a tapatalk import. Do you still have any notes about how you reconstructed the tables to make phpbb happy? Thanks.
Good luck with that:

TheHerb
Joined: 01 Feb 2021, 05:26
Last active: 01 Feb 2021, 06:40
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.

Return to “[3.3.x] Convertors”