Home >> Forums >> Bugs >> no visits possible

no visits possible

Log in or register to add a reply.
HessenYeti
HessenYeti
May 16th 2009, 18:44
Currently no visits are possible. At the top of the hotel page, a sql-query is visible and page says, there were no rooms available - even when many of them are empty.

It seems, that it doesn't make any difference, where the visitors are anonymous or not (exept the number of possible visits of course).
cnland
cnland
May 16th 2009, 19:20
Yeah!!! I can't visit anyone :(
Meyari
Meyari
May 16th 2009, 20:16
Yeah, I'm having that problem too. It says every hotel I look at that there are no free rooms even though there are. At the top of the page it says this:

Query: SELECT `Room`.`id`,`RoomType`.`class`,`RoomType`.`earns`,COUNT(`Visit`.`id`) c FROM `rooms` `Room` LEFT JOIN `visits` `Visit` ON `Room`.`id`=`Visit`.`room_id` AND `Visit`.`created`<'2009-05-16 20:14:59' AND `Visit`.`reserved_till`>'2009-05-16 20:14:59' LEFT JOIN `room_types` `RoomType` ON `Room`.`room_type_id`=`RoomType`.id WHERE hotel_id=3887 AND `RoomType`.`class`<=5 AND `Room`.`active` = 1 GROUP BY `Room`.`id` HAVING c=0 ORDER BY `RoomType`.`class` DESC
Solrayne
Solrayne
May 16th 2009, 22:57
Same problem here.... all this code gibberish is at the top of the page(s):

Query: SELECT `Room`.`id`,`RoomType`.`class`,`RoomType`.`earns`,COUNT(`Visit`.`id`) c FROM `rooms` `Room` LEFT JOIN `visits` `Visit` ON `Room`.`id`=`Visit`.`room_id` AND `Visit`.`created`<'2009-05-16 22:56:49' AND `Visit`.`reserved_till`>'2009-05-16 22:56:49' LEFT JOIN `room_types` `RoomType` ON `Room`.`room_type_id`=`RoomType`.id WHERE hotel_id=4105 AND `RoomType`.`class`<=5 AND `Room`.`active` = 1 GROUP BY `Room`.`id` HAVING c=0 ORDER BY `RoomType`.`class` DESC

Query: SELECT `Room`.`id`,`RoomType`.`class`,`RoomType`.`earns`,COUNT(`Visit`.`id`) c FROM `rooms` `Room` LEFT JOIN `visits` `Visit` ON `Room`.`id`=`Visit`.`room_id` AND `Visit`.`created`<'2009-05-16 22:56:49' AND `Visit`.`reserved_till`>'2009-05-16 22:56:49' LEFT JOIN `room_types` `RoomType` ON `Room`.`room_type_id`=`RoomType`.id WHERE hotel_id=4105 AND `RoomType`.`class`<=5 AND `Room`.`active` = 1 GROUP BY `Room`.`id` HAVING c=0 ORDER BY `RoomType`.`class` DESC
Log in or register to add a reply.