Laughinglizard

@david: I would like to clarify my reasons for not using $wpdb everywhere.
1) Using mysql_query does not mean a new database connection. This hack, for example, uses the existing database pointer and does not open a new one
2) $wpdb performs a bunch of extra data manipulation tasks that are not always required
3) $wpdb does not have a lot of the built in MySql/php features implemented such as count_tables etc (thus a lot of the vanilla WordPress code still contains native MySql calls, as of 1.0 )
However, I do agree that we should try to code within the confines of wpdb as far as possible to make the hacks follow the WP coding style guidelines.
http://wordpress.org/docs/developer/#coding-style

Also, you clicked “no to debugging” so this error was from your browser and not from the webserver? If so, what browser are you using (sounds like IE)? Please give us some more information about the error.
PS: I am the person that posted the MySql dumps. The username to use (after the dump is imported) is admin and password is password. I thought I mentioned that. Sorry if it screwed things up further for you.

The most elegant method of moving data between b2 and wp is to use the old b2 tables and run the import-b2.php. The only catch is to make sure that the wp table prefix is the same as your b2 and the database names are the same in the config files.
However, now that you have made yourself a new WP , here are my suggestions. PLEASE READ THROUGH ALL THE INSTRUCTIONS TO SEE THE CAVEATS AND PITFALLS
1) You are going to need more than just the b2posts table to get your entries to move over correctly, so think about copying b2categories, b2posts and b2users (while you are at it, I would copy the b2comments and the b2settings as well, just for good measure)
2) Now that you have created a new WP database, I am assuming that it does not contain any new entries. In order for the data to be successfully moved using this first method, you will HAVE TO HAVE the same table and table prefixes as b2. So, because it looks like your b2 tables had the ‘b2’ perfix, make that change in wp-config.php as well.
3) Install phpMyAdmin from http://www.phpmyadmin.net/home_page/ and get it working correctly.
4) Once installed, click on the dropdown menu on the left hand frame and click on your database. Now on the right, click on the export tab and Click on the tables you want to export from the table list. Accept all default checkbox settings (SQL, Structure, Enclose table names in backquotes and data checked) but also make sure the ‘Save as File’ is checked. Export the data to your local computer (this is also a very good way to backup your mysql data.
5) Now find the new wordpress database on the left dropdown menu. Click on the SQL tab on the right and browse for your newly created SQL file and click go.
6) Run import-b2.php
Caveats: You could perform the same export table by table and import table by table. In that case you could name your table prefix with anything you want to.
If you replace your wp-config.php table prefix now, your WordPress installation will stop working and new one will be created with the new table prefix and all of your b2 data
Be careful when you move data around in mysql, if phpMyadmin asks you any questions that really confuse you or worry you, you should stop and check around. However, you said you were conversant with mysql, so I will leave you here.
Also, I couldnt tell from your post whether you used a new database or the same one from b2 to install WP. The instructions here assume that you created a new database for WP.
Peace

I have a solution. You can see how it looks at http://dinki.mine.nu/weblog/ and you can download the hack instructions at: http://dinki.mine.nu/word/index.php?p=108&more=1&c=1

That is a great idea! Ill see what I can come up with! 🙂

I am sure you have this right, but I will mention it anyways. The file is called wp-config.php and not config.php
What version are you using?

I wrote a script which determines the popularity of a post (and outputs the most popular posts) if thats what you are looking for.
Here is the link to the forum discussion:
http://dinki.mine.nu/word/index.php?p=108&more=1&c=1