Zen Cart Logo
Forums / General Questions / need help, barely know where to start...

need help, barely know where to start...

Locked

Views: 2,625

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
31 May 2006, 1:45 AM
#1
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

need help, barely know where to start...

Hey there,

I have an account on a server that uses vdeck. I installed zencart and had it configured and running.

Now, I was in vdeck and went into preferences to change the site passwords. I clicked all of the options to change the passwords in...one of which was the "default mysql user", and then reset the password.

Now, at this point the store stopped working completely. I cant even get to the admin page. The store link gives me a message
"Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you."

and the admin page gives the error

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]

How do I fix this???

As you may have guessed, I'm pretty new at all of this.

Thanks

31 May 2006, 1:51 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: need help, barely know where to start...

This is where one calls one's hosting site and tells them the nice story of how ...

I wasn't really runnin' ... just looked like I was runnin' 'cause my feet were moving really, really fast ... but I wasn't runnin' ... cause you said "Never run in the house ..." :unsure:

31 May 2006, 2:06 AM
#3
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

Re: need help, barely know where to start...

yeah, did that, they werent much help, problem is, zencart didnt come with the package, the person Im helping set up the site installed it, and I really dont know exactly what she did.

31 May 2006, 2:16 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: need help, barely know where to start...

Now, I was in vdeck and went into preferences to change the site passwords. I clicked all of the options to change the passwords in...one of which was the "default mysql user", and then reset the password.

IF your hosting site does not know how to reset the master password for your site/database ... you are in trouble ...

IF you only reset the password on your specific Zen Cart database ... (and they should of been able to help you with this too) ... then you can go into MySQL in CPanel and remove the username from the database ... delete the username ... recreate the username and password ...

31 May 2006, 2:19 AM
#5
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,627
Plugin Contributions:
0

Re: need help, barely know where to start...

Do you know what the password was reset to?

31 May 2006, 2:23 AM
#6
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

Re: need help, barely know where to start...

I guess what im hoping is that there is a password stored in the database somewhere that I can reset...or something

31 May 2006, 2:24 AM
#7
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

Re: need help, barely know where to start...

Yeah, I do know what the password was reset to

31 May 2006, 2:30 AM
#8
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

Re: need help, barely know where to start...

Ajeh:

IF you only reset the password on your specific Zen Cart database ... (and they should of been able to help you with this too) ... then you can go into MySQL in CPanel and remove the username from the database ... delete the username ... recreate the username and password ...

its vdeck, not cpanel, but yeah, this was what i hoped i could do...err.. how do I do it? I poked around the zencart database but i dont see where the username is stored.

31 May 2006, 2:37 AM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: need help, barely know where to start...

If you know your database name ...

If you know your username ...

If you know your password ...

Get a copy of the /includes/configure.php from your server and edit it with a good TEXT editor ... and fix the database issues at the bottom of the file that may have changed from your setting changes that you said you made ...

You will also need to edit the file:
/admin/includes/configure.php

31 May 2006, 2:51 AM
#10
jwebster8 avatar

jwebster8

New Zenner

Join Date:
May 2006
Posts:
27
Plugin Contributions:
0

Re: need help, barely know where to start...

Sweet, thats exactly what I was looking for, worked great. Sorry if I seem a bit dense. I'm REALLY new at all this.

31 May 2006, 3:43 AM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: need help, barely know where to start...

Not a problem ... you are doing good ... just be patient with yourself ... :smile:

Hint 1: backup everything ...

Hint 2: see hint 1 ... :cool: