Add Slot and Snippet table replacement

[airbundle] / Repository / LocationRepository.php

diff --git a/Repository/LocationRepository.php b/Repository/LocationRepository.php
index f5efbc6cdc4c0b57194827b3edbb1c468a057e11..129a1763ee497dafc6b64bc339fbe20ab878fcc0 100644 (file)
--- a/Repository/LocationRepository.php
+++ b/Repository/LocationRepository.php
@@ -148,7 +148,7 @@ ORDER BY '.(!empty($userId)?'COUNT(a.id) DESC, ':'').'COUNT(s.id) DESC, l.id'
                ];
 
                //Set the request
-               $req = 'SELECT l.id, l.title, l.short
+               $req = 'SELECT l.id, l.title
 FROM RapsysAirBundle:UserLocation AS ul
 JOIN RapsysAirBundle:Location AS l ON (l.id = ul.location_id)
 WHERE ul.user_id = :uid';
@@ -164,7 +164,6 @@ WHERE ul.user_id = :uid';
                $rsm->addEntityResult('RapsysAirBundle:Location', 'l');
                $rsm->addFieldResult('l', 'id', 'id');
                $rsm->addFieldResult('l', 'title', 'title');
-               $rsm->addFieldResult('l', 'short', 'short');
 
                //Send result
                return $em