On Wed, Jun 13, 2001 at 12:14:55PM +0200, pp wrote:
>
> > > I deleted all topic and article without title,
> > > and also I have about 80 topics without owner.
> > > Anything else should be wrong?
> > For these 80 topics you can set 1 as owner, it'll be admin.
> Ok, but If it is important to set another owner, it won't be bad?
Yes. The idea is to have all pointers in all records point to existing
objects.
> > Next, check relations between pages and hosts.
> how?
You can look into repligard schema file (repligard.xml), it contains
definitions of all objects in XML format. Each object is instance of
<type> element and it contains series of <field> or <link> elements.
<link> elements point to object type which should be reffered at this
field in DB. For example:
<type name="style">
<field name="name" type="text"/>
<link name="owner" link="grp" reverse="no"/>
<link name="up" link="style"/>
</type>
It means that table 'style' in database has three fields about which
repligard knows following information:
1. Field 'name' is a text field, it doesn't contain pointer to anything.
2. Field 'owner' is an integer field and its value should be one from
'id' field of 'grp' table. If 'owner' contains some number which doesn't
exist in some record in 'grp' table in 'id' field then this record
(from 'style' table) is broken.
3. Field 'up' is an integer field and its value should be one from 'id'
field of 'style' table. If 'up' contains a number that doesn't exist in
some record in 'style' table in 'id' field, then this record is broken.
Repligard checks integrity of database using this schema definition.
>
> >How you've got so damaged database?
> Magically! ;)
> If You say dammaged, You mean this
> empty article titles and not owner for topics?
When I'm saying 'damaged' it means that at least one record in database
breaks schema definition from repligard.xml (repligard_withsg.xml) schema
file.
If you have working site then most likely it has no integrity problems at
the database level. But in case of your midgard.sql, it does have
integrity problems. And it is a source of all repligard problems.
--
Sincerely yours, Alexander Bokovoy
The Midgard Project | www.midgard-project.org | ALT Linux Team
Minsk Linux Users Group | www.minsk-lug.net | www.altlinux.ru
-- Tact is the art of making a point without making an enemy.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
