Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Re:>>>>phpBB2 to Fireboard - Yes IT w (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:>>>>phpBB2 to Fireboard - Yes IT w
#54447
Re:Created tool Re:>>>>phpBB2 to Fireboard and CB 4 Months ago  
@ Many thanks to your client - from my side as well!


just got one (lil) big problem to connect the DB:

if i run the newphpbb2fb.php - i get allways the same response:

Connecting to Database...
Importing data from phpBB2
Start time is Wed Jul 23 15:59:23 CEST 2008

Populating Categories... OK Time stamp: Wed Jul 23 15:59:24 CEST 2008

Populating Messages Table...
There are 6852 message posts to port over in the phpBB database
OK .. Time stamp: Wed Jul 23 15:59:27 CEST 2008

Populating Messages_Text Table... OK ... Time stamp: Wed Jul 23 15:59:28 CEST 2008

Populating Users Table...
Emptying FB Users Table...
Invalid query:
SELECT group_id FROM afsj_core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC
Unknown column 'group_id' in 'field list'


what means this exactly? should i rename the anything ... ?
what can i do, that i can solve the problems with the group_id... ?

many thanks for you help in advance..


Cheers
S
cumonvip (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/07/23 19:05 By cumonvip.
 
The administrator has disabled public write access.  
#54464
Re:Created tool Re:>>>>phpBB2 to Fireboard and CB 4 Months ago  
kittymcooper wrote:
yes 1.04 fireboard

Well I do not know if you install the FB 1.05 NB6 is the latest release as it seems pretty stable..

Did you you have a chance to test with Joomla 1.5x or anyone else...
subfighter (User)
Jiu Jitsu Techniques Online
Junior Boarder
Posts: 70
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Subfighter estrada_rick@hotmail.com Location: Oceanside, California Birthdate: 1971-05-13
Logged Logged
 
Database Version: 5.0.51a-community
Database Collation: utf8_general_ci
PHP Version: 5.2.5
Web Server: Apache/2.0.63 (Unix)
Joomla! Version: Joomla! 1.5.7
 
The administrator has disabled public write access.  
#54486
Re:Created tool Re:>>>>phpBB2 to Fireboard and CB 4 Months ago  
Do you have JOOMLA 1.5 per chance? group_id is definitely a field in the core_acl_aro_groups table in JOOMLA 1.0.x and that error indicates that the column is not there.

I am on vacation this week but I will try to test with 1.5 next week. Or you could send me the schema (database layout) for any tables with "aro" or "users" in the name and I can see if it is easy to figure out your problem.

Also my conversion to CB is still too custom, so I will put in a better one on my download in about 2 weeks.
kittymcooper (User)
Junior Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Location: Fort Collins, CO
Logged Logged
 
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
 
The administrator has disabled public write access.  
#56023
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 1 Week ago  
Hi Guys. The file did helped me, really awesome. The only thing now is that everybody are Administrator!! I saw the joomla users and everybody is admin, what can i do? Thank you!!

BTW How do I get the avatars and images again? TY
yayojet (User)
Junior Boarder
Posts: 21
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#56026
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 1 Week ago  
Another thing, everyone says that registered at 1969-12-31 18:00:00, why??

TY!
yayojet (User)
Junior Boarder
Posts: 21
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#56030
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 1 Week ago  
On the time - look at the column user_regdate in your phpBB database. The code is assuming that column is a unix timestamp. What do you see there? This is the code that moves the time over:

Code:

  $registerDate = date( "Y-m-d H:i:s", $row->user_regdate );
  $lastvisitDate = date( "Y-m-d H:i:s", $row->user_lastvisit );



On everyone being an Admin, the code assumes that the phpBB database column user_level is 1 for admins - this is the code

Code:

  // Set user type and group id
  if ( $row->user_level == "1" ) { 
    $usertype = "administrator";
    $gid = $admingid;
  } else {
    $usertype = "Registered";
    $gid = $usergid;
  } 



if that is not the case for your data, then you can make everyone just a registered user by changing the above code to

Code:

    $usertype = "Registered";
    $gid = $usergid;



and the readme explains how to move the avatars:
"3. Copy all files from your old site's forum images/avatars to images/comprofiler
or if you do not have CB, to images/fbfiles/avatars/"

I do not know if the avatars get put into the joomla database properly on a system that does not have CB as I have not tested it that way
kittymcooper (User)
Junior Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Location: Fort Collins, CO
Logged Logged
 
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
 
The administrator has disabled public write access.  
#56031
Re:Created tool Re:>>>>phpBB2 to Fireboard and CB 3 Months, 1 Week ago  
cumonvip -

Just to let you know I have confirmed that the database table `jos_core_acl_aro_groups` has changed in JOOMLA 1.5 so that is why you are getting that error.

I will try to do a fix next week but the JOOMLA 1.5 site I am converting to is one of my own and I have too many paying clients needing work this week and next so it may be a little while before I get to it
kittymcooper (User)
Junior Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Location: Fort Collins, CO
Logged Logged
 
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
 
The administrator has disabled public write access.  
#56321
Re:Created tool Re:>>>>phpBB2 to Fireboard and CB 3 Months, 1 Week ago  
well hopefully we can get this converter to work on Joomla 1.5x and with the FireBoard 1.05NB10 as the release is very stable..

Thanks for the helping kitty and trying to make it happen..
subfighter (User)
Jiu Jitsu Techniques Online
Junior Boarder
Posts: 70
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Subfighter estrada_rick@hotmail.com Location: Oceanside, California Birthdate: 1971-05-13
Logged Logged
 
Database Version: 5.0.51a-community
Database Collation: utf8_general_ci
PHP Version: 5.2.5
Web Server: Apache/2.0.63 (Unix)
Joomla! Version: Joomla! 1.5.7
 
The administrator has disabled public write access.  
#56366
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 1 Week ago  
Thank you, I am going to try that code very soon.

I have another question; if I am not logged in inside joomla! and I try to do it from fireboard, it takes me to the forums, why is that?

The link for the "log in" part is:
.../index.php?option=com_fireboard&Itemid=56

Thank you!
yayojet (User)
Junior Boarder
Posts: 21
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#56367
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months ago  
Did you look at that URL? It goes to fireboard like it is supposed to.

If you want to integrate fireboard with CB try this plugin:
www.pixelwonders.de/index.php?option=com...fileinfo&id=3015

If you need a CB login page, rather than the little side box, I have those for JOOMLA 1.0.x on my JOOMLA downloads page here:
openskywebdesign.com/cms/modules.php?nam...ewdownload&cid=3
kittymcooper (User)
Junior Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Location: Fort Collins, CO
Logged Logged
 
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
 
The administrator has disabled public write access.  
Go to top