Ok, I am trying to install Chat Room and every time I enable it in the Site Building -> Module section of the site I get the following error:

user warning: Table 'joomimi21.chatroom_chat_invite' doesn't exist query: SELECT cci.cciid, n.title, u.name, u.uid, cci.nid FROM chatroom_chat_invite cci INNER JOIN node n ON n.nid = cci.nid INNER JOIN users u ON u.uid = cci.inviter_uid WHERE cci.invitee_uid = 1 AND cci.accepted = 0 AND cci.notified = 0 in G:\content\test\steelyLibDemo\sites\all\modules\chatroom\chatroom.module on line 91.

I followed the instructions for the install and made sure I moved the chatroomread.php file to the root. I'm not sure what the problem is or why it can't find/create the table.

Comments

tormi’s picture

Try to uninstall and re-install the module and see if that helps.

johnmurray’s picture

I've tried that several times and I've had no luck. I've even downloaded another copy just to make sure that no files were corrupted. Thanks!

johnmurray’s picture

I just tried removing (and deleting) all modules that were installed earlier (extras, if you will) and I then re-installed the module just to make sure nothing was conflicting with it. However, upon re-install I am getting the same error messages. It looks to me as if the database tables are not being created (or at least one is not being created). When looking at my database I can see the following tables that I assume to be associated with the module:

chatroom
chatroom_ban_list
chatroom_chat
chatroom_msg
chatroom_online_list

I do not see chatroom_chat_invite table (which is the table for which I am receiving an error message). I don't know if this is the only table that was not created, but it is at least one that is giving me an error.

tormi’s picture

Hi John,

did you uninstalled (using /admin/build/modules/uninstall) or only disabled chatroom tables?

Complete list of chatroom tables:

chatroom
chatroom_ban_list
chatroom_chat
chatroom_chat_ban_list
chatroom_chat_invite
chatroom_chat_kicked_list
chatroom_chat_online_list
chatroom_chat_user
chatroom_msg
chatroom_online_list

Tormi

johnmurray’s picture

Sorry! I was just disabling the tables and not re-installing! I'm new to Drupal, if it's not obvious, thank you sooo much!