mysql errors

well up to my 4th upgrade so far and now fit a wall!

getting the following error after the database upgrade.

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

copied original database
uploaded new folder with 139d
copied and changfe config files from original zencart install into new 139 folder
run zc_install
fail!

http://www.zen-cart.com/forum/showpost.php?p=897548&postcount=6

tried that now i get

1273 Unknown collation: 'uft8_general_ci'
in:
[CREATE TABLE 1uic_counter_history_clean as SELECT * FROM 1uic_counter_history WHERE 1 GROUP BY startdate COLLATE uft8_general_ci;]

What is the default character set and collation on your database?

DrByte:

What is the default character set and collation on your database?

not sure... how can i check?

phpMyAdmin will probably tell you

would it be uft8_generial_ci

If it is, then you won't be getting the errors you quoted.

right i just started from scratch again, download a new zersion copy of the upgrade, uploaded to the server, changed copied the config files from old site over, rand the upgrade and second i do the upgrade i get the error again.

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

phpmyadmin says the following

• Server: Localhost via UNIX socket
• Server version: 5.0.91-community
• Protocol version: 10
• User: me
• MySQL charset: UTF-8 Unicode (utf8)

tired again from scratch.... this time changed the uft8 again in the install paramas and this time no sql error but i get the following message on the upgrade screen.

• NOTE: Skipped upgrade statements: 1
  See details at bottom of page for your inspection.
  (Details also logged in the "upgrade_exceptions" table.)
  Note: In most cases, these failed statements can be ignored,
  as they are indications that certain settings may have already been set on your site.
  If all the suggested upgrade steps have been completed (no recommendations left),
  you may proceed to Skip Upgrades and continue configuring your site. more info...
• Your db prefix of "4gig_" is a potential problem. Database Table-Prefix may only contain letters and numbers and underscores (_).
  and errors at the bottom

SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists
SKIPPED: Cannot insert configuration_key "SHOW_SPLIT_TAX_CHECKOUT" because it already exists

in admin all says 1.3.9d now so i guess this worked?