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!
Thread: mysql errors
Results 1 to 10 of 12
-
1 Jul 2010, 11:34 AM #1
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
mysql errors
-
1 Jul 2010, 01:57 PM #2
Totally Zenned
- Join Date
- Apr 2006
- Location
- London, UK
- Posts
- 10,569
- Plugin Contributions
- 25
Re: mysql errors
Kuroi Web Design and Development | Twitter
(Questions answered in the forum only - so that any forum member can benefit - not by personal message)
-
1 Jul 2010, 03:23 PM #3
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
Re: mysql errors
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;]
-
1 Jul 2010, 09:43 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: mysql errors
What is the default character set and collation on your database?
.
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.
-
2 Jul 2010, 09:10 AM #5
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
Re: mysql errors
not sure... how can i check?
Originally Posted by DrByte
-
2 Jul 2010, 02:35 PM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: mysql errors
phpMyAdmin will probably tell you
.
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.
-
5 Jul 2010, 10:46 AM #7
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
Re: mysql errors
would it be uft8_generial_ci
-
5 Jul 2010, 11:28 PM #8
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: mysql errors
If it is, then you won't be getting the errors you quoted.
.
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.
-
6 Jul 2010, 10:36 AM #9
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
Re: mysql errors
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;]
-
6 Jul 2010, 10:40 AM #10
Totally Zenned
- Join Date
- Feb 2007
- Posts
- 1,704
- Plugin Contributions
- 0
Re: mysql errors
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)
Similar Threads
-
random mysql not connected errors
By marybeshaw in forum General QuestionsReplies: 1Last Post: 2 Mar 2011, 08:02 AM -
MySQL bottlneck - getting mysql errors
By ksoup in forum General QuestionsReplies: 25Last Post: 3 May 2008, 06:35 PM -
running 1.3.0 MySQL Database errors
By Noella in forum Installing on a Linux/Unix ServerReplies: 5Last Post: 15 Sep 2006, 06:34 AM
