[Solved] Problema plugin joomdle en Moodle

Hola, pude instalar todo bien en Joomla y habilite el plugin en Moodle.
Sin embargo en la comprobacion de sistema de Joomla aparece el siguiente mensaje "Algo no funciona con en los servicios web de Joomdle. Visita la página de Notificaciones"

Fui al Admin de Moodle y luego a Notificaciones y aparecen los siguientes errores:

This script generated 15 warnings - Scroll to the first warning
auth/joomdle plugin needs upgrading
(mysql): CREATE TABLE mdl_joomdle_dummytable ( id BIGINT(10) unsigned NOT NULL auto_increment, CONSTRAINT PRIMARY KEY (id) ) 1050: Table 'mdl_joomdle_dummytable' already exists

ADOConnection._Execute(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT(10) unsigned NOT NULL auto_increment,
CONSTRAINT PRIMARY KEY (id)
), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT(10) unsigned NOT NULL auto_increment,
CONSTRAINT PRIMARY KEY (id)
)) % line 89, file: dmllib.php
execute_sql(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT(10) unsigned NOT NULL auto_increment,
CONSTRAINT PRIMARY KEY (id)
), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

ErrorScroll to next warning
(mysql): ALTER TABLE mdl_joomdle_dummytable COMMENT='It appears it is mandatory to have a dummy table.'
Éxito
(mysql): INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1') 1062: Duplicate entry '0-4' for key 2

ADOConnection._Execute(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_firstname', 'locked') 1062: Duplicate entry 'auth/joomdle-field_lock_firstname' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_firstname', 'locked'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_firstname', 'locked')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_firstname', 'locked'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lastname', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_lastname' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lastname', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lastname', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lastname', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_email', 'locked') 1062: Duplicate entry 'auth/joomdle-field_lock_email' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_email', 'locked'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_email', 'locked')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_email', 'locked'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(//public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_city', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_city' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_city', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_city', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_city', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_country', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_country' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_country', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_country', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_country', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lang', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_lang' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lang', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lang', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lang', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_description', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_description' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_description', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_description', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_description', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_url', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_url' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_url', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_url', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_url', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_institution', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_institution' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_institution', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_institution', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_institution', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone1', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_phone1' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone1', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone1', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone1', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone2', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_phone2' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone2', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone2', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone2', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_address', 'unlockedifempty') 1062: Duplicate entry 'auth/joomdle-field_lock_address' for key 2

ADOConnection._Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_address', 'unlockedifempty'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_address', 'unlockedifempty')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_address', 'unlockedifempty'), true) % line 2302, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/public_html/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
Scroll to previous warningInstalling joomdle FAILED!Scroll to continue button


Tengo Joomla 1.5.20 y Moodle 1.9 y ambos instalados en un servidor hosteado.

Que debo hacer?

Bueno el problema era mio, no habia hecho estos cambios en la base de datos:

delete from mdl_config_plugins where plugin like '%joomdle%';
delete from mdl_mnet_host2service where hostid=0 and serviceid=4;
drop table mdl_joomdle_dummytable

Al parecer ahora todo esta bien
Saludos.

Estupendo, gracias por comentar tu solución.

Antonio