[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=40050#action_40050 ] 

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

Okay, I'll keep a running log on my discoveries here ... 

The database today shows 1383 projects in the database:

select id,post_date,title,blurb,author,attach_name,file_name,is_approved,is_public,mojo,voter_count,uri from SmArticle where attach_name like '%.pr' order by post_date

Of these, 1274 have thumbnails, which means that 109 do not, of which 7 are bad filenames (mostly .pr) and the rest are empty.

select id,post_date,title,blurb,author,attach_name,file_name,is_approved,is_public,mojo,voter_count,uri from SmArticle where attach_name like '%.pr' and file_name not like '%.png' and file_name not like '%.gif' and file_name not like '%.jpg' order by post_date

If I link to accounts, the number becomes 1281, which is 102 less than it should be:

select SmArticle.id, post_date, title, blurb, SmAccount.username, author, attach_name, file_name, is_approved, is_public, SmArticle.mojo, voter_count, uri from SmArticle, SmAccount where account = SmAccount.id and attach_name like '%.pr' order by post_date

I've confirmed that 101 projects have an account of zero, which can either be because the account was deleted or was never set to begin with. That's one less than 102, so there's a single weird case (9897) that an account number, but no account. Okay, I've zeroed that one out so we're back to 102.

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 order by post_date

So we've got 109 projects without a thumbnail and 102 projects without an account.  How do these relate?

Well, 83 projects are missing both thumbnail and accounts:

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 and file_name not like '%.png' and file_name not like '%.gif' and file_name not like '%.jpg'  order by post_date

26 are missing just the thumbnail:

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 not like '%.png' and file_name not like '%.gif' and file_name not like '%.jpg'  order by post_date

19 are missing just the account:

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 and ( file_name  like '%.png' or file_name like '%.gif' or file_name like '%.jpg' ) order by post_date


In summary:

1383 total projects
1255 with both account and thumbnail
83 without account or thumbnail
19 without account but with thumbnail
26 with account but no thumbnail



> 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