Upgrading from b2 to WP problems

I too am having the same b2 import problems. Nothing i do works and to be honest it really surprises me as wordpress is meant to be the ‘official’ extension of b2…
Seems like ill just have to start a new blog and forget about my archives… really really sucks.

What IRC server do i connect to?
Cant seem to find any details of it on the site.

ok, attempted to get help on irc, with no luck.
Ive manaully transferred my posts and comments form b2 to wordpress using the queries in the perl script above (i couldnt get the script nitself to work)
I had a problem when importing the posts into WP, due to the post id’s being bigint(20) in b2 but only int(10) in WP. e.g. my b2 posts ids are like this 106479011873570112 (apparently caused from importing from blogger way back) … anyway….
So – people on irc told me it should be ok to change the structure of the WP tables so that post id’s are bigint(20) to match b2.
After doing that the import worked fine. Posts show up, and the number of comments are correct.
However… when i click to view the comment for a post, i get the ‘Sorry, no posts matched your criteria.” error.
I did some code searching and found the problem in the wp-blog-header.php file, around line number 201 is the following code.
// If a post number is specified, load that post
if (($p != ”) && ($p != ‘all’)) {
$p = intval($p);
$where = ‘ AND ID = ‘.$p;
}
Which takes my bigint(20) post ID and converts it to a normal int – which of course gives an ID that doesnt match.
So… I dont want to go hacking the php files, cause everytime an update comes out ill have to rehack it.
My only options i can see are to reassign all the ids and somehow hope thay match up with the comments
OR
export the b2 data with post ids as int(10) and once again hope that they match up wioth the comments.
This is turning in a huge nightmare… b2 -> wp easy? No way.
Can anyone help?
Thanks

Regarding my long psot above – i have FINALLY figured out how to convert my b2 blog to wordpress and it is all working.
Im surprised at the lack of support i received in the wordpress irc channel – where my questions went unanswered, and also the lack of support in these forms.
I am going to write up the method i used to convert and i will post it here when done.

I’m having the same problems too. Ugh, this is frustrating.

Renaming the b2 tables worked for me. I ran the following SQL query in phpMyAdmin:
DROP TABLE wp_categories;
DROP TABLE wp_comments;
DROP TABLE wp_posts;
DROP TABLE wp_settings;
DROP TABLE wp_users;
RENAME TABLE b2categories TO wp_categories;
RENAME TABLE b2comments TO wp_comments;
RENAME TABLE b2posts TO wp_posts;
RENAME TABLE b2settings TO wp_settings;
RENAME TABLE b2users TO wp_users;
Once that completed, I ran the import-b2.php script again without any errors. Checking the blog, all my posts are there… hope this helps.

Holy crap… I’ll second (or 11th or 12th as the case may be) the motion that the b2import documentation sucks ass… but WordPress seems cool, so I guess they spend more time on building than documenting…
That last fix worked for me as well… so here’s my steps for installing WordPress (from a PHP/MySQL idiot).
1. Download the wp zip file.
2. Edit the wp-config as they suggest – however when you’re defining the db_name, db_user & db_password, make sure you use the settings from your B2 installation.
3. Leave table prefix as “wp_”.
4. Save and upload all files.
5. Run: /wp-admin/install.php
6. Visit your phpMyAdmin webclient. Choose the correct database, and then click on “SQL” and do the following:
DROP TABLE wp_categories;
DROP TABLE wp_comments;
DROP TABLE wp_posts;
DROP TABLE wp_settings;
DROP TABLE wp_users;
RENAME TABLE b2categories TO wp_categories;
RENAME TABLE b2comments TO wp_comments;
RENAME TABLE b2posts TO wp_posts;
RENAME TABLE b2settings TO wp_settings;
RENAME TABLE b2users TO wp_users;
click “go”
7. Back on your site, run: wp-admin/import-b2.php
After that, if you’re like me, your b2 posts will show up.

I also followed the above mentioned methode but on the second step i got the usual errors everbody seems to have. Now i’m watching at my page with a big fat error:
Database error:
[Table ‘dzinelab.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories WHERE 1=1
Warning: Invalid argument supplied for foreach() in /home/www/dzinelab/wordpress/wp-blog-header.php on line 235
Database error:
[Table ‘dzinelab.wp_posts’ doesn’t exist]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-09-10 15:43:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 10
Database error:
[Table ‘dzinelab.wp_posts’ doesn’t exist]
SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2004-09-10 17:43:31’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Indeed, table wp_posts doesn’t exist in my DB. I was under the impression WP created that when uploading?
Now i can create the table manually but that’s all i’m capable off: i’m a msql idiot. I don’t know what settings i have to set.
Or is there some other way i can get rid of the error so i can atleast import my b2 entries by hand (copy – paste)?