boardom Forum Index boardom
b2 message board
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Blogger-2-b2 bug ***RESOLVED*** !!! (well, sort of)

 
Post new topic   Reply to topic    boardom Forum Index -> Bugs
View previous topic :: View next topic  
Author Message
Aza



Joined: 18 Sep 2003
Posts: 7

PostPosted: Fri Sep 19, 2003 11:42 am    Post subject: Blogger-2-b2 bug ***RESOLVED*** !!! (well, sort of) Reply with quote

Finally !

I think I have the solution Smile

Well, look at your old posts :
They have a 7-digit unique ID

Look at you new posts, now, those which crash the converter :
They have a 18-digit ID !

It is very easy to bypass the problem !
All you have to do, is log into PhpMyAdmin if you have it. Most hosting services, even if they're free, offer a phpMyAdmin access. Check out your host docs for the address. For free.fr, the address is sql.free.fr. You will need your login and password !

- Click on the name of your database. A list of the available tables will appear.
- Click now on the b2posts table, on the left.
- You should now see a large table, and its first line should be something like this :

Field Type Attributes Null Default Extra Action
ID int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext

This is the first row, OK ? Allright.

- Click on "change", at the right of this ID line. Don't be afraid. You now see something like this :

Type
[Documentation] Length/Values*
INT 10

- Look for the "BIGINT" value in the "INT" dropdown box and select it. It will allow BIGGER and BIGGER unique IDs for your posts !
- Now set the length to 20 in the next row. 10 digits is not enough, it will cause the converter to crash...
- Do the same for comment_post_ID in the b2comments table, and you're done.

You can now safely import your posts.

And, by the way, this works for wordpress too !

EDIT
This WORKS for importing your posts, but there's an issue with the comment system I still can't resolve. When I click on the "comment" link under a converted long-ID post, the comment page is empty. I'm working on this right now, but do not expect a miracle, for I am NO phpGuru Smile


Last edited by Aza on Fri Sep 19, 2003 12:51 pm; edited 1 time in total
Back to top
View user's profile Send private message
epolady



Joined: 30 Jul 2002
Posts: 800
Location: Texas

PostPosted: Fri Sep 19, 2003 12:34 pm    Post subject: Reply with quote

Did you by chance post this on Wordpress' Support Forum? Maybe some members can use it there as well.
Edit: Also, I think you'd get more feedback from their forum.

I have not tried this, I'm assuming it works.
_________________
No more support from me. Goodbye!
Go upgrade to WordPress, you'll find better support there.
Back to top
View user's profile Send private message
Aza



Joined: 18 Sep 2003
Posts: 7

PostPosted: Fri Sep 19, 2003 12:47 pm    Post subject: Reply with quote

I will !

By the way, something seems to be wrong with my comments now. I still don't know what. I'm still working on this Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    boardom Forum Index -> Bugs All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2 © 2001, 2002 phpBB Group