OMG Serious Nuke/PHPBB Help!!

August 11th, 2004, 7:14 pm

Omg I have done the most stupidest thing! I thought that if I backup my database on phpnuke and its forum I would be able to delete nuke then install phpbb and restore my database but I've lost it all!!!

This is what I get when I try to restore my phpbb database on my new phpbb forum

Code: [ Download ] [ Select ]

Error importing backup file

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '

1. Error importing backup file
3. DEBUG MODE
5. SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '

Then I installed phpnuke on another line to try and save it all and restore back to the original but this is what I get on that one...

Code: [ Download ] [ Select ]

Error importing backup file

DEBUG MODE

SQL Error : 1050 Table 'nuke_authors' already exists

CREATE TABLE nuke_authors ( aid varchar(25) NOT NULL, name varchar(50), url varchar(255) NOT NULL, email varchar(255) NOT NULL, pwd varchar(40), counter int(11) DEFAULT '0' NOT NULL, radminarticle tinyint(2) DEFAULT '0' NOT NULL, radmintopic tinyint(2) DEFAULT '0' NOT NULL, radminuser tinyint(2) DEFAULT '0' NOT NULL, radminsurvey tinyint(2) DEFAULT '0' NOT NULL, radminsection tinyint(2) DEFAULT '0' NOT NULL, radminlink tinyint(2) DEFAULT '0' NOT NULL, radminephem tinyint(2) DEFAULT '0' NOT NULL, radminfaq tinyint(2) DEFAULT '0' NOT NULL, radmindownload tinyint(2) DEFAULT '0' NOT NULL, radminreviews tinyint(2) DEFAULT '0' NOT NULL, radminnewsletter tinyint(2) DEFAULT '0' NOT NULL, radminforum tinyint(2) DEFAULT '0' NOT NULL, radmincontent tinyint(2) DEFAULT '0' NOT NULL, radminency tinyint(2) DEFAULT '0' NOT NULL, radminsuper tinyint(2) DEFAULT '1' NOT NULL, admlanguage varchar(30) NOT NULL, PRIMARY KEY (aid), KEY aid (aid) )

Line : 1017
File : /home/missbee/public_html/forum2/modules/Forums/admin/admin_db_utilities.php

1. Error importing backup file
3. DEBUG MODE
5. SQL Error : 1050 Table 'nuke_authors' already exists
7. CREATE TABLE nuke_authors ( aid varchar(25) NOT NULL, name varchar(50), url varchar(255) NOT NULL, email varchar(255) NOT NULL, pwd varchar(40), counter int(11) DEFAULT '0' NOT NULL, radminarticle tinyint(2) DEFAULT '0' NOT NULL, radmintopic tinyint(2) DEFAULT '0' NOT NULL, radminuser tinyint(2) DEFAULT '0' NOT NULL, radminsurvey tinyint(2) DEFAULT '0' NOT NULL, radminsection tinyint(2) DEFAULT '0' NOT NULL, radminlink tinyint(2) DEFAULT '0' NOT NULL, radminephem tinyint(2) DEFAULT '0' NOT NULL, radminfaq tinyint(2) DEFAULT '0' NOT NULL, radmindownload tinyint(2) DEFAULT '0' NOT NULL, radminreviews tinyint(2) DEFAULT '0' NOT NULL, radminnewsletter tinyint(2) DEFAULT '0' NOT NULL, radminforum tinyint(2) DEFAULT '0' NOT NULL, radmincontent tinyint(2) DEFAULT '0' NOT NULL, radminency tinyint(2) DEFAULT '0' NOT NULL, radminsuper tinyint(2) DEFAULT '1' NOT NULL, admlanguage varchar(30) NOT NULL, PRIMARY KEY (aid), KEY aid (aid) )
9. Line : 1017
10. File : /home/missbee/public_html/forum2/modules/Forums/admin/admin_db_utilities.php

Does anyone know how I can save all the info from my nuke forum and add it to my phpbb database or even try to restore my nuke forum so I can manually save all my info??? I am soooo upset and I feel so damn stupid! I have no idea what any of this means!!!

August 11th, 2004, 8:05 pm

Is that the entire first error message?

As for the second one, it just means the table it is trying to create is already there, which means your data may still be intact.

August 11th, 2004, 8:23 pm

also, restoring a nuke DB to a phpbb install won't work at all. The table structures are WAY too different. Nuke uses phpBB as it's forum, but they didn't just "tack it on", they integrated it into Nuke, much the same way the Borg assimilate other species.

(Sorry for the geeky Star Trek analogy, but hey, it fits. )P )

[Bigwebmaster]

August 11th, 2004, 8:41 pm

I would try to reinstall phpnuke and then use your database with that. Hopefully that will solve your immediate problem.

August 11th, 2004, 8:46 pm

Are you trying to run phpbb without PHP-Nuke. If this is the case, you need to edit your dump file from php-nuke to match phpbb. Be sure to back up the dump file first.

Essentially, everything in your dump file should be named:
PREFIX_tablename
where PREFIX is your PHP-Nuke database prefix.

look for anything named PREFIX_bbtablename

those are the tables you want to keep, so after you delete everything else (you did back up the dump file, right?):
Open the dump file in Notepad and click Edit>Replace Check the "Match Case" box and type in
Find What: PREFIX_bb
Replace With: phpbbPREFIX_
where PREFIX is as above and phpbbPREFIX is the prefix you assigned to phpbb when you installed it.
Click "Replace All"

save the file (so you'll have it later) and run it against your phpbb database - which should be empty(no tables at all). If everything goes well, you'll have all of your PHP-Nuke forum data inserted into phpBB.

August 11th, 2004, 8:53 pm

Forgot to mention, you're going to have to do some editing to the users tables if you want to keep all of your old users too. See, aren't you glad you backed up that dump file?

August 11th, 2004, 8:56 pm

it looks like you can just keep your PREFIX_users table - you'll have some extra fields, but nothing should break. Be sure to rename the prefix to match phpbb

August 11th, 2004, 8:58 pm

This213,
I'm 99% sure that won't work. Nuke uses a different, though similar, table structure than phpbb. As I stated earlier, nuke integrated phpbb into the software, they didn't just tack it on.
For instance, your example above would not move users over, since their table name doesn't include the _bb. It's just PREFIX_users. Also, the users table in nuke contains about 20 Nuke specific fields that do not exist in the phpbb users table, and would probably cause more mysql errors trying to import them.

In short, you cannot convert from nuke to phpbb without using a pre-existing conversion script (which I have not found yet), or writing one yourself. I think the best we can hope for in this case is to get her back running nuke for the time being.

I will work on my nuke conversion script to include all the forum data instead of just the users.

August 11th, 2004, 9:01 pm

it should work... http://www.phpbb.com/kb/article.php?article_id=109

August 11th, 2004, 9:07 pm

I'm looking at it running on my development server right now

August 11th, 2004, 9:10 pm

Calendae wrote:

it should work... http://www.phpbb.com/kb/article.php?article_id=109

ok, now where was that when I searched for "Nuke to PHPBB" on the phpbb forums 2 weeks ago?!?

One thing they forgot to mention is to change the user_id of the Anonymous user to -1, otherwise new users won't be able to register.

August 11th, 2004, 9:14 pm

My appologies, this213. I started that post before you posted the stuff about the user table.

However, I still think using the nuke tables without stripping duplicates can cause problems in the long run, since the default config of nuke allows duplicate usernames and duplicate email addresses.

August 11th, 2004, 9:25 pm

ok i'm still lost with all that. My god i feel so dumb right now

August 11th, 2004, 9:27 pm

It does???
I get an error if I try to sign up a new user with either an email address or sn that's already taken. What version of PHP-Nuke are you using?

I've got 7.2 and 7.3

Though I have to agree about the extra fields. One should actually go through the dump file and remove them - which could take some time if you have alot of users. Also, if you ever want access again into your admin section, you'll have to modify the values in the phpBBPREFIX_config table (especially script_path).

I'm just trying to get you up and running asap, you can change those values later

August 11th, 2004, 9:31 pm

What have you done thus far, Miss_Bee?