Error during Database setup on windows virtual machine

What's in your my.cnf for your mysql configuration settings?

I did a search on my HDD but cannot find the my.cnf file
Where should this file be?

I don't know where it is on your unique computer setup. Perhaps the program files/mysql folder.

Quote:

---

Originally Posted by eastboy

Fatal error: 1101:BLOB/TEXT column 'page_parameters' can't have a default value

---

Strictly speaking the statement is true.
However, in practice, this SQL has been there like that for several years without throwing any error.

You can change the SQL for your specific needs by editing:
/zc_install/sql/mysql_zencart.sql
line 121 says:

Code:

---

  page_parameters text default '',

---

change it to:

Code:

---

  page_parameters text NOT NULL default '',

---

I just tried to install v1.5 also and had the same error.

[05-Jan-2012 21:32:36] PHP Fatal error: 1101:BLOB/TEXT column 'page_parameters' can't have a default value :: 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 NOT NULL 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\store\includes\classes\db\mysql\query_factory.php on line 101

I was able to install the v 1.39 with no problem on a Windows 7 machine running IIS. The first try at the zencart I saw the download new version notice and scraped everything and did a fresh install of v1.5 and got the same error.

Applied the NO NULL to the sql file as suggested and got the same error still.

thanks for suggestion DrByte but unfortunately still get error
i made the changes as you said but got this error

Installation In Progress...

~
1101 BLOB/TEXT column 'page_parameters' can't have a default value
in:
[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 NOT NULL 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;]

Fatal error: 1101:BLOB/TEXT column 'page_parameters' can't have a default value :: 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 NOT NULL 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:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\demo\includes\classes\db\mysql\query_factory.php on line 101

Totally bizarre as to why it's never been an issue before, but change this:
/zc_install/sql/mysql_zencart.sql
line 121 says:

Code:

---

  page_parameters text default '',

---

change it to:

Code:

---

  page_parameters text NOT NULL,

---

page_parameters text NOT NULL

doesn't work either. It errors on line 125 for 'gzpost'. I also changed that line to gzpost mediumblob NOT NULL

And the installation went through successfully.

BTW, your documentation on how to change the admin folder needs to be updated also. The line no longer shows the simple directory/folder name, instead it's a parse statement:

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', $p1) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

Please advise how to achieve this part of the installation.

Hello Drbyte

Just to confirm with dancingchimes above, changing the page_parameters text NOT NULL did not fix it.
I then made the same change as dancingchimes namely gzpost mediumblob NOT NULL

The installation then proceeded successfully.

and to follow further in dancingchimes footsteps. I am not sure how to edit the configure.php file after renaming my admin folder

Thanks
Eastboy

Ok. One more thing. After the installation, I can go into the store ok but not the admin part. It complained that gzpost doesn't have a default value. I went into the database, in the 'admin-activity-log' table. Found gzpost and changed its value to 'null'. Not the default null but checking the null (from phpMyAdmin). Not familiar enough with mysql to tell what the difference is. But it worked for me. I can get into the admin section now.