Error during Database setup on windows virtual machine

You will need to adjust the SQL for the table structure to suit the requirements of your server. The Windows implementation of MySQL seems to enforce restrictions that don't manifest problems on other operating systems.

You are probably on to other things by now, but just in case. I had same problem and found that MySQL was creating the empty database for ZenCart using InnoDB as the engine instead of MyISAM. Even though the install scripts have MyISAM as the engine it still causes the the install to fail. I had to use MySQL's Workbench to login to the server administration. Select Configuration, Options, and the General tab. Find 'default-storage-engine' and check the check box and set it to MyISAM. The database for ZenCart can then be created (new) using phpMyAdmin and the default engine will be MyISAM. The zc_install should work okay after these changes.

Thanks, but the error discussed in this thread was not related to InnoDB.

Honorable Sensei,
The point was that the database was expecting something other than MyISAM and even though the install script has MyISAM included in the script the install bombs out with all of the errors noted in the other posts. Changing the default database engine and then creating new the db to be used for ZenCart resolves all of the issues.

Hello EastBoy!

Your changes in the sql file worked for me as well. I am using a fresh install of ZenCart 1.50 on a localhost installation using Apache 2.2/PhP 5.4.11/MySQL 5.6.10.0 and phpMyAdmin 3.5.6

Thanks Again!!!!
Dan Osko

I would add that those changes are no longer needed in the latest version of Zen Cart.