Really could use some help V1.39F crashed

Hi everyone hope someone would be kind enough to help me get my Zencart functional again
In short the Domain host service via their Cpanel told me there was an update for the **V 1.39F ( I think it is and not 1.38F) to 1.5.3 **
So I clicked on the update icon and it then it said it was doing a backup first
Then it did some Zencart script I guess to do the update and in process says it failed :-(
But went to my admin Zencart webapage and said all was OK except an issue saying database needed some path :-(
I did not know how to do that so via Cpanel for this update I did a restore of Zencart and in the process says something was corrupted. :-(
Contacted the domain host server and they said only fix was they do a total restore of my whole domain. They claim that V1.5.3 as to version of SQL was the cause of crashing their version of SQL
Took them 8 hours and finally said they were able to do all files/folders restore BUT could not restore all the databases
Now when I go to the Zencart frontstore as you see in screenshot the error it says and also show it seems the Zencart databases are there ( repair function does not fix it)
If I go to the Zencart admin webpage get this error :
1146 Table 'teamzr5_zc1.zen_db_cache' doesn't exist in: [db_cache table]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can someone please help to solve this as my Zencart is small but it has been up for some years and now it is totally non useable and though I can use the programs and do little HTML, other then that I have no experience in how complex Zencart is to update or fix and I really do not want to loss the products for sake or other content that existed and I assume the old files are on my domain through their backups and restores
Many Thanks -- JR

teamzr1:

Hi everyone hope someone would be kind enough to help me get my Zencart functional again
In short the Domain host service via their Cpanel told me there was an update for the **V 1.39F ( I think it is and not 1.38F) to 1.5.3 **
So I clicked on the update icon and it then it said it was doing a backup first
Then it did some Zencart script I guess to do the update and in process says it failed :-(
But went to my admin Zencart webapage and said all was OK except an issue saying database needed some path :-(
I did not know how to do that so via Cpanel for this update I did a restore of Zencart and in the process says something was corrupted. :-(
Contacted the domain host server and they said only fix was they do a total restore of my whole domain. They claim that V1.5.3 as to version of SQL was the cause of crashing their version of SQL
Took them 8 hours and finally said they were able to do all files/folders restore BUT could not restore all the databases
Now when I go to the Zencart frontstore as you see in screenshot the error it says and also show it seems the Zencart databases are there ( repair function does not fix it)
If I go to the Zencart admin webpage get this error :
1146 Table 'teamzr5_zc1.zen_db_cache' doesn't exist in: [db_cache table]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can someone please help to solve this as my Zencart is small but it has been up for some years and now it is totally non useable and though I can use the programs and do little HTML, other then that I have no experience in how complex Zencart is to update or fix and I really do not want to loss the products for sake or other content that existed and I assume the old files are on my domain through their backups and restores
Many Thanks -- JR

Very unfortunate indeed. While it is nice that the host offered some form of solution to try to upgrade, that really should be left for the store owner to do. In the process of making backups, was a backup of your database ever performed? It's not a total loss, but more than likely it has already been upgraded and now the software to display it needs to be as well...
There are a number of ways you could move forward, but ideally you'd make a backup of everything associated with this one site (files AND database) you could then put together at least a version of it without your current template just to get back online while you spend the next couple of hours upgrading the rest of the software.

But the update should not have been performed in place like it was, and by following the guidelines for upgrading that are posted in the FAQ, the headache and concern will be much less...

Thanks for the reply but most of this is over my head

Now when going to the Zencart main page at the top it says

**Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Rest of that main page shows all products fine

If trying to go to the admin webpage it cannot and responds back with

0 DB_ERROR_NOT_CONNECTED in: [db_cache table]

If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

**Being I cannot get into the admin page how can I do some patch, what patch and how to fix the SQL the
0 DB_ERROR_NOT_CONNECTED in: [db_cache table] ??

Thanks for any help as this means the Zencart has been down since Friday :-(

teamzr1:

Thanks for the reply but most of this is over my head

Now when going to the Zencart main page at the top it says

**Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Rest of that main page shows all products fine

If trying to go to the admin webpage it cannot and responds back with

0 DB_ERROR_NOT_CONNECTED in: [db_cache table]

If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

**Being I cannot get into the admin page how can I do some patch, what patch and how to fix the SQL the
0 DB_ERROR_NOT_CONNECTED in: [db_cache table] ??

Thanks for any help as this means the Zencart has been down since Friday :-(
Since you said that you can access the store-side (except for the database patching message), but not your admin (due to a database configuration issue), I suggest that you

1. Open the file /includes/configure.php
2. Edit the file /YOUR_ADMIN/includes/configure.php
3. Copy the DB_ definitions (the database configuration) from /includes/configure.php, overwriting the same settings in /YOUR_ADMIN/includes/configure.php
4. Save /YOUR_ADMIN/includes/configure.php and upload the changed file to your store's file structure.
   That should get your admin going again.

When you look at the file-system associated with your webhost, is there a directory that looks like it could be the renamed version of the zc_install folder?

Hi thanks for the tips

I copied from includes/configure.php
of :

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'teamzr5_zc1');
define('DB_SERVER_PASSWORD', 'zr1xxx');
define('DB_DATABASE', 'teamzr5_zc2');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/teamzr5/public_html/fstore/cache');

Then replaced those lines in the configure.php in the admin/includes and overwrote (copied) that in admin/includes and still when going to the Zencart main page get same error warning at top of page

and of going to the admin page still get same error of

**0 DB_ERROR_NOT_CONNECTED
in: [db_cache table]
**
What causes NOT connected ? and if so possible fix ?
is there some folder or file called cache ?
or work around be able to turn off cache to get to admin page ?

Thanks

Also can anything be seen or done to the DB-cache tables seen in PHPmyadmin as seen below ?

With zero support I have had to try and fix this myself
I have the frontstore functional and now also the admin webpage but the host provider screwed up all recents SQL database backups and only had the one from 2010 and stupid tech support moved all databases to the same database tables

So if anyone could at least answer as seen with screenshot below ( and red arrows I added)

1. when clicking on "contact" URL only it shows address and phone #, being I have moved some time ago this has to be changed and it is not in the contacts content page
   so what file is that in so I can update that info ?

2. as it is the software version is 1.39f but the failied updating to 1.5.3 left saying as you see at top of page that database needs a hot fix.
   Where do I obtain the fix and the process to fix that ?

3. in the frontstore configure.php and the one for the admin's configure.php
   should both be set for cache as database, or none, ( both set the same way also ?)

Thanks for any help as my frontstore has been broken now for going on 2 weeks ! :-(

1. Changed in Admin - Configuration - My Store (and yes, it's stored in the database).

2. In Admin - Tools - Server/Version Info, what version of Zencart are you showing, and what DB version ?

3. A stock Zencart installation has that option set to 'none' in both files.

You got bit by one of the biggest problems with an auto-update from plesk, cpanel, or softaculous. More likely than not, they automatically create a database prefix of zen_.
If you then import a backup that did not contain the zen_ prefix, you get the error you got. Sorry you weren't asked about that in the first place. For future reference, it's a good idea not to jump on your horse and ride madly off in all directions. Head here for advice, answer EVERY posting tip question you can, and slowly try to recover.
Unless your host is knowledgeable about Zen Cart, they are not your first line of defense. Since we started hosting Zen Cart several years ago, we have turned off EVERY auto installer.
Anywho... Do use phpMyAdmin or some other program to verify that the database prefixes match. If the backup from 1.3.# does not have a prefix, you will need to remove that from BOTH configure.php files when doing the import/upgrade.
When you got that error, the first thing should have been to see if the database teamzr5_zc1 existed. If your host doesn't know that, well......
Second should have been to see if the prefix (in this case zen_) existed in both databases. Still something a host probably should have known.
However, once you get outside the "Does it exist?" and the "Does it have a prefix?" your host could be lost. And, sometimes, we all overlook the obvious.
Suggestions:
Can your host go back to last month? Two months? You need to get a good backup of your database (and, hopefuly the site) that was working. Make sure you have it on your own computer. Download 1.5.3 from Zen Cart and see if the instructions at http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading don't help.

Thanks Stevesh that was a real help !

Doing what you stated I correct #1

As to #2 attached is a screenshot and maybe from that you or others can steer me how to correct the **database error saying a hot fix is required **showing at very top of each webpage including when using Admin URL

Fixed #3 as I did not know what it was before and set both configs as "database" and just replaced that with "none" for both

Now if database problem can be solved I can get this fixed and working properly again

stevesh:

1. Changed in Admin - Configuration - My Store (and yes, it's stored in the database).

2. In Admin - Tools - Server/Version Info, what version of Zencart are you showing, and what DB version ?

3. A stock Zencart installation has that option set to 'none' in both files.

Thank you to dbltoe in helping me fix the screwup the host provider did.

I just assumed since their Cpanel directed me to saying Zencart had updates and in the process it did a backup that I was safe :-(
Worse is when I saw Zencart broken the tech support of host told me on phone to click on the restore of Zencart it would have done so but during the process it failed and said some zip file was corrupted and that is when the tech support guy did a full restore of my domain he said was from Aug 11 and instead he did a restore from 2010 and hence all functions/programs now were using 2010 SQL/PHP databases and then they claimed they had no other backup and they were so sorry and took them till today to admit it and gave me 4 months of hosting for free like that would undo all customers info, etc of Zencart and also all posts on my UBBthreads forum are also back to 2010 so lost 4,000 plus high detail tech content :-(

I cannot go back as host tech support overwrote all SQL/PHP with seems only backup they had was from 2010 and that is what they did a restore on though they claimed they had a backup from AUG 10TH yet now claim they have no other backups.

Being I am a user and can admin Zencart I am not a software programmer and install of Zencart was maybe 5 plus years ago so do not know the insides of PHP code like all of you

I will have to re-read your content on this prefix as I do not know anything about that and then maybe you can steer me on fixing what you think is wrong

How do I check and know if these prefixs are right/wrong ?
Concerned if I try and update from the V 1.39f to 1.5.3 that I make things even worse

As you see I did start this thread back in end of Aug but was holiday weekend and few responded till today's update post.

I just went to phpMyadmin, here uis screenshot, does that help as to prefix you mention and if so what should I do ?

dbltoe:

You got bit by one of the biggest problems with an auto-update from plesk, cpanel, or softaculous. More likely than not, they automatically create a database prefix of zen_.
If you then import a backup that did not contain the zen_ prefix, you get the error you got. Sorry you weren't asked about that in the first place. For future reference, it's a good idea not to jump on your horse and ride madly off in all directions. Head here for advice, answer EVERY posting tip question you can, and slowly try to recover.
Unless your host is knowledgeable about Zen Cart, they are not your first line of defense. Since we started hosting Zen Cart several years ago, we have turned off EVERY auto installer.
Anywho... Do use phpMyAdmin or some other program to verify that the database prefixes match. If the backup from 1.3.# does not have a prefix, you will need to remove that from BOTH configure.php files when doing the import/upgrade.
When you got that error, the first thing should have been to see if the database teamzr5_zc1 existed. If your host doesn't know that, well......
Second should have been to see if the prefix (in this case zen_) existed in both databases. Still something a host probably should have known.
However, once you get outside the "Does it exist?" and the "Does it have a prefix?" your host could be lost. And, sometimes, we all overlook the obvious.
Suggestions:
Can your host go back to last month? Two months? You need to get a good backup of your database (and, hopefuly the site) that was working. Make sure you have it on your own computer. Download 1.5.3 from Zen Cart and see if the instructions at http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading don't help.

Notice that the error in your first post mentions teamzr5_zc1 and the image of your phpMyAdmin (post 6) lists teamzr5_zc2? You've got so many databases floating around now that the confusion may never stop.:( Hopefully none of the other six are Zen Cart databases.
Decide which database has the data you want to pass on to the new install. Back it up.
Rename the OTHER database to teamzr5_zc153 and delete everything in it.
Unzip the latest zip of Zen Cart into your root directory. Extract the zip in the root directory. This should create a directory called zen-cart-v1.5.3-07192014.
Rename the zen-cart-v1.5.3-07192014 directory to demo.
Enter yourdomain.com/demo/zeal into your browser.
Follow the steps to create a ZC site in your /demo folder. USE THE DATABASE YOU NAMED TEAMZR5_ZC153 along with its username and password.
Report back after that.

Hi dbltoe

Via PHPmyAdmin I verified that existing Zencart (V1.3.9f) is in _ZC2

I then selected all tables and exported that to my desktop

I unzipped 1.5.3 to my desktop and the folder is named demo
I then FTP that demo directory ( and all subfolders included ) to the root of the public_html directory

Before doing anything else need you to clear up as you state

**Decide which database has the data you want to pass on to the new install. Back it up.
Rename the OTHER database to teamzr5_zc153 and delete everything in it.

**OK so _ZC2 is exported so I have that copy
**Rename what other database ?
You mean rename _ZC2 ?

And what is ( /demo/zeal) ZEAL that you have in the URL path ?

Thanks for helping
**

dbltoe:

Notice that the error in your first post mentions teamzr5_zc1 and the image of your phpMyAdmin (post 6) lists teamzr5_zc2? You've got so many databases floating around now that the confusion may never stop.:( Hopefully none of the other six are Zen Cart databases.
Decide which database has the data you want to pass on to the new install. Back it up.
Rename the OTHER database to teamzr5_zc153 and delete everything in it.
Unzip the latest zip of Zen Cart into your root directory. Extract the zip in the root directory. This should create a directory called zen-cart-v1.5.3-07192014.
Rename the zen-cart-v1.5.3-07192014 directory to demo.
Enter yourdomain.com/demo/zeal into your browser.
Follow the steps to create a ZC site in your /demo folder. USE THE DATABASE YOU NAMED TEAMZR5_ZC153 along with its username and password.
Report back after that.

deleted for change

You got there with the demo folder but it took forever and upped your bandwidth. If you had just FTPd the zip and extracted it on the server as I stated> Unzip the latest zip of Zen Cart into your root directory. Extract the zip in the root directory. This should create a directory called zen-cart-v1.5.3-07192014.

Rename the zen-cart-v1.5.3-07192014 directory to demo.in my post. But, that's okay because we got there. The files are in the yourdomain.com/demo

teamzr1:

And what is ( /demo/zeal) ZEAL that you have in the URL path ?
#$#($&(*&! Spell Checker!! Should have been /demo/zc_install

**Decide which database has the data you want to pass on to the new install. Back it up.
Rename the OTHER database to teamzr5_zc153 and delete everything in it.

**OK so _ZC2 is exported so I have that copy
**Rename what other database ?**Your phpMyAdmin image (post 1) showed an teamzr5_zc1 as well. You say that teamzr5_zc2 is the database containing as much of your OLD data as could be recovered.
Therefore, the teamzr5_zc1 would be emptied and renamed teamzr_zc153.

When you run the /demo/zc_install, you will be asked to use a database. That's where you will use the teamzr_zc153 with its username and password.

_zc1 does not exist anymore, whatever tech support did when they tried to fix database ended up zc1 does not exist
but zc2 does and both configure.php now point to zc2

So I just remade a zc1 database but ran the demo/zc_install and damn get right away

[an error occurred while processing this directive] what is causing that

Your phpMyAdmin image (post 1) showed an teamzr5_zc1 as well. You say that teamzr5_zc2 is the database containing as much of your OLD data as could be recovered.
Therefore, the teamzr5_zc1 would be emptied and renamed teamzr_zc153.

When you run the /demo/zc_install, you will be asked to use a database. That's where you will use the teamzr_zc153 with its username and password.

_zc1 does not exist anymore, whatever tech support did when they tried to fix database ended up zc1 does not exist
but zc2 does and both configure.php now point to zc2

So I just remade a zc1 database but ran the demo/zc_install and damn get right away

[an error occurred while processing this directive] what is causing that:jawdrop:
Where, oh where, has anyone made any suggestion about touching ANY config file BEFORE running zc_install. Are you talking about the configure.php files in the demo/includes and demo/yourAdmin/includes?!? Actually, no config files should have been touched, period.
You may need to delete everything in the demo directory just for safety's sake. No telling what else got munged. You have hours of work to do BEFORE you bring in anything from the old site.

Rename the _zc1 to _zc153 for clarity. Make sure it is empty.

Get a new copy of ZC into the demo directory.

Run demo/zc_install. You will click Continue and the GPL page will appear. Agree and click on Continue. STOP! Do you have any items checked with anything other than a Green Checkmark?
Let's get that far and see what happens.

NO config files were touched in the demo directory,
they were touched for what is running now to match the zc2 database

It fails right at the start of install after clicking on agreeing to term
I had downloaded V 1.5.3 says hotfix version, one newer then non hot fix and was about 5.8 megs in size
zc1 is empty and shows 0 bytes in size and doing a SQL check test it says it is OK

Not sure what green checkmarks ? you mention as it again fails right from the start

dbltoe:

Where, oh where, has anyone made any suggestion about touching ANY config file BEFORE running zc_install. Are you talking about the configure.php files in the demo/includes and demo/yourAdmin/includes?!? Actually, no config files should have been touched, period.
You may need to delete everything in the demo directory just for safety's sake. No telling what else got munged. You have hours of work to do BEFORE you bring in anything from the old site.

Rename the _zc1 to _zc153 for clarity. Make sure it is empty.

Get a new copy of ZC into the demo directory.

Run demo/zc_install. You will click Continue and the GPL page will appear. Agree and click on Continue. STOP! Do you have any items checked with anything other than a Green Checkmark?
Let's get that far and see what happens.

You don't describe "it fails" so we kind of have to guess.
Does it go to a blank screen? Partial Screen? Back to the start? What does "it fails" mean?
I don't think it's your PHP version although, 5.2.17 is old.
It could be that you don't have all the required files in the demo directory. That's why the direction to upload the zip, extract it to the root, and rename the directory to demo. Extracting elsewhere and uploading the files could lead to a missing file or two.
You need to verify that all files are there.

As mentioned above post
after clicking on agreeing to the term use within a few seconds the screen changes and
the only thing
it then says is "[**an error occurred while processing this directive]" install stops

**there is nothing else on that screen and does not do anything else

Being it is doing this right off the start of the install process I would think what PHP version would not matter ?

I have no idea how to take a microsoft ZIP file ( that I downloaded off this Zencart website) on a** Linux host server** and extract it on the server as only access is
via FTP or Cpanel which has a file function but that is only to up/download files or edit them so if you can tell me that
process I can try that
I know on my P/C where the extracted Zencart files went into demo directory says 15.5 MB (16,338,944 bytes)
1,627 files of 239 folders
Not sure on Cpanel side if it would tell all files in the demo directory that was FTP from my P/C

dbltoe:

You don't describe "it fails" so we kind of have to guess.
Does it go to a blank screen? Partial Screen? Back to the start? What does "it fails" mean?
I don't think it's your PHP version although, 5.2.17 is old.
It could be that you don't have all the required files in the demo directory. That's why the direction to upload the zip, extract it to the root, and rename the directory to demo. Extracting elsewhere and uploading the files could lead to a missing file or two.
You need to verify that all files are there.