admin_activity_log Error when reseting admin log on IIS Server

[chadderuski]

More fun with IIS. This should be an easy fix, but I want to make sure I have the correct default value for 'gzpost':

[24-Aug-2012 15:10:32 UTC] PHP Fatal error: 1364:Field 'gzpost' doesn't have a default value :: insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '2', 'Log reset by {xxxx[2]}.', '', 'xx.xx.216.90') in \web\domain.com\includes\classes\db\mysql\query_factory.php on line 101

This doesn't happen on apache.

So, what should gzpost default to?

Thanks!

-chadd

[DrByte]

As shown here: https://github.com/zencart/zencart/c...a0798af4ab9917, simply add the one-line for

 gzpost => ''

Don't do the other changes shown there, since they're specific to the new version.

[chadderuski]

Thanks Doc! That did the trick!

[su35]

Hi DrByte. I have the same problem on Apache. Unfortunately, I couldn't open the link that you listed above (404). Could you give me more direction?
Thanks

[DrByte]

link updated

[su35]

I got it. Thanks

[su35]

updated to 1.5.1. The problem is still there.

When I clicked the reset button, an error message appeared.

[13-Nov-2012 04:03:01 UTC] PHP Fatal error:  1364:Field 'gzpost' doesn't have a default value :: insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'Log reset by {su35[1]}.', '', '127.0.0.1') in H:\zencart15\includes\classes\db\mysql\query_factory.php on line 120

I had check the init_admin_history.php, it's the 1.5.1 version.

[su35]

I have checked the database by phpmyadmin. The logs was reset exactly.

[DrByte]

Do the same fix at line 264 of /admin/admin_activity.php

[su35]

Thanks DrByte.