phpBB2phpNuke

[Evaders99]

"import data from old board"
- if by that, you mean moving your old phpBB tables into the same database, yes.
The script should do the rest. If not, please post the error messages as you did above
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

[ShotoKan]

Hey Evaders

I've run the script a few times now and every time i run i got that weird problem about dupkey. I end up finding that those records on the table are not really duplicated since they have something that is different.

The whole issue is with only one table the search_bbworlist and let me try to explain that. Let's say that for are reason i two words like that on the table "jose" and another "josé" the mysql Db does not complain about that but when i run the script I got dupkey and the script stops.

the problem is that since now i am trying to convert the entire phpbb DB I am getting lots of those dupkeys and i was wondering if there was a way to change the code to every time i got this error make it ignore and keep going.

[Evaders99]

Hmm well, instead of using "INSERT" you could use "INSERT IGNORE"
May or may not work correctly

Can you give me the exact duplicate key error message?
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.

[ShotoKan]

Rightnow would be difficult because i would have to first load my phpBB tables and then run your script but like i said the error only happens at the search_worldlist table and with values that are almost identical and the difference most of the times are because of a CAPS in one of the letters.

The error is like i mentioned before ig gives me a "can not insert record due to a dupkey" and then is shows the value like "corporal" and when i select this on the phpBB DB i find "corporal" and "corpôral" so when i delete one of those it passes until it reaches onother one.

EDIT: I was able to load and runthe script again. Here the exact error

[Evaders99]

This may or may not work. At most, it could stop the search from functioning or could be very slow searching

In phpMyAdmin, run

[ShotoKan]

Do you think the "INSERT IGNORE" would not work for these cases? I am just a little bit woried about removing the primary key and stop the search from working.

[FragInc]

I am getting this error upon attempting to run phpbb2phpnuke.php:

"Cannot connect to phpNuke's bbconfig table. Please check your phpNuke prefix settings in phpbb2phpnuke_config.php"

I have merged the phpBB and phpNuke databases and modified the phpbb2phpnuke_config.php file as noted below and yet I am
getting that error. Not sure what I have done incorrectly.

Thanks!

My original phpBB config.php:

$dbms = 'mysql4';
$dbhost = 'localhost';
$dbname = 'fraginco_phpbb1';
$dbuser = 'fraginco_phpb1';
$dbpasswd = '**********';
$table_prefix = 'phpbb_';
define('PHPBB_INSTALLED', true);

My original phpNuke config.php:

$dbhost = "localhost";
$dbuname = "fraginco_nuke1";
$dbpass = "**********";
$dbname = "fraginco_nuke1";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "**********";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$tipath = "images/topics/";
$nuke_editor = 1;
$display_errors = false;

My phpbb2phpnuke_config.php:

$dbhost = "localhost";
$dbuname = "fraginco_phpb1";
$dbpass = "**********";
$dbname = "fraginco_phpbb1";
$nuke_prefix = "nuke";
$user_prefix = "nuke";
$phpbb_prefix = "phpbb";

[Evaders99]

[FragInc]

I apologize for taking so long to respond. Thank you for the help also.

I was able to get the db migration completed. Did find some errors with the login list though. Seems
that names that include ASCII symbols do not transfer well. A few member names were garble after
migration and required manual editing.

Still working on a few other things too. I did have a question about avatars. Is there a simple way of
migrating the old avatars to phpNuke forums or do they have to be individually uploaded again.

Thanks again for your help. It is most appreciated!

[mads]

[Evaders99]

[mads]

right, done that. ran your script and got the following error:

[Evaders99]

Seems like you are missing an update
Run this in phpMyAdmin

[mads]

just looked at table and no users were transferred. i did as you said...

installed phpnuke v7.9
upgraded BB2Nuke incremently through the stages and then imported the data from old board. ran your script.

should i still run what you suggested through phpmyadmin?

[Evaders99]

Yes run what I suggested in phpMyAdmin please, and try again
_________________
Evaders99
Webmaster
Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.