$$chat


(mysql): CREATE TABLE mdl_chat ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, keepdays BIGINT(11) NOT NULL DEFAULT 0, studentlogs SMALLINT(4) NOT NULL DEFAULT 0, chattime BIGINT(10) unsigned NOT NULL DEFAULT 0, schedule SMALLINT(4) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_chat' already exists
            ADOConnection._Execute(CREATE TABLE mdl_chat (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,
 ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_chat (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,
 ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_chat (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,
 ..., true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_chat COMMENT='Each of these is a chat room'  
Success

(mysql): CREATE TABLE mdl_chat_messages ( id BIGINT(10) unsigned NOT NULL auto_increment, chatid BIGINT(10) NOT NULL DEFAULT 0, userid BIGINT(10) NOT NULL DEFAULT 0, groupid BIGINT(10) NOT NULL DEFAULT 0, system TINYINT(1) unsigned NOT NULL DEFAULT 0, message TEXT NOT NULL, timestamp BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_chat_messages' already exists
            ADOConnection._Execute(CREATE TABLE mdl_chat_messages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(10) NOT NULL DEFAULT 0,
 ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_chat_messages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(10) NOT NULL DEFAULT 0,
 ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_chat_messages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(10) NOT NULL DEFAULT 0,
 ..., true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_chat_messages COMMENT='Stores all the actual chat messages'  
Success

(mysql): CREATE TABLE mdl_chat_users ( id BIGINT(10) unsigned NOT NULL auto_increment, chatid BIGINT(11) NOT NULL DEFAULT 0, userid BIGINT(11) NOT NULL DEFAULT 0, groupid BIGINT(11) NOT NULL DEFAULT 0, version VARCHAR(16) NOT NULL DEFAULT '', ip VARCHAR(15) NOT NULL DEFAULT '', firstping BIGINT(10) unsigned NOT NULL DEFAULT 0, lastping BIGINT(10) unsigned NOT NULL DEFAULT 0, lastmessageping BIGINT(10) unsigned NOT NULL DEFAULT 0, sid VARCHAR(32) NOT NULL DEFAULT '', course BIGINT(10) unsigned NOT NULL DEFAULT 0, lang VARCHAR(30) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_chat_users' already exists
            ADOConnection._Execute(CREATE TABLE mdl_chat_users (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(11) NOT NULL DEFAULT 0,
    ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_chat_users (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(11) NOT NULL DEFAULT 0,
    ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_chat_users (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    chatid BIGINT(11) NOT NULL DEFAULT 0,
    ..., true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_chat_users COMMENT='Keeps track of which users are in which chat rooms'  
Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name')  
1062: Duplicate entry 'chat-view' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'view', 'chat', 'name'), true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name')  
1062: Duplicate entry 'chat-add' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'add', 'chat', 'name'), true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name')  
1062: Duplicate entry 'chat-update' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'update', 'chat', 'name'), true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name')  
1062: Duplicate entry 'chat-report' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'report', 'chat', 'name'), true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name')  
1062: Duplicate entry 'chat-talk' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('chat', 'talk', 'chat', 'name'), true) % line 2277, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(/var/www/sites/cjm/gepi/moodle/mod/$$chat/db/install.xml) % line  390, file: adminlib.php
Error

$$chat tables could NOT be set up successfully!