Warning: Database upgrade required

[shags38]

Hi,


(gemstone-rings.com.au) This site has been running OK since I built it a few months ago but now I cannot login to my admin, I get the following text showing on a blank screen; 'database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install'

AND I get the following message on the top of a Zen Cart template page when I go directly to the site via browser

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

Problem is I cannot get to admin to do anything. Is there a patch I can download to fix this?

cheers,
Mike

I used v1.5.1 09182012 to build this site but this is shown in version.php

* @package general
* @copyright Copyright 2003-2010 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: version.php 17676 2010-10-02 18:20:50Z drbyte $
* @private
*/

define('PROJECT_VERSION_NAME', 'Zen Cart');
define('PROJECT_VERSION_MAJOR', '1');
define('PROJECT_VERSION_MINOR', '3.9h');
define('PROJECT_VERSION_PATCH1', '');
define('PROJECT_VERSION_PATCH2', '');
define('PROJECT_VERSION_PATCH1_SOURCE', '');
define('PROJECT_VERSION_PATCH2_SOURCE', '');
define('NEW_VERSION_CHECKUP_URL','http://ping.zen-cart.com/version_id.txt');
define('EXPECTED_DATABASE_VERSION_MAJOR', '1');
define('EXPECTED_DATABASE_VERSION_MINOR', '3.9');

[DrByte]

The meaning of your symptoms is simple: your PHP files are from v1.3.9 and not from v1.5.1

You'll need to put back your v1.5.1 files, assuming that you actually used v1.5.1 as you said.

Then find out who or how the wrong/old files have appeared on your server.

This is one of those situations where backups are magically helpful.

[shags38]

The meaning of your symptoms is simple: your PHP files are from v1.3.9 and not from v1.5.1

You'll need to put back your v1.5.1 files, assuming that you actually used v1.5.1 as you said.

Then find out who or how the wrong/old files have appeared on your server.

This is one of those situations where backups are magically helpful.

Thanks for the quick response Doc. I did have a backup so I reinstalled the database and all is OK. I just wasn't sure what to do, that's all. I have no idea how the situation occurred - it was definitely v1.5.1 as it is a clone of another site which is v1.5.1.

Many thanks for your help,
Mike

[samuelsmith1979]

Hi DrByte,
I've had the same error, here is the patch info from the admin I just did an upgrade from 1.3.x 1.5.1
Zen Cart 1.5.1

Database Patch Level: 1.3.7

v1.3.7 [2013-10-07 18:54:46] (Version Update 1.3.6->1.3.7)
v1.3.7 [2013-10-07 18:54:00] (Version Update 1.3.6->1.3.7)
v1.3.6 [2013-10-07 18:54:00] (Version Update 1.3.5->1.3.6)
v1.3.5 [2013-10-07 18:53:59] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2013-10-07 18:53:59] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2013-10-07 18:53:58] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2013-10-07 18:53:58] (Version Update 1.2.7->1.3.0)
v1.5.1 [2013-10-07 17:15:42] (Version Update 1.5.0->1.5.1)
v1.5.0 [2013-10-07 17:15:41] (Version Update 1.3.9->1.5.0)
v1.3.9a [2010-04-23 17:50:09] (Version Update 1.3.8->1.3.9a)
v1.3.8 [2008-03-17 17:11:22] (Fresh Installation)

any advice on fixing this?

[DrByte]

Hi DrByte,
I've had the same error, here is the patch info from the admin I just did an upgrade from 1.3.x 1.5.1
Zen Cart 1.5.1

Database Patch Level: 1.3.7

v1.3.7 [2013-10-07 18:54:46] (Version Update 1.3.6->1.3.7)
v1.3.7 [2013-10-07 18:54:00] (Version Update 1.3.6->1.3.7)
v1.3.6 [2013-10-07 18:54:00] (Version Update 1.3.5->1.3.6)
v1.3.5 [2013-10-07 18:53:59] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2013-10-07 18:53:59] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2013-10-07 18:53:58] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2013-10-07 18:53:58] (Version Update 1.2.7->1.3.0)
v1.5.1 [2013-10-07 17:15:42] (Version Update 1.5.0->1.5.1)
v1.5.0 [2013-10-07 17:15:41] (Version Update 1.3.9->1.5.0)
v1.3.9a [2010-04-23 17:50:09] (Version Update 1.3.8->1.3.9a)
v1.3.8 [2008-03-17 17:11:22] (Fresh Installation)

any advice on fixing this?

Um ... you just ran database-upgrade steps for 1.5.1, and then went back and re-ran upgrades for 1.3.0-thru-1.3.7, effectively backdating things.
Not sure why you did that.
Do you have a database backup from before you did that?