I've released my Snitz Forums to PHPBB / PHPNuke (bbtonuke) converter (2 converters included, one for Nuke and one for BB). This script fully migrates all forums, forum structure, topics and posts. It also merges user databases - more on this in the documentation. Snitz code to BBCode is done for all topics, and the forum search tables are properly set up.
No code changes, mods or hacks to the PHPBB / PHPNuke source are required, and all posts/topics are ordered correctly after migration. Simply run the converter and that's it.
Note, I only had limited Snitz test data to do this with and it has only been tested with Nuke 7.6 and PHPBB 2.0.21, but should work for other versions.
You may need to apply the following patch to the converter (if in doubt, apply it). Before running the converter, open Snitz2PHPBB.php and go to line 1047. You should see:
Code:
$query = "SELECT * FROM ".$snitz_topics." WHERE `TOPIC_ID` >= ".$nexttopic." ORDER BY `LASTACTIVITY` ASC LIMIT ".$nexttopic." , ".$LOW_MEMORY_MAXTOPICS;
Replace this line with:
Code:
$query = "SELECT * FROM ".$snitz_topics." ORDER BY `LASTACTIVITY` ASC LIMIT ".$nexttopic." , ".$LOW_MEMORY_MAXTOPICS;
Save your changes and begin the migration as normal.
Cheers!
Last edited by Endeavour on Sat Feb 17, 2007 11:47 am; edited 1 time in total
0. Changelog
---------------------------
v0.2 - Fixed duplicate topic issue caused by Snitz leaving ghost topics
behind (apparently when moving posts etc). Duplicate topics have
the oldest topic deleted. This won't affect posts.
- Add fixup for the userid auto_increment to match the actual next
id.
- Fixed a bug in the posts migrator, where the link to move to the
next stage of the low memory migration wasn't updated with the
correct params.
- Added option to skip the Snitz table fixup stage - useful if you
have to run this script more than once as fixup only needs to be
run once.
_________________ Stand up for courtesy and decency in the Nuke community, don't support nukeforums.
v0.3 - Re-release of 0.2 mainly because there was a screwup with the
previous package, which didn't include all the fixes.
- Fixed a bug where the user's first name wasn't migrated
- Join dates appear properly in PHPBB migration now
IMPORTANT: Patch to 0.3 is required. Please see the first post in this topic.
_________________ Stand up for courtesy and decency in the Nuke community, don't support nukeforums.
Last edited by Endeavour on Sat Feb 17, 2007 11:48 am; edited 1 time in total
n3m3sis Nuke Cadet
Joined: Jan 23, 2007
Posts: 7
Posted:
Tue Jan 23, 2007 9:03 am
Hi i have a running phpbb forum whit ofcourse its own database. I installed phpnuke 7.6 latest patch,Imported the nuke.sql trough phpmyadmin in another created database(same server) ,i made my Super user/admin in phpnuke.
Forums in phpnuke i didnt touch anything,no one registered. Well i upload all the Snitzz files to my webroot and configured to the converter wich is snitzz2nuke. During the process it stopped and says this:
Code:
MySQL query error!
Query was: INSERT INTO nuke_users (`name`, `username`, `user_email`, `user_website`, `user_regdate`, `user_password`, `user_active_cp`, `user_interests`) values ('SNITZ MIGRATION', 'Snitz User', 'noone@localhost.com', 'http://www.amazingbrass.co.uk', 'Jan 23, 2007', '4a24c0544fe757efc522a3079d9db4a3', 'YES', 'This is a catch-all user for posts from deleted/invalid user accounts. It was created during the Snitz forum migration. This is not a real person!')
mysql_errno = 1044
mysql_error = Access denied for user 'my_databasename'@'localhost' to database 'my_databasename'
extra info = Couldn't add the catch-all Snitz user into the Nuke user table
So whats wrong??
Evaders99 Site Admin
Joined: Aug 17, 2003
Posts: 12482
Posted:
Tue Jan 23, 2007 10:58 pm
Code:
Access denied for user 'my_databasename'@'localhost' to database 'my_databasename'
Indicates that one of the database settings is not correct. I don't know how this script functions, but somewhere you need to place the correct database user information
Thanks a lot! for looking at the problem,problem is solved ,i used another method to integrate phpbb to phpnuke ,whit phpbbtophpnuke from This site : http://evaders.swrebellion.com , And lol you are the author? Excellent script,worked immediately.
Only thing is i have a small few problems/bugs , My avatars arent working cant either upload them trough ,forum profile,but when i select it trough phpnuke i can select a avatar.(edit: I also enabled the abbitliy to upload avatars trough Php administration Panel.)
I would be very very thankfull , if you could help me out whit right side blocks,like on your website i want userinfo at the right side in the home page. You could take a look at my site: http://nuclear-madness.com.
Thank you very much,if you could help me answer this.
Endeavour Corporal
Joined: Oct 22, 2006
Posts: 59
Posted:
Wed Jan 24, 2007 5:42 am
n3m3sis, I did answer your question on the phpbb forums, but glad you got it solved.
I'm not sure why you went Snitz -> PHPBB -> PHPNuke, the converter can go directly from Snitz -> Nuke. But anyway, you've done it.
_________________ Stand up for courtesy and decency in the Nuke community, don't support nukeforums.
n3m3sis Nuke Cadet
Joined: Jan 23, 2007
Posts: 7
Posted:
Wed Jan 24, 2007 5:40 pm
Thanks for the support Endeavour,i got it solved. I think you dont support phpbbtophpnuke ,but got a question wich is:
Why i/users cant upload or select a avatar trough forum profile? That seems to be only problem i got so far since the integration. Since im low level at php dont know were to start?? Would appreciate help very much!
Maybe the script didn't convert avatars phpcode to phpnuke?
Endeavour Corporal
Joined: Oct 22, 2006
Posts: 59
Posted:
Thu Jan 25, 2007 8:41 am
My converter does correctly bbcode-ify all the snitz code, but if your users can't upload an avatar that's a problem with your nuke config, not with the conversion.
_________________ Stand up for courtesy and decency in the Nuke community, don't support nukeforums.
Evaders99 Site Admin
Joined: Aug 17, 2003
Posts: 12482
Posted:
Thu Jan 25, 2007 10:40 pm
Right, check the Avatars directory in your Forums Config and make sure you have that directory permissions set correctly
modules/Forums/images/avatars/ and the gallery folder isnt for phpbb gallery it is for phpnuke your account is that right? Anyway im lost,i think something whit the code is corrupt or something.
n3m3sis Nuke Cadet
Joined: Jan 23, 2007
Posts: 7
Posted:
Mon Jan 29, 2007 2:46 am
Does any one know this bug problem? Evaders99,you released that script:phpbbtophpnuke , Do you maybe know what the problem is and how i can fix this?
I tried everything ,chmoded Avatars directory to 777,configured the path to the avatars in the forum admin configuration still no succes it seems like it resets itself to the default path.
In your script after the install is finished succesfull,at the bottom it says some script you have to add them manually,wich i dont know how
Could you please help me out it looks like crap those X images,in my forum.
Evaders99 Site Admin
Joined: Aug 17, 2003
Posts: 12482
Posted:
Mon Jan 29, 2007 10:05 pm
I don't know, if your path is set to modules/Forums/images/avatars/ with the proper permissions, and your files are there, it should be working
modules/Forums/images/avatars/ tried it ten times,it automaticilly goes back to : images/avatars/.
So you dont know if your script imports the configuration of the avatars ?
Your script is very nice and fast ,only thing that is a current BUG i think is this problem.
Ive tried every possibility ,folder permissions on Avatars 777 also Gallery 777 . Tried to change the path to modules/Forums/images/avatars/ after i click save in php Admin and i look if its modules/Forums/images/avatars/ i see again images/avatars
It is resetting itself to the old path ,maybe there must be something wrong in the phpbbcode table of avatars?
Do you have something usefull whit these details? Thank you
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
