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 ?
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.
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
i.e. chatarea should be mdl_chatarea (or whatever you have set the default prefix to be).
David
When I think too deeply it hurts so I don't
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
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
Just a note that 'chatarea' has now been deleted in favour of the 'chat' module.