"An Error Occurred" on IIS Server, have log

[dgusahospitality]

At my part time job, they have a vast MySQL database that automatically syncs with Quickbooks, and has 1300+ products on it. So they tasked me with finding a shopping cart that can eventually import or use that database. Magento is rather rigidly stuck using it's own database, so I am trying Zen Cart, but I am having trouble with the installation.

I am installing on an IIS server, following this guide:
http://learn.iis.net/page.aspx/308/i...n-cart-on-iis/

First, when performing my first install, the checklist gave me a green checkmark on every item (except for the warning about it not being Apache.) When I do the initial database settings, the Database Setup tells me An Error Occurred, please refresh the page and try again.

Going into zencart\cache, and pulling up the debug log says this:

[05-Jun-2012 17:25:19 UTC] PHP Fatal error: 1101:BLOB/TEXT column 'page_parameters' can't have a default value :: CREATE TABLE usazenadmin_activity_log ( log_id bigint(15) NOT NULL auto_increment, access_date datetime NOT NULL default '0001-01-01 00:00:00', admin_id int(11) NOT NULL default '0', page_accessed varchar(80) NOT NULL default '', page_parameters text default '', ip_address varchar(20) NOT NULL default '', flagged tinyint NOT NULL default '0', attention varchar(255) NOT NULL default '', gzpost mediumblob NOT NULL default '', PRIMARY KEY (log_id), KEY idx_page_accessed_zen (page_accessed), KEY idx_access_date_zen (access_date), KEY idx_flagged_zen (flagged), KEY idx_ip_zen (ip_address) ) ENGINE=MyISAM COLLATE utf8_general_ci; in C:\inetpub\wwwroot\PyroCMS-Professional-v2.1.1\zencart\includes\classes\db\mysql\query_factory.php on line 101

And pulling up the zcInstallLog in the same cache folder logs this:

---------------
Jun 05 2012 13:24 -- inspect
System Inspection Results:
------------------------------
NA: Webserver => Microsoft-IIS/7.5
NA: HTTP Host => [I SHOULD NOT REVEAL THIS]
NA: Path_Translated => C:\inetpub\wwwroot\PyroCMS-Professional-v2.1.1\zencart\zc_install\index.php
NA: Real Path => C:\inetpub\wwwroot\PyroCMS-Professional-v2.1.1\zencart
NA: PHP O/S => WINNT
NA: PHP API Mode => cgi-fcgi
NA: PHP Max Execution Time per page => 300
OK: Register Globals => OFF
OK: MySQL Support => ON
OK: PHP Version => 5.3.10
OK: PHP Safe Mode => OFF
OK: PHP Sessions Support => ON
OK: PHP Session.AutoStart => OFF
OK: PHP session.use_trans_sid => OFF
OK: Suggested SQL Cache Folder => C:/inetpub/wwwroot/PyroCMS-Professional-v2.1.1/zencart/cache
OK: PHP magic_quotes_runtime setting => OFF
OK: PHP magic_quotes_sybase setting => OFF
OK: PHP GD Support => ON
OK: GD Version => GD bundled (2.0.34 compatible)
OK: PHP ZLIB Compression Support => ON
OK: PHP OpenSSL Support => ON
OK: PHP cURL Support => ON
OK: CURL NON-SSL Capability => Okay
OK: CURL SSL Capability => Okay
OK: PHP Upload Support => ON upload_max_filesize=3M; post_max_size=8M
OK: PHP Upload TMP dir => C:\Windows\temp
WARN: Apache .htaccess Support => OFF
NA: PHP include_path => .;C:\php\pear
NA: PHP SMTP destination => localhost
NA: PHP sendmail path =>
NA: PHP sendmail 'from' =>
OK: PHP open_basedir restrictions =>
OK: PHP Output Buffering (gzip) => ON
OK: PHP XML Support => ON
OK: PHP Session.Save_Path => C:\inetpub\wwwroot\PyroCMS-Professional-v2.1.1\zencart\cache-->Writeable
OK: includes/configure.php => Writeable
OK: admin/includes/configure.php => Writeable
OK: cache => OK 777 read/write/execute
OK: images => OK 777 read/write/execute (INCLUDE SUBDIRECTORIES TOO)
OK: includes/languages/english/html_includes => OK 777 read/write (INCLUDE SUBDIRECTORIES TOO)
OK: media => OK 777 read/write/execute
OK: pub => OK 777 read/write/execute
OK: admin/backups => OK 777 read/write
OK: admin/images/graphs => OK 777 read/write/execute
PHP Extensions compiled: Core, bcmath, calendar, com_dotnet, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, bz2, SimpleXML, wddx, xml, xmlreader, xmlwriter, cgi-fcgi, mysql, mysqli, mbstring, gd, gettext, curl, exif, xmlrpc, openssl, soap, pdo_mysql, pdo_sqlite, imap, tidy, Phar, wincache, mhash
------------------------------


---------------
Jun 05 2012 13:25 -- database_setup1
Installer - Page: database_setup -- collected information: Array
(
[language] => english
[DIR_FS_SQL_CACHE] => C:/inetpub/wwwroot/PyroCMS-Professional-v2.1.1/zencart/cache
[DB_TYPE] => mysql
[DB_PREFIX] => usazen
[DB_CHARSET] => utf8
[DB_SERVER] => localhost
[DB_SERVER_USERNAME] => root
[DB_SERVER_PASSWORD] => ***private***
[DB_DATABASE] => zencart
[SQL_CACHE_METHOD] => file
)

What should I do to get the database properly setting up? I can see within phpmyadmin that the database was created. It's called zencart and it has four tables in it. address_book, address_format, admin, and upgrade_exceptions.

[dgusahospitality]

I should add that I read some direction here,
http://www.zen-cart.com/showthread.p...se-setup/page2

and they did not work. By changing it from default to NOT NULL, the log changes to an SQL error, so I decided to do a new installation from scratch rather than jump around for solutions that might not apply.

[DrByte]

Sounds like you're running into a known problem with the Windows implementation of MySQL vs the Linux implementation.
See here for some changes you'll need to consider making if you want to use Windows hosting.
http://www.zen-cart.com/showthread.p...tup-on-windows

Not sure why you're using Windows/IIS in the first place. But if you're stuck with it then you'll need to make a few adjustments.

[schoolboy]

If your install brought in just 4 tables, consider that there are actually 93 tables - so you are missing 89 of them.

What you are trying to do is massively complicated and (while possible) will require some expert knowledge on database bridging.

[CMCM]

I encountered same problems. I was doing a test install to see what ZenCart is all about. I found that phpMyAdmin was creating the zencart empty database with InnoDB set as the search engine whereas ZenCart uses MyISAM. The only place I could find to change this was to use MySQL's Workbench and log in to server administration. There is a tab for configuration and there is a setting, 'default-storage-engine'. Check the box for this setting and change it from InnoDB to MyISAM. Recreate the empty database for the ZenCart install and then run zc_install. It will work flawlessly.