warning/failure notice when loading gallery index page

[Nikki]

First the needed info:
Warning: main(/bridge/phpBB2.inc.php): failed to open stream: No such file or directory in /homepages/43/d89789219/htdocs/wf1/theater/include/init.inc.php on line 268

Fatal error: main(): Failed opening required '/bridge/phpBB2.inc.php' (include_path='.:/usr/local/lib/php') in /homepages/43/d89789219/htdocs/wf1/theater/include/init.inc.php on line 268

Site Link:http://www.wayfarerone.com/theater

The only changes I've made in the phpBB.inc.php file are the ones instructed:

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'db139855705'); // The name of the database used by the board
define('phpbb_BD_HOST', 'db210.perfora.net'); // The name of the database server
define('phpbb_DB_USERNAME', 'dbo139855705'); // The username to use to connect to the database
define('phpbb_DB_PASSWORD', 'xxxxxx'); // The password to use to connect to the database

// The web path to your phpBB directory
// If your URL to your board is for example 'http://yoursite_name.com/phpBB2/',
// you'll have to set the below var to '/phpBB2/'.
define('PHPBB_WEB_PATH', 'http://www.wayfarerone.com/phpBB2/');


This is the line from init.inc.php returning the error:

Code Select Expand

if (defined('UDB_INTEGRATION')) require '/bridge/' . UDB_INTEGRATION . '.inc.php';

I've triple checked everything, and don't beleive I've missed anything.

Any help will be greatly appreciated. Thanks,

Nikki

[Nibbler]

The line is suppose to be this:

Code Select Expand

if (defined('UDB_INTEGRATION')) require 'bridge/' . UDB_INTEGRATION . '.inc.php';

And this

Code Select Expand

define('PHPBB_WEB_PATH', 'http://www.wayfarerone.com/phpBB2/');

is not a path, a path would be

Code Select Expand

define('PHPBB_WEB_PATH', '/phpBB2/');

[Nikki]

Thanks for the response, but no change after editing the files. I had tried changing the path to the full url thinking that it might help.

Any other ideas?

[Nibbler]

Init.inc.php should read:

Code Select Expand


define('UDB_INTEGRATION', 'phpbb');


You seem to have changed it to

Code Select Expand


define('UDB_INTEGRATION', 'phpBB2');


So far, all your problems are caused by editing things you are not supposed to, please follow the instructions exactly.

[Nikki]

Nibbler,
I get your point, but I have to say that change was made whilst trying to fix the error. I've had other installs/mods fail from calling phpbb instead of phpBB2.
I changed that and now get the following error:

Notice: Use of undefined constant PHPBB_BD_HOST - assumed 'PHPBB_BD_HOST' in /homepages/43/d89789219/htdocs/wf1/theater/bridge/phpbb.inc.php on line 518
Coppermine critical error:
Unable to connect to phpBB Board database !

MySQL said: Unknown MySQL Server Host 'PHPBB_BD_HOST' (1)

Line 518 in phpbb.inc.php is:

Code Select Expand

define('UDB_CAN_JOIN_TABLES', (PHPBB_BD_HOST == $CONFIG['dbserver'] && (PHPBB_DB_NAME == $CONFIG['dbname'] || PHPBB_DB_USERNAME == $CONFIG['dbuser'])));.

I do appreciate your help.

[Nibbler]

PHPBB_BD_HOST is undefined because you changed it to phpbb_BD_HOST at the top of the file. Put it back as it was.

[Nikki]

*beep*? How the hell did that happen? Sigh. Just shows what a lack of sleep and small children can do. I don't recall ever altering thhose lines, but I must have.

Anyway, I'm going to start over, because I get a different error this time, and it's most unhelpful:

Fatal error :
There was an error while processing a database query

I beleive a fresh install is the way to go here.

Thank you for your help....

[Nibbler]

Disable the bridge (re-comment the define in init.inc.php) , enable debug mode, re-enable the bridge and replicate the error. You'll then get a detailed error message that will tell you what the problem is.

[Nikki]

OK, I got it! Sort of...
This is the error text:

While executing query "SELECT user_id, username as user_name, user_level, user_posts FROM `db139855705`.phpbb_sessions INNER JOIN `db139855705`.phpbb_users ON session_user_id = user_id WHERE session_id='3fa0a93c1c8e58495a214147758c592c' AND session_user_id ='-1' AND user_active='1'" on 0

mySQL error: Table 'db139855705.phpbb_sessions' doesn't exist

I checked my tables, and it is a case of the table prefix being phpbb2_
The error is being generated by phpbb.inc.php on line:

Code Select Expand

     $sql = "SELECT user_id, username as user_name, user_level, user_posts " . "FROM " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_SESSION_TABLE . " " . "INNER JOIN " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_USER_TABLE . " ON session_user_id = user_id " . "WHERE session_id='$session_id' AND session_user_id ='$cookie_uid' AND user_active='1'";

Can I simply change

Code Select Expand

define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables

to phpbb2_?

Thanks again...

[Nibbler]

Yes, you most certainly can.

[Nikki]

It worked! YEA!!! Thank you very much for your assistance in overcoming my stupidity.