[etoys-notify] [JIRA] Commented: (SQ-862) Ballots in Showcase not being sent

[teefal (JIRA)]

    [ http://tracker.squeakland.org/browse/SQ-862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=40051#action_40051 ] 

teefal commented on SQ-862:
---------------------------

To look at the 1255 good ones:

select SmArticle.id, post_date, title, blurb, SmAccount.id, SmAccount.username, author, attach_name, file_name, is_approved, is_public, SmArticle.mojo, voter_count, uri from SmArticle left join SmAccount on account = SmAccount.id where attach_name like '%.pr' and username is not null and ( file_name  like '%.png' or file_name like '%.gif' or file_name like '%.jpg' ) order by post_date

To look at the the 128 bad ones:

select SmArticle.id, post_date, title, blurb, SmAccount.id, SmAccount.username, author, attach_name, file_name, is_approved, is_public, SmArticle.mojo, voter_count, uri from SmArticle left join SmAccount on account = SmAccount.id where attach_name like '%.pr' and ( username is null or ( file_name not like '%.png' and file_name not like '%.gif' and file_name not like '%.jpg' ) ) order by post_date

Interestingly all but three of these 128 have mojo's of less than 2 and voter counts of 0.

Next we look at ballots.

> Ballots in Showcase not being sent
> ----------------------------------
>
>                 Key: SQ-862
>                 URL: http://tracker.squeakland.org/browse/SQ-862
>             Project: squeakland
>          Issue Type: Bug
>          Components: showcase
>            Reporter: Stephen Thomas
>            Assignee: teefal
>
> I haven't received any ballots since January 15th.  There have been 45 projects (that were NOT mine) posted since March 18th (I stopped counting).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.squeakland.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira