When I go to occupy or reserve a seat, it says I already occupy a seat. Looking in the backend, I can view all of the seats, none of which are occupied by me.

I tried clearing my cookies, but that didn't work.

Any suggestions?

Moensch, have you had a chance to look into this for me? Apparently only the site administrator (me) is having the problem.

Can you send me your database and also let me know which seat exactly you want to occupy and which user (userid) is trying to occupy? I then can check this out.

I only need the jos_mls_seatmap_XXX tables.

Hi,

I had this problem too and tracked it down to a bug. If you have move than one event with a room on each the occupy function done take this into account and just checks to see if you have a seat at all.
If you go to the folder /components/com_mls_seatmap/ and open mls_seatmap.php. Find the function occupySeat() and you will see this sql query a few lines below.

Code:

$database->setQuery( "SELECT s.id FROM `#__mls_seatmap_room_elements` AS `s`" ."\n WHERE" ."\n (s.userid = '".$my->id."' AND s.status='1')" ."\n OR (s.res_userid='".$my->id."' AND s.status='2' AND s.res_end_time > '".$now."')" ."\n AND s.id!='".$id."'"«»);

and replace it with

Code:

$database->setQuery( "SELECT s.id FROM `#__mls_seatmap_room_elements` AS `s`, `#__mls_seatmap_rooms` AS `r`" ."\n WHERE s.roomid = r.id" ."\n AND (s.userid = '".$my->id."' AND s.status='1' AND r.eventid='".$room->eventid."')" ."\n OR (s.res_userid='".$my->id."' AND s.status='2' AND s.res_end_time > '".$now."' AND r.eventid='".$room->eventid."')"«»);

All working fine for me now . This basically now checks the mls_seatmap_rooms to see what rooms are linked to the event in question and not all rooms.

Good stuff. I forgot about that. I will change it in SVN asap.

ta

Holy crap. Thanks man that was it!