[Solved] Deu errado o ip

Caro colega este ip voce colocou é sim o meu ip: 75.125.220.162

Veja a situação:tenho dois sites, ambos no mesmo host que apresenta este ip , acima, o site powerconcuros esta na pasta principal do host (www) do dominio powerconcursos.co.cc, já o site nutrisaber.co.cc esta na pasta "p" dentro da pasta "nutrisaber" que esta dentro da pasta "www" do dominio powerconcuros.co.cc.Já a plataforma moodle esta na pasta "www" do dominio powerconcuros.co.cc. Ufa que bagunça , mas foi necessario devido a problemas de permissao no host, enfim vamos ao problema principal.

No site powerconcuros.co.cc ( ip:75.125.220.162 ) instalei o antigo moodlejoomla - integração , que nos modulos ocorre erro ao apresentar os cursos, veja:

powerconcursos.co.cc/

Já no site nutrisaber.co.cc ( mesmo ip:75.125.220.162)instalei o componente joomdle - apresenta o seguinte erro nos modulos, veja:

www.nutrisaber.co.cc/

Configurei ambos os sites para direcionar para o moodle que esta na pasta:

powerconcursos.co.cc/moodle

Como proceder?

Ahhh.... no site nutrisaber.co.cc quando tento logar ao clicar login vai para o site powerconcursos.co.cc, o que pode estar de errado, tambem?

Sobre powercursos: deves instalar o último Joomdle. Tens mas capacidades, e é mais facil de usar.

Sobre nutrisaber: visistaste a página de Notificaçoes en Moodle depois de instalar auth_joomdle? Que aparece?

após clicar em notificações no moodle apresentou assim:

This script generated 13 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) )
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')
Success
(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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/public_html/moodle/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_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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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



Como proceder pode-me ajudar.
Obrigado

No phpmyadmin, tens que borrar as filas que dao erro.

Executa:
delete from mdl_config_plugins where plugin like '%joomdle%';

Depois, clica outra vez em notificações para ver que aparece.

Caro colega, na tabela mdl_config_plugins deletei todos referentes a auth_joomdle e depois cliquei em notificações e apareceu novos erros e continua o erro no modulo 7015, por favor poderia me ajudar como proceder? Seguintes erros após clicar em notificações em moodle:

This script generated 3 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/p22h/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 2300, file: dmllib.php
execute_sql_arr(Array[15]) % line 635, file: ddllib.php
install_from_xmldb_file(/home/p22h/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')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lastname', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_email', 'locked')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_city', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_country', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_lang', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_description', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_url', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_institution', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone1', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_phone2', 'unlockedifempty')

Success

(mysql): INSERT INTO mdl_config_plugins(plugin, name, value) VALUES ('auth/joomdle', 'field_lock_address', 'unlockedifempty')

Success

Scroll to previous warningInstalling joomdle FAILED!Scroll to continue button



Duvida na configuração no moodle do pluign do joomdle tem que deixar aberto ou fechados os campos para o cadastro?


obrigado.

Depois que realizei o que falei acima, cliquei novamente em notificações e apreceu como antes com

This script generated 15 warnings - Scroll to the first warning
auth/joomdle plugin needs upgrading

Como proceder?

Obrigado

Esqueci de dizer tudo o que tens que borrar:
- delete from mdl_config_plugins where plugin like '%joomdle%';
- delete from mdl_mnet_host2service where hostid=0 and serviceid=4;
- Borrar a tabla mdl_joomdle_dummytable

Depois, visita notificações.

antonio escribió:

Esqueci de dizer tudo o que tens que borrar:
- delete from mdl_config_plugins where plugin like '%joomdle%';
- delete from mdl_mnet_host2service where hostid=0 and serviceid=4;
- Borrar a tabla mdl_joomdle_dummytable

Depois, visita notificações.

veja se entendi o que fazer?

-Devo deletar dentro da tabela mdl_config_plugins todos os campos do plugin auth/joomdle.

Remover 62 auth/joomdle field_lock_address unlockedifempty
Remover 61 auth/joomdle field_lock_phone2 unlockedifempty
Remover 60 auth/joomdle field_lock_phone1 unlockedifempty
Remover 59 auth/joomdle field_lock_institution unlockedifempty
Remover 58 auth/joomdle field_lock_url unlockedifempty
Remover 57 auth/joomdle field_lock_description unlockedifempty
Remover 55 auth/joomdle field_lock_country unlockedifempty
Remover 56 auth/joomdle field_lock_lang unlockedifempty
Remover 54 auth/joomdle field_lock_city unlockedifempty
Remover 53 auth/joomdle field_lock_email locked
Remover 51 auth/joomdle field_lock_firstname locked
Remover 52 auth/joomdle field_lock_lastname unlockedifempty

-Devo deletar na tabela mdl_mnet_host2service os campos hostid e serviceid, ficando assim?


id subscribe
2 0

-devo deletar toda a tabela mdl_joomdle_dummytable?


Duvida após realizar isto os campos da tabela mdl_config_plugins são criadas novamente?

- Tens que remover as filas completas, nao os campos. Por isso o SQL delete.
- Tens que eleminar a tabela mdl_joomdle_dummytable. Em SQL: drop table mdl_joomdle_dummytable;

Depois, tudo é criado novamente ao visitar notificaçoes.

Obrigado pela paciência.

Mas ainda apresenta erro após clicar em notificações:

1054: Unknown column 'hostid' in 'field list'

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/p22h/public_html/nutrisaber/moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php



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


Como proceder?