Blank profiles. Data is in Joomla, not in client.

My second last problem. So close now


This is my profile in Joomla:



And in mysql:

mysql> select * from k8w1g_opensim_userprofile;
| avatar_id | partner | image | aboutText
| allowPublish | maturePublish | url | wantmask | wanttext | skillsmask | skillstext
| languages | firstLifeImage | firstLifeText |

| fcc1efc6-992c-4e83-acaf-feed0b44df9b | | 00000000-0000-0000-0000-000000000000 | This was entered in Joomla.
| | | google.com | 135 | | 48 | Landscaping, Terrain
| en,fr | 00000000-0000-0000-0000-000000000000 | I make 747s fly... or crash.
MWAAHAAHAA |
3 rows in set (0.00 sec)



Turning on debugging I see the profile requested and come into the client:



2012-10-25 14:01:16 Request coming from 184.169.147.242


########## 25.10.2012 14:01:16 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>avatar_properties_request</methodName><params><param><value><struct><
member><name>avatar_id</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member></struct></value></param><
/params></methodCall>'

2012-10-25 14:01:16 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php

########## 25.10.2012 14:01:16 ##### response for profile ##########
'
response for avatar_properties_request:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>Partner</name>
<value><string></string></value>
</member>
<member><name>ProfileUrl</name>
<value><string> google.com </string></value>
</member>
<member><name>wantmask</name>
<value><string>135</string></value>
</member>
<member><name>wanttext</name>
<value><string></string></value>
</member>
<member><name>skillsmask</name>
<value><string>48</string></value>
</member>
<member><name>skillstext</name>
<value><string>Landscaping, Terrain</string></value>
</member>
<member><name>languages</name>
<value><string>en,fr</string></value>
</member>
<member><name>FirstLifeImage</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value>
</member>
<member><name>FirstLifeAboutText</name>
<value><string>I make 747s fly... or crash. MWAAHAAHAA</string></value>
</member>
<member><name>Image</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value>
</member>
<member><name>AboutText</name>
<value><string>This was entered in Joomla.</string></value>
</member>
<member><name>userFlags</name>
<value><int>65535</int></value>
</member>
</struct></value>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''


***************** So, the data is being returned. BUT not displayed.
This request fails just after that call:



########## 25.10.2012 14:01:32 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>groups.getGroup</methodName><params><param><value><struct><member><na
me>GroupID</name><value><string>f56edf21-6076-4fb4-9048-1a2ac63befe7</string></value></member><member><name>RequestingSessionID</nam
e><value><string>00000000-0000-0000-0000-000000000000</string></value></member><member><name>ReadKey</name><value><string>7117</stri
ng></value></member><member><name>WriteKey</name><value><string>7117</string></value></member><member><name>RequestingAgentID</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value></member><member><name>RequestingAgentUserService</name><value><
string /></value></member></struct></value></param></params></methodCall>'

2012-10-25 14:01:32 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php


########## 25.10.2012 14:01:32 ##### response for groups ##########
'
response for groups.getGroup is an error. The part in error is:

<value><string>SELECT
....
WHERE k8w1g_opensim_group.GroupID = 'f56edf21-6076-4fb4-9048-1a2ac63befe7'
</member>



but my table doesn't have that key.



mysql> select * from k8w1g_opensim_group;
| GroupID | Name | Charter | InsigniaID | FounderID
| MembershipFee | OpenEnrollment | ShowInList | AllowPublish | MaturePublish | OwnerRoleID |
| 7bb76748-b2e7-4994-9b4a-a56cbaf58d9b | HyperLand | | bd84a345-8e22-4779-760b-239642afdbbf | 0dbf9b20-023f-44f9-80d8-59
862c72f7db | 0 | 0 | 1 | 0 | 1 | d0ffea2e-a4dc-40ce-8450-aafc366f92c2 |
| 436f91b2-e559-43fa-8831-4cb6694a7bda | HyperShopping | | 9a4a7f21-66cb-4840-a01d-cd8b9a054dd0 | fcc1efc6-992c-4e83-acaf-fe
ed0b44df9b | 0 | 0 | 1 | 0 | 1 | c916eec8-ccc0-4a4f-9edb-fa2820e99432 |
2 rows in set (0.00 sec)



And the profile is never loaded into the viewer. It's blank.


If I type anything into the profile into the viewer and save it then that appears in Joomla.

I think this failure on groups is stopping the login in the viewer from continuing past the groups stage.

No note, no profile picture, no other tabs.

So the question is which table or what part of the code does f56edf21-6076-4fb4-9048-1a2ac63befe7 come from right after the avatar properties request?

It has to be associated to the user, I have 1 user working 2 that don't. When I create a new character and then click creates I see that they have one to start called "New Group" and then the one I do. They get 2 groups, the spurious one goes away and never comes back, but could it be this UUID?

Is there maybe a problem in the group creation that stores a UUID that is never created.

My test was going to be to find this table with f56edf21-6076-4fb4-9048-1a2ac63befe7 and purge that record if possible.

But I've gone through all the joomla _opensim_ databases and can't find it.

>.<

Sorry to ask such a complex question. Please let me know if more information will help?

Hmm, maybe creating the group : f56edf21-6076-4fb4-9048-1a2ac63befe7 will also show me what's wrong. If the profile then comes up I am on the right track. I will look into it tomorrow, 2am for me.

No, adding that group doesn't work.
I also deleted all the groups and tried, still not working
I also created a new group and it didn't fix the issue, although I got the extra group creted again, group uuid = 00000-00000-000000-000000ish

Attaching a full log from asking for the profile with no groups right up to seeing it blank on the screen.

2012-10-26 01:19:08 Request coming from 184.169.147.242


########## 26.10.2012 01:19:08 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>avatarpicksrequest</methodName><params><param><value><struct><member><name>uuid</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:08 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php
2012-10-26 01:19:08 Request coming from 184.169.147.242


########## 26.10.2012 01:19:08 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>avatar_properties_request</methodName><params><param><value><struct><member><name>avatar_id</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:08 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php
2012-10-26 01:19:08 avatarpicksrequest: array (
'uuid' => 'fcc1efc6-992c-4e83-acaf-feed0b44df9b',
)


########## 26.10.2012 01:19:08 ##### response for profile ##########
'
response for avatarpicksrequest:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>errorMessage</name>
<value><string></string></value>
</member>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>pickid</name>
<value><string>a8249775-5f51-67a9-8ec1-74ffdbc9d387</string></value>
</member>
<member><name>name</name>
<value><string>Drop Area</string></value>
</member>
</struct></value>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''



########## 26.10.2012 01:19:08 ##### response for profile ##########
'
response for avatar_properties_request:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>Partner</name>
<value><string></string></value>
</member>
<member><name>ProfileUrl</name>
<value><string> google.com </string></value>
</member>
<member><name>wantmask</name>
<value><string>0</string></value>
</member>
<member><name>wanttext</name>
<value><string></string></value>
</member>
<member><name>skillsmask</name>
<value><string>0</string></value>
</member>
<member><name>skillstext</name>
<value><string></string></value>
</member>
<member><name>languages</name>
<value><string></string></value>
</member>
<member><name>FirstLifeImage</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value>
</member>
<member><name>FirstLifeAboutText</name>
<value><string></string></value>
</member>
<member><name>Image</name>
<value><string>66250cf4-1b58-4439-b895-9363893618eb</string></value>
</member>
<member><name>AboutText</name>
<value><string>This is from Phoenix</string></value>
</member>
<member><name>userFlags</name>
<value><int>65535</int></value>
</member>
</struct></value>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''

2012-10-26 01:19:08 Request coming from 184.169.147.242


########## 26.10.2012 01:19:08 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>avatarclassifiedsrequest</methodName><params><param><value><struct><member><name>uuid</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:08 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php
2012-10-26 01:19:09 Request coming from 184.169.147.242


########## 26.10.2012 01:19:09 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>avatarnotesrequest</methodName><params><param><value><struct><member><name>avatar_id</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member><member><name>uuid</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:09 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php


########## 26.10.2012 01:19:09 ##### response for profile ##########
'
response for avatarclassifiedsrequest:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>errorMessage</name>
<value><string></string></value>
</member>
<member><name>data</name>
<value><array>
<data>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''



########## 26.10.2012 01:19:09 ##### response for profile ##########
'
response for avatarnotesrequest:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>notes</name>
<value><string></string></value>
</member>
<member><name>targetid</name>
<value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value>
</member>
</struct></value>
</data>
</array></value>
</member>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>errorMessage</name>
<value><string></string></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''

2012-10-26 01:19:09 Request coming from 184.169.147.242


########## 26.10.2012 01:19:09 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>groups.getAgentGroupMemberships</methodName><params><param><value><struct><member><name>WriteKey</name><value><string>7117</string></value></member><member><name>RequestingSessionID</name><value><string>00000000-0000-0000-0000-000000000000</string></value></member><member><name>ReadKey</name><value><string>7117</string></value></member><member><name>AgentID</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member><member><name>RequestingAgentID</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member><member><name>RequestingAgentUserService</name><value><string /></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:09 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php


########## 26.10.2012 01:19:09 ##### response for groups ##########
'
response for groups.getAgentGroupMemberships:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>succeed</name>
<value><string>false</string></value>
</member>
<member><name>error</name>
<value><string>No Memberships</string></value>
</member>
<member><name>params</name>
<value><string>array ( 'WriteKey' => '7117', 'RequestingSessionID' => '00000000-0000-0000-0000-000000000000', 'ReadKey' => '7117', 'AgentID' => 'fcc1efc6-992c-4e83-acaf-feed0b44df9b', 'RequestingAgentID' => 'fcc1efc6-992c-4e83-acaf-feed0b44df9b', 'RequestingAgentUserService' => '', )</string></value>
</member>
<member><name>sql</name>
<value><string>SELECT k8w1g_opensim_group.GroupID, k8w1g_opensim_group.Name AS GroupName, k8w1g_opensim_group.Charter, k8w1g_opensim_group.InsigniaID, k8w1g_opensim_group.FounderID, k8w1g_opensim_group.MembershipFee, k8w1g_opensim_group.OpenEnrollment, k8w1g_opensim_group.ShowInList, k8w1g_opensim_group.AllowPublish, k8w1g_opensim_group.MaturePublish, k8w1g_opensim_groupmembership.Contribution, k8w1g_opensim_groupmembership.ListInProfile, k8w1g_opensim_groupmembership.AcceptNotices, k8w1g_opensim_groupmembership.SelectedRoleID, k8w1g_opensim_grouprole.Title, IFNULL(k8w1g_opensim_groupactive.ActiveGroupID, '00000000-0000-0000-0000-000000000000') AS ActiveGroupID FROM k8w1g_opensim_group JOIN k8w1g_opensim_groupmembership ON (k8w1g_opensim_group.GroupID = k8w1g_opensim_groupmembership.GroupID) JOIN k8w1g_opensim_grouprole ON (k8w1g_opensim_groupmembership.SelectedRoleID = k8w1g_opensim_grouprole.RoleID AND k8w1g_opensim_groupmembership.GroupID = k8w1g_opensim_grouprole.GroupID) LEFT JOIN k8w1g_opensim_groupactive ON (k8w1g_opensim_groupactive.AgentID = k8w1g_opensim_groupmembership.AgentID) WHERE k8w1g_opensim_groupmembership.AgentID = 'fcc1efc6-992c-4e83-acaf-feed0b44df9b'</string></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''

2012-10-26 01:19:09 Request coming from 184.169.147.242


########## 26.10.2012 01:19:09 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>pickinforequest</methodName><params><param><value><struct><member><name>avatar_id</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member><member><name>pick_id</name><value><string>a8249775-5f51-67a9-8ec1-74ffdbc9d387</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:09 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php
2012-10-26 01:19:09 Request coming from 184.169.147.242


########## 26.10.2012 01:19:09 ##### input ##########
'<?xml version="1.0" encoding="utf-8"?><methodCall><methodName>pickinforequest</methodName><params><param><value><struct><member><name>avatar_id</name><value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value></member><member><name>pick_id</name><value><string>a8249775-5f51-67a9-8ec1-74ffdbc9d387</string></value></member></struct></value></param></params></methodCall>'

2012-10-26 01:19:09 Access granted for 184.169.147.242 at line 281 in /var/www/components/com_opensim/interface.php


########## 26.10.2012 01:19:09 ##### response for profile ##########
'
response for pickinforequest:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>errorMessage</name>
<value><string></string></value>
</member>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>pickuuid</name>
<value><string>a8249775-5f51-67a9-8ec1-74ffdbc9d387</string></value>
</member>
<member><name>creatoruuid</name>
<value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value>
</member>
<member><name>toppick</name>
<value><string>false</string></value>
</member>
<member><name>parceluuid</name>
<value><string>97ca6ae2-3ca3-45b0-a101-613ef134de32</string></value>
</member>
<member><name>name</name>
<value><string>Drop Area</string></value>
</member>
<member><name>description</name>
<value><string>No Description</string></value>
</member>
<member><name>snapshotuuid</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value>
</member>
<member><name>user</name>
<value><string>Unknown</string></value>
</member>
<member><name>originalname</name>
<value><string>Unknown</string></value>
</member>
<member><name>simname</name>
<value><string>Welcome</string></value>
</member>
<member><name>posglobal</name>
<value><string><1968256, 2200960, 21.83142></string></value>
</member>
<member><name>sortorder</name>
<value><string>0</string></value>
</member>
<member><name>enabled</name>
<value><string>true</string></value>
</member>
</struct></value>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''



########## 26.10.2012 01:19:09 ##### response for profile ##########
'
response for pickinforequest:

\'<?xml version="1.0"?>
<methodResponse>
<params>
<param>
<value><struct>
<member><name>success</name>
<value><boolean>1</boolean></value>
</member>
<member><name>errorMessage</name>
<value><string></string></value>
</member>
<member><name>data</name>
<value><array>
<data>
<value><struct>
<member><name>pickuuid</name>
<value><string>a8249775-5f51-67a9-8ec1-74ffdbc9d387</string></value>
</member>
<member><name>creatoruuid</name>
<value><string>fcc1efc6-992c-4e83-acaf-feed0b44df9b</string></value>
</member>
<member><name>toppick</name>
<value><string>false</string></value>
</member>
<member><name>parceluuid</name>
<value><string>97ca6ae2-3ca3-45b0-a101-613ef134de32</string></value>
</member>
<member><name>name</name>
<value><string>Drop Area</string></value>
</member>
<member><name>description</name>
<value><string>No Description</string></value>
</member>
<member><name>snapshotuuid</name>
<value><string>00000000-0000-0000-0000-000000000000</string></value>
</member>
<member><name>user</name>
<value><string>Unknown</string></value>
</member>
<member><name>originalname</name>
<value><string>Unknown</string></value>
</member>
<member><name>simname</name>
<value><string>Welcome</string></value>
</member>
<member><name>posglobal</name>
<value><string><1968256, 2200960, 21.83142></string></value>
</member>
<member><name>sortorder</name>
<value><string>0</string></value>
</member>
<member><name>enabled</name>
<value><string>true</string></value>
</member>
</struct></value>
</data>
</array></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>\''



I notice my picks and notes are there on further testing. So it's just the 2nd life, web, interests, classified and 1st life tabs that are not shown.

I'm stuck I fear.

Hi Jayden

and thanks for your very detailed info Sorry my delay for replying but I had a suspect I first wanted to check myself. This all seems to be an issue of incompatibility of my profile module with opensim 0.7.4+

Today I finally could setup a v0.7.4 sim for testings and could reproduce this issue. I will investigate the code asap and hopefully can provide you soon with a working version of jOpenSim.Profile.dll

Greetz
FoTo50