Chat - module help needed

Chat - module help needed

by Seppo Venäläinen -
Number of replies: 4
Database error: Invalid SQL: SELECT welcome_msg,banish,no_swear,save,use_smilies,html_tags_keep,html_tags_show,msg_order,msg_nb, msg_refresh,show_timestamp,notify,welcome,version,defaultchatrooms,defaultprivaterooms FROM chatarea WHERE id=1
MySQL error: 1146 (Table 'moodle.chatarea' doesn't exist)
Session halted.

Where have I done wrong ?
Average of ratings: -
In reply to Seppo Venäläinen

Re: Chat - module help needed

by Loren Winfrey -
It sounds like the chatarea didn't make it through the installation. Try going in the administration area, this should install the tables in the BD.
In reply to Seppo Venäläinen

Re: Chat - module help needed

by David Lamotte -
Without thinking too deeply about it, don't you need to add the Moodle Table prefix to the table name.

i.e. chatarea should be mdl_chatarea (or whatever you have set the default prefix to be).

David
In reply to David Lamotte

Re: Chat - module help needed

by John Gone -
When I think too deeply it hurts so I don't smile
When I start a chatarea I also receive error messages. Chatarea starts and seems to function OK but these error messages appear on the right side of the chatarea.
These are the only chatarea tables in my Moodle DB
mdl_chatarea
mdl_chatarea_ban_users
mdl_chatarea_messages
mdl_chatarea_users
Is this typical? John
In reply to Seppo Venäläinen

Re: Chat - module help needed

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Just a note that 'chatarea' has now been deleted in favour of the 'chat' module.