Assembla home | Assembla project page
 

Ticket #7 (closed defect: fixed)

Opened 2 years ago

Last modified 1 year ago

Comments count not working for user

Reported by: digitalspaghetti Assigned to: digitalspaghetti
Priority: critical Milestone:
Component: Models Version: 0.3.*
Keywords: comment Cc:

Description (Last modified by digitalspaghetti)

When adding a comment, does not increase the users comment count, instead gives an error: SQL Error: 1052: Column 'user_id' in where clause is ambiguous

SQL code is as follows: Query: SELECT COUNT(*) AS count FROM comments AS Comment LEFT JOIN posts AS Post ON (Comment.post_id = Post.id) LEFT JOIN users AS User ON (Comment.user_id = User.id) WHERE user_id = 1

Change History

04/30/07 15:44:19 changed by digitalspaghetti

Seems to be an issue when there are two belongsTo in the model, look at unbind

04/30/07 18:39:59 changed by digitalspaghetti

  • priority changed from minor to critical.
  • component changed from Users to Models.
  • description changed.
  • milestone changed from Alpha 2 to Alpha 1 (first demo site).

05/02/07 16:49:19 changed by digitalspaghetti

  • status changed from new to closed.
  • resolution set to fixed.

Now fixed in behaviour

07/19/07 13:14:12 changed by

  • milestone deleted.

Milestone Alpha 1 (first demo site) deleted