splatt to phpbb is there any easy way????

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

I have upgraded my site from phpnuke 6.0 to phpnuke 7.0.
Everything seems in order. I still need to move all the data from
splatt 4.2 to phpbb 2.0.6
I have tried a couple of scripts but none of them worked.
I even created the categories and topics by hand and
try importing as one script suggested, but that didn't work either.
Any help would be greatly appreciated!!!

Dss

Raven · Posted: Tue Feb 17, 2004 12:43 pm

I have never used Spaltt so I cannot offer much to this. I'm sure you've already searched google. Other than that it seems that many have been searching for this, but to date, it remains elusive.

chatserv · Posted: Tue Feb 17, 2004 1:15 pm

Only registered users can see links on this board!
Get registered or login to the forums!

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

Thanks for the replies! I have searched google, nukemods, nukecops,
nukeresources, and every other place I can think of.
Chatserv, thanks for the info, but unfortunately I have already tried that one too. It says it works, but nothing is moved. I tried creating all the categories and forums manually and then running it. Still says it works, but nothing gets moved. I have tried writing the sqls manually and was able to get that working partially but wasn't able to get the rest of it
working correctly. Anymore help and/or suggestions would be greatly
appreciated!!!

Dss

chatserv · Posted: Tue Feb 17, 2004 2:35 pm

I made one for MyPHPNuke to Nuke that transfers the forums (Splatt) guess i should make one for Nuke 6.0 to newer version.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

well.. I would be greatful and judging by the posts that I have ran across while trying to figure this one out, I think there are many people that would be greatful.
The 70sql upgrade that you did worked great!!! I was abit worried about upgrading from 6.0 to 7.0....but everything was flawless except for the forum issues.
If you need me to test this, I would be happy to. The splatt forums are still fully functional and it seems that the phpbb are functional as well. I would just like to use something more customizeable. I also never liked the fact that the guys that do most of the work on splatt are italian. I have spent hours trying to babblefish post. LOL I think splatt was great in it's time...but it's time to me on...at least for me it is. Thanks again for the responses!!!!

Dss

chatserv · Posted: Tue Feb 17, 2004 4:27 pm

Let's see if we can get this working, download

Only registered users can see links on this board!
Get registered or login to the forums!

, here's how it works:
basically it works the same way nukesql.php does with the exception that you need to edit a config file located in the nukesql folder (could have grabbed the variables from Nuke's config but i took the code from a new version of nukesql.php i am working on which i want to run independant of Nuke to minimize errors).

since this was done in a hurry (yes i did test it) it has its limitations:
You must upgrade Nuke before using this, if you already did ignore this.
The BBtoNuke forums can not have any forums, posts or categories in them.
Ranks might have to be manually edited once done.

Depending on how it works for you i will edit it as required.

Please make a backup of your db tables before running the script.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

It seem to run fine. It said it converted, but there was still nothing there.
I had created all my categories and forums but deleted them prior to running
the script. It's almost as there is a permissions problem on the database.
It says it does the conversion but nothing really happens. Thanks again for
your wonderful help!!!!

Dss

chatserv · Posted: Tue Feb 17, 2004 5:04 pm

Did you check the bb tables to see if anything had been imported?

chatserv · Posted: Tue Feb 17, 2004 5:27 pm

If any data was inported into bbcategories, bbforums, bbtopics, bbposts, bbposts_text, bbprivmsgs and bbprivmsgs_text empty them, download the script again and retry running it.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

I made sure everything was empty and ran the script again... Same results.
It said it converted, but go to the forums and nothing there.

Dss

chatserv · Posted: Tue Feb 17, 2004 6:15 pm

Ok, but the tables i listed are empty? i ask because i tried it on a test site i upgraded from 6.0 to 7.1 and the data did get sent to those tables.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

Yes, I went back and checked once again. They are empty. If you would like to login and take a look let me know...I will give you the info.
Thanks!

Dss

chatserv · Posted: Tue Feb 17, 2004 6:30 pm

Pm the info to me, site url too.

chatserv · Posted: Tue Feb 17, 2004 6:44 pm

It's not importing the data because Splatt's tables are not in the database.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

The following are in the nuke database.

nuke_splattforum_access
nuke_splattforum_catagories
nuke_splattforum_config
nuke_splattforum_forums
nuke_splattforum_forumtopics
nuke_splattforum_mods
nuke_splattforum_notifica
nuke_splattforum_posts
nuke_splattforum_ranks

chatserv · Posted: Tue Feb 17, 2004 6:51 pm

The edit the script's config file and make $mpnprefix nuke_splattforum

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

that seem to import some things but not the posts

1nuke_bbtopicsColumn count doesn't match value count at row 1nuke_bbtopicsColumn count doesn't match value count at row 1nuke_bbtopicsColumn count doesn't match value count at row 1nuke_bbtopicsColumn count doesn't match value count at row

I get that above error.

Dss

chatserv · Posted: Tue Feb 17, 2004 6:58 pm

Ok, i made the script with splatt 3.2 as base, i'll backup those tables and edit the script.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

Ok... Do i need to edit the script or will you post it?
Once again, i can't tell you how much i appreciate your help!

Dss

chatserv · Posted: Tue Feb 17, 2004 7:42 pm

I emptied the bb tables and modified the script, download it again and give it one last run, let's see if it works now.

dssripper · Regular Joined: Feb 16, 2004 Posts: 67

Ok...we are making progress.
It showed to convert the data. The data show up in
the database, but they aren't showing up in the actual forums.
The numbers look right, but there isn't any real topics listed or
actual posts. That make sense?

Dss

chatserv · Posted: Tue Feb 17, 2004 8:10 pm

Create a temp user/admin account with access to the forums and pm me the name/pass info, also if you remember let me know which forums were private..