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:phpBB (1 viewing) (1) Guest
Go to bottom Favoured: 8
TOPIC: Re:phpBB
#9950
Re:phpBB 1 Year, 5 Months ago  
Best place for support with this issue is on SMF.
Here's a thread that should help -> www.simplemachines.org/community/index.php?topic=85064.0
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10357
Re:phpBB 1 Year, 5 Months ago  
just using this tool on my database (phpnuke with phpbb2)


I'm getting a

Invalid query:
INSERT INTO `jos_fb_users` (userid, posts, signature) VALUES ('1593', '', ''
Duplicate entry '1593' for key 1

any ideas ? is this a duplicate username ?

my site is about 21,000 users and 127mb of posts

everything else seems to be ok, just the users conversion dies.
diveboy (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10364
Re:phpBB 1 Year, 5 Months ago  
Yep - looks like a duplicate user. I had the same problem, found that the user registered twice using the same email address but different username. Try looking up user No. 1593 in Joomla, then copy and search using the email or username they registered with. Find the oldest registration date and delete it. I found about 10 in a database of 400 so you may find a few of these.
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10365
Re:phpBB 1 Year, 5 Months ago  
thanks.

I'll have a look and see if I can find him. spot on, found him again a few records down the track. will have to nuke him out of the database before I do the live conversion.

do I have to restart the conversion process from scratch again ? or will it resume if I just reload phpbb2fb.php ?

Thanks

Michael.
diveboy (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/06/05 07:26 By diveboy.
 
The administrator has disabled public write access.  
#10371
Re:phpBB 1 Year, 5 Months ago  
Good to hear... start the conversion from scratch each time until you get a clear run.
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10597
Re:phpBB 1 Year, 5 Months ago  
Rapid wrote:
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?


well,

I have the same problem.

127597 articles with 21320 users = 6 hours on a core duo of crunching to find this out

might have to try the SMF conversion process.

Can anyone comment if there are issues with renumber users in joomla ? or know of a tool to renumber users in phpbb2 ? I'm guessing if I add 62 to all users in phpbb2, then the problem will sort it's self out yeh ?
diveboy (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10612
Re:phpBB 1 Year, 5 Months ago  
I found out (in a prior post) that Joomla users starts at 62, you don't need to make any changes. Try the method I did and move to SMF then FB.
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10613
Re:phpBB 1 Year, 5 Months ago  
argh! I tryed a fresh conversion from phpbb2 to SMF and still failed... I might be inclined to just start fresh as a new project! Luckly I have a small site with less then 2500 users.
tokyo_suicide (User)
Junior Boarder
Posts: 31
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10617
Re:phpBB 1 Year, 5 Months ago  
Post the error message on the SMF forum and get some answers before you try again.
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#10652
Re:phpBB 1 Year, 5 Months ago  
To all prior posters: 62 is the standard first userid of Joomla, you don't have to change anything for it to happen. The Joomla-usertable has an auto-increment setting which starts at 62 (no clue why...). So 62 is ok, it's not a problem.
michiel (User)
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top