Table phpbb_categories does not exist!

In the settings are you pointing to the correct database?

If the tables are in the same database as drupal, then they should be showing by default. If not, you need to untick the "Same database" box, save the page and go back to the database settings section to put in the correct details.

I was having the same problem. I unchecked the "Same database" checkbox. Saved page, it still gave missing sql tables errors.

So I changed it to point to (what i thought was correct db), hit save, and i got error:

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user '****_drpl3'@'localhost' to database '*****_phpb1'.

I tried deleting the phpbb2drupal directory (under modules) from server and re-uploading a fresh copy. Doesn't work !!!

Anyone know how to fix this error?

Oh never mind, I ran 'CleanUp' under 'phpBB to Drupal' under Admin options. Error has disappeared. But I would still like to why I got that error...

Was it the correct db?

Not sure about this, but did it have a different username/password etc?

(if none of that works, as a work around, you can import the phpbb contents (I think it is just 7 [large] tables) into the same database as drupal using big dump - just google it.)

I think it was the wrong db.

Now the question is, what do i enter for "phpBB2 database location: "

I mean there is no way to get password required to access the phpbb db from drupal, as they are separate. I can only get username, that's it.

If i change the database and username without changing password, it will lock me out again ...

Oh I'm so lost

I might as well say a bit about how things are setup on server. Drupal and phpbb are in separate directories. This is automated by fantastico, it will only allow me to install in a NEW directory. I guess I would need to do a dump as you have suggested. But wouldn't it break the forum? All I want to do is have a 'latest forum topics' on my homepage. I still want to use phpbb as the main form.

You should be able to untick the box for same db, and when saving the page, there should be a texfield with the following layout:

[dbtype - mysql, mysqli etc as long as it is the same as what the default drupal install is at]://[phpbb_db_username]:[phpbb_db_password]@[phpbb_location - could be localhost, or an ip adress to the database server]/[phpbb_db_name]

Is that how you filled it in? (without the square brackets) were the username and the database name in the correct locations?

I did not fill it.

Here are the steps i followed
1. copied module (phpbb2drupal) to drupal_install_directory/modules
2. logged in drupal as admin
3. enabled phpbb2drupal module
4. went to Admin->site config -> php2drupal settings. This came up with defaults. I unchecked "phpbb is on the same database as drupal" and hit Save
5. page reloaded, showed up with a new text field, which was already filled

 mysql://*****_drpl3:******@localhost/****_drpl3

I'm pretty sure that '********' is some auto-generated password when i installed drupal.

I now know that _drpl3 is the database for my drupal install. phpbb uses a db called _phpb1.

I think I will install phpbb manually myself, rather than going through a server host provided 'installshield' called Fantastico. It configures everything in the background and sticks the new install in a new database. If i do it manually, I think I should be able to stick phpbb database into my existing drupal database.

yes, when you untick the same_db box, the default filled in details are still for the drupal install. you need to replace that data with the data for the phpbb database. that long blurb is your drupal db password - I would advise you to edit your post and delete that password. you will also have probably a similar autogenerated password for the phpbb database.

Thanks for the advice.

Yes, I do get an auto-generated password for phpbb database. So I think it would be best to do a manual install where I can give db username/password that I want. I already found a decent tutorial on it, http://www.phpbb-design.com/faq/install_phpbb.php

Thanks for all the help, nbz ! Much appreciated

You do not need to reinstall phpbb - just get the database dump for the required tables, insert them into the drupal database, do the conversion, then delete those tables (but not the tables created by the phpbb2drupal module.)

I am afraid it's a bit late for that. It's already done. This time I have gotten a bit farther than before.

During manual install, i put phpbb tables in drupal database. Now when I run phpbb2drupal configuration script. It is complaining about not finding only 2 (was 6 before) tables, phpbb_categories and phpbb_posts_text.

I believe the problem is due to versions.

This script will import your phpBB data into Drupal. It currently targets imports from phpBB 2.x.

Well, I should learn to research more before attempting something.

Back to square 1 ...