Re: Modlos 1.5.0 database issues

List posts in the topic

Re: Modlos 1.5.0 database issues

msg# 1.5.1

depth:

2

Previous post - Next post | Parent - No child | Posted on 2010/12/2 16:48 | Last modified

iseki    Posts: 1581

Hi Adam,
We wish to express our gratitude for your cooperation.

Quote:

same problem :(
create avatar error:

* Owner Name (Adam Farrugia)
* User not Found in Moodle (Adam Farrugia)
* It failed in making user of Modlos!!

..But it still creates a valid opensim avatar account..

This error message means that "Adam Farrugia" is not moodle user.
Though Modlos want to set "Adam Farrugia" to owner of created avatar, Modlos can not find "Adam Farrugia" in Moodle user DB.
Because this is not a fatal error, OpenSim user is created. But owner of created avatar is undecided.

Let's look DB directory!! :)

 $ mysql -p -u [USERNAME]               ([USERNAME] is MySQL userid or Manager ID [ex. root])
 Enter password: [PASSWORD]             ([PASSWORD] is password of [USERNAME])
 
 mysql> show databases;
 mysql> use [DATABASENAME];             ([DATABASENAME] is name of Moodle DB)
 mysql> show tables;
 .....................
 mysql> select firstname,lastname,deleted from [PREFIX]user;   ([PREFIX] is table prefix. It is mdl_ usually. In this case, table name is mdl_user)
 +------------+----------+---------+
 | firstname  | lastname | deleted |
 +------------+----------+---------+
 | Guest User |          |       0 |
 ...................................
 ...................................    (Does the displayed user have Adam Farrugia?)
 | Adam       | Farrugia |       0 |    (Is this line displayed?)
 +------------+----------+---------+
 mysql> quit

Does the displayed user by select query have Adam Farrugia? What value of "deleted"?

And how about "Not Synchro DB" message? I corrected there a little, too. Is it still displayed?

Thanks.

Votes:140 Average:5.21

Posts tree

• Modlos 1.5.0 database issues (fudge, 2010/11/30 10:05)
  • Re: Modlos 1.5.0 database issues (iseki, 2010/11/30 23:13)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/1 5:35)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/1 11:22)
      • Re: Modlos 1.5.0 database issues (iseki, 2010/12/2 11:11)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/2 11:45)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/2 12:07)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/2 14:45)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/2 15:29)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/2 16:48)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/2 20:30)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/3 3:06)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/3 8:55)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/3 10:03)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/3 10:48)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/3 11:03)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/3 16:53)
      • Re: Modlos 1.5.0 database issues (iseki, 2010/12/3 17:55)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/6 7:40)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/7 7:32)
    • Re: Modlos 1.5.0 database issues (iseki, 2010/12/7 17:58)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/9 13:14)
    • Re: Modlos 1.5.0 database issues (admin, 2010/12/9 17:47)
  • Re: Modlos 1.5.0 database issues (fudge, 2010/12/10 9:52)
  • Re: Modlos 1.5.0 database issues- FINAL UPDATE (fudge, 2011/6/2 14:34)