$$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!