MySQL Error Occured
1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci' at line 8
QUERY = CREATE TABLE `CubeCart_SpamBot` ( `uniqueId` varchar(32) NOT NULL, `spamCode` varchar(5) NOT NULL, `userIp` varchar(15) NOT NULL, `time` int(10) NOT NULL default '0', PRIMARY KEY (`uniqueId`), UNIQUE KEY `uniqueId` (`uniqueId`) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

This is a fresh install with new db with no exhisting tables. I get this error when trying to go to step 4.

Any ideas?

Jen

I find that lots of DB servers don't like you telling them which charset or engine to use. If you want to pull those bits from the DB config, you may be good to go.

In /install/db/schema.inc.php, delete the "DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" from the table creation code and give it a shot.

Morning. Bill is right. The database collation should really be UTF-8 for CubeCart so I added some code to build the tables as UTF-8 and I feared compatibility issues for old MySQL versions.

To get it to work please edit:

/install/db/schema.inc.php


Find at line 6:

Replace with:

Maybe I should take this out.

What are the issues with people using non-western charactersets by default?

The Pound and Euro symbol can be corrupt with default Latin Swedish charset.

I always recommend creating the database as UTF-8-Unicode.

p.s. I've updated 3.0.16 to remove that from the database schema now so this shouldn't arise again.

Thank you, the fix worked!

Jen