Your database appears to need patching to a higher level. See Tools->Server Informati

I ran the recommended upgrade for ZenCart that was recommended by my host. It was an auto install offered. However, it errored out and I know get the following message: "Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels." It is visible on the homepage, and in the admin area. I went as instructed to the admin area, server info and see the following:

Server Host: gs14.inmotionhosting.com (205.134.240.228) Database Host: localhost (127.0.0.1) Server OS: Linux 2.6.9-42.0.3.ELsmp Database: MySQL 4.0.27-standard-log Server Date: 11/16/2006 06:49:56 Database Date: 11/16/2006 06:49:56 Server Up Time: 06:49:56 up 25 days, 4:23, 2 users, load average: 2.58, 2.84, 2.96
PHP Version: 4.3.11 (Zend: 1.3.0)
HTTP Server: Apache/1.3.36 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.27 OpenSSL/0.9.7a

I look to the config.php and see the following database info.

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

Basically, I know enough to be dangerous, but not enough to corerct this. Can anyone help me out so I do not loose the hours of work I have input. My only thought is to delete and do a fresh install.

Does anyone have an answer to this? I'm getting it too.

Quote:

---

Originally Posted by dranet

Does anyone have an answer to this? I'm getting it too.

---

It means that your database structure doesn't match the version that your PHP files are expecting.
This typically happens only when you've started to do an upgrade but haven't completed it properly.

Quote:

---

Originally Posted by DrByte

It means that your database structure doesn't match the version that your PHP files are expecting.
This typically happens only when you've started to do an upgrade but haven't completed it properly.

---

Thanks for replying, but I just installed ZenCart. I went through every step in the instructions and the only errors I got are for the fcgi thingie. Well, that and I'm getting a page not found error on the catalog (admin works ok).

Are all of these related?

Thanks,
Tracy

What is the URL?

I had a database backup from version 1.3.7.1

I left a site host and held onto the backup until I got a chance to redo the site. I installed zen, apparently 1.3.8.a, restored the backup I had, and am getting the same message about patch levels. I wanted to avoid typing in all of our product data again. Not sure what to do next.

Zen Cart 1.3.8a
Database Patch Level: 1.3.7.1

Quote:

---

Originally Posted by traders

I had a database backup from version 1.3.7.1

I left a site host and held onto the backup until I got a chance to redo the site. I installed zen, apparently 1.3.8.a, restored the backup I had, and am getting the same message about patch levels. I wanted to avoid typing in all of our product data again. Not sure what to do next.

Zen Cart 1.3.8a
Database Patch Level: 1.3.7.1

---

Um ... you need to upgrade your database.

Ok, I'll try to find information on that. I do not know if I was to upgrade it BEFORE upload, or after. There were some switches and/or selections at the restore page but I just left everything alone and did not change anything. Any clue on how to do appreciated, meantime I'll search. Thanks.

Upload the zc_install folder for your Zen Cart version, and run it from your browser.
Full upgrade documentation is available in several places:
a) the /docs/ folder of your Zen cart files
b) the FAQ/Tutorials area
c) all over the forum



Or, you could just download the older version of Zen Cart and install that instead.
And plan your upgrade later.

ok, i'll try to figure it out thanks for the help. i originally installed through fantastico which is automatic install so i have never installed outsite of there, so i'll work with your info thanks.

No time like the present to learn how to do an upgrade.
Fantastico is fine for new installs, but that's about all.

apparently i do not have a zc install file, i am going to try and figure out how to upload one I guess fantastico does all that automatically, if I have one I cannot find it so I am trying to find that now.

You'll have to download the Zen Cart files from this site.
Click the Home link at the top of the page ...

i downloaded zen from the site and upload the zc_install folder to my server, but it won't execute, so I kind of know what i need to do just don't know how.

In your browser, go to http://your_domain.com/zc_install/index.php ... or whatever the correct path to it is.

I think I got it, finally, thanks for your patience.

Ok, I got it done and have ONE problem. if you view the site at www.wildwillysposters.com, there is a yellow bar appearing with the letters ggg in it. I can view source and see it and am trying to find out how to remove it.

That looks like an EZ-Page ?

I figured out the ggg problem, somehow it configured an ez page that was non-existent but I fixed it. You are right, I am glad I went through the upgrade. Fantastico does not teach anything, does everything so I needed to do this, thanks again for all your help. :smartalec:

Hello All,

I just made a big mistake & upgraded my ZC 1.3.8 to the latest version through FANTISTICO.

It did a less than FANTASTICO job on my site though.
I followed all posts referring to correcting this that I could find & when I added the zc_install folder n went through everything I got this message on the Database Upgrade.

--------

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]


What did I do wrong?
Could this be due to the renaming of the Admin Dir as mentioned to do in other posts?

Any Help would be greatly appreciated.

Thank You,
Stephen:smile:

I got this error message installing a brand-new copy of ZenCart through cPanel yesterday, and it was version 1.5.1. I immediately updated it to 1.5.5f, but the error is still there. I've already done quite a lot of work on it, so I don't want to have to start over from scratch. Please help? Thank you! Below is the information it's giving me.


Server Host: cloud1040.hostgator.com (162.144.19.11)
Server OS: Linux 3.10.0-693.17.1.2.ELK.el6.x86_64
Server Date: 05/06/2018 06:56:39
Server Up Time: 06:56:39 up 44 days, 8:49, 0 users, load average: 0.03, 0.01, 0.00
HTTP Server: Apache
PHP Version: 5.5.37 (Zend: 2.5.0)
PHP File Uploads: On
Upload Max Size: 64M
PHP Memory Limit: 256M
POST Max Size: 64M
Database: MySQL 5.6.32-78.1
Database Host: localhost (127.0.0.1)
Database Date: 05/06/2018 06:56:39
Database Data Size: 2,045 kB
Database Index Size: 739 kB
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: /var/lib/mysql/cloud1040-slow.log
MySQL Mode: NO_ENGINE_SUBSTITUTION

Zen Cart
Zen Cart 1.5.5f
Database Patch Level: 1.5.1
v1.5.1 [2018-05-05 16:54:10] (New Installation)
v1.5.1 [2018-05-05 16:54:10] (New Installation)

You've jumped on to an old thread but it's still somewhat pertinent.

If I'm reading correctly you did your upgrade using the autoloader provided in cpanel by hostgator. If so, that's not the recommended way to go and you're apparently experiencing one of the major problems. Autoloaders are not prepared to upgrade as they generally do not include the zc_install directory.

The zc_install directory will look for a non-current database and give you the option to upgrade. Here's what I suggest:

1. backup your site completely
2. download the latest ZC
3. extract the zip and load the zc_install directory to your site.
4. enter yoursite.com/zc_install and see if it gives you the option to upgrade your database (DO NOT CONTINUE WITH ANYTHING BUT UPGRADE)

This should get the database where it needs to be.

If the above is not the case, please let us know the steps used to upgrade.

Yeah, when I typed in the error message, it brought me to this page. I was hoping someone could help me even though it obviously dealt with the old-old versions of ZenCart. Thanks for that!

IT WORKED PERFECTLY!!! Thank you so much!!!