Forum OpenACS Q&A: Ecommerce randomly failing

Hi all,

Well, I'm having a frustrating issue with ecommerce. I had it all set up and working hunky dory. On Sunday, the admin/ecommerce/ page was fine. All of a sudden on Monday it starts showing this error:

[21/Aug/2001:07:33:26][152.721924][-conn101-] Error: Ns_PgExec: 
result status: 7 message: ERROR:  Unable to convert null timestamp to 
date

[21/Aug/2001:07:33:26][152.721924][-conn101-] Error: nsd.tcl:
Database operation "1row" failed (exception NSDB, "Query was not a 
statement returning rows.")
Database operation "1row" failed (exception NSDB, "Query was not a 
statement returning rows.")
    while executing
"ns_db 1row $db "
select 
  sum(one_if_within_n_days(confirmed_date,1)) as n_in_last_24_hours,
  sum(one_if_within_n_days(confirmed_date,7)) as n_in_la ..."
    invoked from within
"set selection [ns_db 1row $db "
select 
  sum(one_if_within_n_days(confirmed_date,1)) as n_in_last_24_hours,
  sum(one_if_within_n_days(confirmed_date ..."
    (file "/web/vwparadise/www/admin/ecommerce/index.tcl" line 30)
    invoked from within
"source $ad_conn(file)"
    invoked from within
"if { $extension == ".tcl" } {
        # Tcl file - use source.
        source $ad_conn(file)
    } elseif { $extension == ".adp" } {
        # ADP file - parse and return  ..."
    (procedure "ad_handle_abstract_url" line 65)
    invoked from within
"ad_handle_abstract_url cns1481 {}"

Now, this has happened to EVERY ecommerce installation I've done. From the browser, all you can see is the "Potential Problems" link, then it's "Server Error" under that. Any ideas why it keeps mutating to this? Have you guys seen this before? I'm running 3.2.4, does 3.2.5 fix this?

Thanks,

Scott