Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's
Author Message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Thu Oct 13, 2005 12:15 am Reply with quote

worship
 
View user's profile Send private message
spinfist
New Member
New Member


Joined: Oct 12, 2005
Posts: 4

PostPosted: Thu Oct 13, 2005 9:00 am Reply with quote

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.
 
View user's profile Send private message
chatserv
Member Emeritus


Joined: May 02, 2003
Posts: 1389
Location: Puerto Rico

PostPosted: Thu Oct 13, 2005 10:02 am Reply with quote

The phpBB tables will not suffer any changes.
 
View user's profile Send private message Visit poster's website
spinfist
PostPosted: Thu Oct 13, 2005 10:21 am Reply with quote

Info sent via PM. Smile Good luck, lemme know if I can help you help me!
 
spinfist
PostPosted: Thu Oct 27, 2005 8:20 am Reply with quote

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


Joined: Jan 19, 2006
Posts: 9

PostPosted: Tue Jan 24, 2006 3:40 pm Reply with quote

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...
 
View user's profile Send private message
2int3nc3
PostPosted: Tue Jan 24, 2006 5:06 pm Reply with quote

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...
 
2int3nc3
PostPosted: Tue Jan 24, 2006 5:08 pm Reply with quote

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
 
2int3nc3
PostPosted: Tue Jan 24, 2006 5:24 pm Reply with quote

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??
 
2int3nc3
PostPosted: Tue Jan 24, 2006 7:45 pm Reply with quote

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
 
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Tue Jan 24, 2006 10:01 pm Reply with quote

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;

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Raven
PostPosted: Wed Jan 25, 2006 12:13 am Reply with quote

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.
 
2int3nc3
PostPosted: Sun Feb 12, 2006 3:38 pm Reply with quote

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.
 
Raven
PostPosted: Sun Feb 12, 2006 4:02 pm Reply with quote

Get the bbtonuke upgrade scripts from Chatserv's site and run then one by one from your version to the current version.
 
2int3nc3
PostPosted: Sun Feb 12, 2006 5:43 pm Reply with quote

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


Joined: Jul 15, 2006
Posts: 64

PostPosted: Sun Jul 16, 2006 11:27 pm Reply with quote

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.
 
View user's profile Send private message
ekanar
New Member
New Member


Joined: Jul 14, 2006
Posts: 1

PostPosted: Thu Jul 20, 2006 9:52 am Reply with quote

** Deleted due to lack of interest

_________________
" ... a little bit of knowledge can be a dangereous thing ..." A. Einstein (1879-1955) 
View user's profile Send private message
shotokan
Worker
Worker


Joined: Aug 27, 2006
Posts: 172

PostPosted: Fri Sep 15, 2006 7:22 am Reply with quote

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 Only registered users can see links on this board! Get registered or login!


then you posted this one.

Which one should i use to convert the data fro my phpBB to my php-nuke databases?
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©