Re: [gitorious] Re: Unable to open watchlist.atom for a specific user

2011-02-02 Thread Christian Johansen
>
> if I delete a tag and push it to
> the remote it generates an entry into the same table with user_id =
> null.
>
> Do you think could it be a bug?
>

It sure is (was), thanks for finding it. It's fixed on master now:
http://gitorious.org/gitorious/mainline/commit/7671a930573796fbc8cb6048194b2bb2ffc9e009

Cheers,
Christian

-- 
To post to this group, send email to gitorious@googlegroups.com
To unsubscribe from this group, send email to
gitorious+unsubscr...@googlegroups.com


Re: [gitorious] Re: Unable to open watchlist.atom for a specific user

2011-01-31 Thread Thomas Schamm
Renato, have you already taken a look into the feed table in your database? 

I propose that you select all feed items of a user id for whom the news items 
do not work properly. Then have a look on the corresponding events in the event 
table. In my case, some events were not valid - delete those feed items.

I think it should be possible to write a ruby maintenance script to delete all 
invalid feed items. However I'm still not used to ruby well.

Good luck!

Thomas


Am 31.01.2011 um 21:29 schrieb Renato Isidio :

> Hi Thomas!
> 
> Im facing the same problem as yours, but theres a difference between
> them. Im having problem showing newsfeed for evry user, but not for
> new ones. Thats strange!
> Can you help me?
> 
> Thank you!
> 
> Renato
> 
> 
> 
> On 14 jan, 08:35, Thomas Schamm  wrote:
>> Hi Marius,
>> 
>> I've had another look on the database, especially the feed_item table. The 
>> mentioned user's feed_item list contained some rather old entries (~1 year) 
>> on events which did not exist. After destroying these feed_items, the 
>> dashboard could be accessed again!
>> 
>> Thanks!
>> Thomas
>> 
>> Am 14.01.2011 um 09:57 schrieb Marius MÃ¥rnes Mathiesen:
>> 
>> 
>> 
>> 
>> 
>>> On Fri, Jan 14, 2011 at 8:43 AM, Thomas Schamm  wrote:
 We have quite a strange problem on our company's gitorious installation: 
 The watchlist.atomfeed is invalid, the error page says the source is not 
 available. However, this only happens for one specific user, all others 
 are able to access their watchlists. The specific user is unable to open 
 it's dashboard, as soon as he tries to access this site, a 404 error page 
 is shown (which I think is because of the invalid watchlist).
>> 
 I have the belief, an invalid event may corrupt the user's watchlist. Is 
 there an option to "rebuild" the user's watchlist? I think this would 
 result in a massive database manipulation, as all events bound to this 
 user have to be deleted.
>> 
>>> Thomas,
>>> It sounds like you found the problem - did you identify which event
>>> this is? There isn't functionality for rebuilding a user's watchlist,
>>> so your best option is probably to identify the event and delete it
>>> from the database (ie. Event.find().destroy in the console). To my
>>> knowledge, events relating to other objects in the database should be
>>> removed when their "parents" are removed.
>> 
 ps: It's nice to see gitorious progressing so well. It makes much of fun 
 using gitorious in our company!
>> 
>>> :-)
>> 
>>> Cheers,
>>> - Marius
>> 
>>> --
>>> To post to this group, send email to gitorious@googlegroups.com
>>> To unsubscribe from this group, send email to
>>> gitorious+unsubscr...@googlegroups.com
>> 
>> --
>> E-Mail: tho...@tschamm.de
> 
> -- 
> To post to this group, send email to gitorious@googlegroups.com
> To unsubscribe from this group, send email to
> gitorious+unsubscr...@googlegroups.com

-- 
To post to this group, send email to gitorious@googlegroups.com
To unsubscribe from this group, send email to
gitorious+unsubscr...@googlegroups.com