Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: fval on August 19, 2008, 07:16:13 PM

Title: Timout on search page
Post by: fval on August 19, 2008, 07:16:13 PM
My database has to many keywords. Then the page stop by php timeout.

I did change SQL clause in include/keyword.inc.php, line 24.

Original:

Code Select
$result = cpg_db_query("select keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");

With my change:

Code Select
$result = cpg_db_query("select distinct keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");
Text only | Text with Images