forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: mariahxxx on February 12, 2013, 04:26:13 pm

Title: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 04:26:13 pm

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?

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: phill104 on February 12, 2013, 04:38:51 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 04:51:55 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 04:52:37 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: Αndré on February 12, 2013, 04:55:02 pm

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

Quote

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]

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 05:07:12 pm

it's bridged

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: Αndré on February 12, 2013, 05:09:56 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 09:20:57 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: Jeff Bailey on February 12, 2013, 11:04:44 pm

Did you already run Αndré's query?

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 12, 2013, 11:09:45 pm

/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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: Αndré on February 13, 2013, 09:03:13 am

Please also run the following query:

Quote

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: mariahxxx on February 19, 2013, 04:34:33 pm

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

Title: Re: Entire CPMN shut down with Fatal Error! HELP!
Post by: Αndré on February 19, 2013, 05:02:54 pm

Please run

Quote

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

and post the extended error message.