[Solved] auth/joomdle 15 ERRORS Install Failed

Any idea what is happening here?



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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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.'

---

Success

---

(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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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(/hsphere/local/home/kerstenkloss/learning.refreshedit.com/mdl/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

I don't know why this happens to many people, I never had a problem installing myself

Try deleting the offending data ditectly from the DB, and revisit Notifications:

- 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

Antonio...your my hero bud! Run the commands above, notifications were fine. I checked the 'System check' but it was still complaining..i nearly cried. Then after some time to refresh properly and registering moodle, everything seems perfect. I can now manage my users via the Joomdle component!
Hope the above issues help anyone else with the same issue
All the best!

Hi,

I have the same problem whith same message error

I'm a beginner and i don't understand what do you mean when you say

Try deleting the offending data ditectly from the DB, and revisit Notifications:

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

what i need to do in mdl_config_plugins and in mdl_mnet_host2service? delete them??


Thank you

---Sorry i have solved my problem by run the commands above and that run fine
Thank you