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
Re: Error during Database setup
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
Re: Error during Database setup
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
Re: Error during Database setup
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.
Re: Error during Database setup
Okay I will try and re download and report back
Thank you
Re: Error during Database setup
Quote:
Originally Posted by
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.
Re: Error during Database setup
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?
Re: Error during Database setup
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
http://www.elway.co.za/error.jpg
Thanks for your help
Re: Error during Database setup
Try enabling STRICT_ERROR_REPORTING by editing /zc_install/includes/installer_params.php and changing FALSE to TRUE:
Code:
define('STRICT_ERROR_REPORTING', TRUE);
Re: Error during Database setup
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