If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Windows Server / "An Error Occurred" on IIS Server, have log

"An Error Occurred" on IIS Server, have log

Started by dgusahospitality on 5 Jun 2012, 5:35 PM · Views: 3,442

Results 1 to 5 of 5
5 Jun 2012, 5:35 PM
#1
dgusahospitality avatar

dgusahospitality

New Zenner

Join Date:
Jun 2012
Posts:
2
Plugin Contributions:
0

"An Error Occurred" on IIS Server, have log

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/install-zen-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.

5 Jun 2012, 7:10 PM
#2
dgusahospitality avatar

dgusahospitality

New Zenner

Join Date:
Jun 2012
Posts:
2
Plugin Contributions:
0

Re: "An Error Occurred" on IIS Server, have log

I should add that I read some direction here,
http://www.zen-cart.com/showthread.php?190604-Error-during-Database-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.

6 Jun 2012, 4:11 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: "An Error Occurred" on IIS Server, have log

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.php?190604-Error-during-Database-setup-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.

.
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 Jun 2012, 9:36 AM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: "An Error Occurred" on IIS Server, have log

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.

20 years a Zencart User

25 Jun 2012, 3:47 AM
#5
cmcm avatar

cmcm

New Zenner

Join Date:
Jun 2012
Posts:
4
Plugin Contributions:
0

Re: "An Error Occurred" on IIS Server, have log

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.