PhpBB 2.0.17 to SMF 105 wont copy my posts

[DispatcherEMTB]

When I run the converter that is in the DL section of this site it will convert most everything But will not swing over the messages for some reason.. Can anyone help me?

http://www.explorecrossroads.com/forum/ [nofollow]   is our main boards right now PHPbb2 that is,
but we want it to be your boards at
http://www.explorecrossroads.com/boards/ [nofollow]

Can someone help me?

[simonkiedyk]

I'm getting a similar error... here are the details:

Converting ranks...Successful.
Converting groups...Successful.
Converting members...
Warning: copy(/home/cite/public_html/shinigami/board/images/avatars/106744111343158861878bc.jpg): failed to open stream: No such file or directory in /home/cite/public_html/shinigami/forums/convert.php(764) : eval()'d code on line 33

Warning: copy(/home/cite/public_html/shinigami/board/images/avatars/11423297742fc7882a876a.jpg): failed to open stream: No such file or directory in /home/cite/public_html/shinigami/forums/convert.php(764) : eval()'d code on line 33

Warning: copy(/home/cite/public_html/shinigami/board/images/avatars/30.jpg): failed to open stream: No such file or directory in /home/cite/public_html/shinigami/forums/convert.php(764) : eval()'d code on line 33

Warning: copy(/home/cite/public_html/shinigami/board/images/avatars/146696404319b4f0e67a6.gif): failed to open stream: No such file or directory in /home/cite/public_html/shinigami/forums/convert.php(764) : eval()'d code on line 33
Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `cite_smf2`.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 ('2', '0', '4', '151', '-1', '-1', '1', '', '0', '3', '63'),
    ('3', '0', '3', '3', '2', '2', '6', '', '0', '0', '19'),
    ('4', '0', '5', '5', '2', '2', '4', '', '0', '0', '43'),
    ('5', '0', '6', '6', '2', '2', '4', '', '0', '0', '14'),
    ('6', '1', '7', '7', '2', '2', '8', '', '0', '0', '53'),
    ('7', '0', '8', '135', '2', '21', '7', '', '0', '1', '42'),
    ('8', '0', '9', '16', '13', '2', '4', '', '0', '1', '16'),
    ('9', '0', '10', '841', '4', '20', '4', '', '0', '17', '193'),

........list goes on........

     ('372', '0', '2671', '2675', '87', '57', '4', '', '0', '1', '16'),
    ('373', '0', '2673', '2685', '6', '2', '4', '', '0', '4', '28'),
    ('374', '0', '2676', '2684', '5', '7', '4', '', '0', '3', '21'),
    ('375', '0', '2686', '2686', '2', '2', '8', '', '0', '0', '4'),
    ('376', '0', '2687', '2688', '2', '2', '6', '', '0', '1', '2');

Caused the error:

    Duplicate entry '408-4' for key 3



The members copied fine I think so there is no real problem there, but none of my topics/posts have been copied over which is a serious problem :-)

Please respond when you can. Thanks!

[DispatcherEMTB]

Converting messages... (this may take some time)
This is where its hanging up on me, I left this from the time I posted yesterday till just now and no change, I only have a database file size of 29megs and about 1309 posts it shouldn't take that long...........anyone help?

[[Unknown]]

When I run the converter that is in the DL section of this site it will convert most everything But will not swing over the messages for some reason.. Can anyone help me?

http://www.explorecrossroads.com/forum/   is our main boards right now PHPbb2 that is,
but we want it to be your boards at
http://www.explorecrossroads.com/boards/

Can someone help me?

Would you be willing to try converting to SMF 1.1 Beta 3 Public?  I think some mods applied to phpBB are causing the conversion to cough and stumble.

The members copied fine I think so there is no real problem there, but none of my topics/posts have been copied over which is a serious problem :-)

Please respond when you can. Thanks!

It would appear you have some errors in your phpBB database.  In the phpbb2_to_smf.sql file, find:

Code Select Expand

SELECT
t.topic_id AS ID_TOPIC, t.topic_type = 1 AS isSticky,
t.topic_first_post_id AS ID_FIRST_MSG, t.topic_last_post_id AS ID_LAST_MSG,
t.topic_poster AS ID_MEMBER_STARTED, p.poster_id AS ID_MEMBER_UPDATED,
t.forum_id AS ID_BOARD, v.vote_id AS ID_POLL, t.topic_status = 1 AS locked,
t.topic_replies AS numReplies, t.topic_views AS numViews
FROM {$from_prefix}topics AS t
LEFT JOIN {$from_prefix}posts AS p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN {$from_prefix}vote_desc AS v ON (v.topic_id = t.topic_id)
GROUP BY t.topic_id

Replace:

Code Select Expand

SELECT
t.topic_id AS ID_TOPIC, t.topic_type = 1 AS isSticky,
MIN(p.post_id) AS ID_FIRST_MSG, MAX(p.post_id) AS ID_LAST_MSG,
t.topic_poster AS ID_MEMBER_STARTED, pl.poster_id AS ID_MEMBER_UPDATED,
t.forum_id AS ID_BOARD, v.vote_id AS ID_POLL, t.topic_status = 1 AS locked,
t.topic_replies AS numReplies, t.topic_views AS numViews
FROM {$from_prefix}topics AS t
LEFT JOIN {$from_prefix}posts AS p ON (p.topic_id = t.topic_id)
LEFT JOIN {$from_prefix}posts AS pl ON (p.post_id = t.topic_last_post_id)
LEFT JOIN {$from_prefix}vote_desc AS v ON (v.topic_id = t.topic_id)
GROUP BY t.topic_id

Any difference?

-[Unknown]

[DispatcherEMTB]

Tried to upgrade to both 1.0 and 1.1. Still no luck but I am letting it set on the page because I heard it can take upto six hours, so its sitting right now at the
Converting...
Converting members... successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time)
part its been there for about 2hours now.

any thing else you can perhaps think of?

[DispatcherEMTB]

This is the error that i got when i ran convert for the 1.1 and the convert is in debug mode., this is the error............. HELP PLEASE lol i am going nuts.

Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
forum_last_post_id AS ID_LAST_MSG, forum_name AS name, cat_id AS ID_CAT,
forum_desc AS description, forum_topics AS numTopics,
CASE auth_read
WHEN 0 THEN '-1,0,2'
WHEN 1 THEN '0,2'
WHEN 3 THEN '2'
WHEN 5 ELSE ''
END AS memberGroups
FROM `bbmain`.phpbb_forums
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 'ELSE ''
END AS memberGroups
FROM `bbmain`.phpbb_forums
LIMIT

[[Unknown]]

You're not using the latest files.  Please try the ones I'm attaching here.

-[Unknown]

[DispatcherEMTB]

Trying it now its put a few posts over and such, http://www.explorecrossroads.com/nexus/ [nofollow] is the site that the boards are being updated to.

[DispatcherEMTB]

I just let those files run for about 12 hours and it still has only copied a few of the posts......... ideas?
I am using the convert files and beta 1.1 public 3

[[Unknown]]

I just let those files run for about 12 hours and it still has only copied a few of the posts......... ideas?
I am using the convert files and beta 1.1 public 3

It won't show until done.  But, clearly, 1322 posts should not take 12 hours.

Where does it stop?  Does the page continue reloading?  Would you be willing to pm me the database password you've used for SMF, so I can see what it says and does?

-[Unknown]

[DispatcherEMTB]

I can't get in touch with the site owner, but I know he wouldn't let me let you know the pw.

I what it does is the page loads up  until here
Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...

then the page says done, never reloads,

ok here is the thing though i've shown you what it says and told you what the page does goto http://www.explorecrossroads.com/nexus/ [nofollow]          login is being PMed to you.

[DispatcherEMTB]

Haven't heard anything from anyone.....is there anyone who can help me or should i just give up on trying to use these boards??

[ReaperUK]

I get the following

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user: 'h2odesig_smf1@localhost' for table 'phpbb_users'

smf was an auto install from fantastico

[DispatcherEMTB]

any one help me? I sent Unknown the info and still haven't heard back from him......................i need help.

[winnet]

the problemis in your database, caused by some mods

1300 post should take max 5 min.

[Oldiesmann]

I get the following

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user: 'h2odesig_smf1@localhost' for table 'phpbb_users'

smf was an auto install from fantastico

Go into CPanel and add the user h2odesig_smf1 to the phpBB database and that should fix your problems.