[ic] (no subject)

Brian Kosick interchange-users@interchange.redhat.com
Mon Oct 8 13:41:37 2001


I'm reposting this, without the attachments, as the original post was too 
large.

Hello list,
         I have a IC 4.8.2 (CVS today) perl 5.6.1, RaqXTR RH6.x, and GDBM.
Eberything in the Admin section works properly except for the Orders 
Section under Reports.  The transaction log, should have over three months, 
and around 500 orders worth of data, however, when you click on "Overall by 
Month" (FYI it has no affiliates, so it's listed as "None") I get one month 
up to 50 orders, never more than 50, it doesn't matter if there are more 
than 50 order for that month, it will only show 50.  I have attached three 
files.  (in order of ByAffiliate.html, Monthly.html, Detail.html)

Start off with ByAffiliate.html you'll notice that in only shows August 
2001 (I should see August, Sept, and Oct) and that the orders add up to 50.

Then take a look at Monthly.html you'll see that it starts off with the 
21st of August, which is the day that it went live.  and goes to the end of 
the month.  The "Number of Orders" adds up to 50 however, If you then pick 
a day, (In the example "Details.html is August 28 which should have 6 
orders according to Monthly.html) but it actually has 8 orders (Which I 
confirmed by separate DB look up)

I have exported transactions.gdbm to transactions.txt, deleted the .gdbm 
file, and let it recreate the gdbm file from the txt file, same 
results.  Grepped though the catalog directory to find if There is some 
arbitrary Match limit for Reporting no luck.  I search through the actual 
UI reports/orders files, and can't find anything to indicate that there is 
a limit.  I enabled the Log("query returned " . $Tag->uneval( {ref => 
$Tmp->{main} } ));
line in ByAffiliate, and the search results it, only return the 21-31 of August

I tried changing (see the commented section) the query code on the page
[query
         st=db
         table=transactions
         hashref=main
[comment]
         sql="
                 select affiliate, campaign, total_cost, order_date
                         from  transactions
                         WHERE deleted != '1'
         "]
[/comment]
         sql="
                 select affiliate, campaign, total_cost, order_date
                         from  transactions
                         WHERE deleted != '1' [scratch date_limit] [scratch 
synd_limit]
                         order by affiliate, campaign, order_date
         "][/query]

Which will result in all three months showing up, but the order total will 
still only add up to 50.

Reporting by the other options also, the number of orders, will *always* 
add up to 50 orders, unless you limit your search to a date range that you 
know has less than 50 orders.


PS
         I have the exact same (CVS This morning) RPM version running on a 
different box (RH7.1, PGSQL 7.1.2, perl 5.6.1) The reporting sections run 
perfectly on that one.

This problem has been occurring since the early versions of 4.8.x


Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@nacs.net