Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

consistency.pl

Quote Reply
consistency.pl
Hi.

users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0

I have entries in dgraph table for which there are no entries in any table (including the user table).

In light of above, what does the above report of consistency.pl run indicate?
And How Exactly do i have a reconciled dgraph<-->user table data?

Thanks
Quote Reply
Re: [anup123] consistency.pl In reply to
What does the following mean

users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0

when i know i have more rows in dgraph table as compared to users table. Why is 0 0 being reported? Is it a bug?

Thanks
Anup
Quote Reply
Re: [anup123] consistency.pl In reply to
Here's a fix:
Code:
--- consistency.pl 5 Mar 2004 18:14:55 -0000 1.14
+++ consistency.pl 5 Aug 2004 20:17:34 -0000
@@ -189,7 +189,7 @@
}

# dgraph => users
- $rel = $DB->table('users', 'dgraph');
+ $rel = $DB->table('dgraph', 'users');
$sth = $rel->select('left_join', 'distinct(dgraph_userid)', { userid => undef });
print "dgraph => users table inconsistencies: ", $sth->rows + 0, "\n";
if ($fix) {

Adrian
Quote Reply
Re: [brewt] consistency.pl In reply to
Thanks.
The inconsistency is fixed now.

Anup