You know.. I tried the id->group_id... and it worked.. .

problem is.. I get a strange error:

bimmer: 504, rfckent: 505, store: 525 - NEW
Invalid query:
INSERT INTO jos_core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( 18, 525 )
Duplicate entry '18--525' for key 1

It just means that a row is already in that table with those values in the columns. For whatever reason, the script was trying to duplicate something. Perhaps the result of several attempts at running it.

Hi.

yes I fixed it..

another problem has arisen.... a VERY strange one..

As I said, I fixed it... anyway... when ever I run the script a new error occurs..

like this:

INSERT INTO jos_core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( 18, 529 )
Duplicate entry '18--529' for key 1

when I check the jos_users for the entry 529 it appears to be a spam user.
I delete the user, rund the script, and :

Ascmovie: 530 - NEW
Invalid query:
INSERT INTO jos_core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( 18, 530 )
Duplicate entry '18--530' for key 1

delete that user in jos_users, AND set 'allow registration' t' 'NO' in Global Config..:

Ascmovie: 531 - NEW
Invalid query:
INSERT INTO jos_core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( 18, 531 )
Duplicate entry '18--531' for key 1


just keeps going...

what, where.. how... WHY???? oh why oh why..

I don't think you understand the error you're getting. You're getting duplicate entry messages because the row already exists in the jos_core_acle_groups_aro_map table. If the script continues, just ignore these messages. As for deleting one or more rows out of the jos_users, that has no effect on the error you're getting (unless you're using some special tool that is cascading the deletes, which I doubt based on the post. )

Hope that helps.

the script halts here..

Ascmovie:
Invalid query:
INSERT INTO jos_core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( 18, 525 )
Duplicate entry '18--525' for key 1

please... how can I fix this.. it keeps creating the same spamuser over and over and over again..

where should I delete entries?

perhaps I fixed it..

I kept deleting the "duplicate entrys" in aro_map.. and eventually it created a different spamusers, and the gave up and said : Complete... lol... time to check everything..

what happened I don't know. But changing the id to group_id worked... the spamusers are just a stange bonus. Deleted then over and over, and suddenly it all worked.

Hi all,

What is solution for having 2 DB one (old joomla+phpbb2(with cb_convertor) and other new vanila Joomla 1.0.13 +Community Builder 1.1 + Fireboard 1.0.3(now 1.0.4).

What would i like is only to import categories/threads/nummer of post. As i already imported users and their all data from CB and Joomla+CB is working fine. Fireboard is also working fine bud i am missing old categorys/posts etc..

Edit:
Well i tried something on my own. This is what i did. I installed new Joomla 1.0.13 on that DB where was old Joomla+CB+phpbb2. I used other table prefix for this new install so there is not conflict in DB. After Joomla i installed Firebird 1.0.4 there also and runed the srcipt that i found i this forum.
Then i manualy export _fb_categories _fb_messages _fb_messages_text and reimported in that new site install where are already user imported.

The Categories/Messages are there and also username that posted over there.
But problem is if i click on that username it point me to someone else profil and not the right one. I see that there are user_id not the same in jos_users and jos_fb_users.

Did someone else have such problems with user_id??
phpbb_users table start with:
-1 Anonymous
2 admin
I hope someone can help me in this.

Thank you! After months of lost hope of ever actually being able to use FB and not losing any users/posts from my phpBB2 forum, this converter worked like a charm.

Thank you so much!

has anyone converted a very large forum? also can you post your website so i can see the finished conversion in Fireboard.