forum.coppermine-gallery.net

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");