phpBB to php nuke

New Member Joined: Oct 12, 2005 Posts: 4

chatserv wrote:

Now that is a first, a few things to check are the cookie setting for the forum and making sure gzip_compress is off, if you still have the converted forums on the nuke site pm me a url and i'll take a look, if possible create a temp superuser or admin with access to the forums.

I forgot to mention in my details that I did ensure that gzip_compress in the forum config was off prior to conversion.

Since I already restored my database from backup, I'll go ahead and run another backup, re-setup nuke and do the transfer. If I understand this process correctly after doing it twice already (with the same result both times) the transfer.php code doesn't really touch the standalone phpbb tables (other than copying them) so my users shouldn't notice any changes on the old forum while we do this, correct? *sweat*

Oh, also, what would I be looking for in the cookie settings? Making them identical to the old forum or something like that?

I'll get it set up and fire off a PM with some info for you ASAP. Thanks a lot ahead of time.

Posted: Thu Oct 13, 2005 10:02 am

The phpBB tables will not suffer any changes.

Posted: Thu Oct 13, 2005 10:21 am

Info sent via PM. Smile

Good luck, lemme know if I can help you help me!

Posted: Thu Oct 27, 2005 8:20 am

It's been a few weeks and through further digging, I'm still coming up empty handed. Does anyone have any ideas?

New Member Joined: Jan 19, 2006 Posts: 9

I'm kinda of mixed up here...any help would be great.

I have backup of my phpbb forums, that I downloaded through the forum admin panel because I dont have access to the phpadmin or sql for where the forums are being hosted...

What I want to do is use my old phpbb forum information and apply it to my newly installed phpnuke7.6RV now that i have my own hosting.

Where I'm confused is where I should upload the entire backup to? Do I upload it to the same database where my phpnuke tables are stored or do I create a new database and store the phpbb tables there...

Posted: Tue Jan 24, 2006 5:06 pm

Ok well here's what i've done since my post...
I uploaded all the tables and information from my back up to the same database as my nuke tables, so now i have nuke_etc. tables and phpbb_etc.. tables in one database...Now i'm not sure if this is what i was suppose to do...if not please stop me lol...

Posted: Tue Jan 24, 2006 5:08 pm

Code:

Browse: (1 Rows)   nuke_authors


Browse: (0 Rows)  nuke_autonews


Browse: (0 Rows)  nuke_banned_ip


Browse: (0 Rows)  nuke_banner


Browse: (0 Rows)  nuke_bannerclient


Browse: (0 Rows)  nuke_bbauth_access


Browse: (0 Rows)  nuke_bbbanlist


Browse: (0 Rows)  nuke_bbcategories


Browse: (61 Rows)  nuke_bbconfig


Browse: (0 Rows)  nuke_bbdisallow


Browse: (0 Rows)  nuke_bbforum_prune


Browse: (0 Rows)  nuke_bbforums


Browse: (2 Rows)  nuke_bbgroups


Browse: (0 Rows)  nuke_bbposts


Browse: (0 Rows)  nuke_bbposts_text


Browse: (0 Rows)  nuke_bbprivmsgs


Browse: (0 Rows)  nuke_bbprivmsgs_text


Browse: (2 Rows)  nuke_bbranks


Browse: (0 Rows)  nuke_bbsearch_results


Browse: (0 Rows)  nuke_bbsearch_wordlist


Browse: (0 Rows)  nuke_bbsearch_wordmatch


Browse: (4 Rows)  nuke_bbsessions


Browse: (44 Rows)  nuke_bbsmilies


Browse: (1 Rows)  nuke_bbthemes


Browse: (1 Rows)  nuke_bbthemes_name


Browse: (0 Rows)  nuke_bbtopics


Browse: (0 Rows)  nuke_bbtopics_watch


Browse: (2 Rows)  nuke_bbuser_group


Browse: (0 Rows)  nuke_bbvote_desc


Browse: (0 Rows)  nuke_bbvote_results


Browse: (0 Rows)  nuke_bbvote_voters


Browse: (0 Rows)  nuke_bbwords


Browse: (13 Rows)  nuke_blocks


Browse: (0 Rows)  nuke_comments


Browse: (0 Rows)  nuke_comments_moderated


Browse: (1 Rows)  nuke_config


Browse: (0 Rows)  nuke_confirm


Browse: (20 Rows)  nuke_counter


Browse: (0 Rows)  nuke_downloads_categories


Browse: (0 Rows)  nuke_downloads_downloads


Browse: (0 Rows)  nuke_downloads_editorials


Browse: (0 Rows)  nuke_downloads_modrequest


Browse: (0 Rows)  nuke_downloads_newdownload


Browse: (0 Rows)  nuke_downloads_votedata


Browse: (0 Rows)  nuke_encyclopedia


Browse: (0 Rows)  nuke_encyclopedia_text


Browse: (0 Rows)  nuke_faqanswer


Browse: (0 Rows)  nuke_faqcategories


Browse: (0 Rows)  nuke_groups


Browse: (21 Rows)  nuke_groups_points


Browse: (27 Rows)  nuke_headlines


Browse: (0 Rows)  nuke_journal


Browse: (0 Rows)  nuke_journal_comments


Browse: (0 Rows)  nuke_journal_stats


Browse: (0 Rows)  nuke_links_categories


Browse: (0 Rows)  nuke_links_editorials


Browse: (0 Rows)  nuke_links_links


Browse: (0 Rows)  nuke_links_modrequest


Browse: (0 Rows)  nuke_links_newlink


Browse: (0 Rows)  nuke_links_votedata


Browse: (1 Rows)  nuke_main


Browse: (1 Rows)  nuke_message


Browse: (22 Rows)  nuke_modules


Browse: (0 Rows)  nuke_pages


Browse: (0 Rows)  nuke_pages_categories


Browse: (0 Rows)  nuke_poll_check


Browse: (12 Rows)  nuke_poll_data


Browse: (1 Rows)  nuke_poll_desc


Browse: (0 Rows)  nuke_pollcomments


Browse: (0 Rows)  nuke_pollcomments_moderated


Browse: (0 Rows)  nuke_public_messages


Browse: (0 Rows)  nuke_queue


Browse: (1 Rows)  nuke_quotes


Browse: (1 Rows)  nuke_referer


Browse: (0 Rows)  nuke_related


Browse: (0 Rows)  nuke_reviews


Browse: (0 Rows)  nuke_reviews_add


Browse: (0 Rows)  nuke_reviews_comments


Browse: (0 Rows)  nuke_reviews_comments_moderated


Browse: (1 Rows)  nuke_reviews_main


Browse: (1 Rows)  nuke_session


Browse: (730 Rows)  nuke_stats_date


Browse: (48 Rows)  nuke_stats_hour


Browse: (24 Rows)  nuke_stats_month


Browse: (2 Rows)  nuke_stats_year


Browse: (0 Rows)  nuke_stories


Browse: (0 Rows)  nuke_stories_cat


Browse: (0 Rows)  nuke_subscriptions


Browse: (1 Rows)  nuke_topics


Browse: (2 Rows)  nuke_users


Browse: (0 Rows)  nuke_users_temp


Browse: (43 Rows)  phpbb_auth_access


Browse: (1 Rows)  phpbb_banlist


Browse: (2 Rows)  phpbb_categories


Browse: (61 Rows)  phpbb_config


Browse: (0 Rows)  phpbb_confirm


Browse: (1 Rows)  phpbb_disallow


Browse: (0 Rows)  phpbb_forum_prune


Browse: (3 Rows)  phpbb_forums


Browse: (129 Rows)  phpbb_groups


Browse: (2906 Rows)  phpbb_posts


Browse: (2906 Rows)  phpbb_posts_text


Browse: (41 Rows)  phpbb_privmsgs


Browse: (41 Rows)  phpbb_privmsgs_text


Browse: (1 Rows)  phpbb_ranks


Browse: (1 Rows)  phpbb_search_results


Browse: (5786 Rows)  phpbb_search_wordlist


Browse: (29784 Rows)  phpbb_search_wordmatch


Browse: (5 Rows)  phpbb_sessions


Browse: (42 Rows)  phpbb_smilies


Browse: (1 Rows)  phpbb_themes


Browse: (1 Rows)  phpbb_themes_name


Browse: (184 Rows)  phpbb_topics


Browse: (61 Rows)  phpbb_topics_watch


Browse: (132 Rows)  phpbb_user_group


Browse: (128 Rows)  phpbb_users


Browse: (4 Rows)  phpbb_vote_desc


Browse: (9 Rows)  phpbb_vote_results


Browse: (49 Rows)  phpbb_vote_voters


Browse: (0 Rows)  phpbb_words

Posted: Tue Jan 24, 2006 5:24 pm

Ok well i ran the script and it WORKED!!!!!!!!!!!!!!!!!!!!!!
Now is it normal for example that the permission were removed and moderators were removed as well things like that? Also do i go back and delete all the php_etc... tables??

Posted: Tue Jan 24, 2006 7:45 pm

Ok i'm getting this error when i try loggin in thorugh the short way in the forums not sure what this means i've followed all the steps and everythings been working fine so far so not sure what to do next...I can login to the forums using other methods but when i try it this way thats the error i get.

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM nuke_users WHERE username = 'test'

Line : 70
File : login.php

registered · Posted: Tue Jan 24, 2006 10:01 pm

You're missing some fields for BBToNuke 2.0.19

Code:




ALTER TABLE nuke_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL; 


ALTER TABLE nuke_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;

Posted: Wed Jan 25, 2006 12:13 am

You really needed to run the database upgrades on your database to bring it up to 2.0.19 prior to trying to move the tables. That would have been easier and smoother. However, if that was the only error you encountered, then do as Evaders states and the transition should be easy.

Posted: Sun Feb 12, 2006 3:38 pm

Ok well i'm posting here again because I was never able to get it working properly I was still having trouble with users loging in. So i'm starting over now that i have some time.

Can you explain to me how i can upgrade a database backup if all I have of my old forum is the backup.sql file that I downloaded from the Admin Panel.

I tried installing just a phpbb forum version 2.0.19 and then loading the tables with my backup file however that was not succesful either I was getting login problems. So im really not sure how it is that I'm suppose to upgrade this single backup file that I have.

Posted: Sun Feb 12, 2006 4:02 pm

Get the bbtonuke upgrade scripts from Chatserv's site and run then one by one from your version to the current version.

Posted: Sun Feb 12, 2006 5:43 pm

whats the different from bbtonuke 2.0.19 and bbtonuke 2.0.19 Nuke Patch??

Regular Joined: Jul 15, 2006 Posts: 64

I want to do this EVER so badly, as I spent many hours setting up my original phpbb forums, but this whole process seems a little to shoddy for my taste, especially with my VERY limited knowledge of sql.

I've tried comprehending the instructions to the point where i feel comfortable I could accomplish every step on my own, but I'm still skeptical, as many assumptions were made.

The first hurdle is that my phpbb forums is on one mysql database, and my nuke install is on another. I've read that if I export the phpbb database (after backing up), that I can then import it into the nuke database. That I can do.

The second hurdle is that I don't know how to make all those changes that are required to the sql tables (steps like 2 through 6).

If I could get a 'procedure for dummies' I'd be very grateful. I'm not going to attempt the transfer until then, as I want to avoid causing errors for my current users.

New Member Joined: Jul 14, 2006 Posts: 1

** Deleted due to lack of interest

Worker Joined: Aug 27, 2006 Posts: 172

Raven wrote:

This is the last version I worked with. Follow the instructions at the top and run this from the directory of you phpNuke site where the config.php is located.

This was your first post with the conversion script. Of course i removed the script to not fill the forum duplitating the data.

Raven wrote:

Just comment out that line. Your host has restricted you. Also, go here for the latest edition http://www.ozerov.de/bigdump.php

then you posted this one.

Which one should i use to convert the data fro my phpBB to my php-nuke databases?