Error: Unable to fetch group info.

Ok, that makes sense.

Here's the code I use to connect to the other database:

                $connection = mysql_connect ($hostname, $username, $password) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ($databasename);

                if (!($result2 = @ mysql_query($strsql2, $connection))) die("Error " . mysql_errno(  ) . " : " . mysql_error(  ));

Am I stepping on punbb's toes with the $connection name?
Otherwise, how can I switch PHP/MySQL back to the right connection?

Thanks for the super-quick reply BTW!!

--Alan

The easiest way is to create a second DB object

$db2 = new DBLayer($db_host, $db_username, $db_password, $db_name, $db_prefix, $p_connect);

Then just modify in there what you need.

It determines whether or not to setup a persistent connection to the database. Generally, you don't want this so just set it to false.

Hmm

This doesn't seem to have solved my problem.

I'm essentially calling several scripts to build my page, some of my own and some punbb related (extern.php).
When extern.php is called, it returns this error:

PunBB reported: Unable to fetch group info

Database reported: Table 'anotherdb.punbb_groups' doesn't exist (Errno: 1146)

Which I know means it (MySQL) is looking at the wrong database (anotherdb).

This is despite me setting up a second db object, called $db2 and using that to access my database in my own scripts. I don't have any mysql_select_db commands in my scripts!

All help/ideas appreciated.

Can you post your code?

No, the code where you're using the second DB object.

*anotherdb being my database that I'd connected to using $db2

I get the error when I try to include extern.php

I include the PHP stuff first:

// Include PunBB stuff
    define('PUN_ROOT', 'messageboard/');
    require PUN_ROOT.'include/common.php';
    define('PUN_TURN_OFF_MAINT', 1);
    define('PUN_QUIET_VISIT', 1);

Then include my scripts, which use $db2. Then I include extern.php

Essentially I think that the current database is being switched to my db (as defined by $db2), so when the punbb (extern) code tries to run, it's simply pointing at the wrong database. In other words, punbb relies on the author not switching php/mysql to another database, whether explicitly or implicitly.

I can't believe I'm the only person to come across this. Surely other people are integrating punbb into their pages along with their own scripts?

Any ideas? (Thanks for your help so far)

Alan

OK, could you post your complete code so we can take a look at how the scripts are potentially interacting?