New Installation problem on Windows host

Zen Cart® v1.5.0
new install

                        Installation In Progress...

                                         ~

WARNING: An Error occurred, please refresh the page and try again.

creates 4 tables in my database and then stops
address_book
address_format
admin
upgrade_exceptions

Haved you tried deleting the files and database and starting over ?

I have deleted the tables and started over. but i haven't deleted the database and created a new one...

ok, I deleted the database and created a new one w/the same results... I'm running Php 5.3 and i haven't installed patches, but that's next i guess...

got it,
slight mod's to the mysql_zencart.sql

DROP TABLE IF EXISTS admin_activity_log;
CREATE TABLE admin_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;

deleted what you see in red and wala
ran it in MySQL Workbench 5.2 CE
found the lines that was stoping it and edited them...

DROP TABLE IF EXISTS admin_activity_log;
CREATE TABLE admin_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,
ip_address varchar(20) NOT NULL default '',
flagged tinyint NOT NULL default '0',
attention varchar(255) NOT NULL default '',
gzpost mediumblob,
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;

Up and running!

Are you really on a Windows server? If so, get your host to switch you to a unix server. It will make your life easier in the long run.

The solution offered by rd-hall worked for me. Thanks!

I have installed 1.5.0(12302011) on Windows /PHP(5.3.10)(/MySQL(5.2.38) after modified two column in mysql_zencart.sql.

But I can not get the Admin page. Still problem on gzpost data type, BLOB, against default value.
I tried to fix it using phpMyADmin and Workbench. but no meaning.

Is there any solution?

I was having the same issue installing on Windows Vista with Apache 2.2 PHP 5.3.8 My SQL 5.5.16 and Zen Cart 1.50 thank you rd-hall as I think I had just completed the third round of going over file and folder permissions when I decided to check the forum.