Entire CPMN shut down with Fatal Error! HELP!

[mariahxxx]

when trying to access my coppermine gallery this is all you get:
"Fatal Error:
While executing query "SELECT * FROM cpg130_bridge" on 0

mySQL error: Table 'mxxx.cpg130_bridge' doesn't exist"

we've gone through the backups but cannot find this file. how does this happen and how can I fix it?

[phill104]

That is not a file but a table in your database. Do you have a backup of your database?

[mariahxxx]

yes but my hosting tech can't find this anywhere
is there someplace specific I should direct them?

[mariahxxx]

the tech said he can't find this table in any of the backups.

[Αndré]

If your gallery wasn't bridged you can simply execute the following query:

CREATE TABLE cpg130_bridge (
  name varchar(40) NOT NULL default '0',
  value varchar(255) NOT NULL default '',
  UNIQUE KEY name (name)
) COMMENT='Stores the bridging data, not used when unbridged';

INSERT INTO cpg130_bridge VALUES ('short_name', '');
INSERT INTO cpg130_bridge VALUES ('full_forum_url', '');
INSERT INTO cpg130_bridge VALUES ('relative_path_to_config_file', '');
INSERT INTO cpg130_bridge VALUES ('use_post_based_groups', '');
INSERT INTO cpg130_bridge VALUES ('cookie_prefix', '');
INSERT INTO cpg130_bridge VALUES ('recovery_logon_failures', '0');
INSERT INTO cpg130_bridge VALUES ('recovery_logon_timestamp', '');

[Edit: fixed prefix in last line]

[mariahxxx]

it's bridged

[Αndré]

Executing the above query should fix the error message. Then, you have to run the bridge manager to re-enable your bridge.

[mariahxxx]

ok my issue is that I cannot login as admin to run the bridge manager  it gives an error: Fatal error: require_once() [function.require]: Failed opening required 'bridge/.inc.php' (include_path='.:/usr/local/lib/php') in /home/httpd/html/mariahxxx.net/members/media/include/init.inc.php on line 257

[Jeff Bailey]

Did you already run Αndré's query?

Also check if bridge/.inc.php exists on your server

[mariahxxx]

/bridgemgr.php  is on the server

i dont see bridge/.inc.php    is there something not showing up in front of the . in .inc.php? there are several files like coppermine.inc.php

[Αndré]

Please also run the following query:

UPDATE cpg130_config SET value = '0' WHERE name = 'bridge_enable'

[mariahxxx]

ok I have gotten rid of that error but now any page in my gallery says: "Si è verificato un errore eseguendo una query al database"   not sure why the language changed but this is every page of my gallery

[Αndré]

Please run

UPDATE cpg130_config SET value = '1' WHERE name = 'debug_mode'

and post the extended error message.