NukeXchange Network

          

Nuke Sites Link Directory
Nuke Fixes · NukeForums · NukeZone Hosting · NukeUnited · Nuke Sites · Nuke Skins · NukeLance
Nuke Resources
 :: Home  :: Downloads  :: Your Account  :: Forums  :: Advertise :: 
Login or Register
Main Menu
General
 Main
 AvantGo
 Banner_Clients
 cfaq
 Donations
 Downloads
 Forums
 Members_List
 Private_Messages
 Search
 Stories_Archive
 Submit_News
 Surveys
 Topics
 Web_Links
 Your_Account

Your Account
 Login
 Register
 Lost Pass

Modules
Quick Links
· CMS Focus
· Domain Names
. Game Quest
· Learning Linux
. MateMaker
· NukeFixes
· NukeForums
· NukeLance
· Nuke Sites
· Nuke Skins
· NukeZone Hosting
. SearchDevil
Other Options

Download Resources
· Nuke Downloads
· Add a Link
· New Files
· Top Rated
· Most Popular

Web Site Resources
· Nuke Sites
· Add A Site
· New Sites
· Top Rated
· Most Popular

Support
· NukeZone Hosting
· NukeSkins.com
· NukeForums.com
· phpnuke.org
· NukeFixes.com
Information
NukeForums
·PHPNuke 8 security worries
·PHP-Nuke SQL Injection Vulnerability Fix
·decompressing EN-Book-Nuke.tar.tar
·How to allow spaces/gaps/"-" in allowed usernames
·How to Setup PHPNUKE on win2k
·cannot save changes
·voting?
·Nuke forum picture problem
·How to change smtp port on wampserver and windows
·yet another 301 redirect problem

read more...
Top10 Links
· 1: Nuke Forums
· 2: PHPNukeFiles
· 3: NukeSkins
· 4: Nuke Templates
· 5: EcomJunk
· 6: MDesign
· 7: Windows Installation: PHP
· 8: FLASH-FOR-NUKE
· 9: Dezina
· 10: Global Dream News Sharing Portal!
Site Visitors
User Login:

Nickname:
Password:
Security Code: Security Code
Type Security Code Here:

Members List Membership:
Latest: tones
Today: 1
Yesterday: 2
Overall: 15105

Visitation:
Guests: 443
Members: 0
Total: 443


You are Anonymous user. You can register for free by clicking here
Sponsor Links
Game Quest Online - Games and more!
Game Quest Online - Games and more!

NukeResources :: View topic - injecting phpBB into Nuke
NukeResources Forum Index

NukeResources Forum Index -> phpMyAdmin -> injecting phpBB into Nuke
Post new topic  Reply to topic    View previous topic :: View next topic 
injecting phpBB into Nuke
PostPosted: Thu Aug 17, 2006 6:59 am Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




Hi all, I hope I have the correct forum.

specs,
phpMyAdmin 2.7.0
phpBB 2.0.21 (existing SQL Db)
phpNuke 7.6 (fresh install)

I have an existing phpBB forums with members/comments. I have installed a fresh install of phpNuke. When I click on the forums I get a session error I presume because it has no data yet.

I want to copy over the members/comments to the Nuke install, I have now got the script. phpbb_nuke_conv.tar and understand how to set-up the config file for access and prefix's but for this script to work I need the phpBB tables inside the same database as the Nuke tables, and that is where Im stuck.

I'm new to SQL and phpMyAdmin, could someone please point me.

How do I add the tables from a phpBB2 SQL database to a phpNuke SQL database so both sets of tables reside in one?

thanks in advance even if you couldn't help

Scabb's
View user's profile Send private message
PostPosted: Thu Aug 17, 2006 7:07 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Use phpMyAdmin and go to Operations for each table, copy them over to the other database. If you do not see such an option, another way is to Export the tables to a sql file and then Import them to one database.

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Thu Aug 17, 2006 10:14 am Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




There doesn't seem to be a way of transfering the tables between SQL db's only export the whole list of 45 tables.

How do I Import an existing SQL file? There doesn't seem to be a click point.

I have successfully used a script to restore an SQL database but not done it this way,

oh and thanks for replying
View user's profile Send private message
PostPosted: Thu Aug 17, 2006 11:23 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Go to the SQL box and there should be an option to import the file. If its a rather big file, use a script such as bigdump to import it

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Thu Aug 17, 2006 5:57 pm Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




Amazing, I'm gettin so confused doing this. It's only cause I havn't done it before.

Ok I have found the import but this has a file size limit to the import of 2,048k. My site is not the biggest in the world with a total SQL file size of 17 meg. I fear even if I export in single tables one of em aint gonna fit!

Any suggestions (I didn't want to but even if only the membership came over without the comments then that is at least a start as long as the phpbb_nuke_conv.tar will still work to merge them)

hey and thanks buddy for your time, this problem has taken me an age elsewhere and still no helpful responses.
View user's profile Send private message
PostPosted: Fri Aug 18, 2006 5:50 am Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




Hey whot ho,

I have figured out how to move the tables and ran the script with no reported errors till I selected the forums and got this.

Code:
phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('8c055d1c048cc5e7ed652d22aacf960a', '1', '1155862477', '1155862477', '522f55aa', '0', '0', '0')

Line : 203
File : sessions.php


This is the exact same error I had before I installed the tables, I have never had an empty forums show up in this Nuke installation even though the files are there in the modules folder, only this error. I presumed it was because I had not installed the SQL yet, now I thought I had, could you please explain,

When I select either forums (main), forums (from admin) or personal messages this error comes up, before or since table insertion.

Is there a config file I should have edited post Nuke installation that would have fired up the forums? I found no reference.

gone, figured, stuck, please prod with a cattle fork!

[edit- update]
I have just checked for membership on the Nuke site and membership is there.
View user's profile Send private message
PostPosted: Fri Aug 18, 2006 2:34 pm Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Your phpNuke needs to be upgraded to the same version of forums that you started. Thus you need to install all the way up to BBToNuke 2.0.21

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Fri Aug 18, 2006 4:56 pm Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




Sad

Is it me or is this lot worth the effort, I was tossing around the idea of Jamoola, I went with Nuke because there are a lot of them.

I do not understand why there are so many installation versions, the phpNuke I installed was downloaded from here, why didn't it come with the latest phpBB, it doesn't make any sense not to have that on the server,

no critisism intended, I think this site is great, it's just that with all the versions it's such a maze to a newcomer with no guide to "hello, this is where to go and i recommend using this to start off with"

I appreciate all your advice so far, i shall continue
View user's profile Send private message
PostPosted: Fri Aug 18, 2006 11:59 pm Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Mostly because FB, the creator of phpNuke, does not update his software in a timely fashion. Rather, good people such as chatserv need to continually update and patch it.

Until FB decides to put 2.0.21 into his next release, there isn't anything we can do.

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Sat Aug 19, 2006 4:52 pm Reply with quote
Scabby
Resource Seeker
Resource Seeker
 
Joined: Aug 11, 2006
Posts: 8




Could you please do me one favour,

Could you please list what to load from here so I do not install wrongly a second time. I suppose I'm gonna have to start from scratch again. My knowledge of SQL really isn't good enough to sort this problem out now, as the membership seems screwed also somehow (probably I used the wrong coversion script) Crying or Very sad

If this happens a second time I'm affraid I'm going to have scrap the whole idea.

put simply, I have a phpBB2.0.21 and want to start using Nuke instead.

My knowledge of php is sufficient to handle using the patches and alterations however my knowledge of SQL and phpMyAdmin is, well, Crap! and The manual might aswell be written in Klingon! I can back-up the SQL database and re load it should I need to do a backup/reinstall and thats about it.

Iwould be VERY appreciative.

Phil
View user's profile Send private message
PostPosted: Thu Aug 24, 2006 1:50 pm Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




phpNuke must be upgrade to BBToNuke 2.0.21.
From phpNuke 7.6, that includes 2.0.10. So you need to download and install:
BBToNuke 2.0.11, 2.0.12.... to 2.0.21

Next you can run my phpBB2phpNuke script available here: http://evaders.swrebellion.com/forums/postt25.html

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
injecting phpBB into Nuke
 NukeResources Forum Index -> phpMyAdmin
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
All times are GMT - 4 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic