[Solved] XML-RPC Error (7015): Unable to locate

I have installed Joomla! 1.5.20 Stable and Moodle 1.9.9+ (Build: 20100825). I have also installed Joomdle R0.25.

Joomdle is visible as an extension in both Joomla and Moodle. However, when I try to add Joomdle as a Joomla menu item I get the error:

XML-RPC Error (7015): Unable to locate function, or function prohibited for RPC.


Moodle Notifications shows the following errors:

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(/home/acet162/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.'
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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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(/home/acet162/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


I'd be extremely grateful for advice about how to remedy this problem. But please be forewarned that I know next to nothing about MySQL. Though I could probably stumble my way around phpMyAdmin if given clear newb-friendly instructions.

Thanks in advance!

Hi.

You need to run some queries on phpmyadmin to delete the offending rows.

Look here for instructions:
www.joomdle.com/wiki/System_health_check...e_Web_Services_setup

That worked Many thanks for the prompt reply!

Glad to hear. Thanks for letting us know