josgc wrote:
An update:

I changed the script as explained here.

Now Iīm getting this error:

Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table... martinho: 64, DSmania: 65 - NEW
Invalid query:
INSERT INTO jos_core_acl_aro (id,section_value,value,order_value,name,hidden) VALUES ( 65, 'users', 65, 0, 'DSmania', 0 )
Unknown column 'id' in 'field list'

The script Iīm using already has line 185 changed

Update: If I run the script multiple times it looks like I can add users, one by one. These users show up in the fireboard "users" menu, but not in the joomla users menu, or the community builder users menu...

There is no column in that table called "id". Here's the table definition for the access rights' table:

[code:1]CREATE TABLE `#__core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `#__gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM;[/code:1]

It makes sense that you're not seeing users in Joomla or Community Builder because every row in jos_users needs a corresponding row in jos_core_acl_aro. At least that's my understanding. I tried to describe this in a [i]little [/i]more detail in a [url=http://www.bestofjoomla.com/component/option,com_fireboard/Itemid,38/func,view/catid,6/id,32379/#32256]previous post[/url].

Actually I found the mistake in the script that was causing the users not to show up in the admin users manager,

Itīs in line 251:

[code:1]$query = "INSERT INTO {$mosConfig_dbprefix}core_acl_aro (id,section_value,value,order_value,name,hidden) VALUES ( $newuserid, 'users', $newuserid, 0, '$row->username', 0 )";[/code:1]

See right after core_acl_aro? it says "id", but the database is expecting a value called "aro_id", so I changed the value:

[code:1]$query = "INSERT INTO {$mosConfig_dbprefix}core_acl_aro (aro_id,section_value,value,order_value,name,hidden) VALUES ( $newuserid, 'users', $newuserid, 0, '$row->username', 0 )";[/code:1]

And it worked :)

There are some other things that didnīt translate properly, like the user creation date and the last visit, but I can live with that ;)

Whooops, you're right. I didn't read what I pasted about the table's definition. There is no "group_id" in #__core_acl_aro. Good job spotting that, and sorry for any confusion on my part in trying to help. I deleted what I said from my post above so I didn't confuse anyone.

I haven't continued testing this.. not yet..

I actually really want this to work ... but I am greedy... I want ALL my phpbb stuff moved.. by that I mean, users, posts, topics, AND images.. in a different gallery than phpbb's...

I know.. asking alot

I really wish it can be done...

It can be done, but if you want someone to spend the time to script this for you, providing a little more information might help get the job started.

I post 2 days ago that you need to change id to group_id

Don't change tables! Read the script and you will see the errors..

I was able to take may phpbb forums and convert them completely...

My forum history is this..

I had a nuke site...

Changed to joomla..

Installed my phpbb forums into joomla using a joomla bridge.

Then I switch forums to FB...

I run script found here and had the same error...

If you do what I did you will have every thing BUT!!! Author history

Good luck..

Please note... My fix is for users that BRIDGED Joomla=>phpbb

Josgc can you please post up the script that you fixed. Thanks.


The initial script works for me fine. I Think It really depends on the mods that you run on your phpBB2. I was running about 4-5 major mods.

Guys, If you want this done properly, Just head over to www.sciptlance.com

The programmers there will write custom fix the script for you in a day according to your databases. It would cost you anywhere between $20 - $80 USD. Obviously you have to pay more for an experienced programmer.

Hi, here is the file. It contains all the changes I described in my posts above, plus I also made a change to try to make the registration&last visit dates to be converted, with no luck. Besides, I also had to enter the jos_users table and change by hand a name which contained a ' before the conversion would run smoothly to the end.

Caveat: Please, handle with care! The id instead of aro_id I believe is an error, but all the changes I made are based on pure trial&error on my part, not on real expertise. -Anyways, as long as it helps Iīll be happy.

By the way, before I found the aro_id error I even tried the phppBB-->SMF-->fireboard, which I read was apparently easier. Nope. Itīs not! (better: not for me ).

Iīm sure itīs no easy task to develop these converters, but on the other side it makes sense that the developers make an effort to help those willing move to their sytem, doesnīt it?

kangt7 wrote:
The programmers there will write custom fix the script for you in a day according to your databases. It would cost you anywhere between $20 - $80 USD. Obviously you have to pay more for an experienced programmer.

Alternatively, if you don't have to have it today, you can wait for me to finish my free script. I've already successfully converted my database from phpnuke with phpbb integrated to Joomla with Fireboard and Community Builder. I have a stand-alone phpbb forum (in SQL Server 2000) that I'm adding to the Joomla installation, and next I'm adding yahoo groups to the mix. I'm doing this all largely for myself, because I'm combining three disparate sites together, but I'm happy to share the fruits of my labor if someone else can benefit. It's just something I'm working on in my free time, so I'm not promising it for tomorrow, but it will be done soon (I'm not adding any new features so I get it done.)

Of course, if this script you paid to have modified is working or others are finding it easy to use to convert their databases, even better. Mine will just be another option.

ok, to give more info on my current wishes..

I run:

joomla. 1.013
Cb 1.1
cbconnector 2.0 beta 2
-
phpbb2.0.22
Full album mod based on Smartor's photoalbum.
users post threads, and are able to upload photo's to the photoalbum for use in posts.

I'd like to convert to Fb to have an all native joomla install, to help maximize speed, usability, and to minimize use of bridges etc.

I require an all content converter, that will let me delete all phpbb tables and files.
that means converting threads incl. picture gallery to Fb.

If I can do anything to help this happen, I am more than willing to lend a hand testing etc.
I am a novice user, and have only fiddled with joomla and phpbb for 1― year.