Cant create chats

Maybe you should try to drop all the chatroom database tables again, and then install the module using the devel.module reinstall modules function to make sure everything is installed again?

I'm having the exact same problem.

I've traced it down to the SQL query in the function chatroom_get_room_summary, which returns 0 rows even when you feed it the nid of a chatroom with active chats.

I'll have to dissect the query and figure out where it's bombing. I'll keep you posted.

in function chatroom_get_room_summary() is the following code:

  $result = db_query("SELECT     GREATEST(COUNT(cm.cmid), COUNT(cma.cmid)) AS msg_count,
                                 MAX(cm.cmid) AS last_cmid,
                                 cc.ccid,
                                 cc.chatname,
                                 cc.when_archived
                      FROM       {chatroom} AS cr
                      INNER JOIN {chatroom_chat} AS cc
                      ON         cc.crid = cr.crid
                      LEFT JOIN  {chatroom_msg} AS cm
                      ON         cm.ccid = cc.ccid
                      LEFT JOIN  {chatroom_msg_archive} AS cma
                      ON         cma.ccid = cc.ccid
                      WHERE      cr.crid =  %d
                      AND NOT    EXISTS(SELECT cm.recipient
                                        FROM {chatroom_msg} AS cm
                                        INNER JOIN {chatroom_chat} AS cc
                                        ON cm.ccid = cc.ccid
                                        INNER JOIN {chatroom} AS cr
                                        ON cc.crid = cr.crid
                                        WHERE cr.crid = %d)
                      GROUP BY   cc.ccid, cc.chatname, cc.when_archived",
                      $room_id, $room_id);

I finally figured out what was making it fail, and removed this bit:

                      AND NOT    EXISTS(SELECT cm.recipient
                                        FROM {chatroom_msg} AS cm
                                        INNER JOIN {chatroom_chat} AS cc
                                        ON cm.ccid = cc.ccid
                                        INNER JOIN {chatroom} AS cr
                                        ON cc.crid = cr.crid
                                        WHERE cr.crid = %d)

And it now appears to work properly. I can't figure out what that bit of the query was there for. None of the rows in my chatroom_msg table had anything in the recipient field. That query alone returned as many rows as there were in the chatroom_msg table. So I'm completely unclear as to why this NOT EXISTS clause is in the query, what it does, and what I've broken by taking it out. But at least my chats get listed now.

That fix worked for me also.

Thank You

Phil

Works for me also.

Thanks for the patch Ogredude.

JPeiro.

I'm having a similiar issue.

After creating a new chat room, then creating the chat. The chat disappears a few minutes later. The only way to re-enter that chat is by typing the chat node number in the URL bar.

Then... I cannot add any new chats to that room. I need to make an entire new chat room and then a new chat... and the process repeats itself.

The chats don't disappear unless you delete the room which held them but you cannot access the chat's in any traditional or interface method unless you create a menu link to a specific chat.

Will correcting this code eliminate this issue as well? Is it similiar to what was being described initially?

This bug was fixed in the 1.1 release.

After creating a new chat room, then creating the chat. The chat disappears a few minutes later. The only way to re-enter that chat is by typing the chat node number in the URL bar.

Then... I cannot add any new chats to that room. I need to make an entire new chat room and then a new chat... and the process repeats itself.

The chats don't disappear unless you delete the room which held them but you cannot access the chat's in any traditional or interface method unless you create a menu link to a specific chat.

It is said that this bug was fixed in version 1.1 but this is the only version I've used. If fact, I thought I might have been mistaken but when I just tried downloading it again, I got the "file already exits..." yadda yadda.

This bug still exists.

What file already exists?

ah, I wasn't sure if I had downloaded version 1.1 or not so when I went to download 1.1 today, I got the "file already exists..." messege; meaning I had indeed downloaded and installed version 1.1

One of the queries was not working. Fixed in CVS commit 52690.

Here's a patch for version 1.1.