[Xerte-dev] Re: Changing Ownership in Management PHP

Fri Mar 1 09:29:41 GMT 2013

Hi Tom

I changed the debug.log path to write to error_logs and set development to
true and then tried again but still getting the same message without any
error log being written.

If I put the svn code back I see all the users and templates.

HTH

Ron

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: 01 March 2013 09:07
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Ron,

It indicates the code is basically working, because you get a reply.
Something goes wrong with one of the mysql queries though.

Could you please try this one (should be in website_code/php/management),
turn on debugging and look in  '/tmp/debug.log' file for 'Query for
templates of user' (and the next line)?

Any php errors?

Tom

Op 1-3-2013 9:49, Ron Mitchell schreef:

Hi Tom

When clicking on users templates I see the drop down list with names but if
I select a user and then view I get This user has no templates at present
which isn't correct e.g. if I select my account which has lots of LO's I get
the same message.

HTH

Ron 

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: 01 March 2013 07:19
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

This should be it...

Op 1-3-2013 0:46, Pat @ Pgogy schreef:

I have no server to test, Ron and Julian would need a patch 

Pgogy Webstuff - http://www.pgogywebstuff.com 

Makers of web things of a fair to middling quality

On 28 Feb 2013, at 20:54, Tom Reijnders <reijnders at tor.nl> wrote:

I've got it...

This is the result:

<fcgabbgg.png>

<bcachfib.png>

Do you want me to check this in, or do you want the files first....

Tom

Op 28-2-2013 11:44, Pat @ Pgogy schreef:

I will write a how to guide to do it, whilst doing it

*returns to cave* *plots*

Pgogy Webstuff - http://www.pgogywebstuff.com 

Makers of web things of a fair to middling quality

On 28 Feb 2013, at 10:25, Tom Reijnders <reijnders at tor.nl> wrote:

I'll have a look. I am not too familiar with Ajax and xot, but... one is
never too old to learn ;-)

Tom

Op 28-2-2013 10:49, Julian Tenney schreef:

I think you might be missing the subtle manager speak in 'would that be hard
to do'

;-)

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 28 February 2013 09:37
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Rewrite the query as a list of usernames, make the username an Ajax function
which fires and then returns just the data for that user

One new js function, and splitting the existing php into two files

Pgogy Webstuff - http://www.pgogywebstuff.com

Makers of web things of a fair to middling quality

On 28 Feb 2013, at 09:08, Julian Tenney <Julian.Tenney at nottingham.ac.uk>
wrote:

It still times out. I think we probably need to limit the searching to a
particular user name, entered by the admin user. I think that makes more
sense, I don't really need to browse all users LOs, would that be hard to
do?

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: 28 February 2013 08:59
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

There were a lot of queries inside loops. If you have say 8000 LO's and 800
users, it would do at least 8800 queries.

Try this one (this is a minor rewrite just re-arranging queries, it does 2
queries)

Tom

Op 27-2-2013 18:05, Pat @ Pgogy schreef:

Guess that page is timing out.

The page will need rewriting, or a new query doing I guess.

Pgogy Webstuff - http://www.pgogywebstuff.com 

Makers of web things of a fair to middling quality

On 27 Feb 2013, at 16:23, Julian Tenney <Julian.Tenney at nottingham.ac.uk>
wrote:

This is what happens:

<image001.png>

Nothing more.

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 27 February 2013 14:41
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Management.php is all ajaxed - so the front page should work regardless.

You can watch the speed of requests in console in firebug or chrome to see
if that is a problem

Pgogy Webstuff - http://www.pgogywebstuff.com

Makers of web things of a fair to middling quality

On 27 Feb 2013, at 13:36, Julian Tenney <Julian.Tenney at nottingham.ac.uk>
wrote:

I had thought it was due to the size of the database, because I noticed it
really starting slow up as the number of LOs increased - we have about 8000
now. Does management.php work OK on the sandpit On? You've got a similar
number of LOs in there haven't you?

From: xerte-dev-bounces at lists.nottingham.ac.uk
[mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 27 February 2013 12:53
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Yes changing ownership has been there for ages.

If it freezes it suggests a JavaScript problem has occurred 

Pgogy Webstuff - http://www.pgogywebstuff.com

Makers of web things of a fair to middling quality

On 27 Feb 2013, at 11:56, Julian Tenney <Julian.Tenney at nottingham.ac.uk>
wrote:

Can I change ownership in management.php? When I log in, it just appears to
freeze, clicking any of the top menus doesn't appear to do anything,

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130301/1b0b3d2b/attachment-0001.html>