Zen Cart Logo
Forums / General Questions / Totaly Freakin Frustrated

Totaly Freakin Frustrated

Views: 996

Results 1 to 11 of 11
20 Jan 2011, 5:08 PM
#1
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Totaly Freakin Frustrated

I can not tell you how many freaking hours I have spent trying to get my store back up and running after one of the tables crashed
The database is gone, I've been trying to reload it with no luck.
I've now spent 3 hours trying to re-install zencart and I keep going in circles. username: password and database name. No matter what I put in nothing works. I know my username to acces the database, I know the password to access my database and I can see the database name on my database., But all of the tables are gone. HOW CAN I GET THE TABLE RELOADED TO THE DATABASE????????????????????????????????????????????????

20 Jan 2011, 5:22 PM
#2
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

This is what I keep getting:

Connection to Database failed
Access denied for user '*****'@'localhost' (using password: YES)

20 Jan 2011, 5:30 PM
#3
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

after one of the tables crashed

If the table disappeared and it was called 'configuration' then your site was almost certainly hacked.

Vger

20 Jan 2011, 6:23 PM
#4
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

No that was on me. I got a table error message and couldn't repair it with phpmyadmin. I thought that I'd be cute and reset my database...and lost it all.
So...now I'm trying to reinstall and Can not get past the above problems.

20 Jan 2011, 11:54 PM
#5
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

Well, there shouldn't be any problems with you importing a backup of your database into phpMydmin, so the problem must be (as you laid out) a matter of connecting to it - and that's controlled by your two Zen Cart configure.php files and what's set for the db connection in them.

If it won't work with the current MySQL user name and password you're using to try and access that database then change them in your hosting control panel and then modify the Zen Cart configure.php files - and see if that works.

Vger

21 Jan 2011, 1:44 AM
#6
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

So here we go. I 1) deleted and reinstalled my mysql database 2) deleted and reinstalled my phpMyadmin 3) set a new database zencart. 4) loaded all of my tables to the zencart database. 5) Could not access the install program again. Went back to my host server re-installed 1.3.8 (this is the version that they have) It worked, however everything is new... I tried loading my backed up files from 1.3.9 to the server. Nothing so...I guess I must start over again!!!!!!!!!!!!!! OMG

21 Jan 2011, 2:28 AM
#7
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

I have ver 1.3.8 loaded and operating. I need to load my most recent backup files (1.3.9).
Can I load my 1.3.9 data to 1.3.8 or will I have to upgrade?
What is the easiest steps to get this done.
Not totally Zenned!

21 Jan 2011, 1:36 PM
#8
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

The simplest way to have a 1.3.9h site while keeping the data from your 1.3.8 database is:

  1. Backup your 1.3.8 database, then 'Drop' all the tables in it.
  2. Delete your 1.3.8 install
  3. Install 1.3.9h.
  4. 'Drop' all tables (using phpMyAdmin) from your 1.3.9h database.
  5. Import your 1.3.8 database into the now empty database.
  6. Go to http://www.yourdomain.com/zc_install and choose the "Upgrade only database" option when you get to the installation page. Make sure that both configure.php files are writeable.
  7. You'll then have a 1.3.9h website with a 1.3.9h database, with all the data from your 1.3.8 database in it.
  8. Make both configure.php files unwriteable, delete the zc_install folder, rename the 'admin' folder.
  9. All done.

Vger

21 Jan 2011, 3:54 PM
#9
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

Since the data from the 1.3.8 is raw and untouched (with none of my data from my backed up data).
Do I want to upgrade to 1.3.9 fisrt before (I restore my data from my backed up data)?
I ran into a block wall trying to upgrade to 1.3.9 on wednesday. It would get past the username, password etc.

21 Jan 2011, 4:48 PM
#10
black68gtx avatar

black68gtx

New Zenner

Join Date:
Dec 2010
Posts:
34
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

I hit the wall again! trying to install 1.3.9h Connection to
I keep getting this and can not go any further...any ideas?

Database failed
Access denied for user 'jersey-subs'@'localhost' (using password: YES)

In my db I have store & zencart. zencart has one file db.opt

21 Jan 2011, 6:41 PM
#11
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Totaly Freakin Frustrated

If it won't work with the current MySQL user name and password you're using to try and access that database then change them in your hosting control panel and then modify the Zen Cart configure.php files - and see if that works.

Did you do this?

Vger