Your database appears to need patching to a higher level.

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

--- I find nothing to fix or even explain this error. There is little help when clicking to Tools->Server.

Can someone explain in plain English how to fix this? I have halted all uprades on client ZEN carts until this issue is resolved.

:(

It simply means that the database-version and the Zen Cart PHP files version are mismatched.

So, either you've upgraded the database and not all the PHP files, or you've upgraded the PHP files and not the database.

https://www.zen-cart.com/tutorials/index.php?article=98

I upgraded an older version to 1.3.9h and per instructions did an install with a new database. Then per instructions I did a backup from the old database in order to restore all the products, customers etc.

All the content and the original template are now working and accepting orders but I cannot get rid of that error across the top of every page.

:blush:

Perhaps someone should edit the title for the upgrade.

It says "3 EASY STEPS TO UPGRADE ZEN CART™"

Suggested title. "3 NOT SO EASY STEPS TO UPGRADE ZEN CART™"
:laugh:

stuffdone:

Perhaps someone should edit the title for the upgrade.

It says "3 EASY STEPS TO UPGRADE ZEN CART™"

Suggested title. "3 NOT SO EASY STEPS TO UPGRADE ZEN CART™"
:laugh:

Not nice to gouge the hand that feeds your site for FREE...

what version did you upgrade from please..

haredo:

Not nice to gouge the hand that feeds your site for FREE...

????? What does this mean :blush:

1.3.8 to 1.3.9h

You have to run the database upgrade with zc_install only...

haredo:

You have to run the database upgrade with zc_install only...

I don't understand this?

I used zc_install into a new directory leaving original site untouched. New database.

I then backed up from the old DB to retain products per the instructions? Wrote down all the info for shipping and payment modules as directed.

I am trying to find out how to fix the error message and not lose all the products and customers.

I used zc_install into a new directory leaving original site untouched. New database.

I am trying to find out how to fix the error message and not lose all the products and customers.
You must RE-RUN zc_install on this new install and select "Upgrade DB Only"

So if your new directory is xxxxdomain/newdirectory - Then you need to insure that the directory and files for zc_install exist and enter

xxxxdomain/newdirectory/zc_install

I get this on screen:

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

Please read this thread: > http://www.zen-cart.com/forum/showthread.php?t=168872

haredo:

Please read this thread:

If this is a mandatory change why was it not an option and a warning in the upgrade install giving the choice to make such a change in the first place?

I have a bunch of zen's to upgrade and this is not turning out to be an "Easy Three Step Process"

Is there another upgrade release on the horizon that will address these issues

If this is a mandatory change why was it not an option and a warning in the upgrade install giving the choice to make such a change in the first place?
It is not, unless somewhere along the way, you or someone has change the DB collation from the default as it appears in your case

kobra:

It is not, unless somewhere along the way, you or someone has change the DB collation from the default as it appears in your case

Is this something my customer could have done via the Zen control panel? I never made any DB changes myself.

I understand the differences between the character sets but have never seen an option at install or other times to select something other than the actual language. If this is something to look for before the upgrade where does one make sure the old matches with the new before an upgrade? Could this check not be part of the upgrade if there are enough people running into the same wall, presenting a fix at the time?

Default is atin1_general_ci

One must do something to alter this

It is not an admin switch

Might be your host configuretion

kobra:

Default is atin1_general_ci

One must do something to alter this

It is not an admin switch

Might be your host configuretion

Host configuration? Can you be more specific so I can find what may have caused this before attempting repair and application to a number of other Zen carts on my server?

Host configuration? Can you be more specific so I can find what may have caused this before attempting repair and application to a number of other Zen carts on my server?
For the server/host in question
Do a test install and check the DB collation

If not latin1_general_ci then they have something set

kobra:

For the server/host in question
Do a test install and check the DB collation

If not latin1_general_ci then they have something set

How is this "They" you keep referring to. Who has what set?

I am the host. My server. Not sure what you want me to check.

This is the test install and the DB check is why I have the error.

You state this

This is the test install and the DB check is why I have the error.
But you did this replacing the default tables with those from the backup
I then backed up from the old DB to retain products

What I am stating is look at the default collation of a fresh inatall

I am the host. My server.
Did you install and configure the LAMP stack yourself'?
If not, you are only the host in name only
Check the my.cnf configuration for the server

kobra:

Did you install and configure the LAMP stack yourself'?

How did this enter the conversation about character set? Did I miss a post?

stuffdone:

How did this enter the conversation about character set? Did I miss a post?
stuffdone:

How is this "They" you keep referring to. Who has what set?

I am the host. My server. Not sure what you want me to check.
kobra:

Might be your host configuration
It is where I stated that it might be the host/server configuration
Where when setup there are thousands of variables that can be set

So if you did not do this, then I guess that is the reason you are perplexed

Did you do a test install and look at the "DEFAULT" DB collation before importing any existing DB backup??