i'd like to also say thanks for this component. after tim_online stopped supporting phpbb integration w/ joomla, i sorta knew i was screwed until something else better came along.

i jumped on board and used the converter file and it worked w/ minor tweaks. a while ago, there was a module that integrated phpbb users with joomla users and it basically migrated all the phpbb_users into jos_users eliminating the phpbb_users field (as specified in the phpbb2fb file). As a result, "user_id" disappeared from the phpbb tables and you have to replace "user_id" w/ "id" in the phpbb2fb file. It worked for me... but can someone else confirm this?

Could this be integrated into the backend in the next release?

This is great news.
I came here with the question of how to convert from phpbb and it has asked and answered.
Thanks Asli.

The convertor worked smoothly (altho my forum isn't working anymore now, no clue why). There was one major tweak I had to add for usernames with -'- in it, though (somehow you always end up with bastard who want to have fancy names )

The changed file is added below for those in need as well



Post edited by: michiel, at: 2007/04/26 13:18

Post edited by: michiel, at: 2007/04/26 13:19

michiel wrote:
(somehow you always end up with bastard who want to have fancy names )
LOL! I couldn't help but laugh at this! It is sooo true!

Is there a way to convert from phpBB to FB if the tables of Joomla and phpBB are not in the same database?

Is there a way to convert from phpBB to FB if the tables of Joomla and phpBB are not in the same database?
then just temporarily copy them to the same db

Hi!

Im having a problem in my phpBB2 converting...

Invalid query:
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_posts AS p, phpbb_topics AS t, phpbb_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
MySQL client ran out of memory

Can someone help?

Arcanjo

definitely check if your query is correct.. and umm.. try googling "MySQL client ran out of memory". It seems to be a common problem w/ db's in general and it appears that there's some solutions you can look into. :]

gene wrote:
definitely check if your query is correct.. and umm.. try googling "MySQL client ran out of memory". It seems to be a common problem w/ db's in general and it appears that there's some solutions you can look into. :]

Thanks.for the answer.

The query is correct it must be something about my phpBB forum because I have more than 3000 users and at moment 117865 messages so maybe the result of this query is to large..

I googled like you said and I found this...but I cant seem to understand...

B.1.2.7. Out of memory

If you issue a query using the mysql client program and receive an error like the following one, it means that mysql does not have enough memory to store the entire query result:

mysql: Out of memory at line 42, 'malloc.c'
mysql: needed 8136 byte (8k), memory in use: 12481367 bytes (12189k)
ERROR 2008: MySQL client ran out of memory

To remedy the problem, first check whether your query is correct. Is it reasonable that it should return so many rows? If not, correct the query and try again. Otherwise, you can invoke mysql with the --quick option. This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server).

Please?

Arcanjo