Error in editpics.php

[fangweile]

Hello there,

After searching this board and found some related topics

http://forum.coppermine-gallery.net/index.php/topic,50792.0.html
http://forum.coppermine-gallery.net/index.php/topic,57124.0.html

I still can't figured it out why my editpics.php is not working.

Last time when I try to edit files in my album containing 10-11 images, it is work just fine.
However, when I try to edit files in my album with 38 images, it is stock in 17th images and doesnt load thoroughly. I can't even see the apply modification and cpg footer cause it stop loading.

I already read those threads that i've found but still can't get it to work. I also try to set it in default theme but still no luck.

I don't think that this is a restriction in my webhost, I just want to be sure if it is.

I have two galleries running in the same webhost

1. http://www.allkoreans.net/gallery/index.php and
2. http://www.lim-eunkyeong.com/gallery

I am having problem with the first site (allkoreans.net) when trying to edit more than 17 files as stated above. In my second cpg gallery(lim-eunkyeong.com). It works just fine. I can edit more than 100 files in any album. I guess that the problem is in the no. of albums in the database.

In my first site, I have 1252 albums, so each files in editpics.php generate 1252 albums. When I try to view the source code of my editpics.php where it stock, and copy paste the code in ms word, its generate 621 pages. I just guess that this is the cause why it isnt load the next images.


Any idea. Hope someone could help
Thanks a lot in advance

[Nibbler]

Try changing

Code Select Expand

$public_albums = cpg_db_query("SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM {$CONFIG['TABLE_ALBUMS']}, {$CONFIG['TABLE_CATEGORIES']} WHERE category < '" . FIRST_USER_CAT . "' AND (category = 0 OR category = cid) ORDER BY cat_title");

to

Code Select Expand

$public_albums = cpg_db_query("SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM {$CONFIG['TABLE_ALBUMS']}, {$CONFIG['TABLE_CATEGORIES']} WHERE category < '" . FIRST_USER_CAT . "' AND (category = 0 OR category = cid) AND aid = $album_id ORDER BY cat_title");

in editpics.php.

It will remove your ability to move pics between albums but should help the page to load. I don't think those 2 threads you posted are relevant here.

[fangweile]

OMG, thanks a lot Nibbler. You really did a great help.
It is working fine now. Thanks again.
I am just editing the album files to put titles on them. No need to move and it load faster.

Thanks again ^_^