Revision history  [back]

We are integrating askbot into our existing django site. We found the join table question_followed_by is empty even when we have created 9 questions.

mysql> describe question_followed_by;
+-------------+---------+------+-----+---------+----------------+
| Field       | Type    | Null | Key | Default | Extra          |
+-------------+---------+------+-----+---------+----------------+
| id          | int(11) | NO   | PRI | NULL    | auto_increment |
| question_id | int(11) | NO   | MUL | NULL    |                |
| user_id     | int(11) | NO   | MUL | NULL    |                |
+-------------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> select * from question_followed_by;
Empty set (0.00 sec)

mysql> select count(*) from question;
+----------+
| count(*) |
+----------+
|        9 |
+----------+
1 row in set (0.00 sec)

I'm wondering what would cause the join table to miss records?

Thanks a lot,

Alex