Forums / Upgrading from 1.3.x to 1.3.9 / osC convert - "Your database appears to need patching to a higher level"

osC convert - "Your database appears to need patching to a higher level"

Locked

Views: 2,773

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
3 Nov 2006, 1:26 AM
#1
jeff_fwd avatar

jeff_fwd

Totally Zenned

Join Date:
Jun 2003
Location:
CA
Posts:
212
Plugin Contributions:
0

osC convert - "Your database appears to need patching to a higher level"

I know there are other threads on this, but instead of stepping into one of those, I figured I would start a new one to keep things clear

ok, I get the error msg in my storefront

I also get error msg in my admin

I am running this on a local machine so there is no link for you to view....

in Tools->Server Information it shows:

Zen Cart 1.3.6
Database Patch Level: .
PHP Version 5.1.6

in running the installer to do a database update, it shows:

Database Information -- Upgrade Sniffer predicts: *** No upgrade required ***
Database Type = mysql
Database Host = localhost
Database Name = xxxxxxx
Database Username = xxxxxxx
Database Table-Prefix =
Database Privileges = Not Checked

and no options are selected in the list of upgrades

the original db is an oSC db converted to Zen using mysqldiff and other tools (have now become a master of doing this....)

so........ ?

3 Nov 2006, 1:31 AM
#2
Kim avatar

Kim

Obaa-san

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

Re: osC convert - "Your database appears to need patching to a higher level"

Jeff-

You were upgrading from 1.3.5? What are the permissions on your includes/configure.php and the admin/includes/configure.php?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

3 Nov 2006, 1:45 AM
#3
jeff_fwd avatar

jeff_fwd

Totally Zenned

Join Date:
Jun 2003
Location:
CA
Posts:
212
Plugin Contributions:
0

Re: osC convert - "Your database appears to need patching to a higher level"

hi Kim

yes

the db goes from an old oSC db, to a Zen db and it has worked flawlessly up until this installation of 1.3.6

started with a clean install of 1.3.6, then I go thru the following:

  1. install clean copy of 1.3.6 and create clean db
  2. download current copy of oSC db
  3. do a mysqldiff on oSC vs 1.3.6 db
  4. apply all changes
  5. change db name in admin & catalog includes/configure.php to new db

permissions are 644 on both config files

3 Nov 2006, 8:36 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: osC convert - "Your database appears to need patching to a higher level"

jeff:

Zen Cart 1.3.6
Database Patch Level: .

Looks like you missed ensuring some tables were ported over or contained current/valid data. In the case of patch-level information, this is in the project_version and project_version_history tables. If you've missed those, then I would venture to consider that others have been missed during your conversion as well.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Nov 2006, 2:25 PM
#5
jeff_fwd avatar

jeff_fwd

Totally Zenned

Join Date:
Jun 2003
Location:
CA
Posts:
212
Plugin Contributions:
0

Re: osC convert - "Your database appears to need patching to a higher level"

DrByte:

Looks like you missed ensuring some tables were ported over or contained current/valid data. In the case of patch-level information, this is in the project_version and project_version_history tables. If you've missed those, then I would venture to consider that others have been missed during your conversion as well.

that was the problem - I didnt move the data in those 2 fields....

thanks!!