error processing pending hits: Database error : Field 'md5' doesn't have a default value

[carlos.santos@…]

Unexpected output: FireStats error processing pending hits: Database error: Field 'md5' doesn't have a default value

[anonymous]

Please answer the following questions:

• Which version of FireStats?
• Is that a clean installation or an upgrade?
• Which versions of MySQL and PHP (You can see it in the tools tab inside FireStats)

[omry]

Hi Carlos, added the information from your email to the ticket. please use the ticketing system to add further info.

No problem in installation and configuration. Problem in refresh.

• 1.6.0-RC1
• Clean instalation
• MySQL: 5.0.45-community-nt
• PHP: 5.2.6

[omry]

what do you mean 'problem in refresh'?

refresh of what?

can you email me a backup of you FireStats tables?

[carlos.santos@…]

Hi there

If a try to save anything or press the refresh botton to update statistcs

Carlos Santos

[omry]

well, I will need a to see your FireStats tables.

please email me a copy. you only need to backup tables named firestats_*.

[omry]

since I never got the the tables I assume you are not interested in solving this.

[fgagne@…]

Hi, having the same bug on 1.6RC2, installed on an IIS6 server with PHP 5.2.6 and MySQL 5.0.51b-community-nt. Will upload tables ASAP

[omry]

fgagne, please email me your FireStats tables for inspections.

also, did you install a fresh FireStats installation or did you upgrade from a previous version (which one?)

[omry]

fixed, will be released with the next 1.6 release.

as a temporary workaround, you can replace php/commit-pending-impl.php with this one