Then try this:
http://www.zen-cart.com/forum/showpost.php?p=378357#post378357
Type: Posts; User: DrByte
Then try this:
http://www.zen-cart.com/forum/showpost.php?p=378357#post378357
Did your hosting company recently upgrade you to PHP 5 ?
If so, then this will likely help: http://www.zen-cart.com/forum/showthread.php?t=67521
Admin->Tools->Server Info
Uwantit,
Are you running Zen Cart v1.2.x, but trying to use a v1.3.x module?
Sounds like you're using a Zen Cart install prior to v1.3 but are attempting to use a module designed for v1.3.x
You could edit the database_update.sql file with a text editor, and remove this part:
collate latin1_general_ci ... and then retry running it.
Some more restrictive database setups don't like...