[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

question about db structure re: fixing potential corruption

hi folks,

i've run into the first signs of potential DB corruption.  so far, it's showing
up as a discrepancy between what trial balance shows on the first page of
by-account totals when selected w/o any dates, vs. what it shows when you drill
down into the account.

select sum(amount) from acc_trans where chart_id = X agrees with the former

my initial thought is that this is caused by entries in acc_trans that don't
have an entry in transactions table, and so perhaps aren't displayed in the
drilldown display.  but this seems not to be correct.

can anyone with more experience suggest what the difference is between what
tables are being accessing in the two levels of trials balance that would
indicate what might be missing from what table?