News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

New phpBB converter problems (was 1.1 Converters)

Started by VTX, July 06, 2005, 08:58:37 AM

Previous topic - Next topic

VTX

I downloaded the new convert.php, result:

Converting group access... Unsuccessful!
This query:

    INSERT INTO `lrt`.smf_lrt_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (18, 17, 'post_new'),
    (18, 17, 'mark_notify'),
    (18, 17, 'mark_any_notify'),
    (18, 17, 'post_reply_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'remove_own'),
    (18, 17, 'delete_own'),
    (18, 17, 'make_sticky'),
    (18, 17, 'announce_topic'),
    (18, 17, 'poll_post'),
    (18, 17, 'poll_add_own'),
    (18, 17, 'poll_vote'),
    (18, 17, 'poll_view'),
    (18, 17, 'moderate_board'),
    (18, 17, 'remove_any'),
    (18, 17, 'lock_any'),
    (18, 17, 'lock_own'),
    (18, 17, 'merge_any'),
    (18, 17, 'modify_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'move_any'),
    (18, 17, 'poll_add_any'),
    (18, 17, 'poll_edit_any'),
    (18, 17, 'poll_remove_any'),
    (18, 17, 'post_reply_own'),
    (18, 17, 'delete_any'),
    (18, 17, 'report_any'),
    (18, 17, 'send_topic'),
    (18, 17, 'split_any');

Caused the error:

    Duplicate entry '18-17-modify_own' for key 1
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

#1
Whoops, I was indeed using the wrong convert.php  :-X

Ok, used the right one now, I get this:

Converting...
Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:


    INSERT INTO `lrt`.smf_lrt_2_messages

    (ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)

    VALUES ('99948', '1982', '1119813073', '172', '[email protected]', 'Schijtprobleem', 'Jas', '1', '', '84.30.139.167', '[img]http://www.affichescinema.com/insc_g/great_fire.jpg[/img]
    <br />Maar dan anders !', '9'),

Caused the error:

    Duplicate entry '99948' for key 1
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

#2
I manually checked the phpbb database, but there is only 1 entry for post_id 99948. I now deleted this entry from phpbb_posts and phpbb_posts_text and Im now running the conversion again.

EDIT: I also disabled the phpbb board now (With the previous tries I didnt shut it down) to make sure no-one can post while the conversion is going on.
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

#3
Ok previous error is gone now, but after that i get the same old error again:


Converting...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Unsuccessful!
This query:

    INSERT INTO `lrt`.smf_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (18, 17, 'post_new'),
    (18, 17, 'mark_notify'),
    (18, 17, 'mark_any_notify'),
    (18, 17, 'post_reply_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'remove_own'),
    (18, 17, 'delete_own'),
    (18, 17, 'make_sticky'),
    (18, 17, 'announce_topic'),
    (18, 17, 'poll_post'),
    (18, 17, 'poll_add_own'),
    (18, 17, 'poll_vote'),
    (18, 17, 'poll_view'),
    (18, 17, 'moderate_board'),
    (18, 17, 'remove_any'),
    (18, 17, 'lock_any'),
    (18, 17, 'lock_own'),
    (18, 17, 'merge_any'),
    (18, 17, 'modify_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'move_any'),
    (18, 17, 'poll_add_any'),
    (18, 17, 'poll_edit_any'),
    (18, 17, 'poll_remove_any'),
    (18, 17, 'post_reply_own'),
    (18, 17, 'delete_any'),
    (18, 17, 'report_any'),
    (18, 17, 'send_topic'),
    (18, 17, 'split_any');

Caused the error:

    Duplicate entry '18-17-modify_own' for key 1


EDIT:

This is in my phpbb_auth_access for forum_id 17:

group_id forum_id auth_view auth_read auth_post auth_reply auth_edit auth_delete auth_sticky auth_announce auth_vote auth_pollcreate auth_attachments auth_mod
48 17 0 0 0 0 0 0 0 0 0 0 0 1
300 17 1 1 1 1 1 0 1 1 1 1 0 0

Edit2:

When I look at my SMF installation Im missing tons of posts. In SMF: 467 posts, in phpbb: 101471 posts. This could be caused by the conversion error?
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

s9jeremiah

Quote from: VTX on July 07, 2005, 07:47:42 AM
Ok previous error is gone now, but after that i get the same old error again:

Edit2:

When I look at my SMF installation Im missing tons of posts. In SMF: 467 posts, in phpbb: 101471 posts. This could be caused by the conversion error?


this is what I am seeing.  lots of posts are just dropping off.   - trying to figure out why...

VTX

Yes, tell me when its updated and ill give it another try :)
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

[Unknown]

Quote from: VTX on July 07, 2005, 01:31:32 PM
Yes, tell me when its updated and ill give it another try :)

Now ^_^.

-[Unknown]

VTX

Convert.php is now running. Ill update this post when its ready. (Thanks for this great support btw, I love your product!)
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

Same error:

Converting...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Unsuccessful!
This query:

    INSERT INTO `lrt`.smf_lrt2_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (18, 17, 'post_new'),
    (18, 17, 'mark_notify'),
    (18, 17, 'mark_any_notify'),
    (18, 17, 'post_reply_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'remove_own'),
    (18, 17, 'delete_own'),
    (18, 17, 'make_sticky'),
    (18, 17, 'announce_topic'),
    (18, 17, 'poll_post'),
    (18, 17, 'poll_add_own'),
    (18, 17, 'poll_vote'),
    (18, 17, 'poll_view'),
    (18, 17, 'moderate_board'),
    (18, 17, 'remove_any'),
    (18, 17, 'lock_any'),
    (18, 17, 'lock_own'),
    (18, 17, 'merge_any'),
    (18, 17, 'modify_any'),
    (18, 17, 'modify_own'),
    (18, 17, 'move_any'),
    (18, 17, 'poll_add_any'),
    (18, 17, 'poll_edit_any'),
    (18, 17, 'poll_remove_any'),
    (18, 17, 'post_reply_own'),
    (18, 17, 'delete_any'),
    (18, 17, 'report_any'),
    (18, 17, 'send_topic'),
    (18, 17, 'split_any');

Caused the error:

    Duplicate entry '18-17-modify_own' for key 1
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

[Unknown]

In phpbb2_to_smf.sql, try finding:

foreach ($this_group as $perm)

And add just before that line:

$this_group = array_unique($this_group);

Does that help?

-[Unknown]

VTX

Conversion completed ok now.

But I only have 133 messages is my smf board, while i have more than 100000 messages in phpbb.
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl


[Unknown]

What mods do you have installed on your forum?  Does a repair change anything at all?

It does indeed look like most posts aren't getting converted.  If they're in the one database and not the other... the question is why.

The converter will only drop posts if the topic doesn't exist, or if the posts_text entry isn't there.  Both are fine in your case, since phpBB works...

-[Unknown]

VTX

Quote from: [Unknown] on July 07, 2005, 03:54:37 PM
What mods do you have installed on your forum?  Does a repair change anything at all?

It does indeed look like most posts aren't getting converted.  If they're in the one database and not the other... the question is why.

The converter will only drop posts if the topic doesn't exist, or if the posts_text entry isn't there.  Both are fine in your case, since phpBB works...

-[Unknown]

I've got tons of mods installed, and made some mods myself. But none of them affect thos tables in the database.
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

#14
I get this huge error list:


The following errors are fouling up your forum (blank if none):
Topic 2 contains no messages
Topic 5 contains no messages
Topic 6 contains no messages
Topic 7 contains no messages
Topic 8 contains no messages
Topic 9 contains no messages
Topic 10 contains no messages
Topic 11 contains no messages
Topic 12 contains no messages
Topic 13 contains no messages
Topic 14 contains no messages
Topic 15 contains no messages
Topic 16 contains no messages
Topic 17 contains no messages
Topic 18 contains no messages
Topic 19 contains no messages
Topic 20 contains no messages
Topic 21 contains no messages
Topic 22 contains no messages
Topic 23 contains no messages
Topic 24 contains no messages
Topic 25 contains no messages
Topic 26 contains no messages
Topic 27 contains no messages
Topic 28 contains no messages
Topic 29 contains no messages
Topic 30 contains no messages
Topic 31 contains no messages
Topic 32 contains no messages
Topic 33 contains no messages
Topic 34 contains no messages
Topic 35 contains no messages
Topic 36 contains no messages
Topic 37 contains no messages
Topic 38 contains no messages
Topic 39 contains no messages
Topic 40 contains no messages
Topic 41 contains no messages
Topic 42 contains no messages
Topic 43 contains no messages
Topic 44 contains no messages
Topic 45 contains no messages
Topic 46 contains no messages
Topic 48 contains no messages
Topic 49 contains no messages
Topic 50 contains no messages
Topic 51 contains no messages
Topic 52 contains no messages
Topic 53 contains no messages
Topic 54 contains no messages
Topic 56 contains no messages
Topic 57 contains no messages
Topic 58 contains no messages
Topic 59 contains no messages
Topic 60 contains no messages
Topic 61 contains no messages
Topic 62 contains no messages
Topic 63 contains no messages
Topic 64 contains no messages
Topic 65 contains no messages
Topic 66 contains no messages
Topic 67 contains no messages
Topic 68 contains no messages
Topic 69 contains no messages
Topic 70 contains no messages
Topic 71 contains no messages
Topic 72 contains no messages
Topic 73 contains no messages
Topic 74 contains no messages
Topic 75 contains no messages
Topic 76 contains no messages
Topic 77 contains no messages
Topic 78 contains no messages
Topic 79 contains no messages
Topic 80 contains no messages
Topic 81 contains no messages
Topic 82 contains no messages
Topic 83 contains no messages
Topic 84 contains no messages
Topic 85 contains no messages
Topic 86 contains no messages
Topic 87 contains no messages


And that goes on for a while, it's too big  to post.
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

#15
Ok, that list was too huge to post..

Anyways, when i try to fix it:

1996 topic(s) without messages have been removed successfully

And that's not good  :P
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

ShannaraAK

I get the exact same error as VTX, 294 posts in 50 topics on SMF while the original phpbb has 28807 posts in 2842 topics ..... The members converted over, but the forums and categories are in wrong order (no biggie). This is with a non-modded phpbb 2.0.16. to SMF 1.1 Beta 3. Running the newest 1.1 converter on the first post of this thread.


[Unknown]

Tell me, then... if you run this query:

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 phpbb_topics AS t
LEFT JOIN phpbb_posts AS p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN phpbb_vote_desc AS v ON (v.topic_id = t.topic_id);


In phpMyAdmin or similar, how many rows does it return?  What is phpMyAdmin?

It's looking like I'm going to need live data to test this; is there any way I could use a backup from one of you, or just try to convert it there with an FTP account that goes to where teh converter is?

-[Unknown]

VTX

Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

VTX

I sended you a backup of the sql-tables via pm. Thanks.
Dutch bike drivers, have a look @ http://www.limburgracingteam.nl

Advertisement: