[ic] (no subject)

[Kyle Cook]

At 10:33 AM 10/8/01, you wrote:
>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


I don't use the UI but the query tag does use ml=XX to limit result sets 
and perhaps it defaults to 50?

Try setting ml to a higher number and see what happens.

Kyle