Symptom: Difficulty installing on Windows hosts - zc_install won't complete the database installation. Error message triggered instead.
Solution: Edit 3 files:
/zc_install/sql/mysql_zencart.sql
Replace the following lines:```
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 '',
[B] page_parameters text default '',[/B]
ip_address varchar(20) NOT NULL default '',
flagged tinyint NOT NULL default '0',
attention varchar(255) NOT NULL default '',
[B] gzpost mediumblob NOT NULL default '',[/B]
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;
with this instead:```
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 '',
[B] page_parameters text,[/B]
ip_address varchar(20) NOT NULL default '',
flagged tinyint NOT NULL default '0',
attention varchar(255) NOT NULL default '',
[B] gzpost mediumblob,[/B]
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;
/zc_install/sql/mysql_upgrade_zencart_139_to_150.sql
Replace this line:```
ALTER TABLE admin_activity_log ADD COLUMN gzpost [B]mediumblob[/B] [B]NOT NULL default ''[/B];
with:```
ALTER TABLE admin_activity_log ADD COLUMN gzpost [B]mediumblob[/B] ;
/YOUR_RENAMED_admin/includes/init_includes/init_admin_history.php
add the line shown:```
$sql_data_array = array( 'access_date' => 'now()',
'admin_id' => (isset($_SESSION['admin_id'])) ? (int)$_SESSION['admin_id'] : 0,
'page_accessed' => 'Log found to be empty. Logging started.',
'page_parameters' => '',
[B] 'gzpost' => '',[/B]
'ip_address' => substr($_SERVER['REMOTE_ADDR'],0,15)
);
.
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.
