[Solved] Probleme bei der Instalation

Hi, you are not in late :laugh: i think that what we call community then I can say thanks to you for this nice components ..

However, I executed the query that the result : ( I use a version 1.9.7+ (Build: 20091216) )

the last one give a empty result then find attached the 3 query result in html format.


cryptoxyz use a version 1.9.5+ , i dont remember the build, but he didnt have to use the dangerous value too.

Thank you

Fabrice

You are right, but as you were the first one replying here...

Anyway, thanks for the testing. First thing I see is strange value in mdl_mnet_host2service.
Hostid has '1' value, when the installation file (db/install.xml) has '0' value. Maybe it has something to do with trying earlier versions?

Maybe, only setting that to '1' instead of '0' resolves the problem (ie, you would be able to remove the 'dangerous' setting).

I can not tell for sure, as the result for first query is missing:
select * from mdl_config where name = 'mnet_localhost_id';

Thanks for testing,
Antobio

Hi,

I try to change it but nothing change.

However i propose you to not waste more time on it, I will reinstall moodle has seems that i m the only one with it. I probably do something wrong somewhere...

I let you know as soon as i re install it. I will be a bit busy this week with my job but i will do asap, and try to come often here maybe i can help others too.

Thank you

Fabrice

Ok, if you prefer to reinstall, no problem. But I don't think you made any mistakes, becase a more people seem to be having similar problems.

Can you do the SQL before doing it, just to check:
select * from mdl_config where name = 'mnet_localhost_id';

Thanks,
Antonio

Hi,

If others people have the same issue, then let try to find out what happen, i will keep the re install option for the last solution :

the result of the quesry :

mysql> select * from mdl_config where name = 'mnet_localhost_id';
+

---

+

---

+

---

+
| id | name | value |
+

---

+

---

+

---

+
| 197 | mnet_localhost_id | 1 |
+

---

+

---

+

---

+
1 row in set (0.00 sec)

mysql>

Thanks

Hi.

Right now I don't really know if it is the same problem, other related or nothing at all
But for sure I want to understand why it is not working for you

I looked again at the selects. You changed mdl_mnet_host2service, so hostid was '0' instead of '1' right?

Can you re-run this SQL with this change applied. Looking at the data I think it should return something
SELECT count(r.id) FROM mdl_mnet_host2service h2s, mdl_mnet_service2rpc s2r, mdl_mnet_rpc r WHERE h2s.serviceid = s2r.serviceid AND s2r.rpcid = r.id AND r.xmlrpc_path = 'auth/joomdle/auth.php/list_courses' AND h2s.hostid in (0, 2) AND h2s.publish = '1' LIMIT 1;

Antonio

Hi sorry for this long silence, but I was very busy..

I re run the sql query but in both case it's returning : count(r.id) => 0

To resume and to be sure : that i put 0 or 1 for the value of this field : select * from mdl_config where name = 'mnet_localhost_id' ;

the result stay the same for this query :
SELECT count(r.id) FROM mdl_mnet_host2service h2s, mdl_mnet_service2rpc s2r, mdl_mnet_rpc r WHERE h2s.serviceid = s2r.serviceid AND s2r.rpcid = r.id AND r.xmlrpc_path = 'auth/joomdle/auth.php/list_courses' AND h2s.hostid in (0, 2) AND h2s.publish = '1' LIMIT 1;

thx

Re Hi,

If you want i can give you access to check out the databases...

Let me know if you want one.

Tahnks

Fabrice

Hi. Sorry, but I think there has been a confussion on what to change.

What you should modify is not mdl_config table, but mdl_mnet_host2service table.
It should be 0 instead of 1 in hostid field. That way this condition: h2s.hostid in (0, 2) will be OK.

Please test, and I if does not work and you want me to take a look, just write me an email with the details.

Regards,
Antonio

Hi,

Ok that why it was better that wrote back a summary to be sure ..

Ok so that make the things, in passing the value to 0 it's working..

sorry to waste u time..

then it fixed for me.. im in mode Strict and have access to the moodle cours..

Tahnk you