[Solved] Courses not showing up on Joomla frontend

I'm getting "Error XML-RPC (7015): Unable to locate function, or function prohibited for RPC" on Joomla frontend, for both the "Joomdle Courses" and "My Joomdle Courses" modules. I'm gettting "auth/joomdle plugin needs upgrading" on Moodle backend with 14 errors.

I am running Moodle 1.9.8 with Joomla 1.5.17.

Things that actually work:
Creating an account in Joomla creates a user account in Moodle. Looging in Joomla logs the user in Moodle. Logging out in Joomla logs the user out in Moodle.

I have Moodle Network Authentication and Joomdle both enabled with the correct settings on each.

Networking is on in the Networks settings in Moodle. XML-RPC settings in Moodle has the IP of my website and it is a valid trusted IP.

I have deleted the table "mdl_joomdle_dummytable many times before reinstalling.
But still does not fix problem.

The errors I get in notifications area in Moodle are:

mysql): CREATE TABLE mdl_joomdle_dummytable ( id BIGINT(10) unsigned NOT NULL auto_increment, CONSTRAINT PRIMARY KEY (id) )

---

Success

---

(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 'mdl_mnethost_hosser_uix'

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(/home4/techlear/public_html/chemistry/auth/joomdle/db/install.xml) % line 137, file: adminlib.php
ErrorScroll 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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/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 'mdl_confplug_plunam_uix'

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(/home4/techlear/public_html/chemistry/auth/joomdle/db/install.xml) % line 137, file: adminlib.php
Scroll to previous warningErrorScroll to next warning
Scroll to previous warningInstalling joomdle FAILED!




Any ideas? Thanks in advance if you are able to help with these.

Hi. You should delete everything that is giving errors, and then re-visit 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

Outstanding! Worked perfectly. Thanks!