"Admin tools" cause mysql lockup

[Xandrios]

I've just upgraded an 1.3.2 coppermine test install to 1.4.2. There are still some theme issues with my custom theme (That I dont want to bother you with), but there is one strange issue.

Whenever the  "Admin tools" page is requested, mysql causes 100% cpu load....locking up the server. I have tried using the 'sample'-template, but that has the same effect. Somehow there is some kind of infinite loop or strange mysql query executed there.

Any ideas on how to solve this?

Thanks in advance,
Xandrios

[Nibbler]

Are you bridged or using coppermine on its own ? Also do you have a lot of albums and categories ?

[Xandrios]

It is a standalone install, and has about 1800 albums... is that considered much?

[Nibbler]

The code that makes the album box at the end of the page is not very efficient and 1800 may well be too much for it. Attached is an updated file that has better code. Please overwrite bridge/udb_base.inc.php with this new version and report back.