Rapid wrote:
Hi All,
I've imported the PHPBB tables into Joomla database and get the following error:

Connecting to Database... OK
Invalid query:
ALTER TABLE `jos_fb_messages` ADD `phpbb_userid` int(10) NOT NULL default '1'
Table 'xxxxx_phpbb1.jos_fb_messages' doesn't exist

Any ideas???

Thanks!

OK I was able to fix this (my fault of course) now I have forums and posts and most users?
Problem now is the posts are moslty marked as "Guest" (even mine) and I noticed that some of the posts that do have a username are the wrong user e.g not the user who made the post.
When I look at a users profile in (User Profile) I get a heap of code stuff before it get to the bottom of the page. e.g.

"
// bbCode control by // subBlue design // www.subBlue.com // adapted for Simpleboard by the Two Shoes Module Factory (www.tsmf.jigsnet.com) // Startup variables var imageTag = false; var theSelection = false; // Check for Browser & Platform for PC & IE specific bits // More details from: www.mozilla.org/docs/web-developer/sniffer/browser_type.html var clientPC = navigator.userAgent.toLowerCase(); // Get client info var clientVer = parseInt(navigator.appVersion); // Get browser version var is_ie = ((clientPC.indexOf("msie" != -1) && (clientPC.indexOf("opera" == -1)); var is_nav = ((clientPC.indexOf('mozilla' != -1) && (clientPC.indexOf('spoofer' == -1) && (clientPC.indexOf('compatible' == -1) && (clientPC.indexOf( 'opera' == -1) && (

ETC> ETC ETC>

Appreciate some help!!!

thanks JLW, i actually have barely any good knowledge of SQL db's so yep your far better than me

That's a fancy username issue.. Find in the script this line of code (around line number 134):

[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', '$row->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;[/code:1]

And change it to:

[code:1]
$post_username = addslashes($row->post_username);

// 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;[/code:1]

michiel wrote:
No, it's not your fault.. There is a bug in that script.. Sorry for the inconvenience...

Here's the newest edition

File Attachment:
File Name: 20070522phpbb2fb.zip
File Size: 4342

Post edited by: michiel, at: 2007/05/22 16:41


When i try the one you gave me last I get :
Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table... Dylan62, Test63, OK
Complete...

Sorry.

I have the tables together and there are over 1500 users. I don't know why but those users that it is importing are not together. The first one is the first in the list but the second is nowhere near it.

Thanks for all the help!

I get this message again

Connecting to Database... OK
Invalid query:
ALTER TABLE `jos_fb_messages` ADD `phpbb_userid` int(10) NOT NULL default '1'
Duplicate column name 'phpbb_userid'

I can not find phpbb_userid in my database

ok,

I have try it now. but it only transfer half of the poster on to my fireboard

@yvonne: the maximum execution time is a setting in your php.ini file you should up the amount. Obviously, your database is very large for the script to run it's full cycle

Hey...
Finally got the patch to work BUT...
90% of Posts have no user assigned to them. The ones that do have the wrong user assigned.
Even as the Admin my posts are shown as "Guest"!

I'd be great to get a reply on this one.

Thanks.

*Just noticed the user list in FireBoard & Joomla now begins at '62' would this have something to do with the messages not in sync with the user?

I'd have no clue as to why that is.. if you're familiar with php-scripting, you could edit the script to give you debug-information (i.e. use echo(variable) or something like that (out of the top of my head) to check whether several variables are receiving the correct information such as $row->username etc.).