Error during Database setup on windows virtual machine

Hello

I have zencart 1.3.9h
Mysql 5.5
php 5.2.17

I have a copy of my site running on a virtual machine, so I can practice upgrading without any risk.

I am following theinstructions on how to upgrade.

1. i copied the 1.5 zencart file to mysite.com/demo
2. I then ran the install in zc_install
3. When I get to the section for databse settings I fill all that in then click save database settings
4. The install screen comes up (usually showing all the tildas). however my install only shows 1 tilda and then says "An error occured, please refresh the page and try again."

Are there some log files I could look at, to point me in the right direction?
Any help appreciated.

Thanks
Eastboy

Just wanted to add

i tried running zc_install on a windows 7 pc and got the same error.
I was running the same versions as the above post

Oh Im getting worried still no reply to my problem. If you have installed zen cart 1.5 successfully with the above version of Apache mysql and php, please let me knoe

The most common cause of problems such as that is incomplete files, often damaged by incomplete FTP uploads or bad copies, etc.

Your problem is less likely to be your version of Apache/MySQL/PHP, but rather an incomplete set of files uploaded to the server.

Okay I will try and re download and report back
Thank you

DrByte:

The most common cause of problems such as that is incomplete files, often damaged by incomplete FTP uploads or bad copies, etc.

Your problem is less likely to be your version of Apache/MySQL/PHP, but rather an incomplete set of files uploaded to the server.
okay i downloaded a new copy , but still get the same error

The file name is :
zen-cart-v150-full-release-12302011.zip

size : 5.08MB ( 5 336 524 bytes)
size on disk : 5.08MB (5 337 088 bytes)

When I extract the zip file the size of the entire folder is 11.1MB (11 640 700 bytes)
size on disk : 14.9MB (15 642 624 bytes)

This ones really got me stumped.

size vs size-on-disk is very often different due to operating system issues. Don't be alarmed that those numbers don't match each other.

As far as "an error occurred", I can't seem to find any way to replicate that.

What's unique about your VM that's different from the majority of LAMP-empowered servers? Which LAMP stack are you using?

I am running my server on a windows XP machine.
But i did try and install zen cart on another windows 7 pc aswell, which gave the same error
I installed apache mysql and php seperatly when i first installed zen cart 1.3.9h and everything installed correctly

Here is a screenshot of my error

Thanks for your help

Try enabling STRICT_ERROR_REPORTING by editing /zc_install/includes/installer_params.php and changing FALSE to TRUE:```
define('STRICT_ERROR_REPORTING', [B]TRUE[/B]);

I followed your instructions and got the following errors

1. First I got this new error below

CURL problems detected: 28 => connect() timed out! more info...
CURL requires SSL support. Please notify webmaster or hosting company. 28 => SSL connection timeout more info...

I checked my php info and do have curl enabled as follows

curl
cURL support enabled
cURL Information libcurl/7.21.0 OpenSSL/0.9.7c zlib/1.2.3

2. I then proceeded with installation and received the following 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 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 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

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.

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:page_parameters text default '',change it to:```
page_parameters text [B]NOT NULL[/B] 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:page_parameters text [B]default ''[/B],change it to:```
page_parameters text [B]NOT NULL[/B],

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.