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
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.
Please do not PM for support issues: a private solution doesn't benefit the community.
Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.
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.
Bookmarks