Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Database error on home page!

Database error on home page!

Locked

Views: 2,249

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
12 Apr 2009, 3:50 AM
#1
gizmo_girl avatar

gizmo_girl

Zen Follower

Join Date:
Nov 2007
Location:
Texas
Posts:
286
Plugin Contributions:
0

Database error on home page!

Domain: https://www.kings-kreations.com

When I type in my domain name, this is the error message I get:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/a/j/k/ajking5464/html/core/class.php on line 16
MySQL error!

If I type in https://www.kings-kreations.com/index.html, the splash page comes up just like it should.

Can anyone tell me why I'm getting a database error message on my home page? That shouldn't have any connection to the database, so I'm really confused!! :blink:

12 Apr 2009, 3:57 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database error on home page!

gizmo_girl:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/a/j/k/ajking5464/html/core/class.php on line 16
MySQL error!
That message has nothing to do with Zen Cart. (Zen Cart doesn't have a /html/core/class.php file)

I suggest you talk to your hosting company.

12 Apr 2009, 3:59 AM
#3
gizmo_girl avatar

gizmo_girl

Zen Follower

Join Date:
Nov 2007
Location:
Texas
Posts:
286
Plugin Contributions:
0

Re: Database error on home page!

I will call again and hope I can get someone who can/will help me this time. Thanks!

12 Apr 2009, 4:49 AM
#4
gizmo_girl avatar

gizmo_girl

Zen Follower

Join Date:
Nov 2007
Location:
Texas
Posts:
286
Plugin Contributions:
0

Re: Database error on home page!

I've talked to 3 people now and they're all blaming the problem on Zen Cart. :-/ No idea where to go from here. The file appears to be jibberish...a little bit of text at the beginning, then lines and lines of foreign characters, etc.

12 Apr 2009, 5:38 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database error on home page!

gizmo_girl:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) **in /home/content/a/j/k/ajking5464/html/core/class.php **on line 16

Well ... since the error is occurring when a script file runs that doesn't even exist as part of Zen Cart, I don't know how it makes any sense that the message would have anything to do with Zen Cart.

Perhaps whoever is claiming it's got to be Zen Cart could explain exactly how they've come to such an insane conclusion?

Maybe you should figure out what files exist in that "/html/core/" folder, and what THEY are there for?

12 Apr 2009, 5:41 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database error on home page!

And ... if it's GoDaddy support you're using, well ... you might look up their track record and see that they're all programmed to give you canned responses in order to get you off the phone. There might be 1 person that actually takes the matter seriously ... but they're about 5 levels up the chain. Good luck.

12 Apr 2009, 2:07 PM
#7
gizmo_girl avatar

gizmo_girl

Zen Follower

Join Date:
Nov 2007
Location:
Texas
Posts:
286
Plugin Contributions:
0

Re: Database error on home page!

Ugh...well, I have no idea WHY they think Zen is the problem, I tried to explain that the error isn't even coming from a Zen folder. It is GoDaddy...and I'm starting to regret it. However, at this point I just need to get the site operational. It's been down for 3 weeks now, thanks to Jumpline just pulling the plug on me without any kind of notification (apparently I was over my alloted disc space). Anyway, I don't know enough about how all this works to figure out the files. The very first part of that file talks about Zend....there's about 1 1/2 lines of code, then the rest looks like it's in foreign characters/jibberish. No clue what to do with it. :-/

12 Apr 2009, 3:29 PM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database error on home page!

Zend is entirely different from Zen Cart. They are completely unrelated.

The file you're referring to is likely encrypted by the Zend Guard tools used by some programmers, to prevent people from reverse-engineering their code or seeing how things actually work behind-the-scenes. Zen Cart doesn't encrypt their code because they have nothing to hide. Besides, encrypting code flies in the face of the Open Source philosophy.

If you're getting errors from other software on your site, you need to figure out what that other software is, and fix the problems there. Maybe the database connection settings for that program are wrong for the new server you've moved to? or maybe the software wasn't moved to the new server properly? or maybe your new host uses different approaches for connecting to the database, which your new host will have to help you figure out in order to change the configuration.

Again, since you're dealing with software other than Zen Cart, it's rather tough to find support for that software here on the Zen Cart support site ...

12 Apr 2009, 4:15 PM
#9
inovermyhead avatar

inovermyhead

Zen Follower

Join Date:
Feb 2007
Posts:
154
Plugin Contributions:
0

Re: Database error on home page!

Hi gizmo_girl ... did you get this fixed ? When I click on your splash screen, the home page comes up fine, as well as the products I clicked on ...

12 Apr 2009, 4:45 PM
#10
steven300 avatar

steven300

Totally Zenned

Join Date:
Jan 2008
Posts:
1,564
Plugin Contributions:
1

Re: Database error on home page!

There was never a problem with the splash screen, it's https://www.kings-kreations.com that had, and still has, a problem.

13 Apr 2009, 8:21 PM
#11
inovermyhead avatar

inovermyhead

Zen Follower

Join Date:
Feb 2007
Posts:
154
Plugin Contributions:
0

Re: Database error on home page!

Sorry, I should have been clearer. I click on your splash screen and your home page comes up. I can can click on categories, products, back to home page, no problem whatever, and no error displayed on any of them ...

18 Apr 2009, 1:07 AM
#12
Join Date:
Apr 2009
Posts:
36
Plugin Contributions:
0

Re: Database error on home page!

Sounds like a Zend encoded file with the problem - However- the error that is being given indicates that MySQL is not running, or the database hostname being given is incorrect, which I suspect is the most likely case.

(if you just moved from other host to godaddy, you need to know that godaddy hosts mysql on a separate server, so you cannot use 'localhost' for mysql host name.. sounds like whatever script is running that Zend encoded file needs to have its configuration adjusted. - Either way- it is a software problem, and correctly, godaddy says it is not their problem - it is a problem in the script configuration, and since it is not zen-cart script or file involved, you're looking for help in the wrong place - you need to figure out who wrote the script you are using that refers to core/class.php and get them to help you out and support their script...)