Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1] 2   Go Down

Author Topic: Critical error: unable to connect to UDB database  (Read 21191 times)

0 Members and 1 Guest are viewing this topic.

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Critical error: unable to connect to UDB database
« on: October 15, 2013, 02:01:10 am »

Hi,

I have not worked on my website in a couple of years and need to get it updated and running again.  I can see that my database tables for coppermine are using the prefix cpg14x_ so I'm sure that I had version 1.4 working at some time.  I need to upgrade to 1.5 and continue adding photos.

When I try to view coppermine in a web browser I get this message:

Coppermine critical error:
Unable to connect to UDB database !

MySQL said:


I get the same message when running the version checker.  I've checked the includes/config.inc.php file and believe all of the login information to be correct.  I'm using the following safe mode work around since I'm using hostgator for my hosting service (I commented this out and got the same result):

// Silly safe mode
define('SILLY_SAFE_MODE', 1);

The said site is http://www.glassresearch.net/coppermine/

I've searched the forum and have not found anything that has worked on correcting this issue.  Any help or direction would be much appreciated.
Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #1 on: October 15, 2013, 04:35:49 am »

I'm pretty sure that I have the dbserver, dbuser, dbpass, and dbname all correct since I verified it all using myphpadmin.

Could the smf bridge have anything to do with this?  It's been so long since I've worked with my site I can't remember what affects what enough to troubleshoot this.
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Critical error: unable to connect to UDB database
« Reply #2 on: October 15, 2013, 05:38:40 am »

Looks like your using v1.4.19. If you can find out what the actual error is you'll probably be able to fix the problem (update password, repair table ... )

Use PHPMyAdmin to change the debug mode.
1.5.x docs: http://documentation.coppermine-gallery.net/en/errors.htm#errors_debug_mode_manual
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #3 on: October 15, 2013, 09:13:00 am »

I set the debug mode as instructed and it didn't put any more information on the page... I'm not finding anywhere in my hostgator files where it's saving any mysql error logs or any other logs that might be helpful...
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error: unable to connect to UDB database
« Reply #4 on: October 15, 2013, 10:57:51 am »

You should contact hostgator to check that all the credentials are correct and that there is no fault on their end

Another option would be to download your db and files to your local machine and using a tool such as WAMP test everything is working obviously not forgetting to change the db details in config.inc.php. If all is working as expected do the upgrade locally while you try and find out what is wrong with your hosting.

If your hostgator account is still requiring safe mode then it could also be they have not upgraded PHP as most recent hostgator accounts I have seen no longer are setup that way. So again, it might be worth having a word with their support.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #5 on: October 15, 2013, 06:04:37 pm »

I have another option... I have a domain on hostgator that really is empty.  Would I be correct in testing if I loaded clean updated mambo, coppermine and smf installs on that domain then imported my tables?  I'm thinking that would test the programs themselves.  Hostgator would still be in the mix so it would be a limited test.

I'd have to figure out how to import the tables that have all my data in them....
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error: unable to connect to UDB database
« Reply #6 on: October 15, 2013, 06:35:02 pm »

Am I by that post assuming that you have SMF, Mambo and Coppermine all on the same db and if so do they also have connection problems?

As for Mambo I thought that had all but died out and most of those behind it had forked into Joomla.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #7 on: October 15, 2013, 06:36:46 pm »

Mambo is working fine.  SMF and coppermine are having issues.  But keep in mind it's been several years since I've worked on the site and there was a server change in there too.  I can't be sure I even had smf and coppermine working correctly since migrating to hostgator.  I just can't remember.
Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #8 on: October 15, 2013, 06:37:32 pm »

You can see the main site at http://www.glassresearch.net
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error: unable to connect to UDB database
« Reply #9 on: October 15, 2013, 06:41:16 pm »

So both SMF and CPG are having problems which suggests that db connection details are incorrect. Check the configuration.php file in mambo and compare the db settings.

As for using spare space at hostgator you could do that but much better to work locally as everything will be so much faster. Take a look at wampserver.com/en/ . With that you can install a completer webserver on your desktop and with just a few clicks set it up with the same php and MySQL versions and setting as your live hosting. Then import everything locally for testing.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #10 on: October 15, 2013, 06:58:05 pm »

Will do... I'll check those settings
Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #11 on: October 15, 2013, 07:09:03 pm »

Oh good grief... I just figured out that hostgator changed my server path.  Instead of it being /home/.....   it is /home1/....

Now I have to figure out where in all of mambo, smf and coppermine I need to change that path!  Check out the error message in smf now:

http://www.glassresearch.net/index.php?option=com_smf&Itemid=53

Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #12 on: October 16, 2013, 03:03:00 am »

I was only able to find a couple of instances with the wrong server path and updating them made no difference with the issue.... Any other ideas for me to try or research?
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error: unable to connect to UDB database
« Reply #13 on: October 16, 2013, 10:57:25 am »

The path shouldn't cause the unable to connect to DB error you are getting.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Niecher

  • LocalSupporter
  • Coppermine frequent poster
  • ***
  • Country: es
  • Offline Offline
  • Gender: Male
  • Posts: 191
Re: Critical error: unable to connect to UDB database
« Reply #14 on: October 16, 2013, 01:10:05 pm »

Hello treehstn,

I suggest, create a new file config.inc.php and upload it via ftp overwriting the previous one.

Regards.
Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #15 on: October 16, 2013, 05:06:33 pm »

Recreating the config.inc.php file had no effect.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Critical error: unable to connect to UDB database
« Reply #16 on: October 16, 2013, 07:21:13 pm »

You will need to speak to your host as there is not a lot else we can do. But please try your setup locally as I have suggested above and if it works there then you have more ammo to go to your host with.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #17 on: October 17, 2013, 03:11:21 am »

Phill... I'm working today on getting all the files and db downloaded and then will run everything local to test as you suggest... will post back with my findings.  Thank you!
Logged

Niecher

  • LocalSupporter
  • Coppermine frequent poster
  • ***
  • Country: es
  • Offline Offline
  • Gender: Male
  • Posts: 191
Re: Critical error: unable to connect to UDB database
« Reply #18 on: October 17, 2013, 01:32:03 pm »

Hello treehstn,

There seems to be a strange behavior in your config.inc.php file. Here.

Regards.
Logged

treehstn

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 106
Re: Critical error: unable to connect to UDB database
« Reply #19 on: October 17, 2013, 06:36:02 pm »

I overwrote the config.inc.php file with a brand new one from the install files.  It didn't make any impact on the connection issue so I put it back to what it was.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.034 seconds with 20 queries.