[Xerte] Re: XOT Shared Settings working for some users but not others

[Pat Lockley]

That half tallies in that the query looks for the root folder. Now if
it sees the recyclebin and gets confused, the query probably doesn't
return an id (so it dies).

The recyclebin code (which was their in the beginning) was put back in
later on and so isn't that gainly.

There is an explicit create recyclebin call in index.php to do this
(only was we could do it retrospectively).

I'd imagine the sandbox new user code makes a recyclebin before hand,
and then the recyclebin creator code gets confused.

If this code was in the core, or downloadable, i'd help more - but
this is a private fork of the main XOT code and tbh, that irks me so I
don't feel all that oblidged to help

On Fri, Jun 24, 2011 at 3:40 PM, Ron Mitchell <ronm at mitchellmedia.co.uk> wrote:
> Thanks for your help Pat. As you say the two recycle bins problem has been
> unique to the sandpit and I don't know what caused/causes that. But a
> solution for our sandpit user who couldn't share with a colleague seems to
> work...
>
> The colleague created a folder in their workspace and then the user was able
> to share an LO with her and it went into that folder. Probably works because
> the folder the code finds is no longer recyclebin and therefore the sharing
> works.
>
> So if any sandpit users encounter this problem a current fix is to ask the
> colleague to whom you want to share to create a folder in their workspace.
>
> HTH
> Regards
> Ron
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
> Sent: 23 June 2011 23:34
> To: Xerte discussion list
> Subject: [Xerte] Re: XOT Shared Settings working for some users but not
> others
>
> For ages the sandpit has had two recycle bins. The foldername is fixed as an
> id. The name is fixed as an id, two folders with the same name. Won't work.
>
> So I'd fix the two recyclebins problem, and that's in code thats nothing to
> do with me.
>
> On 23 Jun 2011, at 22:37, "Ron Mitchell" <ronm at mitchellmedia.co.uk> wrote:
>
>> Ok made some progress in identifying the difference between the test
> account
>> that works and the one that doesn't. The difference is in the
> folderdetails
>> table and I think this line:
>>
>> $query_to_find_out_root_folder = "select folder_id from " .
>> $xerte_toolkits_site->database_table_prefix . "folderdetails where
> login_id
>> =\"" . $user_id . "\" and folder_parent=\"0\" and
>> folder_name!=\"recyclebin\"";
>>
>> The account it was possible to share with had more than one row whereas
> the
>> other account only had one row in folderdetails and the foldername was
>> recyclebin.
>>
>> If I edit that row in the db and change recyclebin to something else e.g.
>> test then sharing works with that account too.
>>
>> When an account gets created is a row in folderdetails automatically
> created
>> and should that have a name other than recyclebin? I ask that because I
> know
>> there has been odd behavious in the sandpit in the past with recyclebin
>> appearing at the top of the workspace.
>>
>> Does this point to a cause/solution?
>>
>> Cheers
>> Ron
>>
>> -----Original Message-----
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: 23 June 2011 22:02
>> To: Xerte discussion list
>> Subject: [Xerte] Re: XOT Shared Settings working for some users but not
>> others
>>
>> put a die in share_..... and the nobbled the javascript with alerts so
>> it puts watchpoints in
>>
>> On Thu, Jun 23, 2011 at 9:57 PM, Ron Mitchell <ronm at mitchellmedia.co.uk>
>> wrote:
>>> I'm testing with a local copy now so that I can see the database. Testing
>>> sharing to two different user accounts one of which works the other
>> doesn't.
>>> No real difference in the logindetails table between the two accounts.
> One
>>> is ID 3 the other ID 14. The one that works username is upper and
>> lowercase
>>> the one that doesn't username is all lowercase. I guess that may be
>>> irrelevant.
>>>
>>> I can't get any echo statements in share_this_template.php to appear.
>>>
>>> -----Original Message-----
>>> From: xerte-bounces at lists.nottingham.ac.uk
>>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>>> Sent: 23 June 2011 20:51
>>> To: Xerte discussion list
>>> Subject: [Xerte] Re: XOT Shared Settings working for some users but not
>>> others
>>>
>>> Right,
>>>
>>> The files run, and no JS errors occur.
>>>
>>> As it works for some users fine and not others, the question is - what
>>> is different about these users.
>>>
>>> Looking in share_this_template.php - which does the sharing - it
>>> relies heavily on the root folder working properly.
>>>
>>> So I'd put some echos into this file and see what happens, but i'd be
>>> surprised if the error wasn't caused by the self-reg code and users
>>> which predate it.
>>>
>>> On Thu, Jun 23, 2011 at 4:37 PM, Ron Mitchell <ronm at mitchellmedia.co.uk>
>>> wrote:
>>>> Hi
>>>>
>>>> I guess this might be a question for Pat...
>>>>
>>>>
>>>>
>>>> Someone who uses the JISC Techdis XOT sandpit reported not being able to
>>>> share LO's with a colleague who has an account on the same installation.
>>> So
>>>> I tested this myself and it seems very odd...
>>>>
>>>> We can give a copy of an LO to this colleague but not share.
>>>>
>>>> We can share LO's with some/many users but not all. There doesn't seem
> to
>>> be
>>>> any commonality between who we can share with and who we can't which is
>>>> probably why this hasn't cropped up previously. That said both Pat and
>>>> Julian have accounts on the sandpit and I can't share with those either
>>> but
>>>> can with others!
>>>>
>>>> I've replaced the contents of /website_code/php/properties with the
>> latest
>>>> repository code and also with older versions neither of which have
>>> resolved
>>>> this.
>>>>
>>>> Fiddler doesn't show any errors when trying to share an LO.
>>>>
>>>>
>>>>
>>>> So I'm stumped! :-(
>>>>
>>>>
>>>>
>>>> Anyone else had this problem? Can you share with all users on your
>> system?
>>>>
>>>>
>>>>
>>>> Cheers
>>>>
>>>> Ron
>>>>
>>>> This message and any attachment are intended solely for the addressee
> and
>>>> may contain confidential information. If you have received this message
>> in
>>>> error, please send it back to me, and immediately delete it. Please do
>> not
>>>> use, copy or disclose the information contained in this message or in
> any
>>>> attachment. Any views or opinions expressed by the author of this email
>> do
>>>> not necessarily reflect the views of the University of Nottingham.
>>>>
>>>> This message has been checked for viruses but the contents of an
>>> attachment
>>>> may still contain software viruses which could damage your computer
>>> system:
>>>> you are advised to perform your own checks. Email communications with
> the
>>>> University of Nottingham may be monitored as permitted by UK
> legislation.
>>>>
>>>> _______________________________________________
>>>> Xerte mailing list
>>>> Xerte at lists.nottingham.ac.uk
>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>
>>>> This message and any attachment are intended solely for the addressee
> and
>>>> may contain confidential information. If you have received this message
>> in
>>>> error, please send it back to me, and immediately delete it.   Please do
>>> not
>>>> use, copy or disclose the information contained in this message or in
> any
>>>> attachment.  Any views or opinions expressed by the author of this email
>>> do
>>>> not necessarily reflect the views of the University of Nottingham.
>>>>
>>>> This message has been checked for viruses but the contents of an
>>> attachment
>>>> may still contain software viruses which could damage your computer
>>> system:
>>>> you are advised to perform your own checks. Email communications with
> the
>>>> University of Nottingham may be monitored as permitted by UK
> legislation.
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Xerte mailing list
>>> Xerte at lists.nottingham.ac.uk
>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>
>>>
>>> _______________________________________________
>>> Xerte mailing list
>>> Xerte at lists.nottingham.ac.uk
>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>
>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>