Home Register FAQ Members List Downloads Search Today's Posts Mark Forums Read

» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 225
0 members and 225 guests
No Members online
Most users ever online was 611, 03-21-2008 at 10:10 PM.
» .::.
Web Hosting - web hosting, dedicated servers and web design services.
Online Degree - search for 1000+ online degrees, online colleges & online universities.
Evden eve nakliyat - Evden eve Nakliyat
tattoo - We are a group of tattoo enthusiasts
Gexa Energy - Your absolute best choice in electric service
Texas electricity - save on electric rates

Register Now! Contact Us

About this Page
This is a discussion on Importing phpBB database to nuke phpBB within the Nuke 7.x - Modules forums, part of the PHP-Nuke 7.x category; I will soon be working to convert an old phpbb fourm (2.0.6) to a new phpnuke portal site. ...

Go Back   Nukemods Forum » PHP-Nuke 7.x » Nuke 7.x - Modules

Importing phpBB database to nuke phpBB


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-15-2004, 08:48 PM
Junior Member
  
Join Date: Nov 2004
Posts: 4
Importing phpBB database to nuke phpBB
I will soon be working to convert an old phpbb fourm (2.0.6) to a new phpnuke portal site. I want to convert the database from phpbb to phpnuke. What do i need to look out for.

I havnt had a chance to look at the schema for phpbb in a while, however from memory it looks about the same.
table names are different, I noticed that, I'll have to edit the db file before I import it.

what i'm most worried about is users - since they are shared between phpbb and phpnuke.

I wont be too worried if i have to delete my (4) phpnuke users to import the db, but what has changed in the schema.

also, are there any other schema differences between the two pieces of software?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 11-15-2004, 09:00 PM
Senior Member
  
Join Date: Sep 2002
Posts: 2,905
http://nukeresources.com/downloadvie...e_NukeSQL.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 11-15-2004, 09:48 PM
Junior Member
  
Join Date: Nov 2004
Posts: 4
Thanks! This is exactly what I was looking for.

I was about to start converting this other database by hand!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 11-15-2004, 11:25 PM
Junior Member
  
Join Date: Nov 2004
Posts: 4
with a little modification to the db's after conversion I was able to get 2.0.5 (phpnuke) working with phpbb 2.0.10

there was one field missing from the forums table, and for some reason it didnt convert the phpbb_themes or phpbb_themes_names or phpbb_options tables.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 11-16-2004, 08:02 AM
Senior Member
  
Join Date: Sep 2002
Posts: 2,905
Originally Posted by Cisien
with a little modification to the db's after conversion I was able to get 2.0.5 (phpnuke) working with phpbb 2.0.10

there was one field missing from the forums table, and for some reason it didnt convert the phpbb_themes or phpbb_themes_names or phpbb_options tables.
excellent.

I am going to sticky this topic for future reference.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 11-16-2004, 06:00 PM
Junior Member
  
Join Date: Nov 2004
Posts: 4
tonight I'm converting the real forum. last night was only a quick test forum i made.

I'll take notes on the process i went through to convert from phpbb 2.0.10 to nuke (version 7 phpbb module version 2.0.5)

------edit below-------

Well, the old site admin never got around to upgrading so I was moving from phpbb to phpnuke.

I had to make the same changes with this move as I did on my test 2.0.10 board.

the changes I had to make were:

prior to running the nukesql php script modify the phpbb_forums database. Add a new coloum to this table titled "events_forum", this table's values are: tinyint (1), null, default:0

I dont know if this is an issue with the default phpnuke install, but I was experimenting with my php nuke install and had made some phpbb forums. So prior to running this script I emptied all nuke_bb* tables and nuke_users. Anyway, I had to import the phpbb_config table into nuke_bbconfig by hand and, ofcourse, update the values to reflect the new site.

I had to do the same with the nuke_bbthemes and nuke_bbthemes_name tables - i had to convert them by hand from phpbb to nuke.

I used phpmyadmin for these updates, I also did not start from a fresh nuke install, i instead emptied all the tables that this script would modify (and some it did not) so you may not have to go through some of these steps when upgrading your own board.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 08-02-2005, 10:05 AM
Junior Member
  
Join Date: Apr 2005
Posts: 4
Code:
 
On-Screen Error Log
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 150

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 158

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 166

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 175

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 183

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 191

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 199

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 207

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 215

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 223

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 231

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 239

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 247

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 255

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 263

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 271

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 279

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 287

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 295

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 303

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 311

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 319

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 327

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 335

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 343

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 351

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 359

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 367

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 375

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 383

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 391

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 399

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 407

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 415

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 423

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 431

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 439

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 447

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 455

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 463

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 471

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 481

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 491

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 499

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 509

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 518

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 527

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 536

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 544

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 552

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 562

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 570

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 578

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 587

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 596

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/warlock/public_html/unreal2/nukesql.php on line 604
Here is what i did: Install nuke, import my current phpbb sql to the sql i installed nuke sql database on. Upload the script to the rightful directory.
try to run got that. chmod the script to 77, but same thing happened.

my version of phpnuke is 7.5
the forum is 2.x or the latest version.

I really want to use phpnuke. but dont want to loose my forum's data because its alot. please help. thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 02-23-2007, 11:27 AM
Junior Member
  
Join Date: Feb 2007
Posts: 1
<spam>

For anyone wondering, should you see new members with a .ru extension, ban them on site because they all seem to spam.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Issue with Admin Users | event / Calendar module »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import phpbb to nuke platinum database jendean71 Open topics 2 06-21-2006 03:35 PM
Error importing form phpbb to phpnuke PRM_Punisher Nuke 7.x - Modules 2 03-10-2005 02:25 PM
phpbb database converter to Nukemods database palooka Open topics 3 06-15-2003 10:57 AM
Importing posts and users from phpBB-2.0.6-Port-Beta1 TheSpAwN Purged Topics 7 05-15-2003 01:34 AM
importing some parts from a dump of stand alone phpbb to nuk Kelu Purged Topics 0 05-10-2003 11:54 AM


All times are GMT -5. The time now is 11:13 PM.
Contact Us - Nukemods.com - Archive - Top

Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.

LinkBacks Enabled by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31