SiT! Bugs - SiT!
View Issue Details
0001095SiT!portalpublic2010-02-20 19:572012-12-16 17:04
3.90beta1Current GIT 
0001095: trying to open an incident in the portal lists each contract multiple times
Looks like an incomplete join
No tags attached.
png portal.png (117,155) 2010-02-20 19:57

png sit-3.90-bug3.png (25,464) 2011-06-19 11:49
Issue History
2010-02-20 19:57paulhNew Issue
2010-02-20 19:57paulhFile Added: portal.png
2010-02-23 20:38paulhNote Added: 0002459
2010-02-23 20:42paulhNote Added: 0002460
2010-02-23 20:52ivanNote Added: 0002462
2010-02-23 21:01kieranNote Added: 0002466
2011-06-19 11:49ivanFile Added: sit-3.90-bug3.png
2011-06-19 11:50ivanNote Added: 0004052
2011-06-19 11:50ivanStatusnew => confirmed
2011-06-19 11:50ivanTarget Version => 3.90beta1
2011-06-20 22:14TomseNote Added: 0004055
2011-12-22 14:03nicdevAssigned To => nicdev
2011-12-22 14:03nicdevStatusconfirmed => assigned
2011-12-22 14:24nicdevNote Added: 0004394
2011-12-22 15:36nicdevNote Added: 0004397
2012-12-16 17:04paulhNote Added: 0004617
2012-12-16 17:04paulhStatusassigned => resolved
2012-12-16 17:04paulhResolutionopen => fixed
2012-12-16 17:04paulhFixed in Version => Current GIT

2010-02-23 20:38   

SELECT m.*,, (m.incident_quantity - m.incidents_used) AS availableincidents FROM `supportcontacts` AS sc, `maintenance` AS m, `products` AS p WHERE AND sc.contactid='1' AND AND (expirydate > (UNIX_TIMESTAMP(NOW()) - 15778463) OR expirydate = -1) AND = 1 UNION SELECT m.*,, (m.incident_quantity - m.incidents_used) AS availableincidents FROM `supportcontacts` AS sc, `maintenance` AS m, `products` AS p WHERE AND m.allcontactssupported = 'yes' AND (expirydate > (UNIX_TIMESTAMP(NOW()) - 15778463) OR expirydate = -1) AND = 1 ORDER BY expirydate DESC

returns only three contracts
2010-02-23 20:42   
Thoroughly confused now it was only showing the contracts doubled up after a refresh its now consistently showing just one copy, very confusing
2010-02-23 20:52   
Have a try setting your contract to "all contacts supported" see if that makes a difference? Just a guess.
2010-02-23 21:01   
Hm, the refresh thing rings a bell about another bug having an allowance variable set incorrectly during login but is reset in the header.
2011-06-19 11:50   
Confirmed, just seen this myself, see screenshot: sit-3.90-bug3.png

I think it was fine the first time I looked but then when I look again it was duplicated, so maybe it gets read twice or something.
2011-06-20 22:14   
I had problems reproducing this, but going to the admin page and then entitlement seems to reproduce it
2011-12-22 14:24   
I have tried to reproduce this in current Git, but no matter how I cannot reproduce it. I also tested it on 3.65LTS and could not reproduce it.

Maybe it got fixed and someone forgot to note it?

Anyone to confirm?
2011-12-22 15:36   
Ok, I managed to get this reproduced once: It seems that when the session gets re-generated, the entitlement gets re-written, though i'm not sure why.
2012-12-16 17:04   
Had added a unset entitlements just before populating in git d256e69 so this should never happen