Database Patch

[buzzfever]

I'm seeing a lot of people with the same error and haven't seen any solutions. My site says

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

at the top currently. I have ran zc_install Database Upgrade only twice now and each time I get this:

"253 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;]"

Server Information says:

Zen Cart 1.3.9b
Database Patch Level: 1.3.8

How can I get this off my site or upgrade properly?

Thanks.

[completespray]

I had the same problem. Here are two links discussing this issue.

http://www.zen-cart.com/forum/showth...=157128&page=2

http://www.zen-cart.com/forum/showth...ounter+history

The code discussed on the 2nd link worked for me. Although I would have sworn it was unrelated.

I hope that helps!

[2kredz3]

I did the upgrade through fantastico and got this problem. I cant seem to get it fixed either. I ran the ZC_install and it still doesnt work right.

Also somehow it put a bunch of default adds and headers i need help

[frank18]

I did the upgrade through fantastico and got this problem. I cant seem to get it fixed either. I ran the ZC_install and it still doesnt work right.

Also somehow it put a bunch of default adds and headers i need help

NEVER upgrade via Fantastico or other automated piece of server facility.

See: http://www.zen-cart.com/forum/showthread.php?t=155891

[buzzfever]

completespray - Thanks, but that didn't seem to help me. Just to make sure I followed it correctly here's what I tried. Here's my current/changed counter.php:

if (!defined('IS_ADMIN_FLAG')) {

  die('Illegal Access');

}

if (isset($_SESSION['session_counter']) && $_SESSION['session_counter'] == true) {

  $session_counter = 0;

} else {

  $session_counter = 1;

  $_SESSION['session_counter'] = true;

}
$date_now = date('Ymd');
$sql = "insert into " . TABLE_COUNTER_HISTORY . " (startdate, counter, session_counter) values ('" . $date_now . "', '1', '1')
        on duplicate key update counter = counter + 1, session_counter = session_counter + " . (int)$session_counter;
$db->Execute($sql);

$counter_query = "select startdate, counter from " . TABLE_COUNTER;
$counter = $db->Execute($counter_query);
if ($counter->RecordCount() <= 0) {
  $date_now = date('Ymd');
  $sql = "insert into " . TABLE_COUNTER . " (startdate, counter) values ('" . $date_now . "', '1')";
  $db->Execute($sql);
  $counter_startdate = $date_now;
  $counter_now = 1;
} else {
  $counter_startdate = $counter->fields['startdate'];
  $counter_now = ($counter->fields['counter'] + 1);
  $sql = "update " . TABLE_COUNTER . " set counter = '" . $counter_now . "'";
  $db->Execute($sql);
}


$counter_query = "select startdate, counter from " . TABLE_COUNTER;

$counter = $db->Execute($counter_query);

if ($counter->RecordCount() <= 0) {

  $date_now = date('Ymd');

  $sql = "insert into " . TABLE_COUNTER . " (startdate, counter) values ('" . $date_now . "', '1')";

  $db->Execute($sql);

  $counter_startdate = $date_now;

  $counter_now = 1;

} else {

  $counter_startdate = $counter->fields['startdate'];

  $counter_now = ($counter->fields['counter'] + 1);

  $sql = "update " . TABLE_COUNTER . " set counter = '" . $counter_now . "'";

  $db->Execute($sql);

}



$counter_startdate_formatted = strftime(DATE_FORMAT_LONG, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4))); 

and I ran this:

DROP TABLE IF EXISTS counter_history;
CREATE TABLE counter_history (
  startdate char(8) default NULL,
  counter int(12) default NULL,
  session_counter int(12) default NULL,
  PRIMARY KEY  (startdate)
) ENGINE=MyISAM;

in the admin's Install SQL Patches. Then I ran the Upgrade Database in zc_install. Still got this:

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;]

Admin still says Zen Cart 1.3.9b
Database Patch Level: 1.3.8

but when I ran the zc_install it says Database appears to be Zen Cart™ v1.3.9.

Do I need to upgrade Zen Cart?

[DrByte]

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'

Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.

[simply_sterling]

Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.

Thank you DrByte! That worked for me, and I'm sure it would work for anyone else getting that same error. You saved me from doing a fresh install of my site.

[buzzfever]

OH MY GOSH, DrByte you are amazing! Thank you so much for your time and help. I can't believe it was so simple.

[IdeaShop]

Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.

Thank you! A very easy fix.

[karmasherbs]

Evidently you've created the table with UTF8 character set. If that's what you want to continue using, then change the DB_CHARSET in /zc_install/includes/installer_params.php to 'utf8' before using zc_install.

Thanks Heaps!!