[Solved] Database Error on GoDaddy

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Post by hireconor » Sat Mar 20, 2010 3:20 am

Yesterday GoDaddy decided to work on their MySQL Databases without telling anyone, so my OC couldn't connect all day. Now I'm running test scripts and connecting to the database fine, but OC still won't connect. Do I need to flush something out? Nothing has been changed in the last two days.

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ocsmokestack'@'72.167.xxx.17' (using password: YES) in /home/content/b/e/n/xxx/html/store/system/database/mysql.php on line 6
Error: Could not make a database connection using ocsmokestack@ocsmokestack.db.5073xxx.hostedresource.com
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/content/b/e/n/beneisman/html/store/system/database/mysql.php on line 66

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Re: Database Error

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Sat Mar 20, 2010 3:40 am

Looking at the error I think that your user-info to connect to the db is incorrect.

What is your hoster saying?

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: Database Error

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Post by hireconor » Sat Mar 20, 2010 4:09 am

GoDaddy says they are all up on their side. I've did try a test php file to connect to the database with the current database name/pass/url, it seems to be connecting ok.

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Re: Database Error

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Sat Mar 20, 2010 4:17 am

hireconor wrote:GoDaddy says they are all up on their side. I've did try a test php file to connect to the database with the current database name/pass/url, it seems to be connecting ok.

Strange, they do something and your shop stops working but they say nothing's changed....

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: Database Error

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Post by hireconor » Sat Mar 20, 2010 4:34 am

Well they say all the databases are working and they tested the database and its connecting. Also I've tried a test php script to connect and it did. So they said I should re-code the call function in the mysql.php file because it can't find the creditionals. But I do nothing to the website or the script in the files. I basically woke up and it was like this. I tried to change the db password a couple of times, but it didn't matter when the db's were down anyway. Now I've verified the password with the database.

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Re: Database Error

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Sat Mar 20, 2010 4:39 am

As last resort you could backup your DB and files and do a clean install and see if that solves it.

Re-coding after they did something sounds more like they don't have a clue.

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: Database Error

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Post by hireconor » Sat Mar 20, 2010 4:55 am

i2Paq wrote:As last resort you could backup your DB and files and do a clean install and see if that solves it.

How do I restore the database with the .sql file?

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Re: Database Error

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Sat Mar 20, 2010 4:57 am

hireconor wrote:
i2Paq wrote:As last resort you could backup your DB and files and do a clean install and see if that solves it.
How do I restore the database with the .sql file?

Use your phMyAdmin to backup and restore your DB.

Global Moderator

Posts

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: Database Error

New member

Posts

Joined

Mon Mar 15, 2010 9:31 am

Post by hireconor » Sat Mar 20, 2010 5:17 am

I just created a new database with their Hosting Control Center and restored it, then updated each config.php & admin/config.php files to match the new settings. Voila! It works. Yeah right it wasn't on GoDaddy's side. God I just wasted 48 hours of my life for this. *Note to self* Don't use GoDaddy in the future.