Buffered SQL Setup Not Reading Detail File

[Alan Buxey]

Hi,
> I tried adding the noop block to the detail reader and doesn't seem to
> make a difference. I'm still seeing this suspicious debug:

Alan Dekok already told you this

"  Read raddb/sites-available/default.  Look for "zero".     "


the trouble is, if you HAVE a zero thats sneaked in, then theres be troubles...
so you need a wrapper around your sql-buffer reader...eg

                sql { 
			invalid = 2
			fail = 2
		}
		if (fail || noop || invalid) {
                	ok
        	}

in the buffered-sql  (that syntax might work, take care!)

or, even better, make sure the situation where the detail file
gets such a thing doesnt happen in the first place eg, in your
virtual server accounting section...

	if (Acct-Session-Time != 0) {
                detail
        }
        else {
                ok
        }

alan