SiT! Bugs - SiT!
View Issue Details
0001095SiT!portalpublic2010-02-20 19:572012-12-16 17:04
paulh 
nicdev 
normalminoralways
resolvedfixed 
3.51 
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
http://bugs.sitracker.org/file_download.php?file_id=85&type=bug
png

png sit-3.90-bug3.png (25,464) 2011-06-19 11:49
http://bugs.sitracker.org/file_download.php?file_id=160&type=bug
png
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

Notes
(0002459)
paulh   
2010-02-23 20:38   
SQl

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

returns only three contracts
(0002460)
paulh   
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
(0002462)
ivan   
2010-02-23 20:52   
Have a try setting your contract to "all contacts supported" see if that makes a difference? Just a guess.
(0002466)
kieran   
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.
(0004052)
ivan   
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.
(0004055)
Tomse   
2011-06-20 22:14   
I had problems reproducing this, but going to the admin page and then entitlement seems to reproduce it
(0004394)
nicdev   
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?
(0004397)
nicdev   
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.
(0004617)
paulh   
2012-12-16 17:04   
Had added a unset entitlements just before populating in git d256e69 so this should never happen