system config
sbs 2011
iis7
php ver5.6.0
MySQL 5.6 64 bit
zencart v1.5.4 Fresh install
after completing zc_install successfully I could not get the admin screens at all server 500 error even though the empty store opens fine. after doing some troubleshooting I found the following error in the log
[12-Feb-2015 11:28:48 America/New_York] PHP Fatal error: 1101:BLOB/TEXT column 'logmessage' can't have a default value :: ALTER TABLE hi_admin_activity_log ADD COLUMN logmessage mediumtext NOT NULL default '' ==> (as called by) C:\inetpub\igethigh\admin\includes\classes\class.admin.zcObserverLogWriterDataba se.php on line 90 <== in C:\inetpub\igethigh\includes\classes\db\mysql\query_factory.php on line 155
I then manually added to the table hi_admin_activity_log ADD COLUMN logmessage mediumtext NOT NULL
and restarted iis now everything is fine.
Just thought o would want to know the installer did not create that db properly
Bookmarks