Converting phpnuke forum - > SMF

Started by russ, October 10, 2004, 05:49:46 PM

Previous topic - Next topic
Print
Go Down Pages 1 2 3 4
User actions

halochat

#60
December 28, 2004, 01:18:49 PM
Now, I am not sure what you all have been trying (I just quickly looked through to be sure that this hadn't already been used), but let me show you what I did...

I used hxxp:www.phpbbhacks.com/forums/viewtopic.php?p=169022&highlight=phpnuke#169022 [nonactive] at hxxp:phpbbhacks.com [nonactive] to change from phpnuke to phpbb.

Follow his instructions carefully, you're going to need it.

Be sure to check hxxp:www.phpbbhacks.com/forums/viewtopic.php?p=172501&highlight=phpnuke#172501 [nonactive] as well - it happened to me (I'm correcting it when I actually move my site over...  I've been testing with it lately)

Then, use the phpbb to smf converter, and you're done.

Here is my current forum (this link will go dead on January 1st):  hxxp:halochat.edgegaming.com/new/forum/ [nonactive]

This is just what I did.  I got it to work.  I'm sure what you have been doing works well too, I just thought I'd throw in my 2 cents worth.

Good luck, and enjoy SMF.

Jaanz

#61
December 28, 2004, 02:00:04 PM Last Edit: December 28, 2004, 02:31:48 PM by Jaanz
Only problem now is that i'm not an Administrator... but i'm trying to figure that out myself right now. :) Thanks again.

Edit: Ok, now is that thing fixed. I just modified database.

[Unknown]

#62
December 28, 2004, 07:12:13 PM
Quote from: Jaanz on December 28, 2004, 09:48:39 AM
That was a strange one, because i had a problem (first time) to install SMF, i had to change

All that did was bypass the check; your server is still not configured properly, and your host definitely should fix it.

-[Unknown]

Jaanz

#63
December 29, 2004, 12:45:17 AM Last Edit: December 29, 2004, 12:47:04 AM by Jaanz
Yeh, i did other change in that line before my newest installation:

if ((session_save_path() == '/tmp' && substr(__FILE__, 1, 2) == ':\\'))
to
if ((session_save_path() == 'C:\\tmp' && substr(__FILE__, 1, 2) == ':\\'))

I think that should be ok?
(i'm hosting because it's in my home computer :))

[Unknown]

#64
December 29, 2004, 12:45:26 PM
Again, that's just bypassing the check.  Really, you should fix the setting itself in php.ini (session.save_path.)

-[Unknown]

Jaanz

#65
December 30, 2004, 01:29:53 PM
Ah, now i get it (little bit slow am i? :D)
I opened that php.ini file and there is a path to the /temp so actually i didn't do anything wrong? Or could you explain to me what is going happend if i don't reinstal SMF and leave it like it is now?
I'm sorry but i don't understand what harm it could do if i leave it like that...

packman

#66
December 30, 2004, 02:40:52 PM
If you fix the problem in SMF then next time you apply an SMF upgrade that changes the file you've modified you'll lose the change. Best case, you remember to make the change each time you upgrade SMF and just have some extra work to add onto each upgrade. Worst case you forget what the required change is and you end up with extended downtime whilst you debug and fix the problem (again).

If you're hosting the forum on your own PC, just fix PHP. That fixes the source of the problem and also means that sessions work in any other PHP code you want to use.
Chris

Jaanz

#67
December 31, 2004, 02:31:23 AM
Well i just updatet my SMF RC2 -> Final and there wasn't any problems.
Yeah, i'll fix that php.ini file, thanks again to all of you for help.

Jae

#68
January 23, 2005, 07:17:45 PM Last Edit: January 23, 2005, 07:26:23 PM by Jae
Wow, there has been a lot of action here since I last posted.

packman, thanks so much for the suggestion - when I copied the nuke_users table over to nuke_bbusers, the converter worked great.  The only things that didn't come over were some of my users' avatars (I can import those manually if I need to).

One other quick question:  Hengis, how did you fix the problem with all the users coming over as administrators?  Did you do that manually or was there a tweak you made somewhere?

Thanks to everyone who contributed to this thread!   :)


EDIT:

Okay, maybe I spoke a little too soon - I can't modify the user profiles (change groups, etc) because the users' registration dates didn't come over.  They're all listed as N/A.  Anyone have any ideas on how to fix that one?

[Unknown]

#69
January 23, 2005, 11:32:11 PM
You should be able to enter something like "0000-00-00".

-[Unknown]

Jae

#70
January 24, 2005, 04:32:44 PM
I am able to re-enter the users' registration dates manually.  Apparently PHP-Nuke's version of phpBB uses varchar(20) as the field type for registration dates, while phpBB and SMF use int(), I think?  Anyway, I'm not really sure how to change that in the database, so I'm settling for changing all of them manually.

scott_68

#71
February 02, 2005, 03:35:04 PM
Mhhh millions of users have NUKE & phpBB installed and millions want to change to SMF.
Dear admins would it be to hard to make a nice " how to " simple for newbies ?  I just understand half of the above written posts and would like to change from my nuke to SMF.
So please  help  :-[

( Is there no php/sql gurus here that can write such converter for nuke ? )

Jae

#72
February 09, 2005, 10:10:18 PM
Scott,  here's what worked for me:

I made a copy of my nuke_users table in my database and named the copy nuke_bbusers, like packman said.  That enabled the phpBB converter to find the user information it needed to make the conversion.  There were a few glitches (my users came over as admins, and my admins were users), but that was easily fixed with a command I ran in the MySQL Admin tool (can't remember it right now, but I'll look for it).

JJHayesIII

#73
March 19, 2006, 12:34:44 AM
Just went through the process of moving to SMF from PHPNuke, and figured I'd add some info...
Wasn't TOO painful...

I used the methods posted from the first page:
- directly modifying the phpBB2 conversion script
- users came over as admins/admins as users
Code Select
UPDATE smf_members SET ID_Group = 0 WHERE memberName != 'admin'
UPDATE smf_members SET ID_Group = 1 WHERE memberName = 'admin'
- Registration dates didn't transfer (where nuke/smf tables are in same db):
Code Select
UPDATE smf_members, nuke_users set smf_members.dateRegistered = UNIX_TIMESTAMP(STR_TO_DATE(nuke_users.user_regdate, '%b %d, %Y'))
WHERE smf_members.memberName = nuke_users.username;

linebacker

#74
May 13, 2006, 03:30:02 PM
Just thought I'd say thanks to everyone who contributed on this one, followed the instructions from packman and Hayes and it worked perfectly. nice one!

DaButcher

#75
August 29, 2006, 03:52:06 PM
Hi,
I cant get it to work :S

I tried duplicating the nuke_users to `nuke_bbusers` and inserting the correct data.

However, the convert still crashes :S

Code Select

Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
    u.user_regdate AS dateRegistered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
    u.user_new_privmsg AS instantMessages,
    SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessages,
    SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
    SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
    SUBSTRING(u.user_icq, 1, 255) AS ICQ,
    SUBSTRING(u.user_yim, 1, 32) AS YIM,
    SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
    SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
    u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
    IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    '' AS memberIP2
    FROM `bergengatebilklu`.nuke_users AS u
    LEFT JOIN `bergengatebilklu`.nuke_bbranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `bergengatebilklu`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != 1
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

    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 'AS emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessag' at line


Any help would be appriciated!!

Gavin Chatt

#76
December 24, 2006, 03:56:24 AM Last Edit: December 24, 2006, 04:36:28 AM by Gav-Aus
Sorry to drag up an old thread but is seems to best so far from my searching "lol"

Hello all, I'm new to SMF and love the layout and ease for use. I would like to convert however I'm also moving hosts so heaps to do I guess.

So far things have been great however come to the Converting topic notificationsI'm Unsuccessful! with the following error.

Code Select
Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Unsuccessful!
This query:
INSERT INTO `austeam6`.smf_log_notify
(ID_MEMBER, ID_TOPIC)
VALUES ('11', '28'),
('16', '30'),
('10', '41'),
('25', '49'),
('10', '30'),
('10', '74'),
('25', '76'),
('10', '78'),
('10', '96'),
and so on..........

Caused the error:

Duplicate entry '11-28-0' for key 1

I select try again but same result. Would someone mind suggesting where to from here.

Steps take so far:

1. Backup of old database from HOST A
2. Created database on HOST B (Both phpnuke data and SMF data)
3. Copied SMF files to new HOST B
4. Downloaded phpnuke and installed on HOST B in folder /phpnuke
5. Transfered all phpnuke files to HOST B (V7.8) in folder /phpnuke
6. Import of old data based to HOST B database named austeam5
7. Created folder called /forums for SMF files and uploaded files
8. Downloaded convert files (smf_1-1-1_phpnuke_converter) uploaded to phpnuke folder
9. started convert with above error.


Thanks in advance.

Kind Regards
Regards
Gavin Chatt
Austeam Founder
http://austeamracing.com.au

Gavin Chatt

#77
December 26, 2006, 05:20:55 PM Last Edit: December 26, 2006, 05:39:44 PM by Gav-Aus
Read and re-read and search some more and managed to get my issue down to the following:

Code Select
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/c0a801013db4321a4f2d4.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d23286da3daaa4728d793.png) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d9870e273d3d587ad66fa.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb3382cf3d933be81974e.gif) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cbdc65193d7ea1d828df1.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb2d95743d86a9b52e668.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:...................................................... more date etc:

Caused the error:

Duplicate entry '46249-61' for key 3

Does this mean my issue is the smae where the users/members were unable to be transfered amd as suc the posts and threrads don't show ?

I have been up this time round 24 plus hour working on different areas of the site due to the host move "lol" (wife is playing Startcraft with my son all night ;D) I ahve read you (I) should copy the users table vreating a new table named nuke_bbusers and ensure the data is sopied as well.

I have created the table however have no idea on how to copy the data to it, can someone provide a newbe the process needed to create table (to ensure mine was done right) and copy from one table to another please?

EDIT# Almost forgot, once the tranfer is complete am I amle to delete / drop all non smf data tabnles from the data base?
Regards
Gavin Chatt
Austeam Founder
http://austeamracing.com.au

Gavin Chatt

#78
December 27, 2006, 07:29:33 PM Last Edit: December 27, 2006, 07:55:58 PM by Gav-Aus
G Day Again,

I'm almost done :)

However like others have an issues with the the topics, I tried the phpbb converter as well and that failed has anyone got a suggestion.

BTW, I have (and still am) searching through and reading other posts here.

Not concerned about avatars

Code Select
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/c0a801013db4321a4f2d4.jpg in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/c0a801013db4321a4f2d4.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d23286da3daaa4728d793.png in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d23286da3daaa4728d793.png) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d9870e273d3d587ad66fa.jpg in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/d9870e273d3d587ad66fa.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb3382cf3d933be81974e.gif in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb3382cf3d933be81974e.gif) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cbdc65193d7ea1d828df1.jpg in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cbdc65193d7ea1d828df1.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy() [function.copy]: Unable to access /mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb2d95743d86a9b52e668.jpg in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35

Warning: copy(/mounted-storage/home37b/sub004/sc29757-XAEQ/www/phpnuke/images/avatars/cb2d95743d86a9b52e668.jpg) [function.copy]: failed to open stream: No such file or directory in /mounted-storage/home37b/sub004/sc29757-XAEQ/www/forums/convert.php(816) : eval()'d code on line 35
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `austeam2`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('5767', '0', '42024', '42085', '197', '250', '27', '', '0', '8', '123'),
('5768', '0', '42049', '42200', '1076', '1076', '14', '', '0', '11', '187'),
('5769', '0', '42060', '42060', '163', '163', '14', '', '0', '0', '21'),
('5770', '0', '42063', '42063', '823', '823', '14', '', '0', '0', '29'),
('5771', '0', '42069', '42072', '211', '211', '14', '', '0', '2', '53'),
('5772', '0', '42071', '42123', '211', '1258', '61', '', '0', '11', '216'),
('5773', '0', '42080', '42116', '16', '1045', '27', '', '0', '4', '91'),


AND SO ON.......................

Caused the error:

Duplicate entry '46249-61' for key 3
Regards
Gavin Chatt
Austeam Founder
http://austeamracing.com.au
Print
Go Up Pages 1 2 3 4
User actions
Advertisement: