1050: Error in Moodle when activating

Hi

I have installed Moodle version 1.9.7, Joomla! 1.5.15 Stable and attempted to install Joomdle 0.23.

Moodle site: learning.vatis.com.au
Joomla site: www.vatis.com.au

When activating the authentication in Moodle I receive a page full of errors, starting with:

(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

If anyone could point me towards some things to check that would be great, thankyou. I have checked the forum but only found one post with this error message and unfortunately it wasn't in English so I can't understand it

Jo



P.S. If it helps, the full Error message is:

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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/vatiscom/public_html/learning/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/vatiscom/public_html/learning/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning

It seems there was a problem setting up Joomdle option.

To fix it, just delete the relevant data from the database:
- drop table mdl_joomdle_dummytable
- delete from mdl_mnet_host2service where hostid = 0 and serviceid = 4

Then, visit Notifications again.