Problem Moving Coppermine 1.4.6 from Old Server To New

[Craig Walsh]

We have a gallery running here:
http://www.bark.ch

We have just moved from an older Linux server to a newer server at the same hosting company.  We have a managed server, so the tech support folks at the hosting company handled the move.  We tested CPG on the "new" server before the switch-over, and it was working fine.  The switch-over took place a couple of days ago.

We have now discovered that if you look at images on the main page you'll see that you can double-click on certain images and get the larger image (we have three sizes on the site --- the thumbnail, mid-size image with envelope icon, and the larger image which is the one we upload), but this doesn't work on other images.  I have noticed that all of the images that aren't working are in one particular album, with an album ID of 33.

These images work fine when accessed directly from the album pages:

http://www.bark.ch/displayimage.php?album=33&pos=2
http://www.bark.ch/displayimage.php?album=33&pos=11

But when accessed using the "random" function as on the homepage, these won't show up properly

http://bark.ch/displayimage.php?album=random&cat=0&pos=-5095

If it manually update the "aid" in the picture table, things start working properly:

update picture_table set aid=34 where pid=5095

However, this album is the largest one we have with over 3,000 images in it.

Has anyone run into this before?  Does the album need to be recreated?  If so, how??

The hosting company has asked me to post this message.  While I'm not technical, I can relay comments to them.  And I will give them the link to this posting.

Thank you for your help...!

[Craig Walsh]

Our hosting company solved this for us.  Their explanation:

Craig,

OK, we've got this one fixed. We basically had to trace our way through the Coppermine code and finally reached the line that was failing. What happens is that Coppermine runs a query loading a fair amount of fields for *every* record in the database that's part of the same album as the picture you're currently viewing belongs to

I'm really not sure why this is done, but the result is that for your largest album, Coppermine tries to add *3000* database records into a single array variable. Because of this, PHP was running out of memory

To fix the issue I simply upped the memory allocation in the php.ini file from 8MB to 50, and the images all look to be working now. Please just let us know if you see any further problems with this. We're still investigating your other problems

Regards,
Paul Meserve
http://www.HostMySite.com

We're back up and running on the new server.  Phew!