Database Connection Failure During Install

**Quawk** · 19 Jan 2012, 09:44 PM

Sorry about multiple threads. Your last instructions fixed the problem. Thanks for your help or I'd have never figured it out.

**john-zyx** · 8 Feb 2012, 07:48 PM

John http://www.zen-cart.com/forum/images/smilies/sad.gif

I tried using PHPMyAdmin to use NULL as the default on gzpost but I got this;
Error

SQL query:

ALTER TABLE `tcf_admin_activity_log` CHANGE `gzpost` `gzpost` MEDIUMBLOB NOT NULL DEFAULT '''''' <== ''

MySQL said: Documentation
#1101 - BLOB/TEXT column 'gzpost' can't have a default value

MySQL said: Documentation
#1067 - Invalid default value for 'gzpost'

Also looking at the MySQL documentation it clearly indicates
MEDIUMBLOB can not have defaults?!?!?!

BLOB and TEXT columns cannot have DEFAULT values.

http://dev.mysql.com/doc/refman/5.0/en/blob.html
-------
After installing Zen Cart - zen-cart-v150-full-release-12302011

I had to edit mysql_zencart.sql
and remove some "default ''" statements from the Table creation command
Line 121 'page_parameters' and 125 'gzpost'
Otherwise MySQL would not accept the table.

After I got that done, the Zen Cart Tables installed fine.

I attempted to enter the 'admin' and got the following;

[08-Feb-2012 12:42:57 UTC] PHP Fatal error: 1364:Field 'gzpost' doesn't have a default value :: insert into tcf_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'Log found to be empty. Logging started.', '', '96.240.27.171') in C:\WEB\TCF\zc\includes\classes\db\mysql\query_factory.php on line 101

Seems Zen Cart has not kept up with MySQL canges.
What version of MySQL should I use to avoid this problem?

Help!?!?!

This is what I have now;

ZenCart, Version 150, release-12/30/2011

MySQL
Server: localhost via TCP/IP
Server version: 5.5.20
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server
Microsoft-IIS/6.0
MySQL client version: mysqlnd 5.0.8-dev - 20102224 -

$Revision: 321634 $

phpMyAdmin
Version information: 3.4.9

**primehalo** · 8 Jun 2012, 02:27 AM

When installing zen-cart-v150-full-release-12302011 on my Windows machine, I also had the PHP Fatal error: 1101:BLOB/TEXT column 'page_parameters' can't have a default value :: CREATE TABLE ... error. I attempted to fix it through advice in other posts, but the fix wasn't quite correct as I also encountered this error upon trying to enter the admin area:

Code:

1364 Field 'gzpost' doesn't have a default value in: [insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'Log found to be empty. Logging started.', '', '127.0.0.1')]

To fix that I used phpMyAdmin to access the zen_admin_activity_log table and change the gzpost column to allow NULL.

Thus I just wanted to mention here the proper inital fix to the installation error should probably be:

Open: /zc_install/sql/mysql_zencart.sql

Find: (line 121)

Code:

page_parameters text default '',

Replace with:

Code:

page_parameters text

Find: (line 125)

Code:

gzpost mediumblob NOT NULL default '',

Replace with:

Code:

 gzpost mediumblob,

**primehalo** · 8 Jun 2012, 02:35 AM

By the way, wasn't this supposed to have been fixed:
http://www.zen-cart.com/showthread.p...97#post1085297

**DrByte** · 8 Jun 2012, 03:52 AM

Unfortunately it has not been fully fixed universally in any official release as yet.

The Windows implementation of MySQL enforces rules differently than the way the Linux implementation does.

It will be fixed in a release after v1.5.0.

In the meantime it works without error on Linux hosts ... which are more popular and conventional anyway.

**thietke-web** · 15 Jun 2012, 04:22 AM

Originally Posted by Quawk

I've just installed ZC 1.5 on a clean Windows Server. While I had some install issues, these were solved by information contained in another thread in this forum. As instructed by the install process I renamed my admin folder using the procedure for this version (did not modify any config files). When the install was done I accessed the store just fine. But when I tried to access the admin area I received the following error message from Firefox: "WARNING: An Error occurred, please refresh the page and try again." Internet Explorer gives me a different message which boils down to "HTTP 500 Internal Server Error." I was trying to access the admin area using a URL something like this: "http://www.mysite.com/new_admin_name".
Needless to say, without access to the admin area there thiet ke web is not much I can do with the site. Any help would be appreciated.
Ed

Okay, Dr. Byte,
In your last post you suggested I use phpMyAdmin to add the gz_post field that I removed during the install, and that by doing this I should be able to access the admin section of my site.
I've found phpMyAdmin, downloaded it, and figured out how to install it. Now it is up an running but I have no clue as to how to add the gz_post field.
I've checked the documentation, online wiki, etc. but nothing provided me with information on how to add the gz_post field. Any suggestions? I really do want to use version 1.5 of Zen Cart. This should be the last obstacle standing in my way.

**dbltoe** · 15 Jun 2012, 05:38 PM

Quoting drbyte's instructions

To make a change in phpMyAdmin, log in to phpMyAdmin, open the admin activity log table, find the field you're concerned about, and set a default value of blank.

You should not be adding AA field, but making it's setting null.

**Bad Kitty Studios** · 5 Jul 2012, 12:34 AM

I would just like to make a note that I installed Zen Cart 1.5 on Linux, not Windows, and it could not connect to the database right after install. The error messages were: "Sorry! There seems to be a problem connecting to our database." and on the admin side it said: "WARNING: An Error occurred, please refresh the page and try again."

I had to go to admin/includes/configure.php and includes/configure.php to update the database information. The information it had in both files was incorrect. If you get the two above message right after you install a fresh version of Zen Cart 1.5 take a look at the configure files and make sure your information is correct.

After saving and re-uploading those files the store works fine!

**dbltoe** · 5 Jul 2012, 05:42 PM

Originally Posted by Bad Kitty Studios

I would just like to make a note that I installed Zen Cart 1.5 on Linux, not Windows, and it could not connect to the database right after install. The error messages were: "Sorry! There seems to be a problem connecting to our database." and on the admin side it said: "WARNING: An Error occurred, please refresh the page and try again."

I had to go to admin/includes/configure.php and includes/configure.php to update the database information. The information it had in both files was incorrect. If you get the two above message right after you install a fresh version of Zen Cart 1.5 take a look at the configure files and make sure your information is correct.

After saving and re-uploading those files the store works fine!

There are really only three ways that the config files could have wound up incorrect.

You failed to read the installation instructions for 1.5.0 and incorrectly edited the config files. (Older versions had the installer edit config files for accuracy.)
You entered the wrong database connection information at installation. (should have created problems at installation, not later)
You copied old config files from another installation. (Generally happens with an upgrade)

Don't know which you did, but one of those is probably the culprit.