search

eve-seat / seat

SeAT 0x. [UNSUPPORTED]
https://github.com/eveseat/seat
MIT License
69 stars 38 forks source link

Home page whoops since #355 #368

Closed eve-seat closed 9 years ago

eve-seat commented 9 years ago

When a non admin user visits the SeAT homepage, it will cause a error on this line https://github.com/eve-seat/seat/blob/dev/app/controllers/HomeController.php#L71. The SQL translates to: 

select count(*) as aggregate from `corporation_corporationsheet` inner join `account_apikeyinfo_characters` on `account_apikeyinfo_characters`.`characterID` = `character_charactersheet`.`characterID` inner join `account_apikeyinfo` on `account_apikeyinfo`.`keyID` = `account_apikeyinfo_characters`.`keyID` where `account_apikeyinfo_characters`.`keyID` in (3323619, 3318165) and `account_apikeyinfo`.`type` = Corporation

To reproduce, impersonate a normal user of SeAT with no rights.

eve-seat commented 9 years ago

Need to fix this before we can roll v0.14