A ver si alguien me puede ayudar:
borré el módulo Chat desde: Administración » Configuración » Administración de módulos, estando ahí, directamente pulso sobre Administración y me aparece el siguiente error:
Instalando el módulo de tablas
chat
--------------------------------------------------------------------------------
(mysql): CREATE TABLE `mdl_chat` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `keepdays` int(11) NOT NULL default '0', `studentlogs` int(4) NOT NULL default '0', `chattime` int(10) unsigned NOT NULL default '0', `schedule` int(4) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Each of these is a chat room'
--------------------------------------------------------------------------------
1050: Table 'mdl_chat' already exists
adodb_mysql._execute(CREATE TABLE `mdl_chat` ( `id` int(10) unsigned NOT NULL auto_i..., false) % line 800, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `mdl_chat` ( `id` int(10) unsigned NOT NULL auto_i...) % line 16, file: datalib.php
execute_sql(CREATE TABLE `mdl_chat` ( `id` int(10) unsigned NOT NULL auto_i...) % line 71, file: datalib.php
modify_database(C:\Moodle/mod/chat/db/mysql.sql) % line 295, file: index.php
Error
--------------------------------------------------------------------------------
(mysql): CREATE TABLE `mdl_chat_messages` ( `id` int(10) unsigned NOT NULL auto_increment, `chatid` int(10) NOT NULL default '0', `userid` int(10) NOT NULL default '0', `groupid` int(10) NOT NULL default '0', `system` int(1) unsigned NOT NULL default '0', `message` text NOT NULL, `timestamp` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `timemodifiedchat` (`timestamp`, `chatid`)) TYPE=MyISAM COMMENT='Stores all the actual chat messages'
--------------------------------------------------------------------------------
1050: Table 'mdl_chat_messages' already exists
adodb_mysql._execute(CREATE TABLE `mdl_chat_messages` ( `id` int(10) unsigned NOT NU..., false) % line 800, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `mdl_chat_messages` ( `id` int(10) unsigned NOT NU...) % line 16, file: datalib.php
execute_sql(CREATE TABLE `mdl_chat_messages` ( `id` int(10) unsigned NOT NU...) % line 71, file: datalib.php
modify_database(C:\Moodle/mod/chat/db/mysql.sql) % line 295, file: index.php
Error
--------------------------------------------------------------------------------
(mysql): CREATE TABLE `mdl_chat_users` ( `id` int(10) unsigned NOT NULL auto_increment, `chatid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `groupid` int(11) NOT NULL default '0', `version` varchar(16) NOT NULL default '', `ip` varchar(15) NOT NULL default '', `firstping` int(10) unsigned NOT NULL default '0', `lastping` int(10) unsigned NOT NULL default '0', `lastmessageping` int(10) unsigned NOT NULL default '0', `sid` varchar(32) NOT NULL default '', PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `lastping` (`lastping`)) TYPE=MyISAM COMMENT='Keeps track of which users are in which chat rooms'
--------------------------------------------------------------------------------
1050: Table 'mdl_chat_users' already exists
adodb_mysql._execute(CREATE TABLE `mdl_chat_users` ( `id` int(10) unsigned NOT NULL ..., false) % line 800, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `mdl_chat_users` ( `id` int(10) unsigned NOT NULL ...) % line 16, file: datalib.php
execute_sql(CREATE TABLE `mdl_chat_users` ( `id` int(10) unsigned NOT NULL ...) % line 71, file: datalib.php
modify_database(C:\Moodle/mod/chat/db/mysql.sql) % line 295, file: index.php
Error
--------------------------------------------------------------------------------
(mysql): INSERT INTO mdl_log_display VALUES ('chat', 'view', 'chat', 'name')
--------------------------------------------------------------------------------
Éxito
--------------------------------------------------------------------------------
(mysql): INSERT INTO mdl_log_display VALUES ('chat', 'add', 'chat', 'name')
--------------------------------------------------------------------------------
Éxito
--------------------------------------------------------------------------------
(mysql): INSERT INTO mdl_log_display VALUES ('chat', 'update', 'chat', 'name')
--------------------------------------------------------------------------------
Éxito
--------------------------------------------------------------------------------
(mysql): INSERT INTO mdl_log_display VALUES ('chat', 'report', 'chat', 'name')
--------------------------------------------------------------------------------
Éxito
--------------------------------------------------------------------------------
(mysql): INSERT INTO mdl_log_display VALUES ('chat', 'talk', 'chat', 'name')
--------------------------------------------------------------------------------
Éxito
chat tables could NOT be set up successfully!
Hola Isabel,
Lo que te está ocurriendo es que Moodle intenta crear las tablas necesarias para el módulo chat en la base de datos y éstas ya existen.
1050: Table 'mdl_chat' already exists (la tabla 'mdl_chat' ya existe)
Borra esas tablas desde phpmyadmin y desaparecerá el problema reinstalando el chat.
Si lo que quieres es eliminarlo definitivamente, borra la carpeta chat (situada en moodle/mod/) porque si no, cada vez que entres en administración Moodle la detectará e intentará instalarla.
Espero que te sirva,
Fermin Cueva
Siiii, problema solventado. GRacias Fermin!