Well.... I am at the end of my journey. The convert-prosess works correct. The Message says so. But it didnt work. I mean form SMF to JB. The same Problem as from SMF to JB directly.

There is everything imported, except the Users which are dsplayed with Names but as Guests.

Ok.... I wont give up to soon. But I need a little help or inspiration. My old phpBB was modded. Attachment-Mod, Portal-Mod, Favorite-Mod and so on. What I mean, could it be possible, that the error is caused by the mod-stuff which could be still in the DB?

Does someone knows, how to delete everything out of my DB except the default Tables with the default colums and so on? I will check out this at phpbb.com but I dont realy think thats the cause of the trouble. I think so, because the convert from phpbb to SMF did a great job.

I cant believe, that the phpBB2SMF-Converter take the garbage from old phpBB-Mods and include them in the SMF-DB. What do you mean?

A question for those of you with errors when converting your users from other forums

have a look at your users table (phpbb = phpbb_users, SMF = smf_members)

Can you post if you have a user ID #1 or if your users start at ID #2 ?

I suspect this might be the issue as mine all start at ID #2 and the convert scripts are looking for user id #1 to set that account as admin.

This is the query that is in my convert.php file.

[code:1]
// Read all users from phpBB2
$query="SELECT u.*, b.ban_userid FROM jos_users AS u LEFT OUTER JOIN {$phpbb_dbprefix}banlist AS b ON u.id = b.ban_userid WHERE id > 0 ORDER BY u.id";
$result = mysql_query($query) or die("Invalid query:$query" . mysql_error());
[/code:1]

I might be totally wrong but shouldn't be reading From phpbb_users not jos_users ? as reading from jos_users would only process existing users in joomla already ?

Michael.

Indeed. My phpbb-User starts with the ID=2. No corrctly it starts with ID=-1 Anonymous.
Then the ID=2. Ok then, with your idea, I startet phpMyAdmin and changed the ID=2 to 1. Its really easy. So there was my User with the ID=1. But converting with this DB didnt mak a change. Same Probs as before...

But thanks for the idea...

Hi there,

First of all, I would just like to say big thanks to michiel for his contribution to the converter, as well as to Rapid for his lateral thinking.
I have read the entire thread at least twice, so I'm pretty sure I did my steps right. However, like many people, while my posts were migrated correctly, my users are NOT.

Now I will be happy to devote my time into solving this issue, however I am in no way a coder. So if someone is nice enough to tell me how to debug the script on a sql client such as phpmyadmin, I will definitely publish my findings here for the greater good.

Cheers,
Ray

Try running these queries in phpmyadmin (you do know how to do that right?)

[code:1]SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views, x.post_subject"
." FROM {$phpbb_dbprefix}posts AS p, {$phpbb_dbprefix}topics AS t, {$phpbb_dbprefix}posts_text AS x " // $JMI
." WHERE p.topic_id = t.topic_id AND p.post_id = x.post_id" // $JMI
." ORDER BY p.topic_id, p.post_id[/code:1]

[code:1]SELECT post_id, post_text FROM {$phpbb_dbprefix}posts_text[/code:1]

[code:1]SELECT group_id FROM {$mosConfig_dbprefix}core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC[/code:1]

[code:1]SELECT u.*, b.ban_userid FROM jos_users AS u LEFT OUTER JOIN {$phpbb_dbprefix}banlist AS b ON u.id = b.ban_userid WHERE id > 0 ORDER BY u.id[/code:1]

[code:1]SELECT id FROM {$mosConfig_dbprefix}users WHERE username='$username'[/code:1]

While doing that, make sure you change {$phpbb_dbprefix} and {$mosConfig_dbprefix} and $username to something that makes more sense in each appriopriate query. NB You should try running these queries one by one just to check if they work...

Hi Michiel.

Thanks for posting support. I will try. But first: What does $JMI stands for.
{$phpbb_dbprefix} = ok
{$mosConfig_dbprefix} = ok
$JIM = ?
$username = Just an existing Username in phpBB?

Sorry for these (might be really simple) questions.

[code:1] SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views, x.post_subject"
." FROM gis_posts AS p, gis_topics AS t, gis_posts_text AS x " // $JMI
." WHERE p.topic_id = t.topic_id AND p.post_id = x.post_id" // $JMI
." ORDER BY p.topic_id, p.post_id
[/code:1]
And the errormessage:
[code:1]Error

SQL-Order: Documentation

SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views, x.post_subject " ."
FROM gis_posts AS p, gis_topics AS t, gis_posts_text AS x " // $JMI ."
WHERE p.topic_id = t.topic_id
AND p.post_id = x.post_id " // $JMI ."
ORDER BY p.topic_id, p.post_id
LIMIT 0 , 30

MySQL : Dokumentation
#1064 - 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 '" // $JMI
." WHERE p . topic_id = t . topic_id AND p . post_id [/code:1]


The second sql-order runs correctly:
[color=#008000][b]SELECT post_id, post_text FROM gis_posts_text[/b][/color] - lists everything is suppose. No errormessage


The third order does the job as well:
[b][color=#008000]SELECT group_id FROM jos_core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC[/color][/b] - no error message


The fourth works too...
[color=#008000][b]SELECT u.*, b.ban_userid FROM jos_users AS u LEFT OUTER JOIN gis_banlist AS b ON u.id = b.ban_userid WHERE id > 0 ORDER BY u.id[/b][/color] - no error message

Hello Michiel,

Thanks, I tried the codes. And I'm getting the same error as did Steven. The 4 single-line codes work out fine. But the first segment of code gives me error:
SQL 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 ''' //$JMI '' WHERE p.topic_id = t.topic_id AND p.post_id = x.post_id'' //$JMI ' at line 1

Could this be the hotspot for all our troubles?

hi Michiel,

After my failure I looked more closely at the codes and realized that the first code has a lot more symbols such as " . // compared to the other 4 codes. And after removing all of them, the code actually worked.

But from the script, it seems that the quotation marks are necessary for the script to work.

So ya, for anybody trying this out, the first code should be modified.

Original
[code:1]
SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views, x.post_subject"
." FROM {$phpbb_dbprefix}posts AS p, {$phpbb_dbprefix}topics AS t, {$phpbb_dbprefix}posts_text AS x " // $JMI
." WHERE p.topic_id = t.topic_id AND p.post_id = x.post_id" // $JMI
." ORDER BY p.topic_id, p.post_id
[/code:1]

Modified
[code:1]
SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views, x.post_subject
FROM {$phpbb_dbprefix}posts AS p, {$phpbb_dbprefix}topics AS t, {$phpbb_dbprefix}posts_text AS x
WHERE p.topic_id = t.topic_id AND p.post_id = x.post_id
ORDER BY p.topic_id, p.post_id
[/code:1]

And also, I'm getting quite confused by the number of versions of the converters floating around in this thread. Michiel, is it possible for you to post THE most updated version again please? Thanks.


Now, going into the actual converter script, I noticed something in this segment
[code:1] // Insert the post into the database
$query="INSERT INTO `{$mosConfig_dbprefix}fb_messages`"
." (id, ip, phpbb_userid, userid, name, time, thread, subject, hits, catid, parent)"
// $JMI ." VALUES ('$row->post_id', '$row->poster_ip', '$row->poster_id', '$row->poster_id', '
$row->poster_id', "
." VALUES ('$row->post_id', '$row->poster_ip', '$row->poster_id', '$row->poster_id', '$post_username'
, "
// $JMI ." '$row->post_time', '$currentthread', '$subject', '$row->topic_views', '$row->forum_id'
, '$lastpost')";
." '$row->post_time', '$currentthread', '$subject', '$row->topic_views', '$row->forum_id', '
$postparent')";
$updateresult = mysql_query($query) or die("Invalid query:$query" . mysql_error());
$lastpost = $row->post_id;
}
mysql_free_result($result);[/code:1]

Looking at the query statement, it seems like it's trying to insert both userid AND phpbb_userid into the FB message table. This might be the reason why all posters are listed as visitor?

Cheers,
Ray

Hi Ray,

Ay, I forgot to take those out yes, thanks for noticing. They are comments for php and linebreaks so to say. MySQL doesn't know what to do with that

I will try to get the most updated version tomorrow or so.

As for your last statement about the query... The phpbb_userid is just a temporary step to convert phpbb userid to joomla userid;s. Later on in the script the phpuser_id rows are deleted, so that is not the problem.

I was troubleshooting the exact same problem with someone else a while back, and suddenly it worked for him, we don't know why.. So I'm going to try and reproduce his steps and I will report back as soon as I find anything.

Hi Michiel, thanks again for your prompt reply.
For the updated converter, would it be too much to ask you to place some sort of delay in the insert post texts section in order not to overload the server? Maybe a pause of 3 seconds after every 10,000 iterations? I've seen this done on a phpbb->smf converter. And it works quite effectively. Thanks.