Simple Machines Community Forum

I've attached the converters for 1.1 here incase they are of use to people. Please bear in mind these are beta versions - so please report any bugs you may find!

To use the new converters, first upload both "convert.php" and the file named "yoursoftware_to_smf.sql" or "yoursoftware_to_smf.php" to the same directory.  This directory can be either the directory of SMF, that of your previous software (in most cases - except XOOPS, where it should be in the same directory as XOOPS), or any other directory you prefer.  Then, access the convert.php file much like you might install.php or upgrade.php:

http://www.example.com/path/to/convert.php

From there, proceed as directed by the converter.

Grudge

Thanks a lot Grudge (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fbestgarden.net%2Fsmilies%2Fthumb.gif&hash=fef4d25799562c6654bc97f1e645bdea20079cd9)

Thanks Grudge :)

Looks like a couple small bugs in the phpbb sql

/******************************************************************************/
--- Converting boards...
/******************************************************************************/

TRUNCATE {$to_prefix}boards;

---* {$to_prefix}boards
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT, forum_order AS boardOrder, forum_last_post_id AS ID_LAST_MSG,
"2" AS memberGroups, forum_name AS name, 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'
[b]        WHEN 5
       ELSE '' END AS memberGroups,[/b]
forum_posts AS numPosts
FROM {$from_prefix}forums;
---*

** no 'THEN' after 'When 5'


---# Do all board permissions...
---{
// Select all boards/forums.
$request = convert_query("
SELECT
CASE auth_post WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_post,
CASE auth_reply WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_reply,
CASE auth_edit WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_edit,
CASE auth_sticky WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_sticky,
CASE auth_announce WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_announce,
CASE auth_delete WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_delete,
CASE auth_vote WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_vote,
CASE auth_pollcreate WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 '2,3' ELSE '' END AS auth_pollcreate,
forum_id AS ID_BOARD
FROM {$from_prefix}forums");
while ($row = mysql_fetch_assoc($request))

** after the WHEN 3 there is no THEN statement

and the last one...

Quote
Converting board access... Unsuccessful!
This query:

    INSERT INTO `test_board_-_core`.smf_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (2, 10, 'make_sticky'),
    (2, 10, 'announce_topic'),
    (2, 10, 'remove_own'),
    (2, 10, 'delete_own'),
    (2, 10, 'poll_post'),
    (2, 10, 'poll_add_own'),
    (3, 10, 'make_sticky'),
    (3, 10, 'announce_topic'),
    (3, 10, 'remove_own'),
    (3, 10, 'delete_own'),
    (3, 10, 'poll_post'),
    (3, 10, 'poll_add_own'),
   (, 10, 'post_new'),
    (, 10, 'mark_notify'),
    (, 10, 'mark_any_notify'),
    (, 10, 'post_reply_any'),
    (, 10, 'modify_own'),
    (, 10, 'poll_vote'),
    (, 10, 'poll_view');

Caused the error:

    You have an error in your SQL syntax near ' 10, 'post_new'),
    (, 10, 'mark_notify'),
    (, 10, 'mark_any_notify'),
    ' at line 17

have not had time to disect this yet..


that is all I see so far :)

Those were older versions, actually, although there were a few typos as you described in the current version.

Please note that these have not been thoroughly tested, and I would call them alpha versions, not beta versions.  Still, they will not harm in any way the forum you're converting from, and can only break the destination SMF forum.

I've updated the first post with the most recent versions.  All of the files have changed, and more than a couple things were fixed.

-[Unknown]

phpbb2 to smf 1.1

Just downloaded convert.php and phpbb2 to smf.sql and tried them on a phpbb v2.0.16 conversion.

It produced a long page of output including text from posts. After several sections it says "Successful" and next to some Database query headings it says "skipped". I don't see any error messages.

At the end of the page, it says...

Successful.

Conversion Complete
Congratulations, the conversion has completed sucessfully.

Yet no categories, boards, posts or members appear. Looking in the database via phpMyAdmin, I don't see any phpbb data in the smf tables.

How do we go about debugging this?

Same problem here. Nothing gets imported into the new smf tables, but I got no real errors, just some 'skipped' messages. After that 'Conversion complete', but nothing in there.

running the latest version of the phpbb script I am getting this error after a long line of success outputs.

QuoteDatabase query:

SELECT ID_MEMBER AS latestMember, realName AS latestRealName
FROM `crssi`.smf_members
ORDER BY ID_MEMBER DESC
LIMIT 1


Fatal error: Unsupported operand types in C:\testwebserver\xampp\htdocs\smf\convert.php on line 848

PHP Version 4.3.6
MySQL 4.0.18

I'm digging through it to see what I can find but just a heads up!

I'm having the same problem on my server:

Apache/1.3.33 (Unix)
PHP/4.3.11

Fatal error: Unsupported operand types in /path/to/smf/convert.php on line 848

This line, I'm guessing:
$row += mysql_fetch_assoc($result);

There were another two warnings that I missed earlier:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/smf/convert.php(520) : eval()'d code on line 4
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /path/to/smf/convert.php(520) : eval()'d code on line 5

Just before message:  "Recalculating forum statistics..."

I would love to see the phpBB2 to SMF converter working, too.  I was going to try to do a phpBB 2.0.16 forum to 1.1 Beta 3 conversion tonight for a massively large forum in order to ensure I didn't have to do the manual upgrade from 1.0.5 to 1.1 when it switches over instead, but it appears the converter isn't working properly yet.  The forum is for my employer at http://www.lunarforums.com/

I can convert to 1.0.5, but then I will take the heat for the manual conversion to 1.1 series when that happens b/c the main selling point to SMF was the auto upgrades in the Package Manager :D

Quote from: davo88 on July 05, 2005, 07:38:58 AM
How do we go about debugging this?

Well, I left convert.php in debugging mode... sorry about that.  So you were debugging it ;).  To fix this, download the new convert.php.  You may need to access it with this URL:

convert.php?debug=0

QuoteFatal error: Unsupported operand types in /path/to/smf/convert.php on line 848

Same problem.  Sorry about that.... but I was testing something, and I did mention they were still in testing :P.  That said, if you got no real errors, it means that things were good.

Quote from: zigie on July 05, 2005, 12:41:09 PM
There were another two warnings that I missed earlier:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/to/smf/convert.php(520) : eval()'d code on line 4
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /path/to/smf/convert.php(520) : eval()'d code on line 5

Just before message:  "Recalculating forum statistics..."

Same issue.  Again, please download the new convert.php.

-[Unknown]

I tryed it again with "debug=0" option.
Everything ran fine except group access:
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)... Successful.
Converting poll questions... Successful.
Converting polls options... Successful.
Converting polls options... 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 `forum`.smf_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (41, 1, 'post_new'),
    (41, 1, 'mark_notify'),
    (41, 1, 'mark_any_notify'),
    (41, 1, 'post_reply_any'),
    (41, 1, 'modify_own'),
    (41, 1, 'remove_own'),
    (41, 1, 'delete_own'),
    (41, 1, 'make_sticky'),
    (41, 1, 'announce_topic'),
    (41, 1, 'poll_post'),
    (41, 1, 'poll_add_own'),
    (41, 1, 'poll_vote'),
    (41, 1, 'poll_view'),
    (41, 1, 'moderate_board'),
    (41, 1, 'remove_any'),
    (41, 1, 'lock_any'),
    (41, 1, 'lock_own'),
    (41, 1, 'merge_any'),
    (41, 1, 'modify_any'),
    (41, 1, 'modify_own'),
    (41, 1, 'move_any'),
    (41, 1, 'poll_add_any'),
    (41, 1, 'poll_edit_any'),
    (41, 1, 'poll_remove_any'),
    (41, 1, 'post_reply_own'),
    (41, 1, 'delete_any'),
    (41, 1, 'report_any'),
    (41, 1, 'send_topic'),
    (41, 1, 'split_any');

Caused the error:

    Duplicate entry '41-1-modify_own' for key 1
It seems OK, though. Few things I've noticed so far:

• The smilies didn't covert, I assume this option isn't avalable yet.
  
• Post count based groups (ranks) are duplicated, i.e. there's two for every rank that I've had in phpBB
  
• Total Memebers count is 1 in the info center
  
• Number of members in member list is 100, while in the original board is 107

Same here. Boards, posts, members are there. My error has slightly different numbers in it...

This query:
INSERT INTO `dmn-test1`.smf_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(9, 25, 'post_new'),
(9, 25, 'mark_notify'),
(9, 25, 'mark_any_notify'),
(9, 25, 'post_reply_any'),
(9, 25, 'modify_own'),
(9, 25, 'remove_own'),
(9, 25, 'delete_own'),
(9, 25, 'make_sticky'),
(9, 25, 'announce_topic'),
(9, 25, 'poll_post'),
(9, 25, 'poll_add_own'),
(9, 25, 'poll_vote'),
(9, 25, 'poll_view'),
(9, 25, 'moderate_board'),
(9, 25, 'remove_any'),
(9, 25, 'lock_any'),
(9, 25, 'lock_own'),
(9, 25, 'merge_any'),
(9, 25, 'modify_any'),
(9, 25, 'modify_own'),
(9, 25, 'move_any'),
(9, 25, 'poll_add_any'),
(9, 25, 'poll_edit_any'),
(9, 25, 'poll_remove_any'),
(9, 25, 'post_reply_own'),
(9, 25, 'delete_any'),
(9, 25, 'report_any'),
(9, 25, 'send_topic'),
(9, 25, 'split_any');
Caused the error:

Duplicate entry '9-25-modify_own' for key 1

Oh, I see.  This was designed to ignore such errors.  Part of the problem is the old conversion system skipped such things.

I've updated them again.  How do they go now?

-[Unknown]

Looks much better! No error messages.

The statistics were recalculated properly, so the member count is correct now and latest member appeared (was empty before).
The Ranks are still increasing in number, though, I have 4 of each rank title now :). Could it be because I ran converter several times? I thought it was to overwrite the old data...

Will smilie conversion be added later on? I liked that option in 1.0.x

I'll keep looking for more issues and report back.

Quote from: zigie on July 05, 2005, 06:30:13 PM
Could it be because I ran converter several times? I thought it was to overwrite the old data...

Unfortunately, yes.  I'll see if I can't improve it to fix that problem.  However, you can just delete the extra groups anyway.

QuoteWill smilie conversion be added later on? I liked that option in 1.0.x

Perhaps... it was only removed for simplicity.

-[Unknown]

Looks pretty good now. No error messages from the converter - everything successful and complete.

At a quick glance, everything seems to be there. Will have to go through the fine detail but member count matches, post count is only -3 which could be a phpbb issue.

Good work [Unknown] and thank you for your fast fixes.

Thanks Guys!!!

Now everything seems to be converting Except 2 forums I am having a problem with. 

These 2 forums appear to have posted the topics until you look a little closer and you can't actually see any of the messages in the forums.
Here is the before of one of the forums:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fforum.freakscene.net%2Ftemp%2Fbefore.jpg&hash=39ba1a40945733394eb7cd3b22ba1362e409d219)

and here is the after of the same forum.
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fforum.freakscene.net%2Ftemp%2Fafter.jpg&hash=613325fd92a40a0c2fd52be288e21be481f73a04)

and the detail of where it does 'pagination' yet has no messages:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fforum.freakscene.net%2Ftemp%2Fafterb.jpg&hash=4944f37cb43cb440c9965f05cf89de15ec0aa994)

The one thing they have in common is that the permissions on both were set in such a way that only mods or admins could post new topics but everyone else could reply.  I can't help but think it is the permissions but I tried to set the permissions of these two forums on the phpbb to the same as the other forums that were successful but they had the same end result here.  Very strange!
Any ideas?

Try a recount of all forum totals and statistics, and doing a "find and repair all forum errors".

-[Unknown]

did that but that is not the actual result I was looking for.  That just removed the message counts..    I don't want rid of the counts, I want the messages associated with those copied over.  I have not found them in any other forum, they just don't seem to be in here?

I'll do another port to try again and see if it works this round.

I tried the new version uf the wbb2 converter, but it seems not working very well. The attachments are copied to the SMF-folder, but appart from this, nothing happens. There are no new entries in the SMF-tables in the database, the forum looks like before I ran the converter.

Maybe it's a bug, maybe I did something wrong. Can I give you (the developers of the converter) some more information (which information?) that helps you? I will do my best to support you with this converter.

goetzi

Quote from: goetzi on July 06, 2005, 06:07:28 AM
I tried the new version uf the wbb2 converter, but it seems not working very well. The attachments are copied to the SMF-folder, but appart from this, nothing happens. There are no new entries in the SMF-tables in the database, the forum looks like before I ran the converter.

Maybe it's a bug, maybe I did something wrong. Can I give you (the developers of the converter) some more information (which information?) that helps you? I will do my best to support you with this converter.

Try it again.  As I said above, if you used the converter while in debugging mode, you'll need to go to:

convert.php?debug=0

Quote from: VTX on July 06, 2005, 08:58:37 AM
I downloaded the new convert.php, result:

...

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

You're not using the new converter yet.

Quote from: s9jeremiah on July 06, 2005, 05:38:31 AM
did that but that is not the actual result I was looking for.  That just removed the message counts..    I don't want rid of the counts, I want the messages associated with those copied over.  I have not found them in any other forum, they just don't seem to be in here?

I'll do another port to try again and see if it works this round.

Is there a "Salvage Board" anywhere?  Is it only that board which is missing posts?

-[Unknown]

phpbb2 to smf 1.1 - Lower post count in SMF

As mentioned above, my conversion using the latest convert.php and phpbb2_to_smf.sql was completely successful. However there were 3 less posts in the post count of SMF compared to the original phpBB.

So I ran "Find and repair any errors" as [Unknown] suggested and it identified 3 empty posts. I then looked at the original topics for these missing posts in phpBB and checked every post that appeared in phpBB also appeared in SMF - they matched exactly. The three missing posts were not visible so I went ahead and let SMF fix the errors.

I have one member who frequently makes posts then deletes them. He was active in all three topics. So I believe the SMF forum is now cleaner and more accurate than the original phpBB.

Quote from:  Unknown

Quote from: s9jeremiah on July 06, 2005, 05:38:31 AM
did that but that is not the actual result I was looking for.  That just removed the message counts..    I don't want rid of the counts, I want the messages associated with those copied over.  I have not found them in any other forum, they just don't seem to be in here?

I'll do another port to try again and see if it works this round.

Is there a "Salvage Board" anywhere?  Is it only that board which is missing posts?

-[Unknown]

by "Salvage Board" do you mean the original phpBB I am porting from?  If so, yep.  I can send you the link if you like - (via PM or email would be preferred at this point if that is ok).  I am really wanting to do a test run of the port - do some thorough testing to make sure everything is kosher then I will probably do the port again just before I am ready for the new forums to go live.  The old ones are staying up until that point.

I have even created a new forum and moved 5 of the topics into it before I ran the port script and although the new forum was created in the port, the topics within had the same fate.  very strange.  I think they are cursed. ;)

I am actually looking into coding the update sql for those 2 troublesome forums but would like to get the script fixed too incase you guys hit this problem with someone else in the future.

My conversion has worked too. Actually, later on after I adjusted all the settings, the smilies from phpBB apeared as well, so I guess converter did move them. Everything seems to be in order. :D

There's only one thing I can't figure out yet. I can't seem to be able to add attachments to the posts. Maybe I just don't know how to do it... I can't seem to find an option to add attachment anywhere. I set all permissions to allow it, though.

Any ideas? Am I missing something stupid, or is it a bug?

Edit: Nevermind my question. I found the answer as soon as I did a search.
http://www.simplemachines.org/community/index.php?topic=19839.0

Quote from: goetzi on July 06, 2005, 05:08:06 PM
He is ignoring Forums/Subforums.

I don't suppose you'd be willing to send me (or just post) a dump of your "bb?_boards" table, could you?  I might very well be able to fix it with data; the problem is that I don't have an actual copy of Burning Board 2 to work with.

Quote from: s9jeremiah on July 06, 2005, 05:24:55 PM
by "Salvage Board" do you mean the original phpBB I am porting from?  If so, yep.  I can send you the link if you like - (via PM or email would be preferred at this point if that is ok).  I am really wanting to do a test run of the port - do some thorough testing to make sure everything is kosher then I will probably do the port again just before I am ready for the new forums to go live.  The old ones are staying up until that point.

Well, what I meant was - if the posts *were* converted, but something went wrong, running a "repair all forum errors" would put the posts in a "Salvage Board" in SMF.  I assume you see nothing of the sort, then?

VTX, yes... the converter isn't designed to work off a moving forum, at least not well.  What probably happened is someone deleted a post, making the converter die in surprise!

I think I've fixed the board_permissions error.  I'll be updating the first post in a few minutes - can you try it then?

I should note that if the converter isn't allowed to complete, that number will be off.  Try a "recount all forum totals and statistics" to correct it, in that case.

I should also note that I spent much of yesterday testing these converters.  With basic installs and test data, the following versions worked fine:

Burning Board Lite 1.0.2
MercuryBoard 1.1.4
MiniBB 2.0 RC3a
MyBulletinBoard 1.0 RC4
Oxygen 1.1.3
phpBB 2.0.16
Phorum 5.0.16
PunBB 1.2.5
Simpleboard 1.0.4
Snitz 3.4.05
UBB.threads 6.5.1.1-trial
UseBB 0.5.1
XMB 1.9.1
YaBB 1 Gold - SP 1.4
YaBB SE 1.5.5c

-[Unknown]

Got an error from a conversion from minibb to SMF

QuoteConverting...
Converting members...
Notice: Undefined variable: admin_usr in /home/trekkie1/public_html/forums/minibb-smf/convert.php(577) : eval()'d code on line 7

Notice: Undefined variable: Tu in /home/trekkie1/public_html/forums/minibb-smf/convert.php(577) : eval()'d code on line 8
Unsuccessful!
This query:

    SELECT
    user_id AS ID_MEMBER, username AS memberName, username AS realName,
    UNIX_TIMESTAMP(user_regdate) AS dateRegistered, user_email AS emailAddress,
    UNIX_TIMESTAMP(user_regdate) AS lastLogin, user_from AS location,
    user_password AS passwd, user_icq AS ICQ, user_website AS websiteTitle,
    user_website AS websiteUrl, IF(user_viewemail = 1, 0, 1) AS hideEmail,
    num_posts AS posts, IF('' = username, 1, 0) AS ID_GROUP
    FROM `trekkie1_minibb`.
    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 'LIMIT 0, 500' at line 9

Trekkie,

It worked fine for me. Can you confirm that you have those variables in setup_options.php (minibb directory)


$Tf='bminibbtable_forums';
$Tp='bminibbtable_posts';
$Tt='bminibbtable_topics';
$Tu='bminibbtable_users';
$Ts='bminibbtable_send_mails';
$Tb='bminibbtable_banned';

$admin_usr='admin';


Aaah.

I had downloaded convert.php the other day, I forgot about it, downloaded it again, Firefox called it convert-1, but I uploaded the old version (The one that caused problems a few pages back) and ran it, when I relised, I changed, and its just this minute converted perfectly http://t101.bravehosting.net/forums/minibb-smf/index.php

Ill clean my desktop to avoid it in future.

The converter is designed for SMF 1.1, and you are using SMF 1.0.

You're also using a bit older version than is posted in the first topic.

-[Unknown]

phpbb 2.0.16 to smf 1.1 - Avatars and smilies not displaying.

This is a repeat conversion of one I did earlier. I thought the avatars converted successfully the first time but not sure about the smilies.

I uploaded a fresh copy of smf 1.1, the latest converter files, deleted the smf tables from the database and ran the conversion again. The converter reports a successful conversion...

QuoteConverting...
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)... Successful.
Converting poll questions... Successful.
Converting polls options... Successful.
Converting polls options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

Conversion Complete
Congratulations, the conversion has completed sucessfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the phpBB2 installation.

We hope you had a smooth transition!

The avatars have been copied across to the attachments directory with names like - avatar_2.gif, avatar_4.jpg etc - but they don't display. Should they be displaying? ... or do we need to re-link to them in each member's profiles?

The smilies aren't mentioned in the above conversion report. Should they have been converted or do we need to do something else?

Quote from: davo88 on July 09, 2005, 06:00:41 PM
The avatars have been copied across to the attachments directory with names like - avatar_2.gif, avatar_4.jpg etc - but they don't display. Should they be displaying? ... or do we need to re-link to them in each member's profiles?

The smilies aren't mentioned in the above conversion report. Should they have been converted or do we need to do something else?

I'll check the uploaded avatars - although, they should still be working.  It may be because they don't have a width/height which 1.1 now uses.  If this is the case, none of the converters have been updated and so none should work.

Smileys are not done with the current converter.  How many do you have, anyway?  Seems like it's easy eough to copy them manually...

Quote from: goetzi on July 09, 2005, 09:01:18 PM
@[unknown]
Did you receive the backup of the board? If yes, does it help you?

I did, thanks.  The first post has been updated with a version that works fine on your backup.

-[Unknown]

Quote from: [Unknown]It may be because they don't have a width/height which 1.1 now uses

That's a width/height tag attached to the image is it?

Quote from: [Unknown]Smileys are not done with the current converter.  How many do you have, anyway?  Seems like it's easy eough to copy them manually...

Well, I just wanted to have all the existing smilies in existing messages display as normal. So I tried uploading the stock phpbb smiley set and installing them as the default smiley set. Put them into this subdirectory ... /Smileys/phpbb/... and made it the default set. Left all the other settings unchanged.

However, they still don't appear in phpbb converted messages. And when I open the post form, the smileys aren't displaying there either - just the red cross, file-not-found image. If I right click and look at the properties, the URL says ... Smileys/phpbb/grin.gif  ...whereas the phpbb file names are all in this format  - icon_smile.gif. And grin.gif is not a phpbb smiley.

Maybe I'm missing something, but it seems like it's looking in the ... /Smileys/phpbb/... directory but trying to use the SMF smiley filenames.  ???

If I check Enable customized smileys: and go into Add Smiley, use the drop down list under Use Existing File, both the SMF and phpbb smilies are all listed there, yet it says (using smiley set: phpbb) ... but it looks like it's using both.  ???

Then if I go into Edit Smileys, it shows phpbb in the little drop down list in the top right hand corner, yet is trying to display all the SMF smileys and giving the red cross file-not-found image. There are no phpbb smileys listed on that page. So in that case, it's still trying to use only the SMF smileys.

Better just leave it like that for the moment - so I don't get any more confused. Maybe I should do a search for smileys and 1.1? - perhaps there's something else going on.

ps... [Unknown], have a look at the code of this message, what am I doing wrong when enclosing your name in a quote tag that stops the right hand bracket displaying properly? Is it using the right hand bracket to close the quote tag? There's a bracket on the first line of the quoted message.

Quote from: davo88 on July 10, 2005, 04:33:01 AM

Quote from: [Unknown]It may be because they don't have a width/height which 1.1 now uses

That's a width/height tag attached to the image is it?

Well, it can be calculated.  In any case, I found the problem and updated the converters last night.  It wasn't that after all.

Quote
Well, I just wanted to have all the existing smilies in existing messages display as normal. So I tried uploading the stock phpbb smiley set and installing them as the default smiley set. Put them into this subdirectory ... /Smileys/phpbb/... and made it the default set. Left all the other settings unchanged.

...

You have to remember, smileys in SMF are designed so no one sees weird symbols.  For example, if one smiley set has:

:-D

Then they all have to have an image for that; otherwise, some people will see symbols and other people graphics.  This is probably the cause of your problems.

Quoteps... [Unknown], have a look at the code of this message, what am I doing wrong when enclosing your name in a quote tag that stops the right hand bracket displaying properly? Is it using the right hand bracket to close the quote tag? There's a bracket on the first line of the quoted message.

Well, you either have to use:

quote author=[Unknown] link=kljdfklsdjf date=32897

Or:

quote author="[Unknown]"

Or:

quote="[Unknown]"

For the tag.

Quote from: goetzi on July 10, 2005, 05:51:27 AM
@[Unknown]
Thanks! Now the converter is working much better. But there are still a few things that it doesn't do right:

First of all, the attachments are not shown in the posts. Maybe I do something wrong. Did you get this working on my backup?

I thought so; did you get any error messages during the conversion?  Can you try this query?

SELECT *
FROM smf_attachments
LIMIT 5;

What is phpMyAdmin?

QuoteThen there are a few things at the statistic where no value is shown: "Average registrations per day"," Average posts per day", "Average topics per day" and "Most Time Online". I don't know if it's the converters fault or if the WBB doesn't have this data.

These things are not currently converted.  Some can be extrapolated, some cannot - for example, there's probably no way to guess how many average people were online every day.  However, the number of posts per day could be approximated (although with deletions, etc., it would be off.)  Most softwares do not track these statistics at all.

QuoteEdit: It seems the - Tag isn't working too, because in the WBB2 it's written in upper case and in SMF it has to be lower case.

It does?  This works fine for me:

[iMg]http://smf/Themes/default/images/english/help.gif[/ImG]

As it should.  Perhaps the tag is formatted slightly differently in wbb2... I'll look into it.

-[Unknown]

phpbb 2.0.16 to smf 1.1 - Avatars and Smileys

Avatars

[Unknown], thanks for the updated phpBB converter - avatars now converting successfully.

Quote from: VTXOk so the converter should now convert avatars from phpBB2 correct?

Yes it converted my forum's avatars OK.

Smileys

I've got a better grip on how the Smiley manager works now and can get whichever Smiley set I want to display in SMF - (although it does seem a bit odd the way you add the new set and then de-select the originals - but that's OK).

The problem in a conversion from phpBB, is that the code used for a phpBB smiley when displayed in SMF, is different from the code used in phpBB.

Using the "twisted" smiley as an example...

- phpBB uses this code to generate the smiley -  :twisted:

- after adding the smiley to SMF, it uses this code to generate the smiley - :icon_twisted: (which is derived from the filename).

So it seems there are two ways to address this...

1. rename the smiley filenames before importing them into SMF so the code SMF derives from the filename is correct eg rename the smiley file icon_twisted.gif to twisted.gif

2. or, after conversion, go through the set of imported phpBB smileys using Edit Smileys and edit the code used by SMF to match the code used originally by phpBB eg change :icon_twisted: to :twisted:

Then they will appear in your converted forum.

Quote from: VTX... to convert the old site as smooth as possible. What I really need is an option to convert new posts/members since the last conversion. After that I can shutdown the old site and launch the new one based on SMF. Or is there another(or better) way of doing this?

My plan is to test the whole procedure on a trial site until I have every step worked out. Then, close down the phpBB forum for a few hours, or a day if necessary, do the conversion and all the bits and pieces, then open up the new SMF forum.

One of the biggest jobs for me is converting all the internal links and image links. I'm planning on doing this via a search and replace using a text editor on a dump of the freshly converted SMF database, then re-importing it with the revised links.

That seems like it will be the longest and fiddliest step.

just wanted to say thank you guys!

the last port from phpbb went very well so I am digging through my full test now.

The only error I have thus far is what I got when I tried to create the Fulltext index.

QuoteDuplicate key name 'subject'
File: /var/www/html/smf/Sources/ManageSearch.php
Line: 189

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1 Beta 3 Public, while your database is at version . The above error might possibly go away if you execute the latest version of upgrade.php.

Quote from: davo88 on July 11, 2005, 06:29:07 AM
- phpBB uses this code to generate the smiley -  :twisted:

- after adding the smiley to SMF, it uses this code to generate the smiley - :icon_twisted: (which is derived from the filename).

You can change it manually, as you said, which is a pain.  That, or you can remove all the smileys, and name the files according to the code you want (no icon_ prefix.)

Quote from: s9jeremiah on July 12, 2005, 02:58:01 PM
Duplicate key name 'subject'
File: /var/www/html/smf/Sources/ManageSearch.php
Line: 189

This shouldn't be a problem, and was a bug in SMF 1.1 Beta 3 Public for some versions of MySQL.  That said, you really should upgrade MySQL to a newer version, because SMF will perform much better.

Sorry about not answering questions for some time, I had to get work into other things - I spent a lot of times testing all of the converters several times and rewriting and writing many converters.  Hopefully things are better for it now, but there are a lot of people who want my attention (since I wrote much of the code in SMF.)

I split the following topics off of this one to try to clear things up to make support easier on me and others, and to make it easier for you to communicate back to me:

http://www.simplemachines.org/community/index.php?topic=42061.0
http://www.simplemachines.org/community/index.php?topic=42063.0

-[Unknown]

Sorry, I'm almost newbie

Ok, a new smf is install in the same database of a phpbb. What do i do with phpbb2_to_smf ?
Do i have to copy all this file and run it in mysql ? I tried yhis but it's not working.

Quote from: bjp on July 15, 2005, 02:34:11 PM
Sorry, I'm almost newbie

Ok, a new smf is install in the same database of a phpbb. What do i do with phpbb2_to_smf ?
Do i have to copy all this file and run it in mysql ? I tried yhis but it's not working.

Upload convert.php and phpbb2_to_smf.sql to your webserver, preferrably in the same directory as SMF (although it's okay to put it somewhere else.)  Then, access it via url, like so:

http://www.example.com/forum/convert.php

-[Unknown]

phpbb 2.0.3 to smf 1.1

Ok, I almost finish the conversion (330 000 topics), but it does not convert my members at all. Except this, everything is ok, but zero member !

Is there a solution ?

Perhaps it has something to do with the version of phpBB?  ... 2.0.3 is quite old now. Have you thought about upgrading to 2.0.16? - the converter works well on that.

The phpBB upgrade (changed files) package includes everything to upgrade from older versions to 2.0.16.

You can get it here -   http://www.phpbb.com/downloads.php

Hi
I just look at the phpbb_users table and compare it with 2.16, it's exactly the same.

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default NULL,
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(4,2) NOT NULL default '2.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default 'french',
  `user_dateformat` varchar(14) NOT NULL default '',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '0',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default NULL,
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;

I use the convert.php and the last phpbb2_to_smf.sql
Do i have to change something in the convert.php to be use the last phpbb2_to_smf.sql ?

QuoteI just look at the phpbb_users table and compare it with 2.16, it's exactly the same.

Yes, it does look pretty much the same as 2.0.16. However, maybe the problem is caused by something else in the database that is different.

QuoteDo i have to change something in the convert.php to be use the last phpbb2_to_smf.sql ?

No, I didn't. Just uploaded them and ran convert.php

Well, I can't use it because of zero member !!!

What is strange is that with or with out this file (phpbb2_to_smf.sql ) I have the same résult. All the post are convert, but not even one member.

Quote from: bjp on July 16, 2005, 08:10:32 AM
phpbb 2.0.3 to smf 1.1

Ok, I almost finish the conversion (330 000 topics), but it does not convert my members at all. Except this, everything is ok, but zero member !

Is there a solution ?

I have excactly the same problem with you using latest phpbb . I even tried to upload a fresh copy of smf 1.05 and update from there but didnt worked also.

Dont know what is the problem i will try tonight with a fresh copy of phpbb cause the only mod that i have installed on phpbb is user details.

I will try tonight without that also and give feedback

Are you *ENTIRELY SURE* you are not using the old phpbb2_to_smf.php file?  If you have one of these, delete it.  You want convert.php, and it must be the one attached to the first post of this topic.

-[Unknown]

I only find to download one phpbb2_to_smf.php file, in the download section of this forum.
That the fact. I did not see the new convert.php.
Sorry, I try right now with this.

Ok, everything is fine. I'm sorry for this error.
Can some one give me an advice how to delete with sql all the Personalized Picture that the people download (avatar) ... delette from FROM `smf_members` .....


Total des sujets: 18505
Total des messages: 346445
Total des membres: 28520

For uploads, I would suggest doing it through the administration center.  There's an area to manage attachments, and under that, avatars.

You can also take away everyone's avatars with this query:

UPDATE smf_members
SET avatar = '';

What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)

-[Unknown]

ok i managed to install it .The way that i did is the followin

if you are using phpbb

Download a fress copy from phpbb

backup you conf.php from the forum folder
upload all the files from phpbb

Run update if you dont know which version you got

restore conf.php in its original position

run the script convert as said

It seems the problem is the mods installed on phpbb.

Suggestion - Mark all topics as read

[Unknown],

Been testing the phpBB converter and just realized that after conversion, every topic in every forum is displayed as "new" for every user. So once the new SMF forum is established, every user has to go through every forum (37 of them in my case) and hit  "Mark Topics as Read for this Board".

Just wondering if it would it be possible to include an optional switch, so that all topics for all users are marked as "read" in the converted SMF forum?

I realize that any new topics posted in the original phpBB forum and not read by the user before conversion, will be marked as "read" in the new SMF forum. But having them all marked "new" is no better, as they can't tell what's really "new" from what's not really new - plus they then have to go through 37 forums and mark them all as read anyway.

If a switch is not possible, can I do this in the database by running a query of some sort?

Davo

I just ran the OpenBB 1.0.x to SMF convertor on a fresh install of SMF 1.1 Beta 3 Public. It was unsuccesful in converting posts. It showed a huge dump of what looks like various posts and then at the end says:

QuoteCaused the error:

    Duplicate entry '45171' for key 1

Pressing Try Again yields the same result.  :-\

I was able to log into the forum and after using the matience functions it appears that the numbers and members are alright. Trouble is, the categories, topics, and posts are messed up.  :-[

Quote from: davo88 on July 20, 2005, 08:13:46 PM
Been testing the phpBB converter and just realized that after conversion, every topic in every forum is displayed as "new" for every user. So once the new SMF forum is established, every user has to go through every forum (37 of them in my case) and hit  "Mark Topics as Read for this Board".

Actually, there's a button at the very bottom of the board index to mark everything read.  Since phpBB stores this as a cookie, it's hard to translate.

QuoteJust wondering if it would it be possible to include an optional switch, so that all topics for all users are marked as "read" in the converted SMF forum?

An option might be doable...

Quote
If a switch is not possible, can I do this in the database by running a query of some sort?

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)

Quote from: elvenjess on July 20, 2005, 10:30:27 PM
I just ran the OpenBB 1.0.x to SMF convertor on a fresh install of SMF 1.1 Beta 3 Public. It was unsuccesful in converting posts. It showed a huge dump of what looks like various posts and then at the end says:

Thanks for testing this - you're the first I know of.

Quote
I was able to log into the forum and after using the matience functions it appears that the numbers and members are alright. Trouble is, the categories, topics, and posts are messed up.  :-[

It couldn't finish, so nothing is going to be proper.  Interesting, though.  It almost sounds like there are posts with duplicate IDs or something...

SELECT id, COUNT(id) AS c
FROM obb_posts
GROUP BY id
HAVING c != 1;

If this returns any rows, your database may be... fun to convert.  If it doesn't, I may want to ask for a more complete error message - at least what table it is INSERTing INTO.

-[Unknown]

Quote from: [Unknown]INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

Thanks for this. It removed the "new" flag successfully, but left the new topic icon switched on next to each board name on the index page.

Thanks for pointing out the "Mark ALL messages as read" link too.

For that, also use:

INSERT INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

-[Unknown]

Reloaded a backup of the database fresh after the conversion from phpBB, then ran this to remove the new flag...

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

then this one to turn off the new topic icon...


INSERT INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;


Second one produced an error message and left the new topic icons on...

SQL-query:

INSERT INTO smf_log_boards(

ID_MEMBER,
ID_BOARD,
logTime
)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP( )
FROM smf_members AS mem, smf_boards AS b
MySQL said: 

#1062 - Duplicate entry '2-1' for key 1

Davo

Instead of INSERT INTO, try REPLACE INTO.

-[Unknown]

That did it!  ;D ;D

So for anyone wanting to do a global reset of all message flags for all members after conversion to SMF. run this query to remove the new flag in the topic list.

INSERT INTO smf_log_mark_read
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b;

Then this one to turn off the new topic icon on the board index...

REPLACE INTO smf_log_boards
   (ID_MEMBER, ID_BOARD, logTime)
SELECT mem.ID_MEMBER, b.ID_BOARD, UNIX_TIMESTAMP()
FROM smf_members AS mem, smf_boards AS b

Thanks again [Unknown] - your service is legendary. And these little things will make the transition so much smoother.

PhpBB 2.0.16 to SMF 1.1 B3P

I've been reported problems on 2 conversions (on 2 different installations):

- For the first one, the problem is:
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `user5648a1`.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 ('870', '0', '7727', '7788', '21', '39', '1', '', '0', '12', '65'),
('869', '0', '7723', '7974', '13', '4', '1', '', '0', '28', '239'),
('868', '0', '7712', '7752', '63', '63', '1', '', '0', '6', '51'),
('7', '0', '17', '29', '2', '2', '1', '', '0', '2', '45'),
('8', '0', '18', '21', '3', '3', '2', '', '0', '2', '29'),
('867', '0', '7709', '7722', '21', '21', '1', '', '0', '1', '31'),
('866', '0', '7708', '7747', '21', '8', '1', '', '0', '2', '30'),
.
.
.
.
.
.

('515', '0', '5564', '5568', '4', '11', '1', '', '0', '3', '28'),
('516', '0', '5566', '5573', '4', '15', '1', '', '0', '1', '28'),
('517', '0', '5569', '5570', '4', '11', '1', '', '0', '1', '25'),
('518', '0', '5574', '5658', '18', '39', '1', '', '0', '1', '62'),
('545', '0', '5685', '6040', '15', '2', '1', '', '0', '4', '47'),
('520', '0', '5576', '5576', '21', '21', '5', '', '0', '0', '27');
Caused the error:

Duplicate entry '0-1' for key 2

- For the second conversion, the error reported was:
Unknown column 'pm_email_notify' in 'field list'



Also, it appears that the internal links in posts are not converted so the links would link to posts in SMF.  Is there a way to correct this (by a SQL query) ?

Are you entirely sure you're converting to SMF 1.1 Beta 3 Public (and SMF is working perfectly) and that you are using the latest version of the converter?

-[Unknown]

Both asked for help on July 17th, and the converters were last updated the 16th.  It may be possible they have an old version of the convertor.  I'll look at it.  And I'll look at their SMF version.

I split off the OpenBB problems here:

http://www.simplemachines.org/community/index.php?topic=43093.0

-[Unknown]

Hello,

I tried the PunBB 1.2.5 convertor, but it doesn't work.  It cannot converts all my members.  I tried with and without ?debug=0.

Duplicate entry '571' for key 1

Also, the "Try again" button is useless, it tries to re-insert all rows without truncate the table or delete previous rows before.

Quote from: Ohmer on July 25, 2005, 06:55:48 PM
I tried the PunBB 1.2.5 convertor, but it doesn't work.  It cannot converts all my members.  I tried with and without ?debug=0.

Code Select Expand

Duplicate entry '571' for key 1

Is the forum live?  Are there multiple members with the same ID?  What's the full error message?

-[Unknown]

Quote from: [Unknown] on July 25, 2005, 07:52:04 PM

Is the forum live?  Are there multiple members with the same ID?  What's the full error message?

-[Unknown]

Nop, there is just one member with this ID. 

Converting members... Unsuccessful!
This query:

    INSERT INTO `iquotesfr`.smf_members

    (ID_MEMBER, memberName, dateRegistered, posts, ID_GROUP, usertitle, lastLogin, passwd, realName, location, emailAddress, websiteTitle, websiteUrl, AIM, ICQ, signature, YIM, MSN, hideEmail, timeOffset, memberIP)

    VALUES ('571', 'Coline', '1104785198', '0', '0', '', '0', 'thecryptedpassword', 'Coline', '', 'removed@email', '', '', '', '', '', '', '', '1', '0', '0.0.0.0'),

    ('572', 'Inikisha', '1104864767', '0', '0', '', '0', 'thecryptedpassword', 'Inikisha', '', 'removed@email', '', '', '', '', '', '', '', '1', '0', '0.0.0.0'),
[...]
Caused the error:

    Duplicate entry '571' for key 1


Humm.. I edited the ID for this user (571->9999) and it still bug at the same user :(.

I think you convert the members table in multiples parts.  True ?  If yes, I think you try to re-insert the last row of the first part in first to the second part (I hope you understand what I say :))

Bug in yabb to smf converter

line 2341 

if (trim($tring) == 'TRUNCATE ' . $GLOBALS['to_prefix'] . 'attachments')
removeAllAttachments();



Should be "$string"  not "$tring

I've been using this converter as my sample to create a discus converter and have been banging my head for days because of this LOL

I should have been using the 1.0 converter........... oh well.

Any solutions for my punbb convertor problem ?

where I found the converter.php to convert XOOPS. I have the sql, but the php not.

Quote from: Ohmer on July 26, 2005, 12:27:11 AM
Humm.. I edited the ID for this user (571->9999) and it still bug at the same user :(.

I think you convert the members table in multiples parts.  True ?  If yes, I think you try to re-insert the last row of the first part in first to the second part (I hope you understand what I say :))

Definitely not.  If this was so, none of the converters would work.

If you're willing to either give me a database backup, or let me test it on your server, I can probably find out what the problem is.  If it's always this user, that limits it down.  Still, it will only try to reinsert a row if the primary key on the table is broken, or people are registering while it is converting.

Quote from: [darksteel] on July 28, 2005, 07:54:45 PM
where I found the converter.php to convert XOOPS. I have the sql, but the php not.

Please read the instructions.

With the new style converters you need to upload both converter.php (sic) AND the relevant SQL file to your forum directory and execute.

-[Unknown]

I made a "REPAIR" of my users table and everything worked fine :).

Hi, I tried converting phpbb 2.0.17 to the smf 1.1 beta.

I did manage to convert it, but I am unable to re-login as the administrator! :(. Also, the member list has not been carried over to the smf.

I got this as a message during the conversion:

Converting groups... successful.
Converting members... successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Converting board access... successful.
Converting group access permissions... successful.
Copying avatar image files... successful.
Converting censored words... successful.
Converting reserved names... successful.
Converting ban list... successful.
Converting misc settings... successful.
Recalculating forum statistics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/n/notpanzcom/htdocs/smf/phpbb2_to_smf.php on line 2300

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/n/notpanzcom/htdocs/smf/phpbb2_to_smf.php on line 2305
successful.


Where do I upload the php_to_smf.sql file? should this be uploaded to the folder where all my smf files are stored?

Please help!!

QuoteWhere do I upload the php_to_smf.sql file? should this be uploaded to the folder where all my smf files are stored?

Yes.

Quote from: Vaidy on August 02, 2005, 07:01:04 AM
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/n/notpanzcom/htdocs/smf/phpbb2_to_smf.php on line

You're using the old converter.  You want convert.php and phpbb2_to_smf.sql to be uploaded, and you want to access convert.php.  Delete phpbb2_to_smf.php, it's not useful at all for 1.1.

-[Unknown]

Oh! ok. But I just downloaded the converter yesterday! I will check again! Thanks.

Amazing! It works!!

Thanks.

I just ran the 1.1 converter on a set of 2.0.17 forums twice.  All avatars converted perfectly.  I received this same error message both times:

Converting attachment mod (if installed)...
Parse error: parse error, unexpected ',' in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(548) : eval()'d code on line 56
Error in convert script phpbb2_to_smf on line 971!
Successful.

I checked the attachments folder and it only contains avatar files.  No attachments converted.

Also, all regular groups and post-counted ranks converted successfully.  All non-postcounted ranks did not transfer over.  This one goes much faster than the 1.0 does!  :)

I've updated all the converters to the latest versions.  For the record, that makes 31 converters ;).

Quote from: Celtland on August 03, 2005, 02:48:37 PM
Also, all regular groups and post-counted ranks converted successfully.  All non-postcounted ranks did not transfer over.  This one goes much faster than the 1.0 does!  :)

Forgive my ignorance; I don't know much about phpBB.  What is the difference between a "regular group" and a "non-postcounted rank"?

-[Unknown]

Quote from: [Unknown] on August 03, 2005, 03:29:32 PM
What is the difference between a "regular group" and a "non-postcounted rank"?

*lol* We had some confusions with names of membergroups in SMF, too - remember? ;)

You're far from ignorant!  :)

I was trying to use as little words as possible - it's my fault for not explaining better.  I don't know phpBB very well, either.  ;)  phpBB allows you to have the equivalent (though far from it really - SMF is superior by far) of membergroups here (you can assign permissions to them) - I'm calling them "regular groups".  phpBB also has ranks - perfectly useless as far as permissions go - they are just for show.  We have many ranks on our site - all of which are awarded (manually) based on performance rather than post count.  The converter is transferring over the "regular groups" very well, as well as administrators.  It also is tranferring the only group we have based on post counts - you need 0 posts to be in this group - it's the one new members default into when joining.  All of these gruops show up when you go into the admin area and click on Membergroups.  All of the ranks we have do not show up after converting.  Instead, every member is placed into the default group - because we all have more than 0 posts (I think).

To be honest - I can work around this no problem.  I want to get all the attachments converted more than anything.  I just installed 1.1 B3P for the first time an hour ago and would much rather use that for our new forums than 1.0.5.  Some of the files didn't convert with the 1.0.5 converter (not too many to fix manually :)).  Nothing except avatars made it over with the 1.1 converter.

Quote from: Celtland on August 03, 2005, 03:52:14 PM
I was trying to use as little words as possible - it's my fault for not explaining better.  I don't know phpBB very well, either.  ;)  phpBB allows you to have the equivalent (though far from it really - SMF is superior by far) of membergroups here (you can assign permissions to them) - I'm calling them "regular groups".  phpBB also has ranks - perfectly useless as far as permissions go - they are just for show.  We have many ranks on our site - all of which are awarded (manually) based on performance rather than post count.  The converter is transferring over the "regular groups" very well, as well as administrators.  It also is tranferring the only group we have based on post counts - you need 0 posts to be in this group - it's the one new members default into when joining.  All of these gruops show up when you go into the admin area and click on Membergroups.  All of the ranks we have do not show up after converting.  Instead, every member is placed into the default group - because we all have more than 0 posts (I think).

That's a bit different from how SMF works.  In SMF, you are always in a postgroup.  You can be in many different membergroups, but always at least, and no more than, one postgroup.

But, you'd want this as the displayed group anyway - right?  Just be warned that both "non-postcounted" and "postcounted" ranks will show, to put it in phpBB terminology.

Are they not postgroups when "rank_special" is 1?

Quote
To be honest - I can work around this no problem.  I want to get all the attachments converted more than anything.  I just installed 1.1 B3P for the first time an hour ago and would much rather use that for our new forums than 1.0.5.  Some of the files didn't convert with the 1.0.5 converter (not too many to fix manually :)).  Nothing except avatars made it over with the 1.1 converter.

The new converter I just attached should solve both the ones that didn't go this time, and the ones that didn't go before.  Tell me if not.

-[Unknown]

I ran the new converter once and got the following:

Converting attachment mod (if installed)...
Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/2.0.11_view_ip_on_thread_153.txt (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 52

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/flipstunt_656.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 52

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/mods_to_mttm_boards_143.doc (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 52

.............
.............
.............

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/cannon_202.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 52

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/misc13_568.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 52
Successful.

I skipped a lot.  I think it generated one for every attachment.

QuoteJust be warned that both "non-postcounted" and "postcounted" ranks will show, to put it in phpBB terminology.

Thanks.  I'll remember this.  :D

QuoteAre they not postgroups when "rank_special" is 1?

As far as I can tell, when "rank_special" is 1 they are ranks (membergroup with no permissions to set - in phpBB) only.  The only postgroup (the default group) that tranferred has "rank_special" set to 0.

Okay, can you try the attached?

-[Unknown]

Thanks for all of your quick responses to this.  :)

Here's what I got - for all attachments again:

Converting attachment mod (if installed)...
Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/2.0.11_view_ip_on_thread_153.txt (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 53

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/flipstunt_656.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 53

.................
.................
.................

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/cannon_202.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 53

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/misc13_568.jpg (errno=2 - No such file or directory) in /home/modstoth/public_html/smf_convertfrom_phpbb/convert.php(621) : eval()'d code on line 53
Successful.

I'm sorry.  I forgot to look at membergroups.  The default postgroup and ALL membergroups (ranks) transferred over.  All members were still placed in the default postgroup.

** Edit **

I'm not trying to be picky (because this one's a very easy fix).  Moderators from phpBB 2.0.17 are not transferring into the Moderator or Global Moderator Group.  Thanks again for all your hard work.

Quote from: Celtland on August 03, 2005, 05:41:25 PM
/home/modstoth/public_html/mttmcommunity/attachments/2.0.11_view_ip_on_thread_153.txt

So... erm... where is this file, then?  I assume it's not in the above path.

I've checked on the moderators and I think I can make it do them.  The ranks should also be fine too.  I have to test it, though.

-[Unknown]

I may have to wait to test it more.  We are changing servers righ now and started everything propagating earlier today.  I apologize if that has been the problem to begin with and again thank you for all your efforts.

i also am trying to switch from phpbb to smf, but having problems converting the topics.

i first did a check on the database to make sure there are no duplicate entry's or other strange things.
results of test:

Now checking and repairing table phpbb2_auth_access ... OK
Now checking and repairing table phpbb2_banlist ... OK
Now checking and repairing table phpbb2_categories ... OK
Now checking and repairing table phpbb2_config ... OK
Now checking and repairing table phpbb2_confirm ... OK
Now checking and repairing table phpbb2_disallow ... OK
Now checking and repairing table phpbb2_forum_prune ... OK
Now checking and repairing table phpbb2_forums ... OK
Now checking and repairing table phpbb2_groups ... OK
Now checking and repairing table phpbb2_posts ... OK
Now checking and repairing table phpbb2_posts_text ... OK
Now checking and repairing table phpbb2_privmsgs ... OK
Now checking and repairing table phpbb2_privmsgs_text ... OK
Now checking and repairing table phpbb2_ranks ... OK
Now checking and repairing table phpbb2_search_results ... OK
Now checking and repairing table phpbb2_search_wordlist ... OK
Now checking and repairing table phpbb2_search_wordmatch ... OK
Now checking and repairing table phpbb2_sessions ... OK
Now checking and repairing table phpbb2_smilies ... OK
Now checking and repairing table phpbb2_themes ... OK
Now checking and repairing table phpbb2_themes_name ... OK
Now checking and repairing table phpbb2_topics ... OK
Now checking and repairing table phpbb2_topics_watch ... OK
Now checking and repairing table phpbb2_user_group ... OK
Now checking and repairing table phpbb2_users ... OK
Now checking and repairing table phpbb2_vote_desc ... OK
Now checking and repairing table phpbb2_vote_results ... OK
Now checking and repairing table phpbb2_vote_voters ... OK
Now checking and repairing table phpbb2_words ... OK
Now checking and repairing table phpbb_addons ... OK
Now checking and repairing table phpbb_album ... OK
Now checking and repairing table phpbb_album_cat ... OK
Now checking and repairing table phpbb_album_comment ... OK
Now checking and repairing table phpbb_album_config ... OK
Now checking and repairing table phpbb_album_rate ... OK
Now checking and repairing table phpbb_auth_access ... OK
Now checking and repairing table phpbb_banlist ... OK
Now checking and repairing table phpbb_bans ... OK
Now checking and repairing table phpbb_blocks ... OK
Now checking and repairing table phpbb_cal_config ... OK
Now checking and repairing table phpbb_calendar ... OK
Now checking and repairing table phpbb_categories ... OK
Now checking and repairing table phpbb_chatbox ... OK
Now checking and repairing table phpbb_chatbox_session ... OK
Now checking and repairing table phpbb_config ... OK
Now checking and repairing table phpbb_confirm ... OK
Now checking and repairing table phpbb_connections ... OK
Now checking and repairing table phpbb_disallow ... OK
Now checking and repairing table phpbb_favorites ... OK
Now checking and repairing table phpbb_forum_prune ... OK
Now checking and repairing table phpbb_forums ... OK
Now checking and repairing table phpbb_groups ... OK
Now checking and repairing table phpbb_ignors ... OK
Now checking and repairing table phpbb_liw_cache ... OK
Now checking and repairing table phpbb_messages ... OK
Now checking and repairing table phpbb_messages_comments ... OK
Now checking and repairing table phpbb_posts ... OK
Now checking and repairing table phpbb_posts_text ... OK
Now checking and repairing table phpbb_privmsgs ... OK
Now checking and repairing table phpbb_privmsgs_text ... OK
Now checking and repairing table phpbb_quickstats ... OK
Now checking and repairing table phpbb_ranks ... OK
Now checking and repairing table phpbb_report ... OK
Now checking and repairing table phpbb_report_cat ... OK
Now checking and repairing table phpbb_report_config ... OK
Now checking and repairing table phpbb_rooms ... OK
Now checking and repairing table phpbb_search_results ... OK
Now checking and repairing table phpbb_search_wordlist ... OK
Now checking and repairing table phpbb_search_wordmatch ... OK
Now checking and repairing table phpbb_sessions ... OK
Now checking and repairing table phpbb_smilies ... OK
Now checking and repairing table phpbb_stats_config ... OK
Now checking and repairing table phpbb_stats_modules ... OK
Now checking and repairing table phpbb_themes ... OK
Now checking and repairing table phpbb_themes_name ... OK
Now checking and repairing table phpbb_topics ... OK
Now checking and repairing table phpbb_topics_watch ... OK
Now checking and repairing table phpbb_user_group ... OK
Now checking and repairing table phpbb_users ... OK
Now checking and repairing table phpbb_vote_desc ... OK
Now checking and repairing table phpbb_vote_results ... OK
Now checking and repairing table phpbb_vote_voters ... OK
Now checking and repairing table phpbb_words ... OK
Now checking and repairing table phpbb_xtras ... OK


but when converting it still gives me errors like this:

Converting topics... Unsuccessful!
This query:
INSERT INTO `fzrclub_nl`.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 ('520', '0', '4703', '4711', '156', '156', '4', '', '0', '6', '121'),
('521', '0', '4709', '4909', '15', '41', '5', '', '0', '4', '140'),
('522', '0', '4726', '4910', '41', '41', '5', '', '0', '9', '129'),
('523', '0', '4732', '4756', '136', '136', '3', '', '0', '4', '65'),
('524', '0', '4733', '4863', '156', '-1', '4', '', '0', '11', '193'),
('525', '0', '4734', '10066', '-1', '41', '4', '', '0', '3', '146'),
Caused the error:

Duplicate entry '520' for key 1


Is the forum in use?  New posts cannot be made while the converter is going, I fear.

-[Unknown]

the old forum is in use yes.

so what u say is that it is only possible to convert when the old forum is not in use? (ex: disable board?)

Yes, I'm afraid.  You only have to disable it for a few minutes.  You may not have to disable it if no one is using it, but it's just not as safe unforuntately.

-[Unknown]

tnx for the fast reply's uknown,
but still having the same error mesages :(

www.fzrclub.nl/smf is what it looks like right now, i cant even login due to nu users have been transfered ( as well as the posts)

I was getting errors like these:

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/wf-shapes_882.zip (errno=2 - No such file or directory) in /home/modstoth/public_html/community/convert.php(621) : eval()'d code on line 53

Warning: filesize(): Stat failed for /home/modstoth/public_html/mttmcommunity/attachments/mods_to_mttm_boards_143.doc (errno=2 - No such file or directory) in /home/modstoth/public_html/community/convert.php(621) : eval()'d code on line 53

And then as I was reading it over I realized... phpBB keeps all attachments in a folder called "files."  I renamed that folder to "attachments" and everything successfully transferred.  All of the attachments are in the attachments folder - however, there are no links to the attachments in any posts.

still no luck on my site :(

it keeps giving me errors on duplicate entry's


Converting topics... Unsuccessful!
This query:
INSERT INTO `fzrclub_nl`.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 ('2566', '0', '45975', '46015', '-1', '-1', '5', '', '0', '2', '78'),
('2567', '0', '45979', '46274', '505', '262', '2', '', '0', '16', '211'),
('2568', '0', '46011', '50017', '541', '530', '4', '', '0', '9', '213'),
('2569', '0', '46041', '47262', '369', '233', '9', '', '0', '17', '263'),
('2570', '0', '46080', '50338', '-1', '233', '4', '', '0', '13', '201'),

Caused the error:

Duplicate entry '2761' for key 1

i have disabled the board, i do not have acces to phpmyadmin at my work, but have a script that kan check if there are dbproblems as shown a few posts before, that script returns no errors

what do i need to do to correctly transfer my forum?
anyone who can help me with that?

Yeah - I'm an idiot.  I had attachments disabled because I didn't want anyone posting them while I was trying to get everything worked out.  They're all there and attached to posts.  Great converter, [Unknown].  Thank you for all of your help.  :)

I am converting phpbb2-->SMF and this is the message I am getting.

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.

Are both of the forums on the same domain?  If so, you may have to add permissions so that your SMF boards can access you phpBB boards (I also ran into this problem when I was converting).  If you have access to you MySQL databases - you need to add the user *name*_smf1 (or whatever number after smf is the database you plan to convert phpbb to) to the database *name*_phpbb1 (or again - which ever phpbb database you will be converting from) with ALL priveleges.

Quote from: Celtland on August 05, 2005, 02:11:41 PM
If you have access to you MySQL databases - you need to add the user *name*_smf1 (or whatever number after smf is the database you plan to convert phpbb to) to the database *name*_phpbb1 (or again - which ever phpbb database you will be converting from) with ALL priveleges.

Thanks your response!

Edit: I got the converter to start and ran into a problem converting the members. Here is the error message.

images/avatars/175689279642bd889a626a8.gif): failed to open stream: No such file or directory in /home/XXXXX/public_html/smf/convert.php(758) : eval()'d code on line 33


Caused the error:

    Unknown column 'pm_email_notify' in 'field list'


Quote from: gh0stw4lk3r on August 05, 2005, 04:05:12 AM
still no luck on my site :(

it keeps giving me errors on duplicate entry's

If it gives them even with a disabled forum, it may mean something is wrong with phpBB or with the converter.  Would you be willing to give me (temporary) FTP access?

Quote from: Jay T on August 05, 2005, 03:56:19 PM
    Unknown column 'pm_email_notify' in 'field list'

This converter is only for converting to SMF 1.1 Beta 3 Public and above, not for SMF 1.0.x.

-[Unknown]

OK, the conversion stopped here. Looks like it has something to do with a  phpbb modification I had.

    REPLACE INTO `legends_smf`.smf_settings
    (variable, value)
    VALUES ('cash_disable_spam_message', 'Quit spamming so damn much and this wouldn't happen. You will have to wait 3hrs to start receiving gold for your posts.');

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 't happen. You will have to wait 3hrs to start receiving gold for


Also, the memberlist show all the members but the total says only 1. Do they have to login in for it to actually acknowledge them?

That shouldn't be happening.  It shouldn't even be running that query.

But, you can try the attached.... which should work around it.

-[Unknown]

That solved it.

Thanks [unknown].

Hello,

since November 2002 I am using phpBB2 with the MOD´s which having SMF on Board ( Calendar, Notify Forum, Last XX Topics on Index, Attachment and and and ) Yesterday I saw SMF and was thinking to leave phpBB2, because the last security Problems and with my MODs I have now not much time to hardcoded line per line the fixes. Ok, long words short sense - Today I convert my whole Board 2.0.17 to SMF 1.1 Beta 3 Public..... what I should say .. I need 3 installations but now after 13 hours work all is running fine. BUT, I have problems with the Attachments. I see only a link inside the posting of the attachment. If i click on it, I could dowload it but the Image is not showing inside the posting as an Image. If I upload a new picture, I see it without problems. No, I am not using Thumbnails ..... I disable under Admin the show inline function and enable it again, but nothing. So what I making wrong ? I am using the default Theme and also try to switch to classic, but no help. The user rights should not be the problem, because I am the Admin of the Board. I noticed also the link inside the text posting is :

domain.com/smf/index.php?action=dlattach;topic=1123.0;attach=742
if I click on it, I must download it

If I take a look from the Admin Panel and click on the File it shows me
domain.com/smf/index.php?action=dlattach;topic=1123.0;id=742
and opens in the browser

Is this possible the problem ?

No forget it, the new Image which I upload and is showing fine as an Image inside the text having the same syntax...
domain.com/smf/index.php?action=dlattach;topic=1136.0;attach=749

Regards

Try uploading the upgrade.php and upgrade_1-1.sql files from the upgrade zip file, and running the upgrade.  This may solve that issue for you - please tell me if it does.

-[Unknown]

Thank you very much, now all the pictures are showing up -- jesus what a marathon convert day .. but now - I am a proud User of SMF ;)

Regards

Is it possible to use the YabbSE_to_SMF converter twice?  I have tried te converter first to be able to continue finishing the new layout with SMF, but the old forum has been running during that time (about 2 days). To get the latest messages and new members i have to use the converter again. But is this possible? Or will this give trobble??

Okay, I'm trying to convert my board which is actually the bbtonuke [ported phpbb V2.0.17].  I looked at the pupnuke sql and it seemed that it would go to the right tables for my board, ran the converter and it skips every INSERT/REPLACE/UPDATE/DELETE for my smf tables...bascially any query to alter my smf tables is skipped.

Any suggestions on how to convert?  I tried the phpbb sql just to see if it would work, however it doesn't..I get the '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.' 

I think that's because it's ported to integrate with nuke.  The tables for smf and nuke are in the same database.

EDIT: D'oh! Apologies, I just now spotted the php thread....sheesh...

Quote from: defensieforum on August 10, 2005, 06:14:44 AM
Is it possible to use the YabbSE_to_SMF converter twice?  I have tried te converter first to be able to continue finishing the new layout with SMF, but the old forum has been running during that time (about 2 days). To get the latest messages and new members i have to use the converter again. But is this possible? Or will this give trobble??

No, it's perfectly fine to run the converters a second time.

Quote from: Chelle on August 10, 2005, 12:11:14 PM
Okay, I'm trying to convert my board which is actually the bbtonuke [ported phpbb V2.0.17].  I looked at the pupnuke sql and it seemed that it would go to the right tables for my board, ran the converter and it skips every INSERT/REPLACE/UPDATE/DELETE for my smf tables...bascially any query to alter my smf tables is skipped.

Does it say "skipping"?  Are you sure you're using the latest version?

-[Unknown]

Unknown: wow, quick response  :D  It says this:

Database query: (skipped)

And that for every query that aims to modify my smf tables.   DLed the version in the first post..date 3 Aug..i didn't see any updated nuke sql files in the back pages of this thread or the phpnuke thread I just spotted.

Also there are these warnings as well:

Warning: mysql_fetch_assoc(): 11 is not a valid MySQL result resource in /home/donnie6/public_html/dymb/convert.php on line 649

Warning: mysql_num_rows(): 11 is not a valid MySQL result resource in /home/donnie6/public_html/dymb/convert.php on line 684

vbulletin3 = > SMF Converter not working correctly. It screws up with errors on the converting avatars part.

- Tomer

Converting topics... Unsuccessful!
This query:

    INSERT INTO `v030320`.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 ('3601', '0', '45265', '45457', '1505', '1505', '3', '', '1', '17', '364'),
    ('3602', '0', '45270', '45761', '257', '1046', '3', '', '0', '18', '372'),
    ('3603', '0', '45276', '45510', '738', '738', '2', '', '0', '4', '218'),
    ('3604', '0', '45277', '45300', '4', '3', '5', '', '0', '1', '5'),
    ('3605', '0', '45286', '45513', '4', '211', '5', '', '0', '2', '7'),
...
('3983', '0', '51968', '52409', '1194', '820', '2', '', '0', '25', '436'),
('3984', '0', '51988', '53767', '623', '623', '2', '38', '0', '133', '1475'),
('3984', '0', '51988', '53767', '623', '623', '2', '39', '0', '133', '1475'),
('3985', '0', '51992', '53624', '1805', '300', '30', '', '0', '9', '163'),
...
     ('4109', '0', '54466', '59654', '1787', '1670', '10', '', '0', '2', '222'),
    ('4110', '0', '54473', '54507', '1397', '300', '2', '', '0', '4', '157');

Caused the error:

    Duplicate entry '3984' for key 1

I get also duplicate entry error while trying to convert from phpbb2 2.0.16 to smf 1.1 pb3. Converter downloaded just 2 days ago and never before if you want to ask whether it may be an old version or not.

Quote from: Chelle on August 10, 2005, 12:23:20 PM
Unknown: wow, quick response  :D  It says this:

Database query: (skipped)

You are definitely using a very old version of the convert.php file.

Quote from: Tomer on August 10, 2005, 01:17:28 PM
vbulletin3 = > SMF Converter not working correctly. It screws up with errors on the converting avatars part.

- Tomer

Works fine for me and has worked for others.  Are you certain you are using a recent convert.php *and* vbulletin3_to_smf.sql file?  Both have been updated more than once.  If so, post the errors.

It may just be missing avatars.

Quote from: CMDR-ZOD on August 10, 2005, 10:23:41 PM
Duplicate entry '3984' for key 1

Did you lock the forum while converting?  Is it the same number every time?

-[Unknown]

Wheter I lock the Forum or not it makes no difference (tried both) and the post id is always the same. With MySQLAdmin i didnt found this post twice which should be impossible anyway because it is a auto increment integer column and set as primary key. What bothers me is that not many but some posts outputed in the query list arent sorted after id. 3489, 3490, 6391, 3491 (as example)

How's the attached one, then?

-[Unknown]

Works perfect for the posts... but the polls are corrupted the same way the posts were before.

Converting polls options... Unsuccessful!
This query:

    INSERT INTO `v030320`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES ('1', '1', 'Dorilys', '2'),
    ('1', '2', 'HSINC', '6'),
    ('1', '3', 'Khaindhar', '2'),
    ('1', '4', 'litterman', '1'),
...
('37', '4', 'Opera', '14'),
('38', '1', 'Ja habe ich! 3€ für eine gute Sache kann ich erübrigen...', '0'),
('38', '2', 'Ja ich werde es gleich machen...', '0'),
('38', '1', 'Ja habe ich! 3€ für eine gute Sache kann ich erübrigen...', '0'),
('39', '1', 'Ja habe ich! 3€ für eine gute Sache kann ich erübrigen...', '0'),
('39', '2', 'Ja ich werde es gleich machen...', '0'),
('39', '3', 'Nein, ich bin zu geizig 3€ im Monat zu verschenken...', '0'),
('39', '4', 'Mir scheiss egal ob die Tiger aussterben...', '0'),
...
     ('109', '2', 'Nö das nich aber ihr seit ja JKA, da is das scho ok', '30'),
    ('109', '3', 'Wird echt Zeit das auch mal da was unternommen wird (nich immer nur bei anderen)', '64'),
    ('110', '1', 'Ja !', '73');

Caused the error:

    Duplicate entry '38-1' for key 1

How can that work properly on phpBB's side?

I'd personally try this query:

ALTER IGNORE TABLE phpbb_vote_results
ADD UNIQUE INDEX vote_option (vote_id, vote_option_id);

Which should make the conversion work properly *and* fix some broken things.

But, whatever.  Here, use this one.

-[Unknown]

I dont know but in the vote table there realy were the entrys duplicated. Now it is the same with the vote result table.

Converting polls...Successful.
Converting polls options...Successful.
Converting polls options... Unsuccessful!
This query:

    INSERT INTO `v030320`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('10', '291'),
    ('7', '291'),
    ('10', '175'),
...
    ('8', '-1'),
    ('8', '-1'),
...
     ('18', '621'),
    ('18', '16'),
    ('18', '323');

Caused the error:

    Duplicate entry '8-0-0' for key 1

Why aren't they using unique/primary keys?

-[Unknown]

Only god knows why phpBB does something like it does but it wasnt my choice when we took that for our forum. Now same thing but different entry. I truncated the table by hand and the same error appeared again.

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

    INSERT INTO `v030320`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('102', '2293'),
    ('99', '2293'),
    ('100', '2294'),
    ('110', '2294'),
    ('76', '2295'),
Caused the error:

    Duplicate entry '81-2297-0' for key 1

Quote from: [Unknown] on August 10, 2005, 11:55:57 PM

Quote from: Tomer on August 10, 2005, 01:17:28 PM
vbulletin3 = > SMF Converter not working correctly. It screws up with errors on the converting avatars part.

- Tomer

Works fine for me and has worked for others.  Are you certain you are using a recent convert.php *and* vbulletin3_to_smf.sql file?  Both have been updated more than once.  If so, post the errors.

It may just be missing avatars.

Here are the errors.

Quote
Converting members...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...
Notice: Undefined offset: 4 in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 6
Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board notifications...Successful.
Converting smileys...Successful.
Converting attachments...Successful.
Converting avatars...
Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33
Unsuccessful!
This query:

    INSERT INTO `sdesignz_smf1`.smf_attachments
    (ID_MEMBER, avatardata, filename, avatarrevision)
    VALUES ('1', '�״�א\0JFIF\0
\0\0d\0d\0\0�ל\0Ducky\0
\0\0\0\0P\0\0�מ\0Adobe\0dְ\0\0\0
��\0,,\0

    
 
     
    �ְ\0\0P\0P
\0

�ִ\0©\0\0




\0\0\0\0\0\0\0\0\0 \0
\0


\0\0\0\0\0\0\0\0\0\0\0
\0
 \0\0\0\0
\0!1AQ\"q2a�¡ׁB±ֱbנ'3בR,#c4\'\0
\0\0\0\0
\0!1AQa�'\"נq±ֱׁ¡בR'2Bbr,C²#3¢S4��\0
\0\0?\0שץeֲ1K־
‹ֻkµG÷ַ²[_¼��Sן¶¨�«ך'¾QYו¾�׳z׳c�R@׃ .�¸8gYיnֹ\\5R˜ץ�™­״"H—‡Z[¨גּU@eֳZ�
    �ץ(׳L!�א
Lmמ$—R��}´צ·¼�-נ,,�9W1ײiCj<ׂ�
    ס<\05#©�§Pק9ל¬­ו�±...ׁ...!gצGjחR·‎Dׂ5¡־GqS�kַ·u�3��ƒ��וGzBם¬,,{¨וֹ –ק>�1´tםikc:˜ˆIג�´,²]0�\\ל
    fs –>�בwEs^±;]¿†¢

   ....more and more of this gibberish...

Thanks for looking at it.

- Tomer

I have the 1.0.5 version of SMF as the new 1.1 version is in beta stages. Can I use the Invision Power Board ( 1.3 ) coverter to convert from Invision Power Board 1.3 to SMF 1.0.5 ?

Quote from: [Unknown] on August 10, 2005, 11:55:57 PM

Quote from: Chelle on August 10, 2005, 12:23:20 PM
Unknown: wow, quick response  :D  It says this:

Database query: (skipped)

You are definitely using a very old version of the convert.php file.



-[Unknown]

Wow, that just really stirs my grits...I could have had my board converted by now.  Alright, Dunno how I did that..but I DLed it from this thread.  I'm hoping this is the updated one, and I'll give it a go.  Thanks!

Quote from: CMDR-ZOD on August 11, 2005, 02:55:24 AM
Only god knows why phpBB does something like it does but it wasnt my choice when we took that for our forum. Now same thing but different entry. I truncated the table by hand and the same error appeared again.

I've attached another converter.  Sorry for all the trouble.

Tomer, I've attached one for you as well.

Quote from: Pakistani on August 11, 2005, 05:10:32 AM
I have the 1.0.5 version of SMF as the new 1.1 version is in beta stages. Can I use the Invision Power Board ( 1.3 ) coverter to convert from Invision Power Board 1.3 to SMF 1.0.5 ?

You can use the one from the downloads page, but not the one here.

-[Unknown]

Now an error because vote_option_id dosnt exist in that table. That table only contains who voted not what he voted for.


Converting poll votes... Unsuccessful!
This query:

    SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER
    FROM `v030320`.iw_vote_voters
    WHERE vote_user_id > 0
    GROUP BY vote_id, vote_option_id
    LIMIT 0, 500;

Caused the error:

    Unknown column 'vote_user_id' in 'field list'

table vote_voters
vote_id
vote_user_id
vote_user_ip

table vote_results
vote_id
vote_option_id
vote_option_text
vote_result

table vote_desc
vote_id
topic_id
vote_text
vote_start
vote_length



Hope this might help. Im away for the weekend if you, probably you will much earlier, finish the next fix it will take some time for me to respond. :)
Have a nice one too.

Change "option_id" to "user_id" there.

-[Unknown]

I manually fixed 2 other errors of the same type with group by.

http://www.geezod.de/storage/phpbb2_to_smf.sql

Works fine with me now. Everything seems to be converted very well. Only problem my 100 message where 100 are new arent getting markes as read. But thats nothing for this forum i think. Thanks again for the quick responses. Are you rentable as support bot? *g*

Excellent! Thanks a lot!

- Tomer

Where are the latest versions of these converters, specifically for phpbb to smf 1.1. I tried dl the ones at the start of this topic, but files cant be found?

Thanks in advance.
Dill

Cant find phpBB2 to SMF 1.1 converter the link from 1st page gives a 404.
And the file from the official download section is not 1.1 compatible.

I try to convert phpbb2 2.016 with 1 security fix as a mambo component (com_forum) to convert to SMF

404 error URL (http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=9039)

I've uploaded new ones.  I expect this is a side effect from the recent server maintenance problem.

-[Unknown]

The convert.php script and phpbb_smf.sql i guess works but i did something wrong so im not sure if its basicly not compatible but i get error:
Notice: Undefined variable: Itemid in /customers/xxxxxxx/httpd.www/components/com_forum/extension.inc on line 30

Quote
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: Table 'xxxxxxx.phpbb_users' doesn't exist

I tried converting from a mambo phpbb com_forum component.
Anyway i start from scratch now(20 user lost).

Well i tried to recreate the  mos_user table to phpbb_user and when i then run the script i get:
Converting...
Converting ranks...Successful.
Converting groups...Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, u.username AS memberName, u.username AS realName,
    u.user_password AS passwd, u.user_lastvisit AS lastLogin,
    u.user_regdate AS dateRegistered, u.user_from 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, u.user_email AS emailAddress,
    u.user_unread_privmsg AS unreadMessages, u.user_msnm AS MSN,
    u.user_aim AS AIM, u.user_icq AS ICQ, u.user_yim AS YIM,
    u.user_website AS websiteTitle, u.user_website 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
    FROM `xxxxx`.phpbb_users AS u
    LEFT JOIN `xxxxxx`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `xxxxxx`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

    Unknown column 'u.user_id' in 'field list'

Ok i will try another way to restore the data - i just bridge :-p

I'm afraid for the members you're going to want to cobble together the SimpleBoard and phpBB converters.

-[Unknown]

pbpbb v2.0.16 to smf

Just did two test runs of the converter - one using convert.php and phpbb2_to_smf.sql downloaded from page 1 of this thread on 17th July.
It gave this result.

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)... Successful.
Converting poll questions... Successful.
Converting polls options... Successful.
Converting polls options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

Conversion Complete

Then ran the conversion again using the latest (about 3hours ago) convert.php and phpbb2_to_smf.sql and got this result.

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)...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...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting moderators...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings...
Parse error: parse error, unexpected ']' in /home/httpd/vhosts/my_domain.com/httpdocs/test1/convert.php(627) : eval()'d code on line 9
Error in convert script phpbb2_to_smf.sql on line 832!
Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

Conversion Complete

So just wondering whether I should stick with the July 17th version? - maybe it likes my data better.  :)

Dave

ps ... left out a bit of info. Actually ran the scripts three times - first July 17th version, then latest, then July 17th again. Both July 17th runs gave the same result.

Try the latest now.

-[Unknown]

is this possible to convert punbb 1.2.6 to smf. or only 1.2.5 please let me know it is argent for me because i am facing some bugs on my punbb forum.

It should work for both versions.  If you get any errors, please post them here.

-[Unknown]

Quote from: [Unknown] on August 14, 2005, 12:18:51 AM
Try the latest now.

-[Unknown]

Similar error...


Converting settings...
Parse error: parse error, unexpected ':', expecting ')' in /home/httpd/vhosts/my_domain.com/httpdocs/test1/convert.php(627) : eval()'d code on line 12
Error in convert script phpbb2_to_smf.sql on line 832!
Successful.


Everything else says "successful". Thought it might have something to do with the theme and data I had installed. But dropped all the SMF tables, re-installed 1.1 and it did the same.

Davo

thanks very much

I'm using mambo version of phpbb. I use the convertor and everything looks ok except user cannot ber converted. Must be a very little problem. How to change the sql?

Dennis

Re the error messages I reported above, latest version downloaded just now works without error. That was my final phpBB conversion !  :) :) Thank you [Unknown] for all your help with making this a smooth changeover.

I am sorry if this is a stupid question, but I am looking to convert my forum from Simpleboard RC 1.1 to SMF, and I was a little unclear as to the instructions on how to use the converters listed here.
Any help would be greatly appreciated.
Thanks

Which part were you unclear on?  Upload both of the files (convert.php and simpleboard_to_smf.sql) to the same directory as SMF is *already installed* in, and then access convert.php by URL.  Once there, simply type in the database password (specified in Settings.php) and click go.

-[Unknown]

I get this error:

"Unable to find the settings for Simpleboard 1.0.x. Please double check the path and try again."

Path to my Simpleboard 1.0.4-Beta2-MU is /home/brckop/public_html/components/com_simpleboard   ??

Help please!  :(

Does your simpleboard directory definetly have a configuration.php file in it? That's what it is looking for. I assume it's still called configuration.php in your version?

Please use the path to Mambo, not to Simpleboard itself.

-[Unknown]

I used the path to Mambo for my conversion as [Unknown] suggested (wish this post had been made when I was doing the conversion 2 days ago to save me the 5 minutes trying to figure out the url to use) and it worked great to convert my Simpleboard to SMF - http://endar.org/ (click Endaria to go to the forum), so just confirming that is definitely what you'd use :)

Quote from: [Unknown] on August 11, 2005, 08:31:53 PM
Tomer, I've attached one for you as well.

-[Unknown]

One small bug, it doesn't covert URL's right. It converts the URL's like this:


[url="http://www.domain.com"]http://www.domain.com[/url]

and it should be:

[url=http://www.domain.com]http://www.domain.com[/url]


- Tomer

It doesn't touch URLs.  There was recently a topic posted about that too (in this board.)

-[Unknown]

Hello.....
i updated to latest version of SMF & was bale to conert from nuke 6.9 to SMF successfully.

But attachments did not get converted. Any idea why?
Please do let me know.

Would you happen to have a version of the converter that will rip the data out of phpBB and simply generate an SQL file to import into another (the SMF) database?
The problem is that my webhost doesn't allow databases to be shared for multiple domains, so I can't put both forums on "neutral ground".

Any alternatives?  Suggestions?

I was able to convert from phpbb 2.0.15. to SMF 1.5 with no trouble at all, so i though i would check out SMF 1.1 beta3 and used the converter on top of this link and it did not work, i go the following errors: can anyone of of assistance?

Converting ranks...Successful.
Converting groups...Successful.
Converting members...
Warning: copy(/home/thundazo/public_html/hosting/tfs/forums/images/avatars/124828390342b57e8c5f218.jpg): failed to open stream: No such file or directory in /home/thundazo/public_html/hosting/tfs/smf11/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 `thundazo_smf11`.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 ('2184', '0', '14522', '14531', '45', '158', '1', '', '0', '5', '26'),
('2185', '0', '14542', '14542', '45', '45', '1', '', '0', '0', '11'),
('2187', '0', '14549', '14549', '3', '3', '15', '', '0', '0', '5'),
('2188', '0', '14550', '14550', '2', '2', '15', '', '0', '0', '2'),
('2189', '0', '14551', '14558', '2', '2', '15', '', '0', '4', '11'),
('2190', '0', '14554', '14556', '2', '2', '15', '', '0', '1', '5'),
('2191', '0', '14557', '14557', '2', '2', '15', '', '0', '0', '0'),
('2192', '0', '14559', '14559', '2', '2', '15', '', '0', '0', '0'),
('2193', '0', '14560', '14560', '2', '2', '1', '', '0', '0', '10'),
('2195', '0', '14562', '14576', '2', '45', '1', '', '0', '2', '17'),
('2196', '0', '14564', '14564', '158', '158', '1', '', '0', '0', '17'),
('2197', '0', '14566', '16104', '145', '184', '50', '', '0', '18', '81'),
('2198', '0', '14577', '14577', '158', '158', '1', '', '0', '0', '9'),
('2199', '0', '14583', '14634', '146', '146', '1', '', '0', '3', '27'),
('2201', '0', '14589', '14592', '176', '167', '1', '', '0', '1', '13'),
('2202', '0', '14591', '14753', '2', '176', '34', '', '0', '8', '40'),
('2203', '0', '14597', '14597', '158', '158', '3', '', '0', '0', '5'),
('2204', '0', '14598', '17489', '167', '202', '1', '', '0', '13', '119'),
('2205', '0', '14600', '14600', '158', '158', '1', '', '0', '0', '13'),
('2206', '0', '14603', '14611', '2', '3', '1', '', '0', '1', '14'),
('2207', '0', '14604', '14641', '2', '145', '50', '', '0', '5', '26'),
('2208', '0', '14608', '14710', '170', '176', '51', '', '0', '7', '35'),
('2212', '0', '14642', '14731', '182', '158', '12', '', '0', '12', '65'),
('2213', '0', '14668', '15266', '2', '176', '28', '', '0', '16', '116'),
('2214', '0', '14669', '17663', '139', '202', '3', '', '0', '11', '45'),
('2215', '0', '14671', '15104', '45', '175', '1', '', '0', '7', '40'),
('2216', '0', '14682', '14691', '177', '158', '53', '', '0', '1', '16'),
('2217', '0', '14686', '16128', '183', '184', '12', '', '0', '15', '98'),
('2218', '0', '14720', '14786', '176', '170', '51', '', '0', '10', '67'),
('2219', '0', '14752', '15354', '2', '170', '28', '', '0', '13', '89'),
('2220', '0', '14755', '14755', '35', '35', '1', '', '0', '0', '13'),
('2221', '0', '14762', '15020', '2', '176', '28', '', '0', '4', '33'),
('2222', '0', '14767', '15194', '2', '170', '28', '', '0', '15', '95'),
('2223', '0', '14770', '18519', '176', '198', '26', '', '0', '26', '149'),
('2224', '0', '14771', '14920', '45', '170', '1', '', '0', '22', '91'),
('2225', '1', '14792', '14793', '2', '45', '28', '', '0', '1', '23'),
('2226', '0', '14797', '15721', '177', '170', '14', '', '0', '3', '31'),
('2227', '0', '14801', '14801', '107', '107', '1', '', '0', '0', '38'),
('2228', '0', '14802', '14906', '183', '176', '1', '', '0', '13', '65'),
('2229', '0', '14809', '14946', '2', '170', '50', '', '0', '12', '52'),
('2230', '0', '14818', '14821', '2', '2', '15', '', '0', '1', '7'),
('2231', '1', '14825', '14858', '2', '171', '28', '', '0', '6', '36'),
('2232', '0', '14846', '14903', '158', '176', '1', '', '0', '11', '73'),
('2233', '0', '14850', '15742', '158', '2', '1', '50', '0', '13', '55'),
('2235', '1', '14886', '14912', '2', '167', '28', '', '0', '5', '21'),
('2237', '0', '14889', '14913', '2', '167', '40', '', '0', '2', '10'),
('2238', '1', '14909', '14911', '2', '167', '28', '', '0', '2', '14'),
('2239', '0', '14915', '15115', '2', '153', '28', '', '0', '13', '60'),
('2240', '0', '14927', '15160', '146', '170', '50', '', '0', '7', '32'),
('2241', '0', '14930', '14948', '183', '175', '1', '51', '0', '3', '49'),
('2242', '0', '14940', '14945', '145', '170', '50', '', '0', '2', '20'),
('2243', '0', '14949', '16260', '176', '176', '34', '', '0', '26', '97'),
('2244', '0', '14950', '14952', '2', '167', '50', '', '0', '1', '12'),
('2245', '0', '14959', '15786', '170', '2', '50', '', '0', '3', '30'),
('2247', '0', '14964', '14978', '170', '158', '40', '', '0', '4', '13'),
('2248', '0', '14968', '14976', '170', '2', '40', '', '0', '1', '9'),
('2249', '0', '14969', '14979', '175', '175', '50', '', '0', '3', '17'),
('2251', '0', '14982', '15395', '145', '170', '50', '', '0', '8', '46'),
('2252', '0', '14991', '15008', '2', '45', '1', '', '0', '4', '22'),
('2253', '0', '14995', '15064', '170', '145', '51', '', '0', '7', '29'),
('2254', '0', '14996', '15069', '170', '2', '40', '', '0', '3', '11'),
('2256', '0', '14999', '15093', '170', '45', '50', '', '0', '8', '50'),
('2257', '0', '15010', '15683', '170', '139', '28', '', '0', '20', '111'),
('2258', '0', '15017', '15047', '158', '170', '50', '', '0', '2', '15'),
('2259', '0', '15018', '15046', '177', '170', '1', '', '0', '6', '32'),
('2260', '0', '15038', '15042', '176', '2', '50', '', '0', '1', '8'),
('2261', '0', '15041', '15075', '167', '167', '1', '', '0', '2', '19'),
('2262', '0', '15051', '15430', '170', '176', '28', '', '0', '14', '66'),
('2263', '0', '15054', '15353', '170', '184', '1', '', '0', '18', '120'),
('2264', '0', '15056', '15074', '170', '170', '28', '', '0', '3', '19'),
('2265', '0', '15065', '15655', '145', '139', '1', '', '0', '14', '73'),
('2266', '0', '15077', '17522', '45', '45', '1', '', '0', '15', '138'),
('2268', '0', '15084', '15098', '69', '175', '34', '', '0', '4', '16'),
('2269', '0', '15105', '15105', '45', '45', '1', '', '0', '0', '12'),
('2270', '0', '15113', '15135', '139', '175', '1', '', '0', '8', '36'),
('2271', '0', '15121', '15138', '170', '45', '51', '', '0', '5', '23'),
('2272', '0', '15123', '18980', '170', '167', '40', '', '0', '3', '20'),
('2274', '0', '15139', '15144', '170', '167', '51', '', '0', '4', '31'),
('2275', '0', '15151', '15161', '2', '170', '50', '', '0', '5', '29'),
('2276', '0', '15163', '15175', '181', '175', '1', '', '0', '6', '32'),
('2277', '0', '15179', '15894', '45', '170', '25', '', '0', '9', '54'),
('2278', '0', '15195', '15457', '170', '170', '51', '', '0', '5', '41'),
('2279', '0', '15196', '15434', '170', '176', '51', '', '0', '3', '16'),
('2281', '0', '15199', '15227', '45', '167', '50', '', '0', '3', '28'),
('2282', '0', '15200', '15525', '185', '170', '36', '', '0', '7', '46'),
('2283', '0', '15207', '15225', '158', '175', '1', '52', '0', '7', '41'),
('2284', '0', '15208', '15210', '158', '170', '1', '', '0', '1', '12'),
('2285', '0', '15223', '15447', '167', '167', '28', '', '0', '7', '23'),
('2286', '0', '15226', '15261', '167', '177', '1', '', '0', '5', '34'),
('2287', '0', '15244', '15590', '177', '139', '1', '', '0', '17', '77'),
('2288', '0', '15245', '15591', '139', '175', '1', '', '0', '14', '75'),
('2289', '0', '15246', '15247', '69', '2', '13', '', '0', '1', '5'),
('2291', '0', '15279', '15932', '170', '189', '28', '', '0', '8', '55'),
('2292', '0', '15290', '15328', '2', '2', '28', '', '0', '6', '44'),
('2293', '0', '15297', '15344', '167', '107', '1', '', '0', '9', '62'),
('2294', '0', '15306', '15402', '158', '158', '1', '', '0', '14', '73'),
('2295', '0', '15307', '15350', '2', '171', '1', '', '0', '12', '99'),
('2296', '0', '15317', '15578', '170', '158', '28', '', '0', '9', '65'),
('2297', '0', '15332', '15340', '177', '2', '51', '', '0', '3', '16'),
('2298', '0', '15342', '15342', '2', '2', '33', '', '0', '0', '13'),
('2299', '0', '15355', '15500', '170', '176', '51', '', '0', '8', '47'),
('2300', '0', '15357', '15852', '170', '139', '28', '', '0', '18', '102'),
('2301', '0', '15358', '15451', '170', '171', '28', '', '0', '4', '36'),
('2302', '0', '15359', '15359', '170', '170', '51', '', '0', '0', '7'),
('2303', '0', '15361', '15577', '45', '158', '1', '', '0', '21', '87'),
('2304', '0', '15398', '15435', '170', '176', '50', '', '0', '3', '29'),
('2305', '0', '15417', '15417', '2', '2', '28', '', '0', '0', '4'),
('2306', '0', '15424', '15461', '50', '45', '3', '', '0', '5', '24'),
('2307', '0', '15437', '15467', '167', '175', '1', '', '0', '2', '20'),
('2308', '0', '15441', '15510', '2', '176', '43', '', '0', '4', '25'),
('2309', '0', '15462', '15513', '177', '176', '51', '', '0', '8', '42'),
('2310', '0', '15464', '15473', '170', '2', '40', '', '0', '2', '8'),
('2311', '0', '15474', '15477', '175', '158', '34', '', '0', '1', '9'),
('2312', '0', '15480', '15512', '158', '158', '1', '', '0', '5', '40'),
('2313', '0', '15517', '15649', '189', '189', '12', '', '0', '9', '54'),
('2314', '0', '15519', '15572', '2', '158', '28', '', '0', '9', '36'),
('2315', '0', '15521', '15521', '139', '139', '3', '', '0', '0', '4'),
('2316', '0', '15528', '15568', '170', '158', '1', '', '0', '3', '25'),
('2317', '0', '15529', '15530', '2', '170', '28', '', '0', '1', '27'),
('2318', '0', '15531', '15543', '2', '2', '28', '', '0', '2', '26'),
('2320', '0', '15549', '15692', '2', '189', '1', '', '0', '3', '24'),
('2321', '0', '15589', '16177', '158', '167', '7', '', '0', '67', '371'),
('2322', '0', '15593', '15669', '170', '170', '28', '', '0', '12', '47'),
('2324', '0', '15601', '15612', '175', '176', '1', '', '0', '3', '22'),
('2325', '0', '15605', '15605', '139', '139', '3', '', '0', '0', '10'),
('2326', '0', '15624', '15624', '184', '184', '8', '', '0', '0', '6'),
('2327', '0', '15625', '15795', '158', '158', '3', '', '0', '2', '12'),
('2329', '0', '15631', '15631', '151', '151', '51', '', '0', '0', '10'),
('2331', '0', '15651', '16361', '170', '170', '28', '', '0', '18', '167'),
('2333', '0', '15664', '15664', '2', '2', '53', '', '0', '0', '14'),
('2334', '0', '15681', '15917', '139', '146', '3', '', '0', '5', '24'),
('2335', '0', '15687', '15781', '2', '176', '28', '', '0', '3', '35'),
('2336', '0', '15688', '15691', '2', '167', '28', '', '0', '1', '5'),
('2337', '0', '15689', '15847', '2', '151', '50', '', '0', '13', '80'),
('2339', '0', '15713', '15756', '177', '45', '34', '', '0', '10', '32'),
('2340', '0', '15716', '15801', '189', '167', '34', '', '0', '14', '39'),
('2341', '0', '15724', '15763', '189', '189', '51', '', '0', '6', '24'),
('2342', '0', '15758', '15758', '190', '190', '14', '', '0', '0', '14'),
('2344', '0', '15766', '15766', '184', '184', '14', '', '0', '0', '13'),
('2345', '0', '15771', '16079', '170', '170', '28', '', '0', '12', '112'),
('2346', '0', '15773', '16154', '170', '2', '28', '', '0', '7', '91'),
('2347', '0', '15775', '16042', '170', '176', '25', '', '0', '1', '20'),
('2348', '0', '15782', '15782', '2', '2', '53', '', '0', '0', '35'),
('2349', '0', '15783', '16506', '2', '2', '40', '', '0', '22', '116'),
('2350', '0', '15785', '15815', '2', '153', '50', '', '0', '4', '40'),
('2351', '0', '15820', '15829', '189', '175', '43', '', '0', '1', '14'),
('2352', '0', '15821', '16017', '45', '175', '1', '', '0', '10', '60'),
('2353', '0', '15828', '15841', '175', '175', '51', '', '0', '9', '27'),
('2354', '0', '15840', '15865', '2', '167', '13', '', '0', '4', '17'),
('2355', '0', '15842', '15844', '158', '107', '13', '', '0', '1', '10'),
('2356', '0', '15849', '15902', '170', '170', '40', '', '0', '10', '35'),
('2357', '0', '15853', '15893', '2', '176', '50', '', '0', '2', '43'),
('2358', '0', '15861', '15877', '139', '139', '13', '', '0', '2', '12'),
('2359', '0', '15872', '16390', '170', '175', '46', '', '0', '4', '32'),
('2360', '0', '15881', '15890', '177', '176', '1', '', '0', '2', '21'),
('2361', '0', '15899', '15968', '170', '176', '51', '', '0', '6', '29'),
('2362', '0', '15900', '16036', '170', '184', '51', '', '0', '4', '30'),
('2363', '0', '15901', '15904', '170', '2', '40', '', '0', '1', '6'),
('2365', '0', '15933', '19306', '139', '222', '44', '', '0', '1', '11'),
('2366', '0', '15936', '15998', '191', '167', '12', '', '0', '6', '46'),
('2367', '0', '15946', '15953', '45', '45', '3', '', '0', '2', '15'),
('2368', '0', '15962', '16277', '45', '23', '1', '', '0', '5', '40'),
('2369', '0', '15970', '17488', '45', '202', '1', '', '0', '14', '49'),
('2370', '0', '15971', '15971', '191', '191', '12', '', '0', '0', '12'),
('2371', '0', '15982', '20448', '170', '176', '40', '', '0', '7', '26'),
('2372', '0', '15990', '16077', '139', '158', '1', '', '0', '23', '88'),
('2374', '0', '16040', '16806', '170', '190', '28', '', '0', '13', '102'),
('2376', '0', '16045', '16399', '2', '176', '28', '', '0', '15', '67'),
('2377', '0', '16047', '16047', '45', '45', '1', '', '0', '0', '5'),
('2378', '0', '16049', '16095', '177', '146', '1', '', '0', '4', '29'),
('2379', '0', '16051', '16230', '177', '176', '51', '', '0', '6', '41'),
('2380', '0', '16052', '16058', '177', '177', '51', '', '0', '2', '15'),
('2381', '0', '16055', '16060', '139', '167', '1', '', '0', '1', '12'),
('2382', '0', '16056', '16118', '170', '176', '28', '', '0', '8', '28'),
('2383', '0', '16078', '16217', '145', '145', '50', '', '0', '4', '29'),
('2384', '0', '16093', '16161', '139', '175', '1', '', '0', '7', '51'),
('2385', '0', '16116', '16387', '170', '35', '1', '', '0', '12', '75'),
('2386', '0', '16127', '16127', '184', '184', '51', '', '0', '0', '14'),
('2387', '0', '16129', '16164', '175', '175', '1', '', '0', '7', '45'),
('2388', '0', '16144', '16147', '2', '2', '50', '', '0', '2', '17'),
('2389', '0', '16149', '16155', '139', '139', '34', '', '0', '3', '18'),
('2390', '0', '16156', '16179', '2', '145', '50', '', '0', '2', '27'),
('2391', '0', '16163', '16185', '170', '170', '51', '', '0', '9', '38'),
('2392', '0', '16172', '16172', '2', '2', '28', '', '0', '0', '11'),
('2393', '0', '16182', '16184', '191', '170', '36', '', '0', '1', '17'),
('2394', '0', '16183', '16186', '191', '170', '36', '', '0', '1', '15'),
('2395', '0', '16188', '16253', '170', '170', '1', '', '0', '2', '36'),
('2396', '0', '16190', '16219', '170', '139', '1', '', '0', '4', '26'),
('2397', '0', '16191', '16196', '139', '139', '1', '', '0', '2', '12'),
('2398', '0', '16194', '16194', '2', '2', '1', '', '0', '0', '6'),
('2399', '0', '16195', '16278', '2', '167', '1', '', '0', '4', '27'),
('2400', '0', '16198', '16338', '2', '139', '54', '', '0', '17', '83'),
('2401', '0', '16204', '16365', '175', '175', '54', '', '0', '9', '65'),
('2402', '0', '16205', '16472', '175', '2', '50', '', '0', '14', '60'),
('2403', '0', '16206', '16231', '69', '176', '7', '', '0', '1', '10'),
('2404', '0', '16215', '17662', '177', '202', '1', '', '0', '17', '66'),
('2405', '0', '16221', '16407', '192', '170', '12', '', '0', '7', '51'),
('2406', '0', '16237', '16353', '184', '170', '51', '', '0', '12', '63'),
('2407', '0', '16239', '16259', '158', '176', '54', '', '0', '3', '30'),
('2408', '0', '16262', '16475', '158', '177', '3', '', '0', '4', '21'),
('2410', '0', '16268', '16366', '158', '175', '1', '', '0', '9', '60'),
('2412', '0', '16271', '16441', '2', '175', '28', '', '0', '13', '63'),
('2413', '0', '16272', '16272', '23', '23', '1', '', '0', '0', '9'),
('2414', '0', '16274', '16274', '23', '23', '46', '', '0', '0', '8'),
('2415', '0', '16281', '18296', '145', '175', '50', '', '0', '11', '69'),
('2416', '0', '16301', '16301', '2', '2', '54', '', '0', '0', '15'),
('2417', '0', '16326', '16339', '45', '176', '34', '', '0', '4', '18'),
('2418', '0', '16333', '16333', '45', '45', '37', '', '0', '0', '11'),
('2419', '0', '16337', '17481', '139', '202', '1', '', '0', '3', '21'),
('2420', '0', '16341', '18160', '139', '-1', '36', '', '0', '7', '68'),
('2422', '1', '16346', '16406', '2', '2', '28', '', '0', '6', '37'),
('2423', '0', '16347', '17653', '45', '202', '1', '', '0', '16', '46'),
('2424', '0', '16364', '16364', '158', '158', '1', '', '0', '0', '9'),
('2425', '0', '16371', '16371', '2', '2', '46', '', '0', '0', '6'),
('2426', '0', '16372', '16391', '2', '153', '46', '', '0', '3', '31'),
('2427', '0', '16373', '16373', '2', '2', '46', '', '0', '0', '7'),
('2428', '0', '16374', '16381', '158', '177', '1', '', '0', '6', '32'),
('2429', '0', '16382', '16460', '170', '2', '25', '', '0', '7', '44'),
('2430', '0', '16389', '16435', '35', '35', '7', '', '0', '2', '24'),
('2434', '0', '16408', '16476', '170', '177', '53', '', '0', '7', '39'),
('2435', '0', '16422', '16517', '2', '158', '21', '', '0', '7', '45'),
('2437', '0', '16433', '16433', '2', '2', '40', '', '0', '0', '7'),
('2438', '0', '16438', '16458', '175', '175', '34', '', '0', '6', '28'),
('2439', '0', '16461', '19830', '139', '218', '3', '', '0', '10', '36'),
('2442', '0', '16478', '17113', '176', '158', '50', '', '0', '8', '47'),
('2443', '0', '16479', '17212', '170', '204', '1', '', '0', '7', '55'),
('2444', '0', '16498', '16503', '2', '175', '50', '', '0', '5', '36'),
('2445', '0', '16505', '16614', '170', '167', '1', '', '0', '4', '27'),
('2446', '0', '16508', '16508', '176', '176', '25', '', '0', '0', '17'),
('2447', '0', '16510', '17603', '2', '204', '1', '', '0', '10', '56'),
('2448', '0', '16511', '17585', '2', '204', '1', '', '0', '12', '54'),
('2449', '0', '16519', '16532', '45', '45', '34', '', '0', '7', '32'),
('2451', '0', '16527', '17657', '2', '205', '54', '', '0', '18', '95'),
('2452', '0', '16530', '22609', '175', '45', '54', '', '0', '13', '77'),
('2453', '0', '16533', '18150', '45', '45', '54', '', '0', '5', '46'),
('2454', '0', '16535', '16575', '69', '69', '7', '', '0', '2', '16'),
('2455', '0', '16543', '16566', '184', '167', '1', '', '0', '15', '55'),
('2456', '0', '16567', '17973', '167', '204', '1', '', '0', '15', '57'),

Caused the error:

Duplicate entry '18088-50' for key 3


Thanks for your help

I figured it out, just went to phpbb sql table and deleted the dupliate entry and it converted fine from phpbb to smf1.1 beta 3

anyone tried vB3 to SMF 1.1 yet?

Quote from: subnet_rx on September 23, 2005, 02:25:29 AM
anyone tried vB3 to SMF 1.1 yet?

It does not mean that if someone succeded that it will be same with yours. Sorry for this "useless" answer, but if you try it and find an error, you can help improving the converter. Your original forum won't be touched.

Sorry, but after I was trying every single phpbb2_to_smf.sql
I'm still getting:

Converting ranks...Successful.
Converting groups...Successful.
Converting members...Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics... Unsuccessful!
...
Duplicate entry '3026-2' for key 3

error when trying to convert
phpBB 2.0.17 to SMF 1.1RC1

What can I do?
Thank you.

P.S.
Converting from phpBB 2.0.17 (the same) to SMF 1.0.5 worked just fine (using scripts from download area).

If you read 2 posts up i had some problem and posted how to fix it, you have to go into mysql , open the the database for your old forum, go to your tables, go to topics table, list them, search for the duplicate you list (3026) and delete one of them, once thats done, do the conversion again and it will work

I get the following:

" Converting topics... Unsuccessful!
This query:

    INSERT INTO `smftest`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

....

Caused the error:

    Duplicate entry '18599-1' for key 2"

I can't find any duplicates in either tables.. anybody want to hit me with the clue batton please?

Look in the " topic_first_post_id" column in phpbb_topics

For some reason it was the last post :D
Thanks :D

Getting some error (at the end of list), but seems to work fine... :)
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)...Successful.
Converting polls...Successful.
Converting polls options...Successful.
Converting polls options...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings...Successful.
Converting attachment mod (if installed)...
Parse error: parse error, unexpected ',' in /usr/local/www/data-dist/smf/convert/convert.php(1253) : eval()'d code on line 56
Error in convert script phpbb2_to_smf.sql on line 973!
Successful.
Recalculating forum statistics... Successful.

This happened all over the place.
Apperantly it's because of a mod I used.

An AI bot (every thread it ended is completely screwed up)
Is there a way to remove these duplicates (don't tell me I need to doctor up some SQL please  :'( )

If anybody knows some SQL to just show all the duplicates of LAST_POST_ID I'd be happy

ALTER TABLE phpbb_topics ADD UNIQUE INDEX(topic_last_post_id, forum_id);

Thank you very much :)

thanks for the phorum conversion

Hi! I'am trying to convert a yabb 2 forum to smf and I'm having some problems - after to get the access db converted into mysql the convertor is hanging...


Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Successful.
Unsuccessful!
This query:

    ALTER TABLE `travelli_copp`.smf_topics
    CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    ADD tempID int(10) unsigned NOT NULL default 0,
    DROP INDEX lastMessage,
    DROP INDEX firstMessage,
    DROP INDEX poll;

Caused the error:

    Can't DROP 'firstMessage'; check that column/key exists

<...>

Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
    FROM members AS mem
    LEFT JOIN pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
    GROUP BY mem.ID_MEMBER
    HAVING realNum != instantMessages;

Caused the error:

    No database selected



What can I do?
Thank you.

ok... I've replaced all the process and now it work fine!  :D

From YabbSE 1.5.5 to SMF 1.1 RC 1

Installed SMF into the same database but using different directories, of course I got a working installation of SMF here:

http://www.depechemodeforum.com/board/ (http://www.depechemodeforum.com/board/)

I tried the converter listed in this thread but I get this error:

QuoteConverting members... Unsuccessful!
This query:
UPDATE `dmforum`.smf_members
SET im_ignore_list = ''
WHERE ID_MEMBER = 1414
LIMIT 1;
Caused the error:

Unknown column 'im_ignore_list' in 'field list'

Anybody know how to fix this?

Quote from: Oldiesmann on September 24, 2005, 08:50:07 PM

Code Select Expand

ALTER TABLE phpbb_topics ADD UNIQUE INDEX(topic_last_post_id, forum_id);

Sorry for my late reply in this.
It seems that this does not help the problem, it just throws an error on the first broken record (just like t he conversion script will)
I'm probably going to have to code something up in Java (with Hibernate) to clean out this database

YabbSE 1.5.5 to SMF 1.1 RC 1

Deleted some (old) accounts that were causing the problem, it went a bit smoother after that but not a 100% yet. I got this message:

QuoteConverting...
Converting personal messages (step 2)... Successful.
Converting topic notifications...
Fatal error: Call to undefined function: nextsubstep() in /home/.jasper/proenski/depechemodeforum.com/board/convert.php(627) : eval()'d code on line 10

Can anyone help me with this hopefully last glitsch?

Someone must not have been paying attention when that converter was written...

Open up yabbse_to_smf.sql

Find
nextSubstep($substep);

Replace
pastTime($substep);

That should fix the problem.

Quote from: Oldiesmann on October 05, 2005, 11:02:15 AM


That should fix the problem.

Thanks but now I get this error  :-\

QuoteConverting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting attachments...Successful.
Converting activity logs...Successful.
Converting banning logs...Successful.
Converting mark as read history... Unsuccessful!
This query:
INSERT INTO `dmforum`.smf_log_boards
(ID_BOARD, ID_MEMBER, logTime)
VALUES ('1', '1', '1128459599'),
('2', '1', '1128459599'),
('3', '1', '1049575659'),
('4', '1', '1128459599'),
('6', '1', '1128459599'),
('8', '1', '1049575660'),
('9', '1', '1128459599'),
('10', '1', '1065655162'),
('11', '1', '1128459599'),
('12', '1', '1065655162'),
('13', '1', '1128459599'),
('14', '1', '1128459599'),
('15', '1', '1128459599'),
('16', '1', '1065655163'),
('17', '1', '1128459599'),
('19', '23', '1020095038'),
('19', '2017', '1079806514'),
('26', '1', '1128459599'),
('16', '702', '1032134211'),
('15', '541', '1053550305'),
('8', '35', '1048599719'),
('4', '35', '1049982635'),
('1', '35', '1049982635'),
('2', '35', '1049982635'),
('9', '35', '1049982635'),
('3', '35', '1048599719'),
('6', '35', '1049982635'),
('10', '35', '1049982635'),
('11', '35', '1049982635'),
('12', '35', '1049982635'),
('13', '35', '1049982635'),
('14', '35', '1049982635'),
('15', '35', '1049982635'),
('16', '35', '1049982635'),
('17', '35', '1049982635'),
('19', '35', '1049982635'),
('19', '1', '1128459599'),
('13', '39', '1020265858'),
('17', '59', '1020373159'),
('17', '65', '1020476807'),
('17', '101', '1021054570'),
('17', '100', '1034704887'),
('20', '1', '1060205768'),
('22', '1', '1128459599'),
('23', '1', '1060205768'),
('1', '151', '1022496704'),
('2', '151', '1022496704'),
('3', '151', '1022496704'),
('4', '151', '1022496704'),
('6', '151', '1022496704'),
('8', '151', '1022496704'),
('9', '151', '1022496704'),
('10', '151', '1022496704'),
('11', '151', '1022496704'),
('12', '151', '1022496704'),
('13', '151', '1022496704'),
('14', '151', '1022496704'),
('15', '151', '1022496704'),
('16', '151', '1022496704'),
('17', '151', '1022496704'),
('19', '151', '1022496704'),
('20', '151', '1022496704'),
('22', '151', '1022496704'),
('23', '151', '1022496704'),
('6', '6', '1022510139'),
('23', '195', '1023542967'),
('20', '35', '1049982635'),
('22', '35', '1049982636'),
('23', '35', '1049982636'),
('1', '229', '1025634894'),
('2', '229', '1025634894'),
('3', '229', '1025634894'),
('4', '229', '1025634894'),
('6', '229', '1025634894'),
('8', '229', '1025634894'),
('9', '229', '1025634894'),
('10', '229', '1025634894'),
('11', '229', '1025634894'),
('12', '229', '1025634894'),
('13', '229', '1025634894'),
('14', '229', '1025634894'),
('15', '229', '1025634894'),
('16', '229', '1025634894'),
('17', '229', '1025634894'),
('19', '229', '1025634894'),
('20', '229', '1025634894'),
('22', '229', '1025634894'),
('23', '229', '1025634894'),
('20', '249', '1024916873'),
('15', '255', '1025045575'),
('23', '263', '1025456477'),
('15', '285', '1026055683'),
('15', '119', '1037019787'),
('15', '291', '1128449184'),
('2', '283', '1028657650'),
('1', '283', '1028659357'),
('15', '253', '1029488463'),
('15', '278', '1128445550'),
('15', '339', '1028795121'),
('4', '253', '1028797264'),
('1', '253', '1028797293'),
('15', '282', '1120054228'),
('15', '320', '1029179790'),
('8', '155', '1029252015'),
('1', '612', '1030340074'),
('2', '612', '1030340074'),
('3', '612', '1030340074'),
('4', '612', '1030340074'),
('6', '612', '1030340074'),
('8', '612', '1030340074'),
('9', '612', '1030340074'),
('10', '612', '1030340074'),
('11', '612', '1030340074'),
('12', '612', '1030340074'),
('13', '612', '1030340074'),
('14', '612', '1030340074'),
('15', '612', '1030340074'),
('16', '612', '1030340074'),
('17', '612', '1030340074'),
('19', '612', '1030340074'),
('20', '612', '1030340074'),
('22', '612', '1030340074'),
('23', '612', '1030340074'),
('1', '285', '1030355297'),
('2', '16', '1052815406'),
('19', '119', '1034099495'),
('1', '16', '1036658503'),
('26', '16', '1101143141'),
('19', '16', '1052821673'),
('14', '776', '1034516776'),
('17', '16', '1034601653'),
('4', '16', '1034753174'),
('27', '1', '1128459599'),
('9', '16', '1035205001'),
('8', '16', '1035271225'),
('3', '16', '1035818912'),
('14', '16', '1035906037'),
('15', '824', '1037530457'),
('28', '1', '1046376759'),
('15', '297', '1058429909'),
('1', '872', '1065604943'),
('2', '872', '1060630633'),
('3', '872', '1040310102'),
('4', '872', '1063191266'),
('6', '872', '1040310102'),
('8', '872', '1040310102'),
('9', '872', '1040310102'),
('10', '872', '1040310102'),
('11', '872', '1040310102'),
('12', '872', '1040310102'),
('13', '872', '1040310102'),
('14', '872', '1040310103'),
('15', '872', '1040310103'),
('16', '872', '1040310103'),
('17', '872', '1040310103'),
('19', '872', '1066036099'),
('20', '872', '1040310103'),
('22', '872', '1040310103'),
('23', '872', '1040310103'),
('26', '872', '1053819433'),
('27', '872', '1040310103'),
('28', '872', '1040310103'),
('27', '929', '1039721114'),
('26', '653', '1039766480'),
('17', '97', '1039885509'),
('26', '945', '1073326469'),
('1', '945', '1074881710'),
('2', '945', '1071768904'),
('19', '945', '1074157180'),
('19', '833', '1126867475'),
('26', '120', '1079024531'),
('3', '945', '1048955441'),
('9', '997', '1042147565'),
('27', '826', '1042150158'),
('12', '1018', '1042938827'),
('2', '1118', '1109314690'),
('20', '1051', '1043458540'),
('4', '945', '1071768904'),
('1', '833', '1127466760'),
('30', '1', '1046376759'),
('9', '833', '1126867475'),
('1', '1079', '1045937576'),
('2', '1079', '1045937576'),
('3', '1079', '1045937576'),
('4', '1079', '1045937576'),
('6', '1079', '1045937576'),
('8', '1079', '1045937576'),
('9', '1079', '1045937576'),
('10', '1079', '1045937576'),
('11', '1079', '1045937576'),
('12', '1079', '1045937576'),
('13', '1079', '1045937576'),
('14', '1079', '1045937576'),
('15', '1079', '1045937576'),
('16', '1079', '1045937576'),
('17', '1079', '1045937576'),
('19', '1079', '1045937576'),
('20', '1079', '1045937576'),
('22', '1079', '1045937576'),
('23', '1079', '1045937576'),
('26', '1079', '1045937576'),
('27', '1079', '1045937576'),
('28', '1079', '1045937576'),
('30', '1079', '1045937576'),
('1', '1159', '1045561313'),
('2', '1159', '1045561313'),
('3', '1159', '1045561313'),
('4', '1159', '1045561313'),
('6', '1159', '1045561313'),
('8', '1159', '1045561313'),
('9', '1159', '1045561313'),
('10', '1159', '1045561313'),
('11', '1159', '1045561313'),
('12', '1159', '1045561313'),
('13', '1159', '1045561313'),
('14', '1159', '1045561314'),
('15', '1159', '1045561314'),
('16', '1159', '1045561314'),
('17', '1159', '1045561314'),
('19', '1159', '1045561314'),
('20', '1159', '1045561314'),
('22', '1159', '1045561314'),
('23', '1159', '1045561314'),
('26', '1159', '1045561314'),
('27', '1159', '1045561314'),
('28', '1159', '1045561314'),
('30', '1159', '1045561314'),
('6', '16', '1103114445'),
('19', '291', '1059390257'),
('19', '877', '1046371755'),
('2', '833', '1126867475'),
('19', '1118', '1110012511'),
('1', '1118', '1109402685'),
('1', '1241', '1047513576'),
('3', '833', '1049253836'),
('4', '833', '1126867475'),
('6', '833', '1126867475'),
('8', '833', '1049253836'),
('10', '833', '1065328327'),
('11', '833', '1126867475'),
('12', '833', '1065328327'),
('13', '833', '1126867475'),
('14', '833', '1126867475'),
('15', '833', '1126867475'),
('16', '833', '1065328327'),
('17', '833', '1126867475'),
('20', '833', '1060221244'),
('22', '833', '1126867475'),
('23', '833', '1060221244'),
('26', '833', '1126867475'),
('27', '833', '1126867475'),
('31', '1', '1047564496'),
('31', '833', '1047543970'),
('17', '1270', '1047554871'),
('17', '1302', '1048360140'),
('26', '35', '1049982636'),
('27', '35', '1049982636'),
('26', '63', '1048740899'),
('13', '1327', '1049112439'),
('32', '872', '1065519683'),
('32', '833', '1126867475'),
('32', '945', '1071768904'),
('32', '1', '1128459599'),
('32', '35', '1049982636'),
('17', '64', '1050187525'),
('15', '127', '1050952725'),
('9', '1393', '1051537446'),
('13', '1434', '1051549780'),
('4', '1448', '1051867605'),
('6', '1466', '1070037591'),
('6', '1408', '1061499398'),
('32', '16', '1052814767'),
('1', '551', '1053067559'),
('14', '108', '1125062079'),
('2', '620', '1053607656'),
('15', '1524', '1053609904'),
('1', '1466', '1070037591'),
('2', '1466', '1070037591'),
('4', '1466', '1070037591'),
('9', '1466', '1070037591'),
('10', '1466', '1055330697'),
('11', '1466', '1070037591'),
('12', '1466', '1055330697'),
('13', '1466', '1070037591'),
('14', '1466', '1070037591'),
('15', '1466', '1070037591'),
('16', '1466', '1055330697'),
('17', '1466', '1070037591'),
('19', '1466', '1096048668'),
('20', '1466', '1055330697'),
('22', '1466', '1070037591'),
('23', '1466', '1055330697'),
('26', '1466', '1070037591'),
('27', '1466', '1070037591'),
('32', '1466', '1070037591'),
('14', '120', '1119181817'),
('14', '1154', '1054751278'),
('14', '159', '1058109311'),
('1', '1616', '1056336228'),
('19', '1215', '1117783209'),
('1', '1720', '1091876334'),
('2', '1720', '1091894367'),
('4', '1720', '1091876334'),
('6', '1720', '1091876334'),
('9', '1720', '1091876334'),
('10', '1720', '1060196084'),
('11', '1720', '1091876334'),
('12', '1720', '1060196085'),
('13', '1720', '1091876334'),
('14', '1720', '1091876334'),
('15', '1720', '1091876334'),
('16', '1720', '1060196085'),
('17', '1720', '1091876334'),
('19', '1720', '1091876334'),
('20', '1720', '1060196085'),
('22', '1720', '1091876334'),
('23', '1720', '1060196085'),
('26', '1720', '1091876334'),
('27', '1720', '1091876334'),
('32', '1720', '1091876334'),
('19', '428', '1060508411'),
('1', '786', '1060542006'),
('2', '786', '1060542006'),
('4', '786', '1060542006'),
('6', '786', '1060542006'),
('9', '786', '1060542006'),
('10', '786', '1060542006'),
('11', '786', '1060542006'),
('12', '786', '1060542006'),
('13', '786', '1060542006'),
('14', '786', '1060542006'),
('15', '786', '1060542006'),
('16', '786', '1060542006'),
('17', '786', '1060542006'),
('19', '786', '1060542006'),
('22', '786', '1060542006'),
('26', '786', '1060542006'),
('27', '786', '1060542006'),
('32', '786', '1060542006'),
('32', '1118', '1109285508'),
('1', '1788', '1063444567'),
('2', '1788', '1063444567'),
('4', '1788', '1063444567'),
('6', '1788', '1063444567'),
('9', '1788', '1063444567'),
('10', '1788', '1063444567'),
('11', '1788', '1063444567'),
('12', '1788', '1063444567'),
('13', '1788', '1063444567'),
('14', '1788', '1063444568'),
('15', '1788', '1063444568'),
('16', '1788', '1063444568'),
('17', '1788', '1063444568'),
('19', '1788', '1063444568'),
('22', '1788', '1063444568'),
('26', '1788', '1063444568'),
('27', '1788', '1063444568'),
('32', '1788', '1063444568'),
('2', '1120', '1064004427'),
('19', '1403', '1067256973'),
('26', '1856', '1067389691'),
('15', '0', '1115562609'),
('17', '1001', '1068381162'),
('15', '1896', '1081871684'),
('27', '1906', '1068844393'),
('4', '0', '1093035449'),
('26', '0', '1093035449'),
('1', '0', '1093035449'),
('2', '0', '1097016274'),
('32', '0', '1093035449'),
('6', '0', '1093035449'),
('9', '0', '1093035449'),
('11', '0', '1093035449'),
('13', '0', '1093035449'),
('14', '0', '1093035449'),
('17', '0', '1093035449'),
('22', '0', '1093035449'),
('27', '0', '1100692354'),
('19', '0', '1093035449'),
('6', '945', '1071768904'),
('9', '945', '1071768904'),
('11', '945', '1071768904'),
('13', '945', '1071768904'),
('14', '945', '1071768904'),
('15', '945', '1071768904'),
('17', '945', '1071768904'),
('22', '945', '1071768904'),
('27', '945', '1071768904'),
('13', '1990', '1073184572'),
('4', '2071', '1075463017'),
('2', '2098', '1075916996'),
('4', '2102', '1075977476'),
('26', '2102', '1075977476'),
('1', '2102', '1075977476'),
('2', '2102', '1075977476'),
('32', '2102', '1075977476'),
('6', '2102', '1075977476'),
('9', '2102', '1075977476'),
('11', '2102', '1075977476'),
('13', '2102', '1075977476'),
('14', '2102', '1075977476'),
('15', '2102', '1075977476'),
('17', '2102', '1075977476'),
('22', '2102', '1075977476'),
('27', '2102', '1075977476'),
('19', '2102', '1075977476'),
('4', '2115', '1077325773'),
('26', '2115', '1077325773'),
('1', '2115', '1078518123'),
('2', '2115', '1077325773'),
('32', '2115', '1077325773'),
('6', '2115', '1077325773'),
('9', '2115', '1077325773'),
('11', '2115', '1077325773'),
('13', '2115', '1077325773'),
('14', '2115', '1077325773'),
('15', '2115', '1077325773'),
('17', '2115', '1077325773'),
('22', '2115', '1077325773'),
('27', '2115', '1077325773'),
('19', '2115', '1077325773'),
('9', '2122', '1076776211'),
('13', '2110', '1076848063'),
('1', '2110', '1076848308'),
('1', '2133', '1077226233'),
('22', '2017', '1077712139'),
('1', '1378', '1118840711'),
('4', '1378', '1106690381'),
('26', '1378', '1106690381'),
('2', '1378', '1106690381'),
('32', '1378', '1106690381'),
('6', '1378', '1106690381'),
('9', '1378', '1106690381'),
('11', '1378', '1106690381'),
('13', '1378', '1106690381'),
('14', '1378', '1106690381'),
('15', '1378', '1106690381'),
('17', '1378', '1106690381'),
('22', '1378', '1106690381'),
('27', '1378', '1106690381'),
('19', '1378', '1106690381'),
('17', '2195', '1079423166'),
('4', '2197', '1079459966'),
('26', '2197', '1079459966'),
('1', '2197', '1079459966'),
('2', '2197', '1079459966'),
('32', '2197', '1079459966'),
('6', '2197', '1079459966'),
('9', '2197', '1079459966'),
('11', '2197', '1079459966'),
('13', '2197', '1079459966'),
('14', '2197', '1079459966'),
('15', '2197', '1079459966'),
('17', '2197', '1079459966'),
('22', '2197', '1079459966'),
('27', '2197', '1079459966'),
('19', '2197', '1079459966'),
('1', '1981', '1080114209'),
('22', '2217', '1080248877'),
('27', '1058', '1126401768'),
('19', '2098', '1089498656'),
('19', '2462', '1090983927'),
('19', '1230', '1091015821'),
('1', '2471', '1094810341'),
('9', '733', '1093885949'),
('15', '1972', '1094657647'),
('4', '2417', '1095251065'),
('13', '2499', '1095410359'),
('26', '2300', '1122021450'),
('1', '232', '1103130435'),
('1', '2300', '1096610449'),
('26', '232', '1103130572'),
('19', '232', '1097017552'),
('2', '232', '1097010049'),
('4', '232', '1097017342'),
('32', '232', '1097017488'),
('19', '2300', '1123015989'),
('9', '2585', '1097869637'),
('13', '2018', '1120219834'),
('2', '2018', '1121953452'),
('4', '2598', '1098379346'),
('26', '2598', '1098379346'),
('1', '2598', '1098379346'),
('32', '2598', '1098379346'),
('6', '2598', '1098379346'),
('9', '2598', '1098379346'),
('11', '2598', '1098379346'),
('13', '2598', '1098379346'),
('14', '2598', '1098379346'),
('15', '2598', '1098379346'),
('17', '2598', '1098379346'),
('22', '2598', '1098379346'),
('27', '2598', '1098379346'),
('2', '2598', '1098379346'),
('19', '2598', '1098379346'),
('26', '2018', '1103896808'),
('6', '2018', '1122497203'),
('1', '2018', '1106514224'),
('9', '2348', '1099389182'),
('19', '2018', '1120305518');
Caused the error:

Duplicate entry '1-1' for key 1

You should probably make sure all the SMF tables are empty before you run the converter... Go into phpMyAdmin, check the box next to each SMF table and choose "truncate" from the "with selected" menu. That will empty out all the SMF tables and should allow you to convert properly.

Quote from: Oldiesmann on October 05, 2005, 01:41:50 PM
You should probably make sure all the SMF tables are empty before you run the converter... Go into phpMyAdmin, check the box next to each SMF table and choose "truncate" from the "with selected" menu. That will empty out all the SMF tables and should allow you to convert properly.

Sorry I got the same error message...  :(

Are you sure you emptied out the log_boards table? It's acting like there are already values there when there really aren't...

Will have a look again later today, I was pretty sure I checked all the tables with smf prefix...  :-\

Sorry I tried, I even did a complete re-install of the board. Deleted ALL SMF tables from the database etc. in order to start "clean"

I still get the same error...   :'(

Where can I get the 1.1 convertor now? Didn't notice it in the first post as an attachment.. :(

Proenski - I'm not sure what the problem is. I'll tell Compuart to take a look at this topic and see if he can figure out the issue.

dvd-man - What do you want to convert from?

Proenski, try replacing (yabbse_to_smf.sql):
---* {$to_prefix}log_boards
SELECT ID_BOARD, ID_MEMBER, logTime
FROM {$from_prefix}log_mark_read;
---*


into:
---* {$to_prefix}log_mark_read
SELECT ID_BOARD, ID_MEMBER, logTime
FROM {$from_prefix}log_mark_read;
---*

Quotedvd-man - What do you want to convert from?

phpBB :)

Quote from: Compuart on October 07, 2005, 12:52:38 PM
Proenski, try replacing (yabbse_to_smf.sql):
---* {$to_prefix}log_boards
SELECT ID_BOARD, ID_MEMBER, logTime
FROM {$from_prefix}log_mark_read;
---*


into:
---* {$to_prefix}log_mark_read
SELECT ID_BOARD, ID_MEMBER, logTime
FROM {$from_prefix}log_mark_read;
---*

Ok. Will try. Keep you updated...

Quote from: dvd-man on October 07, 2005, 01:59:39 PM

Quotedvd-man - What do you want to convert from?

phpBB :)

It's there... Right between phorum and phpnuke. Here's a direct link though: http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=9338

Make sure you also download converter.php

Hmm.. strange; wasn't there last time I looked! :-\

Do you mean convert.php?

Yeah, that's what I meant. It's easy to overlook attachments since there are so many of them in that topic.

OK thanks!

As for the attachements... when I was trying to find it I didn't see any attachments on the post.. not like there are now. But that doesn't matter now anyway since I've got it! :P

i made a clean install of 1.1 rc 1 and tried to convert the ipb2.0.4 to my smf database..

it stucks at step 2:

Converting personal messages (step 2)... Unsuccessful!
This query:
INSERT INTO `mkportal1`.smfCH_pm_recipients
(ID_PM, ID_MEMBER, bcc, is_read)
VALUES ('1', '1', '0', '1123274796'),
('21', '1', '0', '1123835608'),
('3', '1', '0', '1123362879'),
('4', '1', '0', '1123411263'),
etc. etc.

Caused the error:

Duplicate entry '1-1' for key 1

Normally you would say that if i empty that table and run it again.. the problem ius solved.. but i still get this error..

what can i do about it..

greetzz

Can you try replacing (invision2_to_smf.sql)

---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, mt_hide_cc AS bcc,
mt_user_read AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id;
---*

by:
---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id
GROUP BY mt_msg_id, mt_to_id;
---*

 Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
    IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
    FROM `mkportal1`.ibf_message_topics
    WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id
    GROUP BY mt_msg_id, mt_to_id
    LIMIT 0, 500;

Caused the error:

    Unknown table 'm' in where clause

this is the result of replacing above.. strange

Strange indeed. Can you try without the m, so like this:

---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != mt_to_id
GROUP BY mt_msg_id, mt_to_id;
---*

ok that functions.. now i get

Converting moderators... Unsuccessful!
This query:

    INSERT INTO `mkportal1`.smf_moderators
    (ID_MEMBER, ID_BOARD)
    VALUES ('-1', '2'),
    ('-1', '3'),
    ('-1', '4'),
    ('-1', '5'),
    ('-1', '7'),
    ('-1', '8'),

etcetc
     ('-1', '13'),
    ('-1', '28'),
    ('-1', '29'),
    ('-1', '33'),
    ('-1', '32'),
    ('-1', '32');

Caused the error:

    Duplicate entry '2-0' for key 1

do you think i have to modify everythin in the tables..

I think (invision2_to_smf.sql):
---* {$to_prefix}moderators
SELECT member_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM {$from_prefix}moderators
WHERE member_id != 1;
---*

has to be:
---* {$to_prefix}moderators
SELECT member_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM {$from_prefix}moderators
WHERE member_id != -1;
---*

Sorry about these errors, the convertors are still in alpha/beta stage.

doesnt matter... no problem about the errors.. i am gla the fault isnt in my installation..  ;)

it works perfectly... please modify the orignal file.. otherwise you get hundred questions..

greetz and thnx  :)

Done. Thanks for the feedback.

I try to use the eblah converter but i get the error:

Quote
E-Blah Platinum 9 to SMF Converter
Converting...
Unsuccessful!
This query:

    ALTER TABLE `foro`.smf_personal_messages
    CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    ADD temp_toName tinytext;

Caused the error:

    Duplicate column name 'temp_toName'

I need help with that.

Thanks in advance.

try replacing (eblah_to_smf.php)
convert_query("
ALTER TABLE {$to_prefix}personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
ADD temp_toName tinytext");

by:
convert_query("
ALTER TABLE {$to_prefix}personal_messages
DROP COLUMN temp_toName", true);
convert_query("
ALTER TABLE {$to_prefix}personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
ADD temp_toName tinytext");

This should make sure the column is dropped before it's created.

I get the following error when converting a phpBB 2.0.7 board to 1.1rc1.. any clues??

Converting boards... Unsuccessful!
This query:
INSERT INTO `reality_smf1`.smf1_boards
(ID_BOARD, boardOrder, numPosts, ID_LAST_MSG, name, ID_CAT, description, numTopics, memberGroups)
VALUES ('2', '10', '1684', '12696', 'BB Anonymous', '2', 'BB6 is over. Are you going through withdrawals? Join our recovery program inside...lol...', '240', '-1,0,2'),
('27', '20', '804', '12765', 'BB Bulletins', '2', 'News to keep you in the know and links to recaps of episodes you might have missed...', '618', '-1,0,2'),
('4', '30', '360', '10443', 'Live Feed Updates', '2', 'Up-to-the-minute updates on what BB6 Houseguests are doing...', '130', '-1,0,2'),
('50', '30', '33', '12744', 'Wife Swap', '11', '', '22', '-1,0,2'),
('61', '10', '145', '12621', 'Survivor: Guatemala Scrutiny', '15', 'Sixteen Survivors...two big twists... Who will Outwit, Outplay, and Outlast?', '27', '-1,0,2'),
('9', '10', '130', '12863', 'Multitude of the Masses', '6', 'This is where you can discuss all the other reality shows with other reality junkies...', '40', '-1,0,2'),
('55', '70', '60', '12822', 'The Apprentice: Martha Stewart', '11', '', '59', '-1,0,2'),
('56', '20', '72', '12829', 'Three Wishes', '11', '', '63', '-1,0,2'),
('52', '40', '21', '12573', 'Supernanny', '11', '', '15', '-1,0,2'),
('13', '10', '2872', '12857', 'The Grapevine', '8', 'Talk about anything here...and everything...', '265', '0,2'),
('14', '40', '213', '12862', 'The Exchange', '8', 'Questions? Complaints? Compliments? Meet with admins here... Keep up to date with RTVG updates and announcements...', '20', '-1,0,2'),
('15', '40', '107', '12826', 'Casting Calls', '6', 'You might discover a reality show you would like to audition for...', '81', '-1,0,2'),
('18', '50', '84', '12064', 'The Conclave', '8', 'Top secret...admin only...', '7', ''),
('20', '40', '230', '9337', 'Live Feed Captures', '2', 'Favorite moments captured as pics during live feeds...', '57', '-1,0,2'),
('24', '50', '18', '8825', 'Reality Links', '6', 'Other sites devoted to reality tv...', '3', '-1,0,2'),
('53', '50', '41', '12832', 'The Biggest Loser', '11', '', '39', '-1,0,2'),
('25', '30', '46', '12769', 'Upcoming Reality Shows', '6', 'New show announcements and schedules...', '36', '-1,0,2'),
('-99', '1', '0', '0', 'INDEX PAGE', '0', 'Index Page Control', '0', '-1,0,2'),
('-7', '1', '0', '0', 'MEMBERLIST', '0', 'Memberlist Control', '0', '-1,0,2'),
('28', '20', '330', '12830', 'MOTM Morsels', '6', 'News and updates about reality tv in general...', '282', '-1,0,2'),
('41', '50', '157', '10858', 'BB6 Houseguests', '2', 'Find info and discuss your favorite houseguests here...', '14', '-1,0,2'),
('47', '80', '202', '12824', 'American Idol', '11', '', '198', '-1,0,2'),
('66', '20', '49', '12861', 'The Amazing Race 8: Family Edition', '16', 'Discuss the first-ever family edition of TAR...', '5', '-1,0,2'),
('69', '20', '479', '12791', 'Cause Celebre: Reality Enquirer', '8', 'www.realityenquirer.blogspot.com airs a lot of dirty laundry about different internet sites that revolve around reality tv discussion... Step inside to discuss RE\'s latest gossip...', '25', '0,2'),
('54', '60', '88', '12828', 'The Apprentice', '11', '', '81', '-1,0,2'),
('68', '30', '633', '12855', 'Square Peg Through Round Hole', '8', 'Have something to say but don\'t want anyone to know you\'re saying it? This is the forum for you... Registered members only may post... Please read guidelines inside...', '33', '-1,0,2'),
('59', '60', '18', '7827', 'Reality Interviews', '6', 'Q & A sessions with contestants on reality shows...', '9', '-1,0,2'),
('62', '20', '234', '12772', 'Survivor Sensations', '15', 'News and updates on current and past seasons and Survivors...', '210', '-1,0,2'),
('65', '30', '102', '12835', 'TAR Tellings', '16', 'News and updates about past and current seasons and contestants...', '95', '-1,0,2'),
('70', '100', '4', '12569', 'Starting Over', '11', '', '2', '-1,0,2'),
('73', '10', '122', '12794', 'Small Screen', '19', 'LOST, Invasion, Threshold, others...discuss them here...', '9', '-1,0,2'),
('74', '20', '25', '12690', 'Small Screen News', '19', 'Commentaries and recaps...', '23', '-1,0,2');
Caused the error:

Duplicate entry '2' for key 1

Try replacing (phpbb2_to_smf.sql)
---* {$to_prefix}boards
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'
ELSE ''
END AS memberGroups
FROM {$from_prefix}forums;
---*

by:
---* {$to_prefix}boards
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'
ELSE ''
END AS memberGroups
FROM {$from_prefix}forums
WHERE forum_id > 0;
---*

well... got past that error and got this one..... the good news is... all teh posts have converted over..... so this may not be a major error....other than board permissions... and those can be changed manualy if needed
Converting board access... Unsuccessful!
This query:

    INSERT INTO `reality_smf1`.smf1_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (-1, -99, 'post_new'),
    (-1, -99, 'mark_notify'),
    (-1, -99, 'mark_any_notify'),
    (-1, -99, 'post_reply_any'),
    (-1, -99, 'modify_own'),
    (-1, -99, 'make_sticky'),
    (-1, -99, 'announce_topic'),
    (-1, -99, 'remove_own'),
    (-1, -99, 'delete_own'),
    (-1, -99, 'poll_vote'),
    (-1, -99, 'poll_view'),
    (-1, -99, 'poll_post'),
    (-1, -99, 'poll_add_own'),
    (0, -99, 'post_new'),
    (0, -99, 'mark_notify'),
    (0, -99, 'mark_any_notify'),
    (0, -99, 'post_reply_any'),
    (0, -99, 'modify_own'),
    (0, -99, 'make_sticky'),
    (0, -99, 'announce_topic'),
    (0, -99, 'remove_own'),
    (0, -99, 'delete_own'),
    (0, -99, 'poll_vote'),
    (0, -99, 'poll_view'),
    (0, -99, 'poll_post'),
    (0, -99, 'poll_add_own'),
    (2, -99, 'post_new'),
    (2, -99, 'mark_notify'),
    (2, -99, 'mark_any_notify'),
    (2, -99, 'post_reply_any'),
    (2, -99, 'modify_own'),
    (2, -99, 'make_sticky'),
    (2, -99, 'announce_topic'),
    (2, -99, 'remove_own'),
    (2, -99, 'delete_own'),
    (2, -99, 'poll_vote'),
    (2, -99, 'poll_view'),
    (2, -99, 'poll_post'),
    (2, -99, 'poll_add_own'),
    (3, -99, 'post_new'),
    (3, -99, 'mark_notify'),
    (3, -99, 'mark_any_notify'),
    (3, -99, 'post_reply_any'),
    (3, -99, 'modify_own'),
    (3, -99, 'make_sticky'),
    (3, -99, 'announce_topic'),
    (3, -99, 'remove_own'),
    (3, -99, 'delete_own'),
    (3, -99, 'poll_vote'),
    (3, -99, 'poll_view'),
    (3, -99, 'poll_post'),
    (3, -99, 'poll_add_own');

Caused the error:

    Duplicate entry '-1-0-poll_view' for key 1

replace (phpbb2_to_smf.sql)
$request = convert_query("
SELECT
CASE auth_post WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_post,
CASE auth_reply WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_reply,
CASE auth_edit WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_edit,
CASE auth_sticky WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_sticky,
CASE auth_announce WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_announce,
CASE auth_delete WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_delete,
CASE auth_vote WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_vote,
CASE auth_pollcreate WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_pollcreate,
forum_id AS ID_BOARD
FROM {$from_prefix}forums");

by:
$request = convert_query("
SELECT
CASE auth_post WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_post,
CASE auth_reply WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_reply,
CASE auth_edit WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_edit,
CASE auth_sticky WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_sticky,
CASE auth_announce WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_announce,
CASE auth_delete WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_delete,
CASE auth_vote WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_vote,
CASE auth_pollcreate WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_pollcreate,
forum_id AS ID_BOARD
FROM {$from_prefix}forums
WHERE forum_id > 0");

thank you soooooo much... conversion complete... you just made one of my customers VERY happy

Glad I could help :)

I have problem with converting Mercuryboard 1.1.4 to SMF it says smf_personal_messages isnt there so it can't convert the personal messages to SMF..

Strange, can you confirm the table does exist? It should in a default install of SMF. Also can you paste the exact error?

sorry had 1.0.5 ...

First off, thanks for all the hard work.  It's much appreciated.

However, I'm having a little problem with the vbulletin_to_smf.sql converter (for vbulletin 2.x).  At one point in the conversion (when it's converting posts), I get a huge dump to the browser window, and at the bottom it says: error 'Got a packet bigger than 'max_allowed_packet'.

The posts contain several jpeg attachments, and after a bit of searching, I determined that it's exceeding the max_packet_size setting on mysqld, but unfortunately I don't think there's a way I can change that on our server.

Is there a way to split the sql INSERTS into smaller chunks so that I don't run into this problem?

Thanks.

Well, I was able to work around the problem on my local computer by typing:

SET GLOBAL max_allowed_packet = 16 * 1024 * 1024; (16MB)

but I wonder if it would be possible to simply include:

SET max_allowed_packet = 16 * 1024 * 1024; (or something similar)

to the beginning of the .sql file?  Since max_allowed_packet is a dynamic runtime variable, and the script is already running as an authorized user, could it be as simple as that?

I'm not sure why I've ran into this problem and it doesn't seem that anybody else has, but it occurs with both vbulletin 2.x and 3.x converters (I also tried it on a database converted to vB 3.x).

Thanks.

Im trying to convert from phpbb 2.0.10 to smf 1.1rc1. I tried both the default download on page one of this thread and a modified version using the changes above this post on page 14. I still get an error when trying to convert topics:

Duplicate entry '34026-4' for key 2

If I click the retry button I get this, over and over:

Duplicate entry '2083' for key 1

I searched my phpbb_topics table for 34026-4 and couldnt find it. Any ideas?

I found the duplicate entry. Got my forum converted.

Hello all  ;)

I have this problem when i try to convert phpBB 2.0.17 to SMF 1.1 RC1 :

QuoteConverting...
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, u.username AS memberName, u.username AS realName,
u.user_password AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered, u.user_from 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, u.user_email AS emailAddress,
u.user_unread_privmsg AS unreadMessages, u.user_msnm AS MSN,
u.user_aim AS AIM, u.user_icq AS ICQ, u.user_yim AS YIM,
u.user_website AS websiteTitle, u.user_website 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
FROM `phpbb`.phpbb_users AS u
LEFT JOIN `phpbb`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `smf`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Is there somewone who had an idea ?

P.S. : sorry for my english  :P

Can you try replacing (phpbb2_to_smf.sql):
LEFT JOIN {$to_prefix}membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
by:
LEFT JOIN {$to_prefix}membergroups AS mg ON (SUBSTRING(mg.groupName, 7) = r.rank_title)


No, always the same problem  :-\

These collation problems always cause headaches :P

If you like, I can look into it. In that case, PM me the access data to phpMyAdmin and I'll try to see where the collation problem originates from and how it can be solved.

I send you a pm  ;)

I'm having some troubles in importing phpBB 2.0.10 to 1.1 RC1 using the importer revolving around groups and ranks.

The convertor is importing all the ranks as groups, and it is setting the user's ID_GROUP to their RANKID, so that the real groups I have created are not populated like they should be. Is it possible to remove the importing of the ranks, and not use the rankid as the groupID so that it only imports the user's group as their group?

Let me just explain whats happening:

I have 4 groups in phpBB and about 10 ranks.

When I convert phpBB data -> SMF, the 4 groups show up with their regular names in the memberGroups table, and the ranks showup with the prefix "phpBB ". The problem is, is that the 4 groups have 0 members in them, while everyone who was assigned a custom rank now retains that as their group, so the ranks are being transformed into groups when this should not be the case.

Seeing as SMF does not have a rank system (where you can just select from a list a user's rank, something that has no effect on their permissions), the ranks (at least it seems this way) should not be imported at all...

*EDIT*

OK, I have edited the file to fix this issue, but now I have an issue with avatars that were selected as "uploaded by the user" to phpBB. The image source is the link to dlattach option of attachments, and that is not right. For now I am just removing those user's avatars.

Has anyone tried doing a vbulletin3 conversion to 1.1RC1? I have it not copying any posts over at all, and refusing to put any of the forums in the correct categories -- instead they go into the recovered forums area, despite the fact that in the database the correct categories seem to have been created. No errors are reported (Successful!) until it gets to stats recalculating forum statistics, at which point it gives a completely unrelated one about the IMs:

     SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
     FROM members AS mem
     LEFT JOIN pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
     GROUP BY mem.ID_MEMBER
     HAVING realNum != instantMessages;

     No database selected


I have no problem with the stats error, as smf seems perfectly capable of rebuilding its own stats anyways. It's the other stuff that's not working.

Unfortunately, because the database is very very large (about 2.0GB) and the site is a live one (so I can only do this during the nightly cron), it's very difficult to diagnose problems with it.

I am getting this error with converting from Vbulletin 3 to SMF... it happens during Converting Posts...

Caused the error:

    MySQL server has gone away

I figured out my problem.... thanks....

Quote from: maharg on October 29, 2005, 12:16:03 PM
Has anyone tried doing a vbulletin3 conversion to 1.1RC1? I have it not copying any posts over at all, and refusing to put any of the forums in the correct categories -- instead they go into the recovered forums area, despite the fact that in the database the correct categories seem to have been created.

If you like, I can take a look at the database to see what's going wrong?

QuoteNo errors are reported (Successful!) until it gets to stats recalculating forum statistics, at which point it gives a completely unrelated one about the IMs:

Code Select Expand


     SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
     FROM members AS mem
     LEFT JOIN pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
     GROUP BY mem.ID_MEMBER
     HAVING realNum != instantMessages;

     No database selected


I have no problem with the stats error, as smf seems perfectly capable of rebuilding its own stats anyways. It's the other stuff that's not working.

This seems to come from the 1.0 converter, right? You might wanna try the 1.1 converter as it can deal better with large databases.

Hey, I am working with simpleboard 1.0.4 b2 and SMF 1.1 RC1.  I have done a clean install of SMF then I applied the converter.  and I get the following error.

QuoteConverting members...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `macmodc_smf`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('217', '13'),
    ('142', '16'),
    ('226', '13'),
    ('226', '23'),
    ('226', '4'),
    ..........
    .........
    .........

Caused the error:

Duplicate entry '0-1421-0' for key 1

Here is what I am calling...   http://dev.macmod.com/convert/convert.php?step=1&debug=0

Any ideas?  I have downloaded the latest files from this thread.  Are there newer ones in which I am unaware?  Thanks - Jacob

Try replacing:

SELECT userid AS ID_MEMBER, thread AS ID_TOPIC


by:

SELECT DISTINCTROW userid AS ID_MEMBER, thread AS ID_TOPIC


great, that fixed it!  Had some issues with a few other things, but nothing I can't work out on my own now.

Attachments with a few issues, avatars didn't transfer, etc.  The only thing I wish I could fix is that each thread being displayed in a category or via a search doesn't show the number of replies.  Any ideas on this one?

EDIT:  Also, the ID_GROUP needs a little work.  The administrators don't get transferred, moderators do though.
EDIT2:  Would also be nice if the escaped quotes could be restored.  Not a huge issue, just a note.

Quote from: Compuart on November 08, 2005, 09:04:41 PM

Quote from: maharg on October 29, 2005, 12:16:03 PM
Has anyone tried doing a vbulletin3 conversion to 1.1RC1? I have it not copying any posts over at all, and refusing to put any of the forums in the correct categories -- instead they go into the recovered forums area, despite the fact that in the database the correct categories seem to have been created.

If you like, I can take a look at the database to see what's going wrong?

QuoteNo errors are reported (Successful!) until it gets to stats recalculating forum statistics, at which point it gives a completely unrelated one about the IMs:

Code Select Expand


     SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
     FROM members AS mem
     LEFT JOIN pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
     GROUP BY mem.ID_MEMBER
     HAVING realNum != instantMessages;

     No database selected


I have no problem with the stats error, as smf seems perfectly capable of rebuilding its own stats anyways. It's the other stuff that's not working.

This seems to come from the 1.0 converter, right? You might wanna try the 1.1 converter as it can deal better with large databases.

I wouldn't be posting in this thread if it were the 1.0 converter ;) It's 1.1 I'm interested in, due to its support of explicit use of caching mechanisms like memcache, and the 1.0 converter doesn't even try to convert to a 1.1.

Allowing a 3rd party to directly access the database would be problematic. If you have any ideas as to what you'd look for, that'd be good. Otherwise I'll just have to wait until I have some real time to dedicate to looking into how the whole converter actually works. The fact that it does not appear to even try to copy over posts is the most strange thing to me.

I'm trying to convert a phpbb 2.0.17 board to 1.1.rc1

I'm getting:

Converting topics... Unsuccessful!
This query:

    INSERT INTO `xxxx_xxxxxx`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

bunches of numbers...

Caused the error:
    Duplicate entry '2' for key 1

Any suggestions?  Am I using an incorrect convertor?  The one in the dl's section is outdated and won't work.

Thanks,
Jason

The board you're converting from contains some integrity errors that prevent topics to be inserted. Most likely some of the topics have equal last messages. The easiest way to work around it is to change the indexes of the topics table to non-unique indexes:
ALTER TABLE smf_topics
DROP INDEX lastMessage,
DROP INDEX firstMessage,
DROP INDEX poll,
ADD INDEX lastMessage (ID_LAST_MSG, ID_BOARD),
ADD INDEX firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD INDEX poll (ID_POLL, ID_TOPIC)

After everything is converted, you can use the 'repair boards' function and readd the unique indexes if you like.

Thank you for your response!

Do I query this on the empty smf table like you said above?  Or did you mean for this to be run on the phpbb's table?   The SMF install is clean/empty.

Would it be easier to remove 1.1rc1 and install a clean 1.0.5 and try one of the existing convertors?

Regards,
Jason

Quote from: charlottezweb on November 10, 2005, 12:12:56 PMDo I query this on the empty smf table like you said above?  Or did you mean for this to be run on the phpbb's table?   The SMF install is clean/empty.

Yes on the empty SMF table. What it does is to redefine the indexes on the table to be non-unique, so that if records are added, no error is given on duplicate indexed records.

QuoteWould it be easier to remove 1.1rc1 and install a clean 1.0.5 and try one of the existing convertors?

The 1.1 converter should be more reliable than the 1.0.5 one. Besides, the above error will be in both converters.

Great, thanks.  I will try that. 

Last question for now  :)

You said:

QuoteAfter everything is converted, you can use the 'repair boards' function and readd the unique indexes if you like.[/quoute]

Will repair boards readd the unique indexes or is that something that will need to be queried manually?

If I don't do that, what will be missing? 

TIA,
Jason

Repair boards won't change the table structure, but it will correct the errors that apparently are in your phpBB install. Adding the unique indexes back is something that'll only increase speed a little and can be done by the query:
ALTER TABLE smf_topics
DROP INDEX lastMessage,
DROP INDEX firstMessage,
DROP INDEX poll,
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD),
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE poll (ID_POLL, ID_TOPIC)

Thank you so much!!

Will try this tonight/tomorrow.

Regards,
Jason

The converters in the first message have been updated. They should now all be compatible with MySQL 5.0.12. Also some queries have been adjusted to prevent the 'illegal mix of collations' error. A new converter has been added: e107.

if anybody has succesfully converted from eblah to smf please let me know.

also how does the converter handling attachment files and user permissions (i.e. moderators)?

hey, i am using myBB pr2 and i wanna convert to smf (any version).... but i tried putting the sql file into my smf directory and myBB directory but it doesn't work... it just shows plan text... i converter the sql file into php and its still the same... i try putting the sql file thru my phpmyadmin and it still doesn't work.. any help?

Did you use convert.php?

Quote from: charlottezweb on November 10, 2005, 12:42:43 PM
Thank you so much!!

Will try this tonight/tomorrow.

As an update, your first query did the trick and the convert.php worked like a charm.   I wasn't able to successfully run the second one.  It errored out but from your earlier posts, it seems it's not necessary.

It somehow altered the tld of the domain name so I had to alter that in a few files and in smf_settings via phpmyadmin.

Also, avatar sizing is not correct, even after adjusting it in the admin section.  If I have them select a different one and then revert back, it sizes it back down.  Otherwise, a 100x100 pixel avatar (for example) was showing many times larger.

All minor things -- overall, I'm impressed with the conversion.  Basically painless!

Thanks!!

-Jason

Quote from: Daniel D. on November 11, 2005, 11:09:21 AM
Did you use convert.php?

erm, i just uploaded mybb_to_smf.sql and run it.... i didn't recall any script thats convert.php....

It's in the first message of this topic.

Quote from: Twistey on October 15, 2005, 10:12:15 AM
I have problem with converting Mercuryboard 1.1.4 to SMF it says smf_personal_messages isnt there so it can't convert the personal messages to SMF..

I've got the same bug from e107 to SMF  :(

Are you converting to RC1?

From e107 v0.6174 to SMF v1.0.5

The e107 converter only works for 1.1 RC1. It's easiest to upgrade your SMF forum to 1.1 RC1 first, before doing the conversion.

It's ok with 1.1 RC1  ;)

..sorry, but ... all the subjects have 474 pages and 7109 Replies ....  :-[ :-[

hmm, odd. Can it be fixed by recounting? ('admin' -> 'Forum Maintenance' -> 'Recount all forum totals and statistics.')

Yesssssss  :) :) :)
I love SMF !!!!

erm, ok... here is what i got when i converted

QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
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... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Unsuccessful!
This query:

    SELECT pid AS ID_MSG, filedata, downloads, filename, filesize
    FROM `chat_test`.mybb_attachments
    LIMIT 0, 500;

Caused the error:

    Unknown column 'filedata' in 'field list'

i got that error and now i can;t log into my smf account but the the account at myBB still can be used.... and when i visited the smf forum which i converted over, no members were there, no forum were there.... nothing was there.... any help please?

Here is what I got when trying to move from e107 v 603 rbv6.  I'm thinking about uping my e107 version - would that make the conversion easier?

Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, u.user_name AS memberName,
    u.user_join AS dateRegistered, u.user_forums AS posts,
    IF (u.user_admin = 1, 1, 0) AS ID_GROUP, u.user_lastvisit AS lastLogin,
    u.user_name AS realName, u.user_password AS passwd,
    u.user_email AS emailAddress, 0 AS gender, u.user_birthday AS birthdate,
    REPLACE(u.user_homepage, 'http://', '') AS websiteTitle,
    u.user_homepage AS websiteUrl, u.user_location AS location,
    u.user_icq AS ICQ, u.user_aim AS AIM, u.user_msn AS MSN,
    u.user_hideemail AS hideEmail, u.user_signature AS signature,
    IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) AS timeOffset,
    u.user_image AS avatar, u.user_customtitle as usertitle,
    u.user_ip AS memberIP
    FROM `e107`.e107_user AS u
    WHERE u.user_id > 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'u.user_customtitle' in 'field list'

Might simply be solved by removing the u.user_customtitle as usertitle, part

Quote from: spicyjoe on November 14, 2005, 01:31:33 AM
erm, ok... here is what i got when i converted

Might be a version conflict. If you like I can look into it. Btw, since this is the last step of the actual conversion, it simply didn't fix the forum statistics. In order to do so, go to 'Admin' -> 'Forum Maintenance' -> 'Find and repair any errors' and '
Recount all forum totals and statistics', and after that, your forum should be alright, though the attachments haven't been converted.

Hey, thanks Compuart that suggestion worked great.

For this particular version of e107, either my original installer didn't install them or they are not available, but I also had to remove the sections concerning PMs. 

Thanks again.  SMF is pure sweetnes... :)

Compuart, check your pm and sorry to send to PM...

Grudge,
I am a complete php virgin but keep getting told to dump eblah for a DB backed forum and have installed SMS to www.ndpa.info/forum and tried to convert the existing forum at www.ndpa.info/mb  but the converter hits an error - presumably it is an unknown field.
The error is when converting members :- Unknown column 'pm_email_notify' in 'field list'
Any Ideas?

Quote from: HuttonIT on November 14, 2005, 12:19:23 PM
Grudge,
I am a complete php virgin but keep getting told to dump eblah for a DB backed forum and have installed SMS to www.ndpa.info/forum and tried to convert the existing forum at www.ndpa.info/mb  but the converter hits an error - presumably it is an unknown field.
The error is when converting members :- Unknown column 'pm_email_notify' in 'field list'
Any Ideas?

The converters only work for SMF version 1.1 RC1. Upgrade your SMF forum to 1.1 RC1 and the converter should work alright.

QuoteThe converters only work for SMF version 1.1 RC1. Upgrade your SMF forum to 1.1 RC1 and the converter should work alright.

Thanks Compuart I am uploading the upgrade as I type this and will run convert again.

I have downloaded and installed the SMF 1.1 RC1 then run the converter but it came up with some errors and although it imported all the users it didn't import any of the threads or boards?

QuoteConverting settings...
Warning: file(/home/fhlinux193/n/ndpa.info/user/htdocs/cgi-bin/mb/Prefs/News.txt): failed to open stream: Permission denied in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 346

Warning: implode(): Bad arguments. in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 346

Warning: file(/home/fhlinux193/n/ndpa.info/user/htdocs/cgi-bin/mb/Prefs/Names.txt): failed to open stream: Permission denied in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 363

Warning: Invalid argument supplied for foreach() in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 365

Warning: file(/home/fhlinux193/n/ndpa.info/user/htdocs/cgi-bin/mb/Prefs/Censor.txt): failed to open stream: Permission denied in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 378

Warning: Invalid argument supplied for foreach() in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 379
Successful.

Converting personal messages... Successful.

Converting boards and categories...
Warning: file(/home/fhlinux193/n/ndpa.info/user/htdocs/cgi-bin/mb/Boards/bdscats.db): failed to open stream: Permission denied in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 598

Warning: Invalid argument supplied for foreach() in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 601

Warning: file(/home/fhlinux193/n/ndpa.info/user/htdocs/cgi-bin/mb/Boards/bdindex.db): failed to open stream: Permission denied in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 620

Warning: Invalid argument supplied for foreach() in /home/fhlinux193/n/ndpa.info/user/htdocs/forum/eblah_to_smf.php on line 623

It looked although it completed but the above errors were recorded.
Anyone know what was goingon and able to offer any help with this?

Thanks for this tool, but I am having problems with IPB 2.1 and got the following error:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Array to string conversion in /home/pspacces/public_html/smf/import/convert.php(1627) : eval()'d code on line 8
Notice: Array to string conversion in /home/pspacces/public_html/smf/import/convert.php(1627) : eval()'d code on line 8
Notice: Array to string conversion in /home/pspacces/public_html/smf/import/convert.php(1627) : eval()'d code on line 8
Notice: Array to string conversion in /home/pspacces/public_html/smf/import/convert.php(1627) : eval()'d code on line 8

After a bunch of the notices above I got a fatal error:

Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 172 bytes in /home/pspacces/public_html/smf/import/convert.php(1305) : eval()'d code on line 89

Fatal error: Unsupported operand types in /home/pspacces/public_html/smf/import/convert.php(1305) : eval()'d code on line 89

php 4.4.1
mysql 4.1.x

And I did run with ?debug=0

Update: I commented out the lines causing the error and it did complete.

//if (eval($current_data) === false)
//  echo '<b>Error in convert script ', $_SESSION['convert_script'], ' on line ', $line_number, '! ......

All the polls did not come in correctly though.  Here is sample sql:

CREATE TABLE ibf_polls (
  pid mediumint(8) NOT NULL auto_increment,
  tid int(10) NOT NULL default '0',
  start_date int(10) default NULL,
  choices text,
  starter_id mediumint(8) NOT NULL default '0',
  votes smallint(5) NOT NULL default '0',
  forum_id smallint(5) NOT NULL default '0',
  poll_question varchar(255) default NULL,
  PRIMARY KEY  (pid),
  KEY tid (tid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `ibf_polls`
--

INSERT INTO ibf_polls VALUES (1, 31, 1113688847, 'a:1:{i:1;a:3:{s:8:"question";s:41:"What kind of media would you like to see?";s:6:"choice";a:5:{i:0;s:13:"Game Trailers";i:1;s:14:"Movie Trailers";i:2;s:16:"Flash Animations";i:3;s:12:"Music Videos";i:4;s:12:"Other (Post)";}s:5:"votes";a:5:{i:0;i:0;i:1;i:2;i:2;i:8;i:3;i:22;i:4;i:3;}}}', 1, 35, 10, 'What kind of media would you like to see?');
INSERT INTO ibf_polls VALUES (2, 57, 1113966102, 'a:1:{i:1;a:3:{s:8:"question";s:11:"Which game?";s:6:"choice";a:2:{i:0;s:7:"Mercury";i:1;s:7:"Lumines";}s:5:"votes";a:2:{i:0;i:4;i:1;i:10;}}}', 1, 14, 8, 'Which game?');
       

I am attempting to convert an e-blah forum 9.2 at www.ndpa.info/mb (http://www.ndpa.info/mb) to SMF but am having some difficulties with the converter.
     I have installed a clean SMF 1.1 RC1 (www.ndpa.info/forum (http://www.ndpa.info/forum)) and the eblah_to_smf.php and convert.php to the same directory.
The first time I ran it there were some access problems as posted in my previous post.
With this in mind  I have backed up the working forum to a new folder and set all the permissions to CMOD 777 so there are no access conflicts.
This time I get this

QuoteUnsuccessful!
This query:
    ALTER TABLE `ndpa`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD;
Caused the error:
    Can't DROP 'topic'. Check that column/key exists

When I look at the forum www.ndpa.info/forum there are no users nor messages.  However, the index is there.  The last time attempted to convert  only the user accounts were imported.
     Any ideas or assistance welcome.

Hi again.  No help yet but I have pressed on anyway.
I have managed to import users and the index by importing the users from the active eblah forum and then ran the eblah_to_smf.php again but pointing at the archived and CMODed folder of the forum.  This time I did not ask it to delete existing posts and members.  It has now converted the board index only and no messages.  A little closer to being there now.  All I need is the messages to be converted.
The last process produced exactly the same error:-

QuoteConverting...
Unsuccessful!
This query:
    ALTER TABLE `ndpa`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD;
Caused the error:
    Can't DROP 'topic'. Check that column/key exists

I have backed up the DB so now at least have the users and index as it stands now.
Anyone explain the error Can't DROP 'topic'. Check that column/key exists so I can get this forum converted and get the users back on line and working properly in SMS?

I've installed smf 1.1 Rc1 and converted the database from a vbulletin 3.0.9 which was really easy,

Quote
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
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... Successful.
Converting board notifications... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

yet at the end it seem to get stuck in a loop, for it keeps reloading a page with this message

Quote
Converting...
Recalculating forum statistics... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

So i close this page and go to the forum admin maintenance - Forum Maintenance
First I start "Find and repair any errors", which gives me a list of personal messages that have been send to unexisting members, so i fix
Next i do a "Recount all forum totals and statistics", that fixes invalid personal message count and then i do "Optimize all tables to improve performance"

That seem to get everything converted and showing up correctly (at first glance)

Thank you, SMF team for a great forum.
The installation is really easy and the forums are quite helpfull.
Thank you all  :D

Hi again,
Having just read Indra's post I have just re-installed everything again. I have run the converter for eblah and again it stated there were errors.  However, this time I have checked the DB and downloaded it in csv format and opened it in a text editor.  I find the posts are there but not shown as being part of anything. then I noticed what Indra had to do:-

QuoteSo i close this page and go to the forum admin maintenance - Forum Maintenance
First I start "Find and repair any errors", which gives me a list of personal messages that have been send to unexisting members, so i fix
Next i do a "Recount all forum totals and statistics", that fixes invalid personal message count and then i do "Optimize all tables to improve performance"
That seem to get everything converted and showing up correctly (at first glance)

Well I had different errors but buy following the same process it worked for me too so if anyone is trying to convert a good hint is to do exactly the same as above.
That said none of the permissions on the forum are correct for users with differing access levels.
I have a board just for Admin users, one for committee members and one where Guests can view only and now find that a guest can see the whole forum.  I will now have to work on permissions for each board......  >:(  Another bug but I can live with that is that HTML has been imported as text so instead of line breaks there are <br> HTML etc.... Mind it is heading in the right direction now.
However, it is a lot slower than eblah the load time for threads is about 4-6 times slower?
Getting there...slowley...  :D 

Yes, also with me board permissions are reset, html tags are alright, at least they are showing up properly at forum display, and thats what matters

Maybe you have to allow html code to be parsed, HuttonIT, this is something i also had to set in my previous forum for it to display some tables i posted.

Yet now, after the conversion, the tables show up properly, does smf allow html in post as a default or did it copy (a part of?) the permissions from my vbulletin forum.
something that i might look up, later :)

On of the other admins for our site tried to use the simpleboard converter and he sent me this messege of what happened.
Maybe because our board was upgraded from simpleboard to joomlaboard. :(

Quote
I installed SMF and tried the converter but it didn't quite work, perhaps because we're converting from Joomlaboard now, not Simpleboard.

First it converts all the users and posts, which seems fine.  Then it fails to find some posted images, which I couldn't find on the server anyway.  Then it says recalculating forum statistics... incomplete.  And it says conversion paused to avoid overloading the server.  It seems to continue at a few seconds intervals, but it stays like this forever, so something is clearly wrong.

Have a look at the SMF board, it looks kinda funky:

www.evilsmurf.com/smf/

Somehow the posts are full of broken img tags.

- Geir

Any chance of making a converter specific to joomlaboard. I think he thought the simpleboard would work..

I've never even heard of Joomlaboard until now. I find it odd that such a thing even exists considering that the official Joomla site is using SMF... I'm not sure what the difference is between the two, but we'll look into the issue.

Joomlaboard is the next version of Simpleboard by the same guy.

Invision Power board 2.1 has the following problems on import:
1) polls do not import
2) bbcode in signatures gets displayed
3) there is misc bbcode in the message bodies
4) smileys show up as code
5) groups do not come in
6) some quotes show up as bbcode

Has anyone been able to successfully import IPB 2.1?  I have a data dump if that could help and could give specific examples.  I have not found any other BB that has a converter for 2.1 so SMF would be the first.

Quote from: hozt on November 17, 2005, 01:37:13 AM
Invision Power board 2.1 has the following problems on import:
1) polls do not import
2) bbcode in signatures gets displayed
3) there is misc bbcode in the message bodies
4) smileys show up as code
5) groups do not come in
6) some quotes show up as bbcode

All the above applied to my conversion from e-Blah except I can add to the list in that the PMs and forum access levels were not imported too.  However, having said that I can live with that as the forum is now up and running after about 6 hours of messing about and the transition to the users from one forum to the other meant no down time at all and only 3 messages had to be input by me for members which posted on the old one while I was converting and getting it ready.  The first they knew was when they were presented with a completely different look.  I even kept the same URL by simply changing the source in the frame calling the forum from the old one to the new one.
Have a look if you want at www.ndpa.info (no guest access to the forums except the rules - but you could always register to see half of it open to the public)

So I have some time to mess around with the converter (vb3 in particular) directly now, having downloaded an entire copy of the database locally so I can do it directly instead of from cron. Turns out it probably didn't work because it really isn't designed to be run automatically. I'm not sure why it ever said it was successful.

Anyways, it would be better if the queries were better tuned. For example, with 70,000 threads, each 500 thread 'page' of the results being converted was taking about 3 *minutes* to complete, which meant it would be done in about 7 hours. Removing the table join (and replacing the fields with dummy data that can be regenerated later, as well as removing the indexes affected) made the thread table convert in seconds. I also tried making it use a covering index, since it was invoking a filesort, but that didn't help very much. I suspect that while fixing the dummy fields will be time consuming, it will be very unlikely to take 7 hours.

A similar optimization to the post table (where the joined values are even easier to generate) has caused an improvement as well, but not by the same degree. My 2 million posts will probably be done in about 40min-1hr, which isn't too bad.

I keep getting Converting Posts Unsuccessful!

Got a packet bigger than 'max_allowed_packet'

Any ideas about how I can solve this?

My problem is:

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: '[email protected]' for table 'phpbb_users'

I have phpBB 2.0.15. The username and the databases for each phorums are diferent. auser is the user for smf and buser is the user for phpBB. Can you help me?

Trying to convert YabbSE 1.5.5 to 1.1 RC1 and am getting the following error:


Converting members... Unsuccessful!
This query:
SELECT ID_MEMBER, im_ignore_list
FROM `digidata`.yabbse_members
WHERE im_ignore_list RLIKE '[a-z]'
LIMIT 512;
Caused the error:

Unknown column 'im_ignore_list' in 'field list'


Thinking it was due to a mod which added thet im_ignore_list column, i deleted it, but am still getting that error.

thanks!!!

Sorry, but I'm reading this thread and I'm unable to find a converter for vbulletin 3.5 to SMF 1.1 :(

Anyone knows if there are any converter to do this?

Sorry for my poor english ;)

regards from spain

I was able to get the conversion to go by deleting the area in the script that was converting the im_ignore_list. after that the conversion was stopping at trying to convert the Email Notifications but i just commented that out and it ran through but then i got a duplicate entries in the log_notfiy but after deleting the entires manually in the database the conversion completed with some errors but everything looks like its there... thanks guys!!!!!

Quote from: netlite on November 23, 2005, 06:13:04 PM
My problem is:

Code Select Expand

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: '[email protected]' for table 'phpbb_users'

I have the solution!
You have two folders, one being the forum you need to convert from (A) , and a folder you need to convert to  (B).

You have two databases, one being say database_A and database_B

If you try converting, you'll get the error "...the MySQL account used does not have permissions to access it."

Solution: Export the tables from Database_B once its been freshly installed and import them to Database_A.  Its not pretty, but your tables will have a prefix to prevent overrighting, such as phpbb_ mb_ or smf_

Go to the settings/config.php file in the folder (B) which was tied to Database_B and tell it that it is now in Database_A


The reason is that the converter is ment to be done in the same database, but between different tables.  Dont know why, but that is the only solution if you get that problem.


Furthermore, for those whom want to convert from Mercuryboard, I fixed the converter!  I spent the day editing PHP and MYSQL code to bypass the smf_private_pms error.

Download the file and run it from the directory of the forum you want to be converted to.  It has been zipped with WinRar. (for those who only use Winzip to know)

It has a couple mysql errors at the very end but it sucessfully converts topics, ranks, usernames, profiles, avatars, boards, posts.. you name it!

http://www.dragonannihilators.net/mercurytosmfconverter.rar (http://www.dragonannihilators.net/mercurytosmfconverter.rar)

Hi, I'm using the YaBB2 converter, and when it converts the messages, it gets stucked on a loop. It only converts a few messages (around 23000 out of 73000) and then says something about no primary key to drop, and duplicated column "temp_filename". So I tried creating a primary key and deleting the column, and it does the same again. Then I tried deleting the "drop key" and "add column" query, and it still went in a loop, reconverting all the messages on and on.
I would really appreciate any kind of help. Thank you.

PS: By loop, I mean that I keep getting the "Not quite done yet" message.

yeah, you'll have to go into the php and fidn the section it cannot do, remove it manually and then reupload.   It will skip what you took out and at least finish the rest.  Cant convert everything, but at least it works.

Yes, that's what I did. But there's still the loop, with the difference that now it's automatic. As soon as it gets to around 27.000 messages, it starts from 0 again. :'(
Thanks for answering. :D

Quote from: Compuart on November 10, 2005, 11:00:35 AM
The board you're converting from contains some integrity errors that prevent topics to be inserted. Most likely some of the topics have equal last messages. The easiest way to work around it is to change the indexes of the topics table to non-unique indexes:

Code Select Expand

ALTER TABLE smf_topics
DROP INDEX lastMessage,
DROP INDEX firstMessage,
DROP INDEX poll,
ADD INDEX lastMessage (ID_LAST_MSG, ID_BOARD),
ADD INDEX firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD INDEX poll (ID_POLL, ID_TOPIC)

After everything is converted, you can use the 'repair boards' function and readd the unique indexes if you like.

Hi, i also used the way that you suggest, but there is a problem...

If i click on "Find and repair any errors." is this listed:

Listing of forum errors
The following errors are fouling up your forum:
The subject of topic #2 is currently not stored in the subject cache.
The subject of topic #3 is currently not stored in the subject cache.
The subject of topic #4 is currently not stored in the subject cache.
The subject of topic #8 is currently not stored in the subject cache.
.............
The subject of topic #20755 is currently not stored in the subject cache.
The subject of topic #20756 is currently not stored in the subject cache.
The subject of topic #20757 is currently not stored in the subject cache.
The subject of topic #20758 is currently not stored in the subject cache.
Cached word 'bei' is linked to a non-existant topic.
Cached word 'smf' is linked to a non-existant topic.
Cached word 'willkommen' is linked to a non-existant topic.

Would you like to fix these errors?
Yes - No

And if i click on YES the following error appears:

Database Error
MySQL server has gone away
File: /usr/local/vhosts/httpd/htdocs/forum2/Sources/RepairBoards.php
Line: 626

Help is needed, Thanx!

Update: still need help, is it possible to get the SQL Codes of that work of RepairBoards.php, so that i can drop the sql code manually in phpmyadmin?

Quote from: testomg iser on November 26, 2005, 10:09:33 PM

Quote from: netlite on November 23, 2005, 06:13:04 PM

You have two databases, one being say database_A and database_B

If you try converting, you'll get the error "...the MySQL account used does not have permissions to access it."

Solution: Export the tables from Database_B once its been freshly installed and import them to Database_A.  Its not pretty, but your tables will have a prefix to prevent overrighting, such as phpbb_ mb_ or smf_

Go to the settings/config.php file in the folder (B) which was tied to Database_B and tell it that it is now in Database_A


The reason is that the converter is ment to be done in the same database, but between different tables.  Dont know why, but that is the only solution if you get that problem.

I have never messed with the tables before.  Can you help with more specific instructions
thanks
Sally

i still need help, i need a RepairBoards.php which loads in steps to avoid the mySQL time out or i need the SQL code to drop it manually in phpmyadmin....

any ideas?

I use Mambo 4.5.2.3, SMF 1.1 RC1, Mambo-SMF.

I run convert.php with simpleboard_to_smf.sql

In Simpleboard:
Testing

After run convert.php, I got this in SMF
T[img width=][img width=]t[img width=]n[img width=]

What am I missing?

Thanks

I'm having some issues converting from Invision v2.1.3 to SMF 1.1RC1.  Here's the error:

Converting...
Converting poll options...
Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `azinfol_smf`.smf_poll_choices

(ID_POLL, ID_CHOICE, label, votes)

VALUES (538, 'What - if any - political party do you associate with?', 'Array', 'Array'),

(538, 'Do you consider yourself ...', 'Array', 'Array'),

(538, 'What is your religion?', 'Array', 'Array'),

(535, 'Which are you?', 'Array', 'Array'),

(536, 'How do you feel about your body after reading a popular women's magazine ( i.e. cosmo, glamour, etc)?', 'Array', 'Array'),

(537, 'What did you do while AZInfoline was down?', 'Array', 'Array'),

(534, 'If you found an abandoned DJ, what would you do with it?', 'Array', 'Array');
Caused the error:
Duplicate entry '538-0' for key 1

This appears to be from the multiple-question-per-poll feature of Invision.  Is there a workaround for this?  I can live without the polls, or perhaps just the first poll question, so any help would be really appreciated.  :)

Unfortunately, SMF only allows one question per poll. I'm working on fixing the issues for 2.1.3 at the moment, so I'll just have SMF pull the first poll question for each one.

Any luck? ;)

Infinite loop when converting a phpBB forum.

While converting a small phpbb2.0.2 forum to smf, i faced an infinite loop during the attachment convertion (substep 10).
My forum contains no attachments but a small number of uploaded avatars. The issue comes from the following statement:
            // Probably not one of the converted ones, then?
            if (!file_exists($filename))
               continue;


This means the row is not processed and then will be retrieved again on the next loop, again and again...

In my case i just disabled the step and everthing went smooth...

I'm converting from Ikonboard 3.1.2a and I get this error message. Any thought on what is wrong?

Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `floridac_smf`.smf_log_notify
    (ID_MEMBER, ID_TOPIC, sent)
    VALUES ('10', '267', ''),
    ('20', '98', ''),
    ('20', '230', ''),
    ('24', '1', ''),
    ('24', '2', ''),
    ('24', '3', ''),
    ('24', '3', ''),
    ('24', '4', ''),
    ('24', '5', ''),
    ('24', '5', ''),
    ('24', '5', ''),
    ('24', '6', ''),
    ('24', '6', ''),
    ('24', '6', ''),
    ('24', '7', ''),
    ('24', '7', ''),
    ('24', '7', ''),
    ('24', '8', ''),
    ('24', '9', ''),
    ('24', '9', ''),
    ('24', '9', ''),
    ('24', '9', ''),
    ('24', '10', ''),
    ('24', '11', ''),
    ('24', '12', ''),
    ('24', '13', ''),
    ('24', '15', ''),
    ('24', '16', ''),
    ('24', '17', ''),
    ('24', '17', ''),
    ('24', '18', ''),
    ('24', '19', ''),
    ('24', '19', ''),
    ('24', '19', ''),
    ('24', '20', ''),
    ('24', '20', ''),
    ('24', '21', ''),
    ('24', '21', ''),
    ('24', '22', ''),
    ('24', '23', ''),
    ('24', '23', ''),
    ('24', '24', ''),
    ('24', '25', ''),
    ('24', '26', ''),
    ('24', '27', ''),
    ('24', '28', ''),
    ('24', '29', ''),
    ('24', '30', ''),
    ('24', '31', ''),
    ('24', '31', ''),
    ('24', '32', ''),
    ('24', '33', ''),
    ('24', '34', ''),
    ('24', '35', ''),
    ('24', '36', ''),
    ('24', '37', ''),
    ('24', '37', ''),
    ('24', '38', ''),
    ('24', '39', ''),
    ('24', '40', ''),
    ('24', '41', ''),
    ('24', '42', ''),
    ('24', '42', ''),
    ('24', '43', ''),
    ('24', '44', ''),
    ('24', '46', ''),
    ('24', '48', ''),
    ('24', '49', ''),
    ('24', '50', ''),
    ('24', '51', ''),
    ('24', '52', ''),
    ('24', '53', ''),
    ('24', '53', ''),
    ('24', '53', ''),
    ('24', '54', ''),
    ('24', '54', ''),
    ('24', '56', ''),
    ('24', '57', ''),
    ('24', '58', ''),
    ('24', '58', ''),
    ('24', '58', ''),
    ('24', '59', ''),
    ('24', '60', ''),
    ('24', '61', ''),
    ('24', '62', ''),
    ('24', '62', ''),
    ('24', '62', ''),
    ('24', '63', ''),
    ('24', '63', ''),
    ('24', '65', ''),
    ('24', '66', ''),
    ('24', '67', ''),
    ('24', '68', '0'),
    ('24', '69', ''),
    ('24', '70', ''),
    ('24', '71', ''),
    ('24', '72', ''),
    ('24', '73', ''),
    ('24', '73', ''),
    ('24', '73', ''),
    ('24', '73', ''),
    ('24', '74', ''),
    ('24', '75', ''),
    ('24', '75', ''),
    ('24', '76', ''),
    ('24', '77', ''),
    ('24', '78', ''),
    ('24', '79', ''),
    ('24', '80', ''),
    ('24', '81', ''),
    ('24', '82', ''),
    ('24', '83', ''),
    ('24', '84', ''),
    ('24', '84', ''),
    ('24', '85', ''),
    ('24', '86', ''),
    ('24', '86', ''),
    ('24', '86', ''),
    ('24', '88', ''),
    ('24', '88', ''),
    ('24', '89', ''),
    ('24', '89', ''),
    ('24', '89', ''),
    ('24', '90', ''),
    ('24', '90', ''),
    ('24', '91', ''),
    ('24', '91', ''),
    ('24', '92', ''),
    ('24', '93', ''),
    ('24', '94', ''),
    ('24', '95', ''),
    ('24', '96', ''),
    ('24', '97', ''),
    ('24', '98', ''),
    ('24', '99', ''),
    ('24', '99', ''),
    ('24', '99', ''),
    ('24', '100', ''),
    ('24', '101', ''),
    ('24', '102', ''),
    ('24', '103', ''),
    ('24', '104', ''),
    ('24', '105', ''),
    ('24', '105', ''),
    ('24', '105', ''),
    ('24', '106', ''),
    ('24', '106', ''),
    ('24', '107', ''),
    ('24', '107', ''),
    ('24', '108', ''),
    ('24', '109', ''),
    ('24', '110', ''),
    ('24', '111', ''),
    ('24', '111', ''),
    ('24', '111', ''),
    ('24', '111', ''),
    ('24', '112', ''),
    ('24', '113', ''),
    ('24', '114', ''),
    ('24', '115', ''),
    ('24', '115', ''),
    ('24', '116', ''),
    ('24', '117', ''),
    ('24', '117', ''),
    ('24', '118', ''),
    ('24', '119', ''),
    ('24', '121', ''),
    ('24', '122', ''),
    ('24', '123', ''),
    ('24', '124', ''),
    ('24', '125', ''),
    ('24', '126', ''),
    ('24', '127', ''),
    ('24', '127', ''),
    ('24', '127', ''),
    ('24', '127', ''),
    ('24', '128', ''),
    ('24', '129', ''),
    ('24', '130', ''),
    ('24', '131', ''),
    ('24', '133', ''),
    ('24', '134', ''),
    ('24', '134', ''),
    ('24', '135', ''),
    ('24', '136', ''),
    ('24', '136', ''),
    ('24', '137', ''),
    ('24', '138', ''),
    ('24', '139', ''),
    ('24', '140', ''),
    ('24', '142', ''),
    ('24', '143', '0'),
    ('24', '143', '0'),
    ('24', '143', '0'),
    ('24', '143', '0'),
    ('24', '143', '0'),
    ('24', '143', '0'),
    ('24', '144', ''),
    ('24', '144', ''),
    ('24', '145', ''),
    ('24', '146', ''),
    ('24', '147', ''),
    ('24', '147', ''),
    ('24', '148', ''),
    ('24', '149', ''),
    ('24', '150', ''),
    ('24', '150', ''),
    ('24', '151', ''),
    ('24', '152', ''),
    ('24', '153', ''),
    ('24', '154', ''),
    ('24', '155', ''),
    ('24', '156', ''),
    ('24', '157', ''),
    ('24', '158', ''),
    ('24', '159', ''),
    ('24', '160', ''),
    ('24', '161', ''),
    ('24', '162', ''),
    ('24', '162', ''),
    ('24', '162', ''),
    ('24', '163', ''),
    ('24', '164', ''),
    ('24', '165', ''),
    ('24', '166', ''),
    ('24', '167', ''),
    ('24', '167', ''),
    ('24', '167', ''),
    ('24', '168', ''),
    ('24', '168', ''),
    ('24', '169', ''),
    ('24', '170', ''),
    ('24', '170', ''),
    ('24', '170', ''),
    ('24', '170', ''),
    ('24', '171', ''),
    ('24', '172', ''),
    ('24', '173', ''),
    ('24', '173', ''),
    ('24', '174', ''),
    ('24', '175', ''),
    ('24', '176', ''),
    ('24', '176', ''),
    ('24', '177', ''),
    ('24', '177', ''),
    ('24', '178', ''),
    ('24', '179', ''),
    ('24', '180', ''),
    ('24', '180', ''),
    ('24', '180', ''),
    ('24', '180', ''),
    ('24', '180', ''),
    ('24', '180', ''),
    ('24', '181', ''),
    ('24', '183', ''),
    ('24', '184', ''),
    ('24', '184', ''),
    ('24', '185', ''),
    ('24', '186', ''),
    ('24', '187', ''),
    ('24', '187', ''),
    ('24', '187', ''),
    ('24', '187', ''),
    ('24', '188', ''),
    ('24', '189', ''),
    ('24', '190', ''),
    ('24', '191', ''),
    ('24', '194', ''),
    ('24', '194', ''),
    ('24', '194', ''),
    ('24', '194', ''),
    ('24', '195', ''),
    ('24', '196', ''),
    ('24', '197', ''),
    ('24', '199', ''),
    ('24', '200', ''),
    ('24', '201', ''),
    ('24', '202', ''),
    ('24', '203', ''),
    ('24', '204', ''),
    ('24', '205', ''),
    ('24', '205', ''),
    ('24', '206', ''),
    ('24', '207', ''),
    ('24', '208', ''),
    ('24', '208', ''),
    ('24', '208', ''),
    ('24', '208', ''),
    ('24', '209', ''),
    ('24', '210', ''),
    ('24', '212', ''),
    ('24', '213', ''),
    ('24', '213', ''),
    ('24', '214', ''),
    ('24', '215', '0'),
    ('24', '215', '0'),
    ('24', '216', ''),
    ('24', '217', ''),
    ('24', '218', ''),
    ('24', '219', ''),
    ('24', '220', ''),
    ('24', '221', ''),
    ('24', '222', ''),
    ('24', '222', ''),
    ('24', '223', ''),
    ('24', '223', ''),
    ('24', '224', ''),
    ('24', '224', ''),
    ('24', '225', ''),
    ('24', '226', ''),
    ('24', '227', ''),
    ('24', '228', ''),
    ('24', '229', ''),
    ('24', '229', ''),
    ('24', '229', ''),
    ('24', '230', ''),
    ('24', '230', ''),
    ('24', '231', ''),
    ('24', '232', ''),
    ('24', '232', ''),
    ('24', '232', ''),
    ('24', '232', ''),
    ('24', '233', ''),
    ('24', '234', ''),
    ('24', '234', ''),
    ('24', '234', ''),
    ('24', '234', ''),
    ('24', '235', ''),
    ('24', '235', ''),
    ('24', '236', ''),
    ('24', '237', ''),
    ('24', '238', ''),
    ('24', '238', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '239', ''),
    ('24', '240', ''),
    ('24', '241', ''),
    ('24', '242', ''),
    ('24', '243', ''),
    ('24', '244', ''),
    ('24', '245', ''),
    ('24', '246', ''),
    ('24', '246', ''),
    ('24', '247', ''),
    ('24', '248', '0'),
    ('24', '249', ''),
    ('24', '250', ''),
    ('24', '251', ''),
    ('24', '252', ''),
    ('24', '253', ''),
    ('24', '253', ''),
    ('24', '254', ''),
    ('24', '255', ''),
    ('24', '255', ''),
    ('24', '255', ''),
    ('24', '256', ''),
    ('24', '257', ''),
    ('24', '258', ''),
    ('24', '259', ''),
    ('24', '260', ''),
    ('24', '261', ''),
    ('24', '262', ''),
    ('24', '264', ''),
    ('24', '266', ''),
    ('24', '266', ''),
    ('24', '266', ''),
    ('24', '266', ''),
    ('24', '266', ''),
    ('24', '267', ''),
    ('24', '267', ''),
    ('24', '268', ''),
    ('24', '269', ''),
    ('24', '270', ''),
    ('24', '271', ''),
    ('24', '272', ''),
    ('24', '273', ''),
    ('24', '274', ''),
    ('24', '275', ''),
    ('24', '276', ''),
    ('24', '276', ''),
    ('24', '276', ''),
    ('24', '277', ''),
    ('24', '279', ''),
    ('24', '280', ''),
    ('24', '283', ''),
    ('24', '284', ''),
    ('24', '284', ''),
    ('24', '284', ''),
    ('24', '285', ''),
    ('24', '286', '1'),
    ('24', '287', ''),
    ('24', '287', ''),
    ('24', '288', '0'),
    ('24', '552', '1'),
    ('24', '553', '0'),
    ('24', '558', '1'),
    ('24', '564', '0'),
    ('24', '567', '0'),
    ('24', '568', '1'),
    ('24', '568', '1'),
    ('24', '570', '1'),
    ('24', '573', '1'),
    ('24', '576', '0'),
    ('24', '577', '1'),
    ('24', '592', '1'),
    ('24', '592', '1'),
    ('24', '596', '0'),
    ('24', '597', '1'),
    ('24', '597', '1'),
    ('24', '598', '0'),
    ('24', '608', '0'),
    ('24', '608', '0'),
    ('24', '608', '0'),
    ('24', '610', '0'),
    ('24', '611', '0'),
    ('24', '612', '0'),
    ('24', '613', '0'),
    ('24', '614', '0'),
    ('24', '618', '0'),
    ('24', '618', '0'),
    ('24', '623', '0'),
    ('24', '624', '1'),
    ('24', '625', '1'),
    ('24', '628', '0'),
    ('24', '289', ''),
    ('24', '290', ''),
    ('24', '292', ''),
    ('24', '293', ''),
    ('24', '293', ''),
    ('24', '293', ''),
    ('24', '294', ''),
    ('24', '295', ''),
    ('24', '296', ''),
    ('24', '297', ''),
    ('24', '298', ''),
    ('24', '299', ''),
    ('24', '299', ''),
    ('24', '300', ''),
    ('24', '301', ''),
    ('24', '302', ''),
    ('24', '303', ''),
    ('24', '304', ''),
    ('24', '305', ''),
    ('24', '306', ''),
    ('24', '307', ''),
    ('24', '308', ''),
    ('24', '309', ''),
    ('24', '310', ''),
    ('24', '311', ''),
    ('24', '311', ''),
    ('24', '312', ''),
    ('24', '314', ''),
    ('24', '315', ''),
    ('24', '315', ''),
    ('24', '315', ''),
    ('24', '315', ''),
    ('24', '315', ''),
    ('24', '316', ''),
    ('24', '316', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '317', ''),
    ('24', '318', ''),
    ('24', '318', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '319', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '320', ''),
    ('24', '321', ''),
    ('24', '322', ''),
    ('24', '322', ''),
    ('24', '322', ''),
    ('24', '322', ''),
    ('24', '322', ''),
    ('24', '323', ''),
    ('24', '325', ''),
    ('24', '326', '');

Caused the error:

    Duplicate entry '10-267-0' for key 1

didn`t read now,

maby somebody asked it.
but if my prefix iz ldp_ not phpBB ???
will http://www.simplemachines.org/download.php?converters phpbb2_to_smf.php work?
and HOW it works?

no manual ;) i`m not good at php so didnt understood :/ sorry for abuse ;(

I'm trying to use the phpbb2_to_smf.php but it keeps failing with this error:

QuoteThe installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

This is with a new install of smf_1-1-rc1_install.tar.gz and an existing phpbb 2.0.10.  Any ideas?  Also where is this convert.php I see people talking about.. I can't find it anywhere.

http://www.simplemachines.org/community/index.php?topic=38966.0
first post ;)

whoops don't mine me~ :o

Has there been any progress on the IPB 2.1.3 converter?  I'm dying to switch away, but vB is starting to look pretty good at this point... :(

Quote from: Compuart on November 10, 2005, 11:00:35 AM
The board you're converting from contains some integrity errors that prevent topics to be inserted. Most likely some of the topics have equal last messages. The easiest way to work around it is to change the indexes of the topics table to non-unique indexes:

Code Select Expand

ALTER TABLE smf_topics
DROP INDEX lastMessage,
DROP INDEX firstMessage,
DROP INDEX poll,
ADD INDEX lastMessage (ID_LAST_MSG, ID_BOARD),
ADD INDEX firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD INDEX poll (ID_POLL, ID_TOPIC)

After everything is converted, you can use the 'repair boards' function and readd the unique indexes if you like.

I have tried the above while attempting to convert phpbb 2.0.18 to smf 1.1 and have been getting following error message:

__________________________________________________________
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `blahblah`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)
VALUES ('7585',

Caused the error:

Duplicate entry '7585' for key 1
_________________________________________________

Will appreciate it if anyone can help me. Thanks in advance.

Cheers,
Mellie

i Have SMF 1.1 RC 1 an the phpBB2 Converter from August 2005.
i got the Error:
The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

What happened?

Quote from: CoasterJoe.com on December 05, 2005, 06:47:17 AM
I'm converting from Ikonboard 3.1.2a and I get this error message. Any thought on what is wrong?

Converting topic notifications... Unsuccessful!
This query:

Caused the error:

    Duplicate entry '10-267-0' for key 1

I had a few of these errors when I converted my IB, I think from memory I had phpmyadmin open at the same time and tried deleting the offending duplicate - didnt work

So I deleted any topic notifications from the IB database to start with  ;D

it has forteh past liek 2-3 hrs been giving me this

Recalculating forum statistics... Incomplete.

um iyts stilldoing it i dunno can i close it ? ad asuem its all fine?

Quote from: keisa on December 19, 2005, 07:09:35 AM
it has forteh past liek 2-3 hrs been giving me this

Code Select Expand

Recalculating forum statistics... Incomplete.

um iyts stilldoing it i dunno can i close it ? ad asuem its all fine?

What system are you converting from?

How large is the board?

Depending, it could be normal.

There seems to be a bug in the converter that causes it to keep doing that and never finish. It should be safe to ignore the problem and go on to the converted board as that's the last step in the converter.

Quote from: Oldiesmann on December 20, 2005, 10:26:46 AM
There seems to be a bug in the converter that causes it to keep doing that and never finish. It should be safe to ignore the problem and go on to the converted board as that's the last step in the converter.

ah thx to you oldesmann!

is there a converter for mybb, because i searched and because in this topic (http://www.simplemachines.org/community/index.php?topic=56889.0) spicyjoe said he used the mybb converter, so i was wondering.

thanks

Quote from: ajburnett34 on December 27, 2005, 03:16:20 PM
is there a converter for mybb, because i searched and because in this topic (http://www.simplemachines.org/community/index.php?topic=56889.0) spicyjoe said he used the mybb converter, so i was wondering.

thanks

It's in the first post of this topic.

I have a an error converting phpbb2 (last version 2.0.19)  to SMF RC1:

Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `tcmtotal_forum`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('2', '2'),
    ('2', '3'),

...

     ('2', '294'),
    ('105', '280');

Caused the error:

    Duplicate entry '2-2-0' for key 1

Somebody knows what is wrong?

Maybe usefull: the full log (http://www.tcmtotal.com/erro-smf.txt)

I am converting to 1.1 RC1  from Vbulletin 3.0.8.  I am in a loop:
Converting...
Recalculating forum statistics... Incomplete.

I have optimized and repaired the VB tables, recounted statistics.. it still loops. Any ideas of what I need to do?

Thank you so much- I am just grateful for a vB3 converter- I am so tired of being under their thumb!

Well I just checked the smf forum and it seems everything, including the attachments are there- even though the converter was in a loop-- does that mean it should be in the clear?

You can recallculate forum statistics from the admin pages after the conversion.
You need to do that and check for orphin threads/forums/category's/PM/messages anyways.

A long running VB install tends to litter its database with quite a few orphins.

Tried converting from Invision 2 boards and got the following:

QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 200 bytes in /home/theredee/public_html/boards/convert.php(653) : eval()'d code on line 89

Fatal error: Unsupported operand types in /home/theredee/public_html/boards/convert.php(653) : eval()'d code on line 89

-Unshra

phpbb2.0.19 convert (everything newest version):

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `sonofsam`.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', '2', '157', '3', '2', '3', '', '0', '18', '282'),
    ('3', '0', '3', '181', '3', '10', '1', '', '0', '5', '44'),
    ('4', '0', '5', '193', '3', '3', '1', '', '0', '12', '90'),
    ('5', '0', '15', '516', '2', '10', '3', '', '0', '20', '362'),
    ('6', '0', '22', '65', '3', '3', '1', '', '0', '11', '68'),
    ('7', '0', '38', '844', '3', '42', '3', '', '0', '31', '871'),
    ('8', '0', '48', '1228', '-1', '3', '3', '', '0', '6', '213'),
    ('9', '0', '51', '205', '2', '2', '3', '', '1', '17', '402'),
...
    ('108', '0', '816', '5645', '39', '5', '5', '', '0', '4', '333'),
    ('109', '0', '817', '5640', '29', '5', '5', '', '0', '3', '206'),
    ('110', '0', '820', '830', '42', '42', '1', '', '0', '1', '26'),
    ('111', '0', '823', '828', '2', '42', '1', '', '0', '2', '55'),
    ('112', '0', '834', '1088', '29', '3', '1', '', '0', '10', '73'),
...
    ('582', '0', '5369', '5424', '7', '2', '1', '18', '0', '12', '62');

Caused the error:

    Duplicate entry '110-3' for key 2

When will this duplicate entry problem solved??

1 have this error converting from mybb1.00 Preview Release 2


when converting topics...
INSERT INTO `my_databasename`.smf_log_topics
(ID_TOPIC, ID_MEMBER, logTime)
VALUES ('350', '4', '1130950869'),
('46', '2', '1130965344'),
('369', '42', '1130965536'),
ecc...
Converting topic view logs... Unsuccessful!

Caused the error:

Unknown column 'logTime' in 'field list'


mybb. it's a nice board indeed but without convertors it just sucks)

Quote from: piskè on January 02, 2006, 07:05:04 PM
1 have this error converting from mybb1.00 Preview Release 2


when converting topics...
INSERT INTO `my_databasename`.smf_log_topics
(ID_TOPIC, ID_MEMBER, logTime)
VALUES ('350', '4', '1130950869'),
('46', '2', '1130965344'),
('369', '42', '1130965536'),
ecc...
Converting topic view logs... Unsuccessful!

Caused the error:

Unknown column 'logTime' in 'field list'


mybb. it's a nice board indeed but without convertors it just sucks)

Currently the converters are only compatible for 1.1 RC 1. We will be updating the converters soon for 1.1 RC2. In the meantime it's easier to install a 1.1 RC1 forum, run the converter and if everything went well, upgrade your SMF forum to RC2

LOL didn't notice the link to the Archived Releases.  :x

i'll upload and install again this time 1.1 RC 1 (just hope the convertor will work fine with the mybb1.00 Preview Release 2)

oh ******...


Converting attachments... Unsuccessful!
This query:
SELECT pid AS ID_MSG, filedata, downloads, filename, filesize
FROM `my_database`.forums_attachments
LIMIT 0, 500;
Caused the error:

Unknown column 'filedata' in 'field list'

why's that?

Managed to work around my problem by converting Invision2 to phpBB2 then converting phpBB2 to SMF.

-Unshra

This is not an answer for any post, just my experience. For ones who are interested.

phpBB converter worked well on my phpBB 2.0.19 forum with attachment mod, to SMF 1.1 RC2. It only generated one "unsuccessfull" error, but it was about forum stats and can easily be corrected using SMF Admin pages. Don't forget to optimize tables and other stuff at Forum Maintainance after converting.

I just installed RC2 - is there any way to import from Netbula AnyBoard 9? I'm using the flat files DB and NOT SQL for my Anyboard install. Thanks, - Fred

phpbb2.0.19 convert (everything newest version):

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `sonofsam`.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', '2', '157', '3', '2', '3', '', '0', '18', '282'),
    ('3', '0', '3', '181', '3', '10', '1', '', '0', '5', '44'),
    ('4', '0', '5', '193', '3', '3', '1', '', '0', '12', '90'),
    ('5', '0', '15', '516', '2', '10', '3', '', '0', '20', '362'),
    ('6', '0', '22', '65', '3', '3', '1', '', '0', '11', '68'),
    ('7', '0', '38', '844', '3', '42', '3', '', '0', '31', '871'),
    ('8', '0', '48', '1228', '-1', '3', '3', '', '0', '6', '213'),
    ('9', '0', '51', '205', '2', '2', '3', '', '1', '17', '402'),
...
    ('108', '0', '816', '5645', '39', '5', '5', '', '0', '4', '333'),
    ('109', '0', '817', '5640', '29', '5', '5', '', '0', '3', '206'),
    ('110', '0', '820', '830', '42', '42', '1', '', '0', '1', '26'),
    ('111', '0', '823', '828', '2', '42', '1', '', '0', '2', '55'),
    ('112', '0', '834', '1088', '29', '3', '1', '', '0', '10', '73'),
...
    ('582', '0', '5369', '5424', '7', '2', '1', '18', '0', '12', '62');

Caused the error:

    Duplicate entry '110-3' for key 2

When will this duplicate entry problem solved??

I am converting from phpBB2 2.0.19 to a fresh install of SMF 1.1 RC2. I downloaded the latest converter and received the following error:

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)... 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... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `kcunck`.smf_boards
SET ID_LAST_MSG = 1014, lastUpdated = 1136653871
WHERE ID_BOARD = 3
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


The lastUpdated column does not exist. I thought about adding it to the table for the time being and recalculating in the admin panel.

Anyone have any idea? Thanks!

Converting...
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `ragnaros_bb2`.smf_boards
    SET ID_LAST_MSG = 2, lastUpdated = 1136808639
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

What should I do to correct this? It's only a test board, but need to be sure in the future.

Run this query in phpMyAdmin and post the results here...

SHOW COLUMNS FROM smf_boards;

I must honest admit I don't know to do it. I have tryed in the tab called "Query". But from there I don't know.

It isn't trying to pull any data from phpBB tables.

At this step, the converter is trying to take all the avatars from the smf_messages table and give it the correct height and width. It then updates the height and width in the smf_boards table. This is "Step 10" in the converter code. It isn't that important so I removed the lastUpdated part from the query.

However, after I did that, it was stuck in an endless loop.

After some debugging, I discovered Step 10 isn't programmed correctly and would stay in an endless loop. I changed the code to break out and told it to skip that step alltogether.

Bottom line, you could tell it to skip Step 10. Add a "break;" tag at the beginning of Step 10.

I've the same problem and i ran that query, here is the results:

ID_BOARD  smallint(5) unsigned      PRI  NULL  auto_increment
ID_CAT tinyint(4) unsigned   MUL 0
childLevel tinyint(4) unsigned     0
ID_PARENT smallint(5) unsigned   MUL 0
boardOrder smallint(5)     0
ID_LAST_MSG mediumint(8) unsigned     0
ID_MSG_UPDATED mediumint(8) unsigned   MUL 0
memberGroups varchar(255)   MUL -1,0
name tinytext      
description text      
numTopics mediumint(8) unsigned     0
numPosts mediumint(8) unsigned     0
countPosts tinyint(4)     0
ID_THEME tinyint(4) unsigned     0
permission_mode tinyint(4) unsigned     0
override_theme tinyint(4) unsigned     0

Quote from: kcunck on January 09, 2006, 02:34:33 PM
It isn't trying to pull any data from phpBB tables.

At this step, the converter is trying to take all the avatars from the smf_messages table and give it the correct height and width. It then updates the height and width in the smf_boards table. This is "Step 10" in the converter code. It isn't that important so I removed the lastUpdated part from the query.

However, after I did that, it was stuck in an endless loop.

After some debugging, I discovered Step 10 isn't programmed correctly and would stay in an endless loop. I changed the code to break out and told it to skip that step alltogether.

Bottom line, you could tell it to skip Step 10. Add a "break;" tag at the beginning of Step 10.

The convertion went okay. I'm not sure if there something that was missing. I uploaded a fresh phpBB and SMF just for fun. And when I encounter error, it isn't that fun afterall.. But thank you for your help..

Ed1t: I think I know what it is now. When I uploaded SMF 1.1 RC2, the upload stopped mysterious. I don't know why, but I resumed with the remaining files.

Quote from: [Unknown] on July 10, 2005, 02:55:07 AM
It may be because they don't have a width/height which 1.1 now uses.  If this is the case, none of the converters have been updated and so none should work.

None of the image attachments are displaying on my forum (1.1RC2) after upgrading. I checked the attachments table and none of my images have a width or height value. When I manually set a few of them, they display properly.

Where can i find the newest version of the 1.1 Converter ??

The downloadlink in the first post doesn't work so i don't know what to do!

Thanks  ;D

Quote from: Birger_Nord on January 09, 2006, 07:17:47 AM

Code Select Expand

Converting...
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `ragnaros_bb2`.smf_boards
    SET ID_LAST_MSG = 2, lastUpdated = 1136808639
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

What should I do to correct this? It's only a test board, but need to be sure in the future.

Easiest error to correct!

Goto SMF admin panel. Forum Maintenance. Click all fixing links there.

Optimize all tables to improve performance.
Check all files against current versions.
Find and repair any errors.
Recount all forum totals and statistics.
Empty out unimportant logs.

Don't forget to use all.

thanks harzem!

I've managed to fix the image size problem - width/height not set correctly for attachment images. Turns out that the directory path was not added to the filename in that step, so it silently failed and ignored the images.

Also I've fixed the infinite loop if avatar images are missing or set with the wrong type in the attachment table.

My fix can be found here:
http://www.windyweather.net/wp/2006/01/11/fix-to-smf-11-convertphp/

I've managed to convert my phpBB2 board to smf with this. There maybe other problems, my phpBB2 board was pretty simple. phpBB2 2.0.18 to SMF 1.1.RC2.

ww

Edit: code summary removed. See the link for working version.

HOLY COW!  Thanks! Thanks! Thanks! Thanks!  Thanks!  Thanks!  and by the way did I say Thanks? 

This script just saved me hours of work with my E107 conversion! 

Didn't convert my personal messages, but that was ok.  :)

I am looking for vb 3.5 to 1.1 anything released yet?

HELP!

Just ran the phpBB to SMF converter with 1.1 RC2 and it was unsuccessful in converting the statistics as mentioned above.  The problem is that I can't get beyond that point with the converter (no clue if there's supposed to be anything beyond that or not), and now I'm also locked out of the forum entirely as it says my username doesn't exist.  WTF?  Tried both sets of my login information (new and old forum) and neither will get me in.

The statistics is the last part of the converter. Your username and password should be the same as they were in phpBB.

I had the similar or same problem
(see post here:  http://www.simplemachines.org/community/index.php?topic=65677.0) (http://www.simplemachines.org/community/index.php?topic=65677.0)))
Fix for me was

     a) remove cookies - then I could login
     b) login and goto maintenance - regen stats and fix errors.

best,

     

I'm having a problem with the yabb convertor.
I can fill in the first screen with paths and passwords no problem, but the next screen shows:

Converting membergroups... Unsuccessful!
This query:

    INSERT INTO `ferretbb_smf`.smf_membergroups

    (groupName, minPosts)

    VALUES ('Super User', -1;

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 '' at line 5.

Do you have a ' character in any of your member groups?

wow! Thanks these are gr8!! :)

Hallo and a very big thanx to you and the makers of SMF,

I love the machine already before starting it :) But ....
I have a quite big forum (1 Gold - SP 1.1) on my site .. its getting old and a bit slow.

So I have to convert it: Found everything .. started .... waited

got some Errors which I ignored:

QuoteConverting members...
Notice: Undefined index: Schlaftablette in /usr/local/apache2/htdocs/YabbSE/yabb_to_smf.php on line 1360

Notice: Undefined index: dragon-fly in /usr/local/apache2/htdocs/YabbSE/yabb_to_smf.php on line 1360

Notice: Undefined index: Atréju in /usr/local/apache2/htdocs/YabbSE/yabb_to_smf.php on line 1360
Incomplete.

But after a while whith about 10000 members imported it seems to stall .. still working but the converter does not step any further.

The Url (substep) which continously increased in it:
http://.../YabbSE/convert.php?step=1&substep=6814&cstep=2&start=0

stops increasing after a few minutes and even drops down:
http://.../YabbSE/convert.php?step=1&substep=814&cstep=2&start=0

A look in the Database shows me a smf_members table which constantly grows .. up to about 10000 and then starts off again at 0 ....

Dont know whats the problem exactly ... Please if somebody can help .. i would be happy

Thanx in advance
          Alex

Hi,

i'm using the phpbb converter, workes fine, only thing i'm missing now are the birthdays which aren't imported from phpbb. Any chance this gets included into the script? Searched and didn't found anything about it. Just haven't had the time yet to put some queries together, maybe later.

rgds,
Benson

I have no ' or " in any of the member group names. A few of them have spaces, but other then that, it's all letters.

when i trying to convert my PHPBB to SMf RC

the converter says :

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 'hammad_smfrc'@'localhost' for table 'phpbb_users'

Quote from: hammad on January 19, 2006, 08:20:36 AM
when i trying to convert my PHPBB to SMf RC

the converter says :

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 'hammad_smfrc'@'localhost' for table 'phpbb_users'

Make sure that the database users are the same for both phpBB and SMF. You probably created a database for SMF with a new user other that phpBB database user.

Hi,

please can you guys fix the attachments in the 1st post, the downloads downt work :(

Thanks!

i m Converting PHPbb to SMF rc1

and i m goting this error


Converting members... Unsuccessful!
This query:
INSERT INTO `smf`.smf_members
(ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated)
VALUES ('2', 'ali', 'ali', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '1137746536', '1137746520', '', '17', '1', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '0', '', '', '1', '1');
Caused the error:

Unknown column 'pm_email_notify' in 'field list'

Well, the attached files do work, but seems like the convert.php is down. :( Could anybody help me? ;D

 Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! ,

i m Giting this PLz tell me Full sloution coz i m new to SMF

QuoteConverting 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)... 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... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `hammad_smf`.smf_boards
SET ID_LAST_MSG = 5, lastUpdated = 1137771750
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'