Em 07-07-2011 17:56, Jarrod Roberson escreveu:
Thanks for the translation of the error messages, with your suggestion
about the nil in repository_id I did the following
mysql> select repository_id from committerships c where repository_id
not in (
select id from repositories );
+---------------+
| repository_id |
+---------------+
| 139 |
| 143 |
| 152 |
| 176 |
.. snipped about 43 entries.
That's one of the reasons that we should add the missing foreign key
constraints to the database, as I stated that in task #1, in the new
Gitorious issues system:
https://issues.gitorious.org/issues/1
once I deleted those I was able to uncomment that line and that team
page started working again.
Now my new question is, are those repositories that were not in the
repositories table, orphaned on my disk?
I don't know what you mean by "orphan in your disk", but I don't believe
the wrong state you got in your database would be possible by just using
Gitorious. You probably made some changes to the database by yourself
and, since Gitorious didn't add these constraints to the database, you
were allowed to put it in a non consistent shape.
Cheers, Rodrigo.
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]